DBA Data[Home] [Help]

APPS.GMDRTLAP_WF_PKG dependencies on FND_PROFILE

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

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

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

172: P_table_name VARCHAR2(32) := 'GMD_ROUTINGS_B'; -- Key Table
173: P_where_clause VARCHAR2(100):= ' gmd_routings_b.ROUTING_ID='||l_ROUTING_ID; -- Where clause to be appended
174: p_role GMA_ACTDATA_WF.ROLE%TYPE;
175: l_data_string VARCHAR2(2000);
176: l_delimiter VARCHAR2(15) := FND_PROFILE.VALUE ('SY$WF_DELIMITER');
177: l_target_status GMD_STATUS_NEXT.TARGET_STATUS%TYPE;
178: BEGIN
179:
180: IF (p_funcmode = 'RUN') THEN