1 PACKAGE PO_Mass_Close_PO_PVT AS
2 /* $Header: PO_Mass_Close_PO_PVT.pls 120.3 2008/01/09 14:39:14 rakchakr noship $*/
3
4 p_org_name hr_all_organization_units.name%TYPE;
5 p_supplier_name VARCHAR2(1000);
6
7 -- Global variables to hold the concurrent program parameter values.
8
9 g_document_type VARCHAR2(200);
10 g_document_no_from VARCHAR2(200);
11 g_document_no_to VARCHAR2(200);
12 g_date_from DATE;
13 g_date_to DATE;
14 g_supplier_id NUMBER;
15
16 --------------------------------------------------------------------------------------------------
17 -- Start of Comments
18
19 -- API Name : po_close_documents.
20 -- Type : Private
21 -- Pre-reqs : None
22 -- Function : Calls the procedure po_actions.close_po to close the PO's and releases.
23
24 -- Parameters :
25
26 -- IN : p_document_type Type of the document(STANDARD,BLANKET.CONTRACT,PLANNED).
27 -- p_document_no_from Document number from.
28 -- p_document_no_to Document number to.
29 -- p_date_from Date from.
30 -- p_date_to Date to.
31 -- p_supplier_id Supplier id.
32 -- p_commit_interval Commit interval.
33
34 -- OUT : p_msg_data Actual message in encoded format.
35 -- p_msg_count Holds the number of messages in the API list.
36 -- p_return_status Return status of the API (Includes 'S','E','U').
37
38 -- End of Comments
39 --------------------------------------------------------------------------------------------------
40
41 PROCEDURE po_close_documents(p_document_type IN VARCHAR2,
42 p_document_no_from IN VARCHAR2,
43 p_document_no_to IN VARCHAR2,
44 p_date_from IN VARCHAR2,
45 p_date_to IN VARCHAR2,
46 p_supplier_id IN NUMBER,
47 p_commit_interval IN NUMBER,
48 p_msg_data OUT NOCOPY VARCHAR2,
49 p_msg_count OUT NOCOPY NUMBER,
50 p_return_status OUT NOCOPY VARCHAR2);
51
52 --------------------------------------------------------------------------------------------------
53 -- Start of Comments
54
55 -- API Name : Print_Output
56 -- Type : Private
57 -- Pre-reqs : None
58 -- Function : Prints the header and body of the output file showing the documents and
59 -- document types which are closed.
60
61 -- Parameters :
62
63 -- IN : p_org_name Operating unit name.
64 -- p_document_type Type of the document(STANDARD,BLANKET.CONTRACT,PLANNED).
65 -- p_document_no_from Document number from.
66 -- p_document_no_to Document number to.
67 -- p_date_from Date from.
68 -- p_date_to Date to.
69 -- p_supplier_name Supplier name.
70
71 -- OUT : p_msg_data Actual message in encoded format.
72 -- p_msg_count Holds the number of messages in the API list.
73 -- p_return_status Return status of the API (Includes 'S','E','U').
74
75 -- End of Comments
76 --------------------------------------------------------------------------------------------------
77
78 PROCEDURE Print_Output(p_org_name IN VARCHAR2,
79 p_document_type IN VARCHAR2,
80 p_document_no_from IN VARCHAR2,
81 p_document_no_to IN VARCHAR2,
82 p_date_from IN DATE,
83 p_date_to IN DATE,
84 p_supplier_name IN VARCHAR2,
85 p_msg_data OUT NOCOPY VARCHAR2,
86 p_msg_count OUT NOCOPY NUMBER,
87 p_return_status OUT NOCOPY VARCHAR2);
88
89 --------------------------------------------------------------------------------------------------
90
91 -- Functions declared to return the value of the parameters passed in this API.
92
93 --------------------------------------------------------------------------------------------------
94
95 FUNCTION get_document_type RETURN VARCHAR2;
96
97 FUNCTION get_document_no_from RETURN VARCHAR2;
98
99 FUNCTION get_document_no_to RETURN VARCHAR2;
100
101 FUNCTION get_date_from RETURN DATE;
102
103 FUNCTION get_date_to RETURN DATE;
104
105 FUNCTION get_supplier_id RETURN NUMBER;
106
107 END PO_Mass_Close_PO_PVT;