DBA Data[Home] [Help]

APPS.ZPB_AC_OPS dependencies on ZPB_WF

Line 48: -- abudnik 07DEC2005 BUSINESS AREA ID to call for ZPB_WF_DELAWINST

44:
45: begin
46:
47:
48: -- abudnik 07DEC2005 BUSINESS AREA ID to call for ZPB_WF_DELAWINST
49: select BUSINESS_AREA_ID
50: into l_business_area_id
51: from ZPB_ANALYSIS_CYCLES
52: where ANALYSIS_CYCLE_ID = p_acid;

Line 100: -- abudnik 07DEC2005 BUSINESS AREA ID to call for ZPB_WF_DELAWINST

96: end;
97:
98:
99: -- submit the ZPB AW DELETE
100: -- abudnik 07DEC2005 BUSINESS AREA ID to call for ZPB_WF_DELAWINST
101: l_REQID := FND_REQUEST.SUBMIT_REQUEST ('ZPB', 'ZPB_WF_DELAWINST', NULL, NULL, FALSE, l_instanceID, l_ownerid, l_business_area_id);
102:
103: -- now that the instance has been cleaned, set its last task to completed
104: -- in order to allow cleaning of the current instance of the BP

Line 101: l_REQID := FND_REQUEST.SUBMIT_REQUEST ('ZPB', 'ZPB_WF_DELAWINST', NULL, NULL, FALSE, l_instanceID, l_ownerid, l_business_area_id);

97:
98:
99: -- submit the ZPB AW DELETE
100: -- abudnik 07DEC2005 BUSINESS AREA ID to call for ZPB_WF_DELAWINST
101: l_REQID := FND_REQUEST.SUBMIT_REQUEST ('ZPB', 'ZPB_WF_DELAWINST', NULL, NULL, FALSE, l_instanceID, l_ownerid, l_business_area_id);
102:
103: -- now that the instance has been cleaned, set its last task to completed
104: -- in order to allow cleaning of the current instance of the BP
105: update zpb_analysis_cycle_tasks

Line 1794: -- abudnik 07DEC2005 BUSINESS AREA ID added for ZPB_WF_DELAWINST

1790: l_business_area_id number;
1791:
1792: BEGIN
1793:
1794: -- abudnik 07DEC2005 BUSINESS AREA ID added for ZPB_WF_DELAWINST
1795: select published_by, BUSINESS_AREA_ID into ownerid, l_business_area_id
1796: from zpb_analysis_cycles
1797: where analysis_cycle_id = ac_id_in;
1798:

Line 1832: zpb_wf_ntf.notify_on_delete(ac_id_in, 'ACID');

1828: * any events on which other cycles were dependent. If so, then
1829: * notify the users who are the owners of the dependent cycles.
1830: */
1831: IF cycle_type = 'PUBLISHED' THEN
1832: zpb_wf_ntf.notify_on_delete(ac_id_in, 'ACID');
1833:
1834: SELECT tmp_ac_id into tmp_ac_id
1835: FROM zpb_cycle_relationships
1836: WHERE published_ac_id = ac_id_in;

Line 1842: ZPB_WF.CallWFAbort(ac_id_in);

1838: SELECT editable_ac_id into edit_ac_id
1839: FROM zpb_cycle_relationships
1840: WHERE published_ac_id = ac_id_in;
1841:
1842: ZPB_WF.CallWFAbort(ac_id_in);
1843:
1844: END IF;
1845:
1846: /*

Line 1911: -- abudnik 07DEC2005 BUSINESS AREA ID added for ZPB_WF_DELAWINST

1907: LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID
1908: WHERE analysis_cycle_id = instance_rec.instance_ac_id;
1909:
1910: -- Clean up the measure for
1911: -- abudnik 07DEC2005 BUSINESS AREA ID added for ZPB_WF_DELAWINST
1912: l_REQID := FND_REQUEST.SUBMIT_REQUEST ('ZPB', 'ZPB_WF_DELAWINST', NULL, NULL, FALSE, instance_rec.instance_ac_id, ownerid, l_business_area_id);
1913:
1914: /*
1915: IF instance_rec.current_instance_id IS NOT NULL THEN

Line 1912: l_REQID := FND_REQUEST.SUBMIT_REQUEST ('ZPB', 'ZPB_WF_DELAWINST', NULL, NULL, FALSE, instance_rec.instance_ac_id, ownerid, l_business_area_id);

1908: WHERE analysis_cycle_id = instance_rec.instance_ac_id;
1909:
1910: -- Clean up the measure for
1911: -- abudnik 07DEC2005 BUSINESS AREA ID added for ZPB_WF_DELAWINST
1912: l_REQID := FND_REQUEST.SUBMIT_REQUEST ('ZPB', 'ZPB_WF_DELAWINST', NULL, NULL, FALSE, instance_rec.instance_ac_id, ownerid, l_business_area_id);
1913:
1914: /*
1915: IF instance_rec.current_instance_id IS NOT NULL THEN
1916: l_REQID2 := FND_REQUEST.SUBMIT_REQUEST ('ZPB', 'ZPB_WF_DELAWINST', NULL, NULL, FALSE, instance_rec.current_instance_id, ownerid);

Line 1916: l_REQID2 := FND_REQUEST.SUBMIT_REQUEST ('ZPB', 'ZPB_WF_DELAWINST', NULL, NULL, FALSE, instance_rec.current_instance_id, ownerid);

1912: l_REQID := FND_REQUEST.SUBMIT_REQUEST ('ZPB', 'ZPB_WF_DELAWINST', NULL, NULL, FALSE, instance_rec.instance_ac_id, ownerid, l_business_area_id);
1913:
1914: /*
1915: IF instance_rec.current_instance_id IS NOT NULL THEN
1916: l_REQID2 := FND_REQUEST.SUBMIT_REQUEST ('ZPB', 'ZPB_WF_DELAWINST', NULL, NULL, FALSE, instance_rec.current_instance_id, ownerid);
1917: END IF;
1918: */
1919:
1920: -- now delete any Data Collection templates

Line 1949: ZPB_WF.DeleteCurrInstMeas(ac_id_in, ownerid);

1945: and ac.analysis_cycle_id=aci.instance_ac_id
1946: and ac.status_code NOT IN ('COMPLETE','ERROR','COMPLETE_WITH_WARNING'));
1947:
1948: -- Clean up Current Instance Measure if Appropriate
1949: ZPB_WF.DeleteCurrInstMeas(ac_id_in, ownerid);
1950:
1951: -- now delete any Data Collection templates
1952: -- associated with this cycle
1953: zpb_dc_objects_pvt.delete_template(

Line 2115: zpb_wf.enable_cycle(pet_row_rec.published_ac_id, enable_option);

2111: if publish_options_in = 'UPDATE_FOR_FUTURE' then
2112: enable_option:= 'ENABLE_NEXT';
2113: end if;
2114:
2115: zpb_wf.enable_cycle(pet_row_rec.published_ac_id, enable_option);
2116: end if;
2117:
2118:
2119: --

Line 2240: zpb_wf_event.acstart_event( acid => editable_ac_id_in

2236:
2237: --BPEXT
2238: --update the horizon params if this is a ext published
2239: IF (p_external = 'Y') THEN
2240: zpb_wf_event.acstart_event( acid => editable_ac_id_in
2241: , p_start_mem => p_start_mem_in
2242: , p_end_mem => p_end_mem_in
2243: , p_send_date => p_send_date_in
2244: , x_event_key => x_item_key_out);

Line 2247: zpb_wf.acstart(editable_ac_id_in, published_before);

2243: , p_send_date => p_send_date_in
2244: , x_event_key => x_item_key_out);
2245: ELSE
2246:
2247: zpb_wf.acstart(editable_ac_id_in, published_before);
2248: END IF;
2249:
2250: published_ac_id_out := editable_ac_id_in;
2251: END publish_cycle;

Line 2426: -- simple wrapper around the zpb_wf procedure of the same name

2422: enable_status_in IN VARCHAR2)
2423: IS
2424: BEGIN
2425:
2426: -- simple wrapper around the zpb_wf procedure of the same name
2427: zpb_wf.enable_cycle(ac_id_in, enable_status_in);
2428:
2429: END enable_cycle;
2430:

Line 2427: zpb_wf.enable_cycle(ac_id_in, enable_status_in);

2423: IS
2424: BEGIN
2425:
2426: -- simple wrapper around the zpb_wf procedure of the same name
2427: zpb_wf.enable_cycle(ac_id_in, enable_status_in);
2428:
2429: END enable_cycle;
2430:
2431: /*