APPS.GMDRVTRG_UPDATE_WF dependencies on GMA_WFSTD_P

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

22:
23: begin
24: /* $Header: GMDRVTRG.sql 120.2 2006/03/08 23:14:22 kshukla noship $ */
25: IF ((:new.VALIDITY_RULE_STATUS between 400 and 499) AND
26: gma_wfstd_p.check_process_enabled(P_LAB_WF_ITEM_TYPE,P_LAB_PROCESS_NAME))
27: THEN
28: gma_wfstd_p.WF_GET_CONTORL_PARAMS(P_LAB_WF_ITEM_TYPE,
29: P_LAB_PROCESS_NAME,
30: null, -- Activity Name

Line 28: gma_wfstd_p.WF_GET_CONTORL_PARAMS(P_LAB_WF_ITEM_TYPE,

24: /* $Header: GMDRVTRG.sql 120.2 2006/03/08 23:14:22 kshukla noship $ */
25: IF ((:new.VALIDITY_RULE_STATUS between 400 and 499) AND
26: gma_wfstd_p.check_process_enabled(P_LAB_WF_ITEM_TYPE,P_LAB_PROCESS_NAME))
27: THEN
28: gma_wfstd_p.WF_GET_CONTORL_PARAMS(P_LAB_WF_ITEM_TYPE,
29: P_LAB_PROCESS_NAME,
30: null, -- Activity Name
31: P_TABLE_NAME,
32: P_WHERE_CLAUSE,

Line 35: IF gma_wfstd_p.check_process_approval_req(p_lab_wf_item_type,

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

Line 50: 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))

46: where :old.VALIDITY_RULE_STATUS = current_status and
47: :new.VALIDITY_RULE_STATUS = Target_status and
48: pending_status IS NOT NULL;
49: END IF;
50: 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))
51: THEN
52: gma_wfstd_p.WF_GET_CONTORL_PARAMS(P_GEN_WF_ITEM_TYPE,
53: P_GEN_PROCESS_NAME,
54: null, -- Activity Name

Line 52: gma_wfstd_p.WF_GET_CONTORL_PARAMS(P_GEN_WF_ITEM_TYPE,

48: pending_status IS NOT NULL;
49: END IF;
50: 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))
51: THEN
52: gma_wfstd_p.WF_GET_CONTORL_PARAMS(P_GEN_WF_ITEM_TYPE,
53: P_GEN_PROCESS_NAME,
54: null, -- Activity Name
55: P_TABLE_NAME,
56: P_WHERE_CLAUSE,

Line 59: IF gma_wfstd_p.check_process_approval_req(p_gen_wf_item_type,

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