APPS.GMDFMTRG_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: GMDFMTRG.sql 120.2 2011/02/04 17:42:29 plowe ship $ */
25: IF ((:new.formula_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: GMDFMTRG.sql 120.2 2011/02/04 17:42:29 plowe ship $ */
25: IF ((:new.formula_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: gmdfmlap_wf_pkg.wf_init(:new.formula_id,
39: :new.formula_no,

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

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

Line 53: gma_wfstd_p.WF_GET_CONTORL_PARAMS(P_GEN_WF_ITEM_TYPE,

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

Line 60: IF gma_wfstd_p.check_process_approval_req(p_gen_wf_item_type,

56: P_TABLE_NAME,
57: P_WHERE_CLAUSE,
58: P_DATA_STRING,
59: p_wf_data_string);
60: IF gma_wfstd_p.check_process_approval_req(p_gen_wf_item_type,
61: p_gen_process_name,
62: p_data_string) = 'Y' THEN
63: gmdfmgap_wf_pkg.wf_init(:new.formula_id,
64: :new.formula_no,