DBA Data[Home] [Help]

APPS.GMDOPGAP_WF_PKG dependencies on FND_PROFILE

Line 34: l_wf_timeout NUMBER := TO_NUMBER(FND_PROFILE.VALUE ('GMD_WF_TIMEOUT'));

30: to prevent SAVEPOINT/ROLLBACK error (see Workflow FAQ)
31: the value to use for this is -1 */
32:
33: l_run_wf_in_background CONSTANT WF_ENGINE.THRESHOLD%TYPE := -1;
34: l_wf_timeout NUMBER := TO_NUMBER(FND_PROFILE.VALUE ('GMD_WF_TIMEOUT'));
35:
36:
37: l_WorkflowProcess VARCHAR2(30) := 'GMDOPGAP_PROCESS';
38: l_count NUMBER;

Line 162: l_delimiter VARCHAR2(15) := FND_PROFILE.VALUE ('SY$WF_DELIMITER');

158: P_table_name VARCHAR2(32) := 'GMD_OPERATIONS_B'; -- Key Table
159: P_where_clause VARCHAR2(100):= ' GMD_OPERATIONS_B.OPRN_ID='||l_OPERATION_ID; -- Where clause to be appended
160: p_role GMA_ACTDATA_WF.ROLE%TYPE;
161: l_data_string VARCHAR2(2000);
162: l_delimiter VARCHAR2(15) := FND_PROFILE.VALUE ('SY$WF_DELIMITER');
163: l_target_status GMD_STATUS_NEXT.TARGET_STATUS%TYPE;
164: BEGIN
165:
166: IF (p_funcmode = 'RUN') THEN