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
0 comments:
Post a Comment