Wednesday, March 30, 2011

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:

About This Blog

  © Blogger templates The Professional Template by Ourblogtemplates.com 2008

Back to TOP