DBA Data[Home] [Help]

PACKAGE: APPS.PO_DOCUMENT_CANCEL_PVT

Source


1 PACKAGE PO_Document_Cancel_PVT AS
2 /* $Header: POXVDCAS.pls 120.1 2005/10/24 16:55:49 shsiung noship $ */
3 
4 g_pkg_name CONSTANT VARCHAR2(30) := 'PO_Document_Cancel_PVT';
5 
6 PROCEDURE cancel_document
7    (p_api_version      IN   NUMBER,
8     p_init_msg_list    IN   VARCHAR2,
9     p_commit           IN   VARCHAR2,
10     x_return_status    OUT  NOCOPY VARCHAR2,
11     p_doc_type         IN   PO_DOCUMENT_TYPES.document_type_code%TYPE,
12     p_doc_subtype      IN   PO_DOCUMENT_TYPES.document_subtype%TYPE,
13     p_doc_id           IN   NUMBER,
14     p_doc_line_id      IN   NUMBER,
15     p_doc_line_loc_id  IN   NUMBER,
16     p_cancel_agent_id  IN   PO_HEADERS.agent_id%TYPE,
17     p_action_date      IN   DATE,
18     p_cancel_reason    IN   PO_LINES.cancel_reason%TYPE,
19     p_cancel_reqs_flag IN   VARCHAR2,
20     p_note_to_vendor   IN   PO_HEADERS.note_to_vendor%TYPE,
21     p_cbc_enabled      IN   VARCHAR2,
22     p_use_gldate       IN   VARCHAR2 DEFAULT NULL -- <ENCUMBRANCE FPJ>
23   );
24 
25 
26 PROCEDURE val_cancel_backing_reqs
27    (p_api_version    IN   NUMBER,
28     p_init_msg_list  IN   VARCHAR2,
29     x_return_status  OUT  NOCOPY VARCHAR2,
30     p_doc_type       IN   PO_DOCUMENT_TYPES.document_type_code%TYPE,
31     p_doc_id         IN   NUMBER);
32 
33 
34 PROCEDURE fetch_req_lines
35    (p_api_version     IN   NUMBER,
36     p_init_msg_list   IN   VARCHAR2,
37     x_return_status   OUT  NOCOPY VARCHAR2,
38     p_doc_id          IN   NUMBER,
39     p_doc_line_id     IN   NUMBER,
40     p_doc_line_loc_id IN   NUMBER,
41     p_control_level   IN   NUMBER,
42     x_req_line_id_tbl OUT  NOCOPY PO_ReqChangeRequestWF_PVT.ReqLineID_tbl_type);
43 
44 -- <Shared Proc FPJ START>
45 
46 PROCEDURE check_cancel_reqs_flag
47 (
48   x_return_status     OUT NOCOPY     VARCHAR2,
49   x_cancel_reqs_flag  IN OUT NOCOPY  VARCHAR2
50 );
51 
52 -- <Shared Proc FPJ END>
53 
54 --<Bug 4571297 START>
55 FUNCTION is_document_cto_order
56 (   p_doc_id   IN PO_HEADERS_ALL.po_header_id%TYPE,
57     p_doc_type IN PO_DOCUMENT_TYPES_ALL_B.document_type_code%TYPE
58 ) RETURN BOOLEAN;
59 --<Bug 4571297 END>
60 
61 END PO_Document_Cancel_PVT;