1 PACKAGE PO_Document_Control_GRP AUTHID CURRENT_USER AS
2 /* $Header: POXGDCOS.pls 115.4 2003/09/16 17:22:47 bao noship $ */
3
4 g_pkg_name CONSTANT VARCHAR2(30) := 'PO_Document_Control_GRP';
5
6
7 PROCEDURE control_document
8 (p_api_version IN NUMBER,
9 p_init_msg_list IN VARCHAR2,
10 p_commit IN VARCHAR2,
11 x_return_status OUT NOCOPY VARCHAR2,
12 p_doc_type IN PO_DOCUMENT_TYPES.document_type_code%TYPE,
13 p_doc_subtype IN PO_DOCUMENT_TYPES.document_subtype%TYPE,
14 p_doc_id IN NUMBER,
15 p_doc_num IN PO_HEADERS.segment1%TYPE,
16 p_release_id IN NUMBER,
17 p_release_num IN NUMBER,
18 p_doc_line_id IN NUMBER,
19 p_doc_line_num IN NUMBER,
20 p_doc_line_loc_id IN NUMBER,
21 p_doc_shipment_num IN NUMBER,
22 p_source IN VARCHAR2,
23 p_action IN VARCHAR2,
24 p_action_date IN DATE,
25 p_cancel_reason IN PO_LINES.cancel_reason%TYPE,
26 p_cancel_reqs_flag IN VARCHAR2,
27 p_print_flag IN VARCHAR2,
28 p_note_to_vendor IN PO_HEADERS.note_to_vendor%TYPE,
29 p_use_gldate IN VARCHAR2 DEFAULT NULL -- <ENCUMBRANCE FPJ>
30 );
31
32
33 PROCEDURE val_control_action
34 (p_api_version IN NUMBER,
35 p_init_msg_list IN VARCHAR2,
36 x_return_status OUT NOCOPY VARCHAR2,
37 p_doc_type IN PO_DOCUMENT_TYPES.document_type_code%TYPE,
38 p_doc_subtype IN PO_DOCUMENT_TYPES.document_subtype%TYPE,
39 p_doc_id IN NUMBER,
40 p_doc_num IN PO_HEADERS.segment1%TYPE,
41 p_release_id IN NUMBER,
42 p_release_num IN NUMBER,
43 p_doc_line_id IN NUMBER,
44 p_doc_line_num IN NUMBER,
45 p_doc_line_loc_id IN NUMBER,
46 p_doc_shipment_num IN NUMBER,
47 p_action IN VARCHAR2);
48
49
50 PROCEDURE check_control_action
51 (p_api_version IN NUMBER,
52 p_init_msg_list IN VARCHAR2,
53 x_return_status OUT NOCOPY VARCHAR2,
54 p_doc_type IN PO_DOCUMENT_TYPES.document_type_code%TYPE,
55 p_doc_subtype IN PO_DOCUMENT_TYPES.document_subtype%TYPE,
56 p_doc_id IN NUMBER,
57 p_doc_num IN PO_HEADERS.segment1%TYPE,
58 p_release_id IN NUMBER,
59 p_release_num IN NUMBER,
60 p_doc_line_id IN NUMBER,
61 p_doc_line_num IN NUMBER,
62 p_doc_line_loc_id IN NUMBER,
63 p_doc_shipment_num IN NUMBER,
64 p_action IN VARCHAR2);
65
66
67 PROCEDURE val_doc_params
68 (p_api_version IN NUMBER,
69 p_init_msg_list IN VARCHAR2,
70 x_return_status OUT NOCOPY VARCHAR2,
71 p_doc_type IN PO_DOCUMENT_TYPES.document_type_code%TYPE,
72 p_doc_subtype IN PO_DOCUMENT_TYPES.document_subtype%TYPE,
73 p_doc_id IN NUMBER,
74 p_doc_num IN PO_HEADERS.segment1%TYPE,
75 p_release_id IN NUMBER,
76 p_release_num IN NUMBER,
77 p_doc_line_id IN NUMBER,
78 p_doc_line_num IN NUMBER,
79 p_doc_line_loc_id IN NUMBER,
80 p_doc_shipment_num IN NUMBER,
81 x_doc_id OUT NOCOPY NUMBER,
82 x_doc_line_id OUT NOCOPY NUMBER,
83 x_doc_line_loc_id OUT NOCOPY NUMBER);
84
85
86 END PO_Document_Control_GRP;
[Home] [Help]