1 PACKAGE PO_Document_Control_GRP AUTHID CURRENT_USER AS
2 /* $Header: POXGDCOS.pls 120.2 2011/04/27 05:58:13 yuewliu ship $ */
3
4 g_pkg_name CONSTANT VARCHAR2(30) := 'PO_Document_Control_GRP';
5
6 /*Bug9321845(6603493) */
7 TYPE po_line_ids IS RECORD (
8 po_line_id po_line_locations_all.po_line_id%type,
9 po_line_location_id po_line_locations_all.line_location_id%type);
10
11 TYPE RecTabpo_line_ids IS TABLE OF po_line_ids;
12 /*Bug9321845(6603493) */
13 PROCEDURE control_document
14 (p_api_version IN NUMBER,
15 p_init_msg_list IN VARCHAR2,
16 p_commit IN VARCHAR2,
17 x_return_status OUT NOCOPY VARCHAR2,
18 p_doc_type IN PO_DOCUMENT_TYPES.document_type_code%TYPE,
19 p_doc_subtype IN PO_DOCUMENT_TYPES.document_subtype%TYPE,
20 p_doc_id IN NUMBER,
21 p_doc_num IN PO_HEADERS.segment1%TYPE,
22 p_release_id IN NUMBER,
23 p_release_num IN NUMBER,
24 p_doc_line_id IN NUMBER,
25 p_doc_line_num IN NUMBER,
26 p_doc_line_loc_id IN NUMBER,
27 p_doc_shipment_num IN NUMBER,
28 p_source IN VARCHAR2,
29 p_action IN VARCHAR2,
30 p_action_date IN DATE,
31 p_cancel_reason IN PO_LINES.cancel_reason%TYPE,
32 p_cancel_reqs_flag IN VARCHAR2,
33 p_print_flag IN VARCHAR2,
34 p_note_to_vendor IN PO_HEADERS.note_to_vendor%TYPE,
35 p_use_gldate IN VARCHAR2 DEFAULT NULL, -- <ENCUMBRANCE FPJ>
36 p_launch_approvals_flag IN VARCHAR2 DEFAULT 'Y', -- Bug#8224603
37 p_caller IN VARCHAR2 DEFAULT NULL --Bug6202440
38 );
39
40 /*Bug9321845(6603493) */
41
42 PROCEDURE control_document
43 (p_api_version IN NUMBER,
44 p_init_msg_list IN VARCHAR2,
45 p_commit IN VARCHAR2,
46 x_return_status OUT NOCOPY VARCHAR2,
47 p_doc_type IN PO_DOCUMENT_TYPES.document_type_code%TYPE,
48 p_doc_subtype IN PO_DOCUMENT_TYPES.document_subtype%TYPE,
49 p_doc_id IN NUMBER,
50 p_doc_num IN PO_HEADERS.segment1%TYPE,
51 p_release_id IN NUMBER,
52 p_release_num IN NUMBER,
53 p_doc_line_id IN RecTabpo_line_ids,
54 p_doc_line_num IN NUMBER,
55 p_doc_line_loc_id IN NUMBER,
56 p_doc_shipment_num IN NUMBER,
57 p_source IN VARCHAR2,
58 p_action IN VARCHAR2,
59 p_action_date IN DATE,
60 p_cancel_reason IN PO_LINES.cancel_reason%TYPE,
61 p_cancel_reqs_flag IN VARCHAR2,
62 p_print_flag IN VARCHAR2,
63 p_note_to_vendor IN PO_HEADERS.note_to_vendor%TYPE,
64 p_use_gldate IN VARCHAR2 DEFAULT NULL,-- <ENCUMBRANCE FPJ>
65 p_launch_approvals_flag IN VARCHAR2 DEFAULT 'Y',-- Bug6202440
66 p_caller IN varchar2 DEFAULT NULL --Bug6202440
67 );
68
69 /*Bug9321845(6603493)*/
70
71 PROCEDURE val_control_action
72 (p_api_version IN NUMBER,
73 p_init_msg_list IN VARCHAR2,
74 x_return_status OUT NOCOPY VARCHAR2,
75 p_doc_type IN PO_DOCUMENT_TYPES.document_type_code%TYPE,
76 p_doc_subtype IN PO_DOCUMENT_TYPES.document_subtype%TYPE,
77 p_doc_id IN NUMBER,
78 p_doc_num IN PO_HEADERS.segment1%TYPE,
79 p_release_id IN NUMBER,
80 p_release_num IN NUMBER,
81 p_doc_line_id IN NUMBER,
82 p_doc_line_num IN NUMBER,
83 p_doc_line_loc_id IN NUMBER,
84 p_doc_shipment_num IN NUMBER,
85 p_action IN VARCHAR2);
86
87
88 PROCEDURE check_control_action
89 (p_api_version IN NUMBER,
90 p_init_msg_list IN VARCHAR2,
91 x_return_status OUT NOCOPY VARCHAR2,
92 p_doc_type IN PO_DOCUMENT_TYPES.document_type_code%TYPE,
93 p_doc_subtype IN PO_DOCUMENT_TYPES.document_subtype%TYPE,
94 p_doc_id IN NUMBER,
95 p_doc_num IN PO_HEADERS.segment1%TYPE,
96 p_release_id IN NUMBER,
97 p_release_num IN NUMBER,
98 p_doc_line_id IN NUMBER,
99 p_doc_line_num IN NUMBER,
100 p_doc_line_loc_id IN NUMBER,
101 p_doc_shipment_num IN NUMBER,
102 p_action IN VARCHAR2);
103
104
105 PROCEDURE val_doc_params
106 (p_api_version IN NUMBER,
107 p_init_msg_list IN VARCHAR2,
108 x_return_status OUT NOCOPY VARCHAR2,
109 p_doc_type IN PO_DOCUMENT_TYPES.document_type_code%TYPE,
110 p_doc_subtype IN PO_DOCUMENT_TYPES.document_subtype%TYPE,
111 p_doc_id IN NUMBER,
112 p_doc_num IN PO_HEADERS.segment1%TYPE,
113 p_release_id IN NUMBER,
114 p_release_num IN NUMBER,
115 p_doc_line_id IN NUMBER,
116 p_doc_line_num IN NUMBER,
117 p_doc_line_loc_id IN NUMBER,
118 p_doc_shipment_num IN NUMBER,
119 x_doc_id OUT NOCOPY NUMBER,
120 x_doc_line_id OUT NOCOPY NUMBER,
121 x_doc_line_loc_id OUT NOCOPY NUMBER);
122
123
124 END PO_Document_Control_GRP;