DBA Data[Home] [Help]

APPS.GMDRPLAP_WF_PKG dependencies on FND_PROFILE

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

17: l_runform VARCHAR2(100);
18: l_performer_name FND_USER.USER_NAME%TYPE ;
19: l_performer_display_name FND_USER.DESCRIPTION%TYPE ;
20:
21: l_wf_timeout NUMBER := TO_NUMBER(FND_PROFILE.VALUE ('GMD_WF_TIMEOUT'));
22:
23: /* Mercy Thomas Bug 3173515 Added the following variables for the NPD workflow changes */
24: l_recipe_description GMD_RECIPES.RECIPE_DESCRIPTION%TYPE;
25: l_owner_id GMD_RECIPES.OWNER_ID%TYPE;

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

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