DBA Data[Home] [Help]

APPS.GMDRVGAP_WF_PKG dependencies on FND_PROFILE

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

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

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

195: P_table_name VARCHAR2(32) := 'GMD_RECIPE_VALIDITY_RULES'; -- Key Table
196: P_where_clause VARCHAR2(100) ;
197: p_role GMA_ACTDATA_WF.ROLE%TYPE;
198: l_data_string VARCHAR2(2000);
199: l_delimiter VARCHAR2(15) := FND_PROFILE.VALUE ('SY$WF_DELIMITER');
200: l_target_status GMD_STATUS_NEXT.TARGET_STATUS%TYPE;
201: BEGIN
202: l_recipe_validity_rule_id:=wf_engine.getitemattrnumber(p_itemtype, p_itemkey,'GMDRVGAP_RECIPE_VALIDITYRULEID');
203: -- Bug# 5030408 Kapil M : Removed the table name