APPS.GMDRVTRG_UPDATE_WF dependencies on GMA_WFSTD_P

Line 25: gma_wfstd_p.check_process_enabled(P_LAB_WF_ITEM_TYPE,P_LAB_PROCESS_NAME))

21:
22: begin
23: /* $Header: GMDRVTRG.sql 120.3 2011/03/07 19:37:17 plowe ship $ */
24: IF ((:new.VALIDITY_RULE_STATUS between 400 and 499) AND
25: gma_wfstd_p.check_process_enabled(P_LAB_WF_ITEM_TYPE,P_LAB_PROCESS_NAME))
26: THEN
27: gma_wfstd_p.WF_GET_CONTORL_PARAMS(P_LAB_WF_ITEM_TYPE,
28: P_LAB_PROCESS_NAME,
29: null, -- Activity Name

Line 27: gma_wfstd_p.WF_GET_CONTORL_PARAMS(P_LAB_WF_ITEM_TYPE,

23: /* $Header: GMDRVTRG.sql 120.3 2011/03/07 19:37:17 plowe ship $ */
24: IF ((:new.VALIDITY_RULE_STATUS between 400 and 499) AND
25: gma_wfstd_p.check_process_enabled(P_LAB_WF_ITEM_TYPE,P_LAB_PROCESS_NAME))
26: THEN
27: gma_wfstd_p.WF_GET_CONTORL_PARAMS(P_LAB_WF_ITEM_TYPE,
28: P_LAB_PROCESS_NAME,
29: null, -- Activity Name
30: P_TABLE_NAME,
31: P_WHERE_CLAUSE,

Line 34: IF gma_wfstd_p.check_process_approval_req(p_lab_wf_item_type,

30: P_TABLE_NAME,
31: P_WHERE_CLAUSE,
32: P_DATA_STRING,
33: p_wf_data_string);
34: IF gma_wfstd_p.check_process_approval_req(p_lab_wf_item_type,
35: p_lab_process_name,
36: p_data_string) = 'Y' THEN
37: gmdrvlap_wf_pkg.wf_init(:new.recipe_validity_rule_id,
38: :new.recipe_id,

Line 49: ELSIF ((:new.VALIDITY_RULE_STATUS between 700 and 799) AND gma_wfstd_p.check_process_enabled(P_GEN_WF_ITEM_TYPE,P_GEN_PROCESS_NAME))

45: where :old.VALIDITY_RULE_STATUS = current_status and
46: :new.VALIDITY_RULE_STATUS = Target_status and
47: pending_status IS NOT NULL;
48: END IF;
49: ELSIF ((:new.VALIDITY_RULE_STATUS between 700 and 799) AND gma_wfstd_p.check_process_enabled(P_GEN_WF_ITEM_TYPE,P_GEN_PROCESS_NAME))
50: THEN
51: gma_wfstd_p.WF_GET_CONTORL_PARAMS(P_GEN_WF_ITEM_TYPE,
52: P_GEN_PROCESS_NAME,
53: null, -- Activity Name

Line 51: gma_wfstd_p.WF_GET_CONTORL_PARAMS(P_GEN_WF_ITEM_TYPE,

47: pending_status IS NOT NULL;
48: END IF;
49: ELSIF ((:new.VALIDITY_RULE_STATUS between 700 and 799) AND gma_wfstd_p.check_process_enabled(P_GEN_WF_ITEM_TYPE,P_GEN_PROCESS_NAME))
50: THEN
51: gma_wfstd_p.WF_GET_CONTORL_PARAMS(P_GEN_WF_ITEM_TYPE,
52: P_GEN_PROCESS_NAME,
53: null, -- Activity Name
54: P_TABLE_NAME,
55: P_WHERE_CLAUSE,

Line 58: IF gma_wfstd_p.check_process_approval_req(p_gen_wf_item_type,

54: P_TABLE_NAME,
55: P_WHERE_CLAUSE,
56: P_DATA_STRING,
57: p_wf_data_string);
58: IF gma_wfstd_p.check_process_approval_req(p_gen_wf_item_type,
59: p_gen_process_name,
60: p_data_string) = 'Y' THEN
61: gmdrvgap_wf_pkg.wf_init(:new.recipe_validity_rule_id,
62: :new.recipe_id,