DBA Data[Home] [Help]

APPS.GMDOPTRG_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: GMDOPTRG.sql 120.2 2011/03/02 19:58:26 plowe ship $ */
24: IF ((:new.operation_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: GMDOPTRG.sql 120.2 2011/03/02 19:58:26 plowe ship $ */
24: IF ((:new.operation_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: gmdoplap_wf_pkg.wf_init(:new.oprn_id,
38: :new.oprn_no,

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

46: where :old.operation_status = current_status and
47: :new.operation_status = Target_status and
48: pending_status IS NOT NULL;
49: END IF;
50: ELSIF ((:new.operation_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.operation_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: gmdopgap_wf_pkg.wf_init(:new.oprn_id,
63: :new.oprn_no,