DBA Data[Home] [Help]

APPS.GMDRPGAP_WF_PKG dependencies on FND_PROFILE

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

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

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

185: P_table_name VARCHAR2(32) := 'GMD_RECIPES_B'; -- Key Table
186: P_where_clause VARCHAR2(100):= ' GMD_RECIPES_B.RECIPE_ID='||l_RECIPE_ID; -- Where clause to be appended
187: p_role GMA_ACTDATA_WF.ROLE%TYPE;
188: l_data_string VARCHAR2(2000);
189: l_delimiter VARCHAR2(15) := FND_PROFILE.VALUE ('SY$WF_DELIMITER');
190: l_target_status GMD_STATUS_NEXT.TARGET_STATUS%TYPE;
191:
192: BEGIN
193: IF (p_funcmode = 'RUN') THEN