FND General

SELECT

req.request_id

,req.logfile_node_name node

,req.oracle_Process_id

,req.enable_trace

,dest.VALUE||'/'||LOWER(dbnm.VALUE)||'_ora_'||oracle_process_id||'.trc' trace_filename

,prog.user_concurrent_program_name

,execname.execution_file_name

,execname.subroutine_name

,phase_code

,status_code

,ses.SID

,ses.serial#

,ses.module

,ses.machine

FROM

fnd_concurrent_requests req

,v$session ses

,v$process proc

,v$parameter dest

,v$parameter dbnm

,fnd_concurrent_programs_vl prog

,fnd_executables execname

WHERE 1=1

AND req.request_id = &request

AND req.oracle_process_id=proc.spid(+)

AND proc.addr = ses.paddr(+)

AND dest.NAME='user_dump_dest'

AND dbnm.NAME='db_name'

AND req.concurrent_program_id = prog.concurrent_program_id

AND req.program_application_id = prog.application_id

AND prog.application_id = execname.application_id

AND prog.executable_id=execname.executable_id

PAYBLES BASE TABLES PAYBLESINTERFACETABLES

AP_INVOICES_ALL AP_INVOICES_INTERFACE

AP_INVOICE_DISTRIBUTIONS_ALL AP_INVOICE_LINES_INTERFACE

AP_INVOICE_PAYMENTS_ALL AP_INTERFECE_REJECTIONS

AP_PAYMENT_DISTRIBUTIONS_ALL AP_SUPPLIERS_INT

AP_PAYMENT_HISTORY_ALL AP_SUPPLIER_SITES_INT

AP_PAYMENT_SCHEDULES_ALL AP_SUP_SITE_CONTACT_INT

AP_AE_HEADERS_ALL

AP_AE_LINES_ALL

AP_BATCHES_ALL

AP_TERMS

AP_LOOKUP_CODES

AP_ACCOUNTING_EVENTS_ALL

AP_BANK_ACCOUNTS_ALL

AP_BANK_BRANCHES

AP_CHECKS_ALL

AP_HOLDS_AL

AP_CARD_CODES

AP_EXPENSE_REPORTS_ALL

AP_EXPENSE_REPORT_HEADERS_ALL

AP_EXPENSE_REPORT_LINES_ALL

PO BASE TABLES PO INTERFACE TABLESPO_HEADERS_ALL PO_HEADERS_INTERFACE

PO_LINES_ALL PO_LINES_INTERFACE

PO_LINE_LOCATIONS_ALL PO_DISTRIBUTIONS_INTERFACE

PO_DISTRIBUTIONS_ALL PO_INTERFACE_ERRORS

PO_RELEASES_ALL

PO_AGENTS

PO_ACTION_HISTORY

PO_VENDORS

PO_VENDOR_SITES_ALL

PO_VENDOR_CONTACTS

PO REQ BASE TABLES PO REQ INTERFACE TABLES

PO_REQUISITION_HEADERS_ALL

PO_REQUISITION_LINES_ALL

PO_REQ_DISTRIBUTIONS_ALL

GL BASE TABLES GL INTERFACE TABLES

GL_JE_HEADERS GL_INTERFACE

GL_JE_LINES GL_INTERFACE_HISTORY

GL_JE_CATEGORIES GL_DAILY_RATES_INTERFACE

GL_JE_SOURCES GL_BUDGET_INTERFACE

GL_SETS_OF_BOOKS GL_IEA_INTERFACE

GL_DAILY_RATES

GL_CODE_COMBINATIONS

GL_BALANCES

GL_PERIODS

GL_PERIOD_SETS

GL_CURRENCIES

GL_HISTORICAL_RATES

GL_LOOKUPS

INVENTORY BASETABLES INVENTORY INTERFACE TABLES

MTL_SYSTEM_ITEMS_B MTL_SYSTEM_ITEMS_INTERFACE

MTL_ITEM_CATEGORIES MTL_ITEM_CATEGORIES_INTERFACE

MTL_ITEM_LOCATIONS MTL_ITEM_REVISION_INTERFACE

MTL_ITEM_REVISIONS_B MTL_INTERFACE_ERRORS

MTL_PARAMETERS

MTL_ITEM_SUB_INVENTORIES

MTL_ONHAND_QUANTITIES

MTL_CATEGORY_SETS_B

CST_ITEM_COSTS

CST_COST_TYPES

MTL_MATERIAL_TRANSACTIONS

MTL_TRANSACTION_TYPES

MTL_SECONDARY_INVENTORIES

MTL_SERIAL_NUMBERS

MTL_LOT_NUMBERS

MTL_TRANSACTION_ACCOUNTS

RECEIVABLE BASE TABLES RECEIVBLE INTERFACE TABLES

HZ_PARTIES HZ_PARTY_INERFACE

HZ_CUST_ACCOUNTS HZ_PARTY_INTERFACE_ERRORS

HZ_CUST_ACCT_SITES_ALL RA_CONTACT_PHONES_INT_ALL

HZ_CUST_SITE_USES_ALL RA_CUSTOMER_PROFILES_INT_ALL

HZ_PARTY_SITES RA_INTERFACE_DISTRIBUTIONS_ALL

HZ_LOCATIONS RA_INTERFACE_ERRORS_ALL

HZ_PARTY_SITE_USES RA_INTERFACE_LINES_ALL

HZ_CUSTOMER_PROFILES RA_INTERFACE_SALESCREDITS_ALL

HZ_ORGANIZATION_PROFILES AR_PAYMENTS_INTERFACE_ALL

HZ_PERSON_PROFILES AR_TAX_INTERFACE

RA_CUSTOMER_TRX RCV_HEADERS_INTERFACE

RA_CUSTOMER_TRX_PARTIAL_V RCV_TRANSACTIONS_INTERFACE

RA_CUSTOMER_TRX_LINES_ALL

RA_CUSTOMERS

AR_PAYMENT_SCHEDULES_ALL

RA_CUST_TRX_LINE_GL_DIST_ALL

RA_CUST_TRX_TYPES_ALL

RA_BATCH_SOURCES_ALL

AR_VAT_TAX_ALL

RA_TERMS

AR_PERIODS

AR_PERIOD_TYPES

RCV_SHIPMENT_HEADERS

RCV_SHIPMENT_LINES

RCV_TRANSACTIONS

OTHER BASE TABLES

FND_USER

FND_RESPONSIBILITY_VL

FND_APPLICATION_VL

FND_CONCURRENT_PROGRAMS

FND_DATA_GROUPS

FND_CONCURRENT_PROCESSES

FND_CONCURRENT_REQUESTS

FND_SEGMENT_ATTRIBUTE_TYPES

FND_SEGMENT_ATTRIBUTE_VALUES

FND_TABLES

FND_FORM

FND_PRODUCT_INSTALLATIONS

ORG_ORGANIZATION_DEFINITIONS

PER_ALL_PEOPLE_F (ENAME)

HR_LOCATIONS(SHIP TO, BILL TO)

SOME IMPORTANT API”S

FND_PROFILE: User Profile APIs

FND_PROFILE.PUT

Procedure FND_PROFILE.PUT

(name IN varchar2,

value IN varchar2);

Puts a value to the specified user profile option. If the option does not exist, you can also create it with PUT.

Arguments (input)

name -- The (developer) name of the profile option you want to set.

value -- The value to set in the specified profile option.

FND_PROFILE.GET

procedure FND_PROFILE.GET

(name IN varchar2,

value OUT varchar2);

Gets the current value of the specified user profile option, or NULL if the profile does not exist.

Arguments (input)

name -- The (developer) name of the profile option whose value you want to retrieve

Arguments (output)

value --The current value of the specified user profile option as last set by PUT or as defaulted in the current user’s profile.

Example

FND_PROFILE.GET (’USER_ID’, user_id);

FND_PROFILE.VALUE

function FND_PROFILE.VALUE

(name IN varchar2) return varchar2;

VALUE works exactly like GET, except it returns the value of the specified profile option as a function result.

Arguments (input)

name --The (developer) name of the profile option whose value you want to retrieve.

FND_CONCURRENT Package

FND_CONCURRENT.GET_REQUEST_STATUS

Function FND_CONCURRENT.GET_REQUEST_STATUS

(Request_id IN OUT number,

Application IN varchar2 default NULL,

Program IN varchar2 default NULL,

Phase OUT varchar2,

Status OUT varchar2,

Dev_phase OUT varchar2,

Dev_status OUT varchar2,

Message OUT varchar2) return Boolean;

Returns the status of a concurrent request. If the request has already completed, also returns a completion message.

Arguments (input)

request_id The request ID of the program to be checked.

application Short name of the application associated with the concurrent program. This parameter is necessary only when the request_id is not specified.

program Short name of the concurrent program (not the executable). This parameter is necessary only when the request_id isnotspecified. When application and program are provided, the request ID of the last request for this program is returned in request_id.

Arguments (output)

phase ---The user–friendly request phase from FND_LOOKUPS.

Status--The user–friendly request status from FND_LOOKUPS.

dev_phase ---The request phase as a constant string that can be used for program logic comparisons.

dev_status ---The request status as a constant string that can be used for program logic comparisons.

message ---The completion message supplied if the request has completed.

Example

begin

call_status boolean;

rphase varchar2(80);

rstatus varchar2(80);

dphase varchar2(30);

dstatus varchar2(30);

message varchar2(240);

call_status :=

FND_CONCURRENT.GET_REQUEST_STATUS(, ’’, ’’,

rphase,rstatus,dphase,dstatus, message);

end;

FND_CONCURRENT.WAIT_FOR_REQUEST (Client or Server)\

function FND_CONCURRENT.WAIT_FOR_REQUEST

(request_id IN number default NULL,

interval IN number default 60,

max_wait IN number default 0,

phase OUT varchar2,

status OUT varchar2,

dev_phase OUT varchar2,

dev_status OUT varchar2,

message OUT varchar2) return boolean;

Waits for request completion, then returns the request phase/status and completion message to the caller. Goes to sleep between checks for request completion.

Arguments (input)

request_id The request ID of the request to wait on.

interval Number of seconds to wait between checks (i.e., number of seconds to sleep.)

max_wait The maximum time in seconds to wait for the request’s completion.

Arguments (output)

Phase--The user–friendly request phase from the FND_LOOKUPS table.

Status--The user–friendly request status from the FND_LOOKUPS table.

dev_phase --The request phase as a constant string that can be used for program logic comparisons.

dev_status--The request status as a constant string that can be used for program logic comparisons.

Message--The completion message supplied if the request has already completed.

FND_FILE: PL/SQL File I/O

FND_FILE.PUT_LINE

procedure FND_FILE.PUT_LINE

(which IN NUMBER,

buff IN VARCHAR2);

Use this procedure to write a line of text to a file (followed by a new line character). You will use this utility most often.

Arguments (input)

Which--Log file or output file. Use either FND_FILE.LOG or FND_FILE.OUTPUT.

Buff --Text to write.

fnd_file.put_line(FND_FILE.LOG,’Warning: Employee ’|| l_log_employee_name||’ (’||

l_log_employee_num || ’) does not have a manager.’);

FND_PROGRAM: Concurrent Program Loaders

FND_PROGRAM.EXECUTABLE

procedure FND_PROGRAM.EXECUTABLE

(executable IN VARCHAR2,

application IN VARCHAR2,

description IN VARCHAR2 DEFAULT NULL,

execution_method IN VARCHAR2,

execution_file_name IN VARCHAR2 DEFAULT NULL,

subroutine_name IN VARCHAR2 DEFAULT NULL,

icon_name IN VARCHAR2 DEFAULT NULL,

language_code IN VARCHAR2 DEFAULT ’US’);

Use this procedure to define a concurrent program executable. This procedure corresponds to the ”Concurrent Program Executable” window accessible from the System Administrator and Application Developer responsibilities.

Arguments (input)

executable Name of executable (for example, ’FNDSCRMT’).

application The short name of the executable’s application, for example, ’FND’.

description Optional description of the executable.

execution_method The type of program this executable uses. Possible values are ’Host’, ’Immediate’, ’Oracle Reports’, ’PL/SQL Stored Procedure’, ’Spawned’,

’SQL*Loader’, ’SQL*Plus’.

execution_file_name The operating system name of the file. Required for all but Immediate programs. This file name should not include spaces or periods unless the file

is a PL/SQL stored procedure.

subroutine_name Used only by Immediate programs. Cannot contain spaces or periods.

icon_name Reserved for future use by internal developers

only. Specify NULL.

language_code

Language code for the name and description, for example, ’US’.

FND ALL BASE TABLES

User

FND_USER

Responsibility

FND_RESPONSIBILITY

Menu Group

FND_MENUS

Data Group

FND_DATA_GROUPS

Request Group

FND_REQUEST_GROUP

Relations

FND_USER_RESP_GROUPS_ALL

Expired Users

FND_USER_RESP_GROUPS_OLD

Business Group

HR_ORGANIZATION_UNITS

Locations

HR_LOCATIONS

Currencies

FND_CURRENCIES

Periods

GL_PERIODS

Periods Types

GL_PERIODS_TYPES

Periods Sets

GL_PERIODS_SETS

Chart Of Account

FND_ID_FLEX_STRUCTURES

Segments

FND_ID_FLEX_SEGMENTS

Value Sets

FND_FLEX_VALUE_SETS

FND_FLEX_VALUES

Set Of Books

GL_SETS_OF_BOOKS

Legal Entity

HR_LEGAL_ENTITIES

Operating Units

HR_OPERATING_UNITS

Inventory

MTL_PARAMETERSORG_ORGANIZATION_DEFINITIONS

API’s

Menu and Toolbar Control: Use the APP_SPECIAL package to enable and customize menu entries and buttons on the toolbar.

APP_SPECIAL

APP_SPECIAL.INSTANTIATE

APP_SPECIAL.ENABLE

Calendar Package: For coding calendars into your forms. CALENDAR:

CALENDAR.SHOW

CALENDAR.SETUP

CALENDAR.EVENT

Function Security APIs for PL/SQL Procedures

FND_FUNCTION.TEST

FND_FUNCTION.QUERY

FND_FUNCTION.EXECUTE

FND_FUNCTION.USER_FUNCTION_NAME

FND_FUNCTION.CURRENT_FORM_FUNCTION

Message Dictionary APIs for PL/SQL Procedures

FND_MESSAGE.CLEAR

FND_MESSAGE.DEBUG

FND_MESSAGE.ERASE

FND_MESSAGE.ERROR

FND_MESSAGE.GET

FND_MESSAGE.HINT

FND_MESSAGE.QUESTION

FND_MESSAGE.RETRIEVE

FND_MESSAGE.SET_NAME

FND_MESSAGE.SET_STRING

FND_MESSAGE.SET_TOKEN

FND_MESSAGE.SHOW

FND_MESSAGE.WARN

FND_PROFILE: User Profile APIs

FND_PROFILE.PUT

FND_PROFILE.GET

FND_PROFILE.VALUE

User Exits Used in Oracle Reports

FND SRWINIT: Sets your profile option values and allows Oracle Application Object Library user exits to detect that they have been called by an Oracle Reports program.

FND SRWEXIT: Ensures that all the memory allocated for Oracle Application Object Library user exits has been freed up properly.

FND FLEXIDVAL}: These user exits allow you to use flexfields in your reports.

FND FLEXSQL}

Concurrent Processing APIs for PL/SQL Procedures

FND_CONC_GLOBAL Package

FND_CONC_GLOBAL.REQUEST_DATA

FND_CONC_GLOBAL.SET_REQ_GLOBALS

FND_CONCURRENT Package

FND_CONCURRENT.AF_COMMIT

FND_CONCURRENT.AF_ROLLBACK

FND_CONCURRENT.GET_REQUEST_STATUS

FND_CONCURRENT.WAIT_FOR_REQUEST

FND_CONCURRENT.SET_COMPLETION_STATUS

FND_FILE: PL/SQL File I/O

FND_FILE.PUT

FND_FILE.PUT_LINE

FND_FILE.NEW_LINE

FND_FILE.PUT_NAMES

FND_FILE.CLOSE

FND_PROGRAM: Concurrent Program Loaders

FND_PROGRAM.MESSAGE

FND_PROGRAM.EXECUTABLE

FND_PROGRAM.DELETE_EXECUTABLE

FND_PROGRAM.REGISTER

FND_PROGRAM.DELETE_PROGRAM

FND_PROGRAM.PARAMETER

FND_PROGRAM.DELETE_PARAMETER

FND_PROGRAM.INCOMPATIBILITY

FND_PROGRAM.DELETE_INCOMPATIBILITY

FND_PROGRAM.REQUEST_GROUP

FND_PROGRAM.DELETE_GROUP

FND_PROGRAM.ADD_TO_GROUP

FND_PROGRAM.REMOVE_FROM_GROUP

FND_PROGRAM.PROGRAM_EXISTS

FND_PROGRAM.PARAMETER_EXISTS

FND_PROGRAM.INCOMPATIBILITY_EXISTS

FND_PROGRAM.EXECUTABLE_EXISTS

FND_PROGRAM.REQUEST_GROUP_EXISTS

FND_PROGRAM.PROGRAM_IN_GROUP

FND_PROGRAM.ENABLE_PROGRAM

FND_REQUEST Package

FND_REQUEST.SET_OPTIONS (Client or Server)

FND_REQUEST.SET_REPEAT_OPTIONS

FND_REQUEST.SET_PRINT_OPTIONS

FND_REQUEST.SUBMIT_REQUEST (Client or Server)

FND_REQUEST.SET_MODE (Server)

FND_REQUEST_INFO and MLS Language Support

FND_REQUEST_INFO.GET_PARAM_NUMBER

FND_REQUEST_INFO.GET_PARAM_INFO

FND_REQUEST_INFO.GET_PROGRAM

FND_REQUEST_INFO.GET_PARAMETER

FND_SET: Request Set Loaders

FND_SET.MESSAGE

FND_SET.CREATE_SET

FND_SET.DELETE_SET

FND_SET.ADD_PROGRAM

FND_SET.REMOVE_PROGRAM

FND_SET.PROGRAM_PARAMETER

FND_SET.DELETE_PROGRAM_PARAMETER

FND_SET.ADD_STAGE

FND_SET.REMOVE_STAGE

FND_SET.LINK_STAGES

FND_SET.INCOMPATIBILITY

FND_SET.DELETE_INCOMPATIBILITY

FND_SET.ADD_SET_TO_GROUP

FND_SET.REMOVE_SET_FROM_GROUP

FND_SUBMIT: Request Set Submission

FND_SUBMIT.SET_MODE

FND_SUBMIT.SET_REL_CLASS_OPTIONS

FND_SUBMIT.SET_REPEAT_OPTIONS

FND_SUBMIT_SET.REQUEST_SET

FND_SUBMIT.SET_PRINT_OPTIONS

FND_SUBMIT.ADD_PRINTER

FND_SUBMIT.ADD_NOTIFICATION

FND_SUBMIT.SET_NLS_OPTIONS

FND_SUBMIT.SUBMIT_PROGRAM

FND_SUBMIT.SUBMIT_SET

CUSTOM Package

CUSTOM.ZOOM_AVAILABLE

CUSTOM.STYLE

CUSTOM.EVENT

APP_COMBO: Combination Block

APP_COMBO.KEY_PREV_ITEM

APP_DATE and FND_DATE

APP_DATE.CANONICAL_TO_DATE and FND_DATE.CANONICAL_TO_DATE

APP_DATE.DISPLAYDATE_TO_DATE and FND_DATE.DISPLAYDATE_TO_DATE

APP_DATE.DISPLAYDT_TO_DATE and FND_DATE.DISPLAYDT_TO_DATE

APP_DATE.DATE_TO_CANONICAL and FND_DATE.DATE_TO_CANONICAL

APP_DATE.DATE_TO_DISPLAYDATE and FND_DATE.DATE_TO_DISPLAYDATE

APP_DATE.DATE_TO_DISPLAYDT and FND_DATE.DATE_TO_DISPLAYDT

APP_DATE.DATE_TO_FIELD

APP_DATE.FIELD_TO_DATE

APP_DATE.VALIDATE_CHARDATE

APP_DATE.VALIDATE_CHARDT

FND_DATE.STRING_TO_DATE

FND_DATE.STRING_TO_CANONICAL

APP_EXCEPTION: Exception Processing APIs

APP_EXCEPTION.RAISE_EXCEPTION

APP_EXCEPTION.RETRIEVE

APP_EXCEPTION.GET_TYPE

APP_EXCEPTION.GET_CODE

APP_EXCEPTION.GET_TEXT

APP_EXCEPTION.RECORD_LOCK_EXCEPTION

APP_EXCEPTION.RECORD_LOCK_ERROR

APP_EXCEPTION.DISABLED

APP_FIELD: Item Relationship Utilities

APP_FIELD.CLEAR_FIELDS

APP_FIELD.CLEAR_DEPENDENT_FIELDS

APP_FIELD.SET_DEPENDENT_FIELD

APP_FIELD.SET_EXCLUSIVE_FIELD

APP_FIELD.SET_INCLUSIVE_FIELD

APP_FIELD.SET_REQUIRED_FIELD

APP_FIND: Query Find Utilities

APP_FIND.NEW

APP_FIND.CLEAR

APP_FIND.CLEAR_DETAIL

APP_FIND.FIND

APP_FIND.QUERY_RANGE

APP_FIND.QUERY_FIND

APP_ITEM: Individual Item Utilities

APP_ITEM.COPY_DATE

APP_ITEM.IS_VALID

APP_ITEM.SIZE_WIDGET

APP_ITEM_PROPERTY: Property Utilities

APP_ITEM_PROPERTY.GET_PROPERTY

APP_ITEM_PROPERTY.SET_PROPERTY

APP_ITEM_PROPERTY.SET_VISUAL_ATTRIBUTE

APP_NAVIGATE: Open a Form Function

APP_NAVIGATE.EXECUTE

APP_RECORD: Record Utilities

APP_RECORD.TOUCH_RECORD

APP_RECORD.HIGHLIGHT

APP_RECORD.FOR_ALL_RECORDS

APP_RECORD.DELETE_ROW

APP_RECORD.VALIDATE_RANGE

APP_REGION: Region Utilities

APP_REGION.ALT_REGION

APP_STANDARD Package

APP_STANDARD.APP_VALIDATE

APP_STANDARD.EVENT

APP_STANDARD.SYNCHRONIZE

APP_STANDARD.PLATFORM

APP_WINDOW: Window Utilities

APP_WINDOW.CLOSE_FIRST_WINDOW

APP_WINDOW.PROGRESS

APP_WINDOW.SET_COORDINATION

APP_WINDOW.SET_WINDOW_POSITION

APP_WINDOW.SET_TITLE

FNDSQF Routine APIs

FND_CURRENCY: Dynamic Currency APIs

FND_CURRENCY.GET_FORMAT_MASK

FND_DATE: Date Conversion APIs

FND_GLOBAL: WHO Column Maintenance and Database Initialization

FND_GLOBAL.USER_ID (Server)

FND_GLOBAL.APPS_INITIALIZE (Server)

FND_GLOBAL.LOGIN_ID (Server)

FND_GLOBAL.CONC_LOGIN_ID (Server)

FND_GLOBAL.PROG_APPL_ID (Server)

FND_GLOBAL.CONC_PROGRAM_ID (Server)

FND_GLOBAL.CONC_REQUEST_ID (Server)

FND_ORG: Organization APIs

FND_ORG.CHANGE_LOCAL_ORG

FND_ORG.CHANGE_GLOBAL_ORG

FND_ORG.CHOOSE_ORG

FND_STANDARD: Standard APIs

FND_STANDARD.FORM_INFO

FND_STANDARD.SET_WHO

FND_STANDARD.SYSTEM_DATE

FND_STANDARD.USER

FND_UTILITIES: Utility Routines

FND_UTILITIES.OPEN_URL

FND_UTILITIES.PARAM_EXISTS

The following concurrent processing packages are covered:

FND_CONCURRENT: Information on Submitted Requests

FND_CONCURRENT.AF_COMMIT is used by concurrent programs that use a particular rollback segment. This rollback segment must be defined in the Define Concurrent Program form.

FND_CONCURRENT.AF_ROLLBACK is used by concurrent programs that use a particular rollback segment. This rollback segment must be defined in the Define Concurrent Program form.

FND_CONCURRENT.GET_REQUEST_STATUS :Returns the status of a concurrent request.

FND_FILE: PL/SQL: File I/O : The FND_FILE package contains procedures to write text to log and output files. For testing and debugging, you can use the procedures FND_FILE.PUT_NAMES and FND_FILE.CLOSE.

FND_FILE.PUT : Use this procedure to write text to a file.

FND_FILE.PUT_LINE : Use this procedure to write a line of text to a file

FND_FILE.NEW_LINE : Use this procedure to write line terminators

FND_FILE.PUT_NAMES : Sets the temporary log and out filenames and the temp directory to the user–specified values.

FND_FILE.CLOSE : Use this procedure to close open files.

FND_PROGRAM: Concurrent Program Loaders - The FND_PROGRAM package includes procedures for creating concurrent program executables, concurrent programs with parameters and incompatibility rules, request sets, and request groups.

FND_PROGRAM.MESSAGE : Use the message function to return an error message.

FND_PROGRAM.EXECUTABLE : Use this procedure to define a concurrent program executable.

FND_PROGRAM.DELETE_EXECUTABLE : Use this procedure to delete a concurrent program executable.

FND_PROGRAM.REGISTER : Use this procedure to define a concurrent program.

FND_PROGRAM.DELETE_PROGRAM : Use this procedure to delete a concurrent program.

FND_PROGRAM.REQUEST_GROUP : Use this procedure to create a new request group.

FND_PROGRAM.ENABLE_PROGRAM : Use this procedure to enable or disable a concurrent program.

FND_SET: Request Set Creation : The FND_SET package includes procedures for creating concurrent program request sets, adding programs to a request set, deleting programs from a request set. and defining parameters for request sets.

FND_SET.CREATE_SET : Use this procedure to register a Request Set.

FND_SET.DELETE_SET : Use this procedure to delete a request set and references to that set.

FND_SET.ADD_PROGRAM : Use this procedure to add a concurrent program to a request set stage.

FND_REQUEST: Concurrent Program Submission :

FND_REQUEST.SUBMIT_REQUEST (Client or Server) : Submits a concurrent request for processing by a concurrent manager.

FND_REQUEST_INFO: Request Information : FND_REQUEST_INFO APIs can be used in MLS Language functions to get information for a request. A user can submit a single request for a concurrent program and have that program run several times, each time in a different language. An MLS function determines which language in which a request should run.

FND_SUBMIT: For Request Set Submission

FND_SUBMIT.SET_MODE : Use this optional procedure to set the mode if the request set is submitted from a database trigger.

FND_SUBMIT.SUBMIT_SET : Call this function to submit the request set

HOW TO find a concurrent program's trace file

ACCEPT request prompt 'Please enter the concurrent request id for the appropriate concurrent program:'

prompt

COLUMN traceid format a8

COLUMN tracename format a80

COLUMN user_concurrent_program_name format a40

COLUMN execname format a15

COLUMN enable_trace format a12

SET lines 80

SET pages 22

SET head OFF