PACKAGE: APPS.PO_INBOUND_XML

Source

1 PACKAGE po_inbound_xml AUTHID CURRENT_USER AS
2 /* $Header: POSYNCIS.pls 120.4 2010/07/20 21:18:02 bvanjaku noship $ */
3 PROCEDURE trace
4   (
5     p_message VARCHAR2,
6     p_module  VARCHAR2,
7     p_level   NUMBER := 9);
8   FUNCTION update_po
9     (
10       P_PO_NUMBER       VARCHAR2,
11       P_RELEASE_NUMBER  NUMBER,
12       P_REVISION_NUMBER NUMBER,
13       P_LINE_NUMBER     NUMBER,
14       P_SHIPMENT_NUMBER NUMBER,
15       P_NEW_QUANTITY    NUMBER,
16       P_NEW_PRICE       NUMBER,
17       P_NEW_PROMISED_DATE DATE,
18       P_NEW_NEED_BY_DATE DATE := NULL,
19       P_LAUNCH_APPROVALS_FLAG VARCHAR2,
20       P_UPDATE_SOURCE         VARCHAR2,
21       P_VERSION               VARCHAR2,
22       P_OVERRIDE_DATE DATE := NULL,
23       P_API_ERRORS OUT NOCOPY PO_API_ERRORS_REC_TYPE,
24       P_BUYER_NAME         VARCHAR2 DEFAULT NULL,
25       P_secondary_quantity NUMBER ,
26       P_preferred_grade    VARCHAR2,
27       P_org_id IN NUMBER DEFAULT NULL )
28     RETURN NUMBER;
29   PROCEDURE cancel_po
30     (
31       l_api_version   IN NUMBER,
32       l_init_msg_list IN VARCHAR2,
33       l_commit        IN VARCHAR2,
34       l_return_status OUT NOCOPY VARCHAR2,
35       l_doc_type         IN PO_DOCUMENT_TYPES.document_type_code%TYPE,
36       l_doc_subtype      IN PO_DOCUMENT_TYPES.document_subtype%TYPE,
37       l_doc_id           IN NUMBER,
38       l_doc_num          IN PO_HEADERS.segment1%TYPE,
39       l_release_id       IN NUMBER,
40       l_release_num      IN NUMBER,
41       l_doc_line_id      IN NUMBER,
42       l_doc_line_num     IN NUMBER,
43       l_doc_line_loc_id  IN NUMBER,
44       l_doc_shipment_num IN NUMBER,
45       l_action           IN VARCHAR2,
46       l_action_date      IN DATE,
47       l_cancel_reason    IN PO_LINES.cancel_reason%TYPE,
48       l_cancel_reqs_flag IN VARCHAR2,
49       l_print_flag       IN VARCHAR2,
50       l_note_to_vendor   IN PO_HEADERS.note_to_vendor%TYPE,
51       l_use_gldate       IN VARCHAR2 DEFAULT NULL,
52       l_org_id           IN NUMBER DEFAULT NULL );
53   PROCEDURE log_err_msg
54     (
55       x_msg PO_API_ERRORS_REC_TYPE,
56       p_userid              NUMBER,
57       p_applid              NUMBER,
58       p_respid              NUMBER,
59       p_batch_id            NUMBER,
60       p_interface_header_id NUMBER,
61       p_interface_line_id   NUMBER);
62   PROCEDURE process_po_inbound_xml
63     (
64       itemtype IN VARCHAR2,
65       itemkey  IN VARCHAR2,
66       actid    IN NUMBER,
67       funcmode IN VARCHAR2,
68       resultout OUT NOCOPY VARCHAR2);
69   PROCEDURE is_po_number_exists
70     (
71       p_po_number      IN VARCHAR,
72       p_operating_unit IN NUMBER,
73       p_po_header_id OUT NOCOPY NUMBER);
74   FUNCTION is_po_number_exists
75     (
76       p_po_number      IN VARCHAR,
77       p_operating_unit IN NUMBER)
78     RETURN BOOLEAN;
79   PROCEDURE GET_OPERATING_UNIT
80     (
81       p_location_code IN VARCHAR,
82       p_operating_unit OUT NOCOPY NUMBER);
83   PROCEDURE GET_CLIENT_CODE
84     (
85       p_trading_location_code IN VARCHAR2,
86       p_client_code OUT NOCOPY VARCHAR2);
87   PROCEDURE GET_LINE_TYPE
88     (
89       p_operating_unit IN NUMBER,
90       p_line_type OUT NOCOPY VARCHAR2);
91   PROCEDURE INITIALISE
92     (
93       p_user_name IN VARCHAR,
94       p_user_id OUT NOCOPY NUMBER);
95   PROCEDURE GET_TERM_ID
96     (
97       p_term_name          VARCHAR2,
98       p_term_id OUT NOCOPY NUMBER);
99   END po_inbound_xml;