1 PACKAGE PO_SUPPLY AS
2 /* $Header: RCVRCSUS.pls 120.2.12010000.1 2008/07/24 14:36:36 appldev ship $ */
3
4 -- Switchboard for PO and Requisition Actions
5
6 FUNCTION po_req_supply(p_docid IN NUMBER,
7 p_lineid IN NUMBER,
8 p_shipid IN NUMBER,
9 p_action IN VARCHAR2,
10 p_recreate_flag IN BOOLEAN,
11 p_qty IN NUMBER,
12 p_receipt_date IN DATE,
13 p_reservation_action IN VARCHAR2 DEFAULT NULL --<R12 PLAN CROSS DOCK>
14 ,p_ordered_uom IN VARCHAR2 DEFAULT NULL --5253916
15 ) RETURN BOOLEAN;
16
17
18 -- Update mtl_supply for an Approve PO Action
19
20 FUNCTION approve_po_supply(p_docid IN NUMBER) RETURN BOOLEAN;
21
22
23 -- Update mtl_supply for an Approve Blanket Release Action
24
25 FUNCTION approve_blanket_supply(p_docid IN NUMBER) RETURN BOOLEAN;
26
27
28 -- Update mtl_supply for an Approve Planned Release Action
29
30 FUNCTION approve_planned_supply(p_docid IN NUMBER) RETURN BOOLEAN;
31
32
33 -- Create PO Supply
34
35 FUNCTION create_po_supply(p_entity_id IN NUMBER,
36 p_entity_type IN VARCHAR2) RETURN BOOLEAN;
37
38
39 -- Delete Supply for PO Header or PO Release
40
41 FUNCTION delete_supply(p_entity_id IN NUMBER,
42 p_entity_type IN VARCHAR2) RETURN BOOLEAN;
43
44
45 -- Update Supply for PO Line, Shipment or Release Shipment
46
47 FUNCTION update_supply(p_entity_id IN NUMBER,
48 p_entity_type IN VARCHAR2,
49 p_shipid IN NUMBER DEFAULT 0) RETURN BOOLEAN;
50
51
52 -- Cancel Supply for PO Header, Line or Shipment
53
54 FUNCTION cancel_supply(p_entity_id IN NUMBER,
55 p_entity_type IN VARCHAR2,
56 p_shipid IN NUMBER DEFAULT 0) RETURN BOOLEAN;
57
58
59 -- Cancel Planned Release or Planned Shipment
60
61 FUNCTION cancel_planned(p_entity_id IN NUMBER,
62 p_entity_type IN VARCHAR2,
63 p_shipid IN NUMBER DEFAULT 0,
64 p_recreate_flag IN BOOLEAN) RETURN BOOLEAN;
65
66
67 -- Maintain mtl_supply
68
69 FUNCTION maintain_mtl_supply RETURN BOOLEAN;
70
71
72 -- Get Debug Information
73
74 FUNCTION get_debug RETURN VARCHAR2;
75
76 -- Create Requisition Header, Line Supply
77 -- The following function will not check the authorization status.
78
79 FUNCTION create_req(p_entity_id IN NUMBER,
80 p_entity_type IN VARCHAR2) RETURN BOOLEAN;
81
82 --<Bug 2752584 mbhargav>
83 FUNCTION explode(p_lineid IN NUMBER) RETURN BOOLEAN;
84
85 END PO_SUPPLY;