1 PACKAGE PO_ACKNOWLEDGE_PO_PVT AUTHID CURRENT_USER AS
2 /* $Header: POXVACKS.pls 120.1.12020000.2 2013/02/10 12:28:12 vegajula ship $ */
3
4 FUNCTION Get_Po_Status_Code (
5 p_api_version IN NUMBER,
6 p_Init_Msg_List IN VARCHAR2,
7 p_po_header_id IN NUMBER,
8 p_po_release_id IN NUMBER )
9 RETURN VARCHAR2;
10
11
12 FUNCTION Get_Shipment_Ack_Change_Status (
13 p_api_version IN NUMBER,
14 p_Init_Msg_List IN VARCHAR2,
15 P_line_location_id IN NUMBER,
16 p_po_header_id IN NUMBER,
17 p_po_release_id IN NUMBER,
18 p_revision_num IN NUMBER )
19 RETURN VARCHAR2;
20
21
22 PROCEDURE Acknowledge_Shipment (
23 p_api_version IN NUMBER,
24 p_Init_Msg_List IN VARCHAR2,
25 x_return_status OUT NOCOPY VARCHAR2,
26 p_line_location_id IN NUMBER,
27 p_po_header_id IN NUMBER,
28 p_po_release_id IN NUMBER,
29 p_revision_num IN NUMBER,
30 p_accepted_flag IN VARCHAR2,
31 p_comment IN VARCHAR2 default null,
32 p_buyer_id IN NUMBER,
33 p_user_id IN NUMBER );
34
35
36 PROCEDURE Carry_Over_Acknowledgement (
37 p_api_version IN NUMBER,
38 p_Init_Msg_List IN VARCHAR2,
39 x_return_status OUT NOCOPY VARCHAR2,
40 p_po_header_id IN NUMBER,
41 p_po_release_id IN NUMBER,
42 p_revision_num IN NUMBER );
43
44
45 FUNCTION All_Shipments_Responded (
46 p_api_version IN NUMBER,
47 p_Init_Msg_List IN VARCHAR2,
48 p_po_header_id IN NUMBER,
49 p_po_release_id IN NUMBER,
50 p_revision_num IN NUMBER )
51 RETURN VARCHAR2;
52
53
54 PROCEDURE Set_Header_Acknowledgement (
55 p_api_version IN NUMBER,
56 p_Init_Msg_List IN VARCHAR2,
57 x_return_status OUT NOCOPY VARCHAR2,
58 p_po_header_id IN NUMBER,
59 p_po_release_id IN NUMBER );
60
61 FUNCTION Get_Header_Ack_Change_Status (
62 p_po_header_id IN NUMBER,
63 p_po_release_id IN NUMBER,
64 p_revision_num IN NUMBER,
65 --<Bug 14310203>
66 p_draft_id IN NUMBER DEFAULT -1)
67 RETURN VARCHAR2;
68
69 END PO_ACKNOWLEDGE_PO_PVT;