APPS.GMDRPTRG_UPDATE_WF dependencies on GMA_WFSTD_P

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

23:
24: begin
25: /* $Header: GMDRPTRG.sql 120.1 2005/06/09 05:02:26 appldev $ */
26: IF ((:new.recipe_status between 400 and 499) AND
27: gma_wfstd_p.check_process_enabled(P_LAB_WF_ITEM_TYPE,P_LAB_PROCESS_NAME))
28: THEN
29: gma_wfstd_p.WF_GET_CONTORL_PARAMS(P_LAB_WF_ITEM_TYPE,
30: P_LAB_PROCESS_NAME,
31: null, -- Activity Name

Line 29: gma_wfstd_p.WF_GET_CONTORL_PARAMS(P_LAB_WF_ITEM_TYPE,

25: /* $Header: GMDRPTRG.sql 120.1 2005/06/09 05:02:26 appldev $ */
26: IF ((:new.recipe_status between 400 and 499) AND
27: gma_wfstd_p.check_process_enabled(P_LAB_WF_ITEM_TYPE,P_LAB_PROCESS_NAME))
28: THEN
29: gma_wfstd_p.WF_GET_CONTORL_PARAMS(P_LAB_WF_ITEM_TYPE,
30: P_LAB_PROCESS_NAME,
31: null, -- Activity Name
32: P_TABLE_NAME,
33: P_WHERE_CLAUSE,

Line 36: IF gma_wfstd_p.check_process_approval_req(p_lab_wf_item_type,

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

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

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

Line 54: gma_wfstd_p.WF_GET_CONTORL_PARAMS(P_GEN_WF_ITEM_TYPE,

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

Line 61: IF gma_wfstd_p.check_process_approval_req(p_gen_wf_item_type,

57: P_TABLE_NAME,
58: P_WHERE_CLAUSE,
59: P_DATA_STRING,
60: p_wf_data_string);
61: IF gma_wfstd_p.check_process_approval_req(p_gen_wf_item_type,
62: p_gen_process_name,
63: p_data_string) = 'Y' THEN
64: gmdrpgap_wf_pkg.wf_init(:new.recipe_id,
65: :new.recipe_no,