DBA Data[Home] [Help]

APPS.GMDRTGAP_WF_PKG dependencies on FND_PROFILE

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

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

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

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