1 PACKAGE CLN_NTFYINVC_PKG AUTHID CURRENT_USER AS
2 /* $Header: CLN3C3S.pls 120.1 2006/10/04 11:32:30 bsaratna noship $ */
3
4 PROCEDURE Get_NotifyInvoice_Params(p_itemtype IN VARCHAR2,
5 p_itemkey IN VARCHAR2,
6 p_actid IN NUMBER,
7 p_funcmode IN VARCHAR2,
8 x_resultout IN OUT NOCOPY VARCHAR2);
9
10 PROCEDURE GET_PAYMENT_TERM_CODE(p_customer_trx_id IN NUMBER,
11 x_pay_t_code OUT NOCOPY VARCHAR2 );
12
13 PROCEDURE GET_TAX_AMOUNT_AND_CODE (p_customer_trx_line_id IN NUMBER,
14 x_tax_amount OUT NOCOPY NUMBER,
15 x_tax_code OUT NOCOPY VARCHAR2);
16
17 PROCEDURE GET_DOC_GENERATION_DATETIME(p_doc_trnsfr_id IN NUMBER,
18 x_doc_gen_dt OUT NOCOPY VARCHAR2 );
19
20 PROCEDURE CLN_UPDATE_DOC_STATUS(p_itemtype IN VARCHAR2,
21 p_itemkey IN VARCHAR2,
22 p_actid IN NUMBER,
23 p_funcmode IN VARCHAR2,
24 x_resultout IN OUT NOCOPY VARCHAR2);
25
26 PROCEDURE RAISE_UPDATE (p_document_id IN VARCHAR2,
27 p_int_cnt_num IN NUMBER,
28 p_org_id IN NUMBER,
29 x_return_status OUT NOCOPY VARCHAR2,
30 x_msg_data OUT NOCOPY VARCHAR2);
31
32 PROCEDURE ERROR_HANDLER(p_internal_control_number IN NUMBER,
33 p_document_id IN NUMBER,
34 p_org_id IN NUMBER,
35 x_notification_code OUT NOCOPY VARCHAR2,
36 x_notification_status OUT NOCOPY VARCHAR2,
37 x_return_status_tp OUT NOCOPY VARCHAR2,
38 x_return_desc_tp OUT NOCOPY VARCHAR2,
39 x_return_status IN OUT NOCOPY VARCHAR2,
40 x_msg_data IN OUT NOCOPY VARCHAR2);
41
42 PROCEDURE XGM_CHECK_STATUS ( p_itemtype IN VARCHAR2,
43 p_itemkey IN VARCHAR2,
44 p_actid IN NUMBER,
45 p_funcmode IN VARCHAR2,
46 x_resultout OUT NOCOPY VARCHAR2 );
47
48 PROCEDURE INVOICE_IMPORT_STATUS_HANDLER (p_itemtype IN VARCHAR2,
49 p_itemkey IN VARCHAR2,
50 p_actid IN NUMBER,
51 p_funcmode IN VARCHAR2,
52 x_resultout OUT NOCOPY VARCHAR2 );
53
54 PROCEDURE UPDATE_INV_HEADER_INTERFACE( p_invoice_id IN NUMBER,
55 p_proprietary_doc_Identifier IN VARCHAR2,
56 p_inv_curr_code IN VARCHAR2,
57 p_inv_amount IN NUMBER,
58 p_inv_date IN VARCHAR2,
59 p_inv_type_lookup_code IN VARCHAR2,
60 x_invoice_num IN OUT NOCOPY VARCHAR2,
61 x_return_status IN OUT NOCOPY VARCHAR2,
62 x_msg_data IN OUT NOCOPY VARCHAR2 );
63
64 PROCEDURE NOTIFY_INVOICE_TO_SYSADMIN ( p_itemtype IN VARCHAR2,
65 p_itemkey IN VARCHAR2,
66 p_actid IN NUMBER,
67 p_funcmode IN VARCHAR2,
68 x_resultout IN OUT NOCOPY VARCHAR2);
69 PROCEDURE TRIGGER_REJECTION(
70 p_invoice_id IN NUMBER,
71 p_group_id IN NUMBER,
72 p_request_id IN NUMBER,
73 p_external_doc_ref IN VARCHAR2);
74
75 PROCEDURE GET_REJECTED_INVOICE_DETAILS(
76 p_invoice_id IN NUMBER,
77 x_invoice_num IN OUT NOCOPY VARCHAR2,
78 x_po_num IN OUT NOCOPY VARCHAR2,
79 x_invoice_amt IN OUT NOCOPY NUMBER,
80 x_invoice_date IN OUT NOCOPY DATE);
81
82 PROCEDURE GET_PO_SHIPMENT_INFO(
83 p_org_id IN VARCHAR2,
84 p_so_num IN VARCHAR2,
85 p_so_rev_num IN VARCHAR2,
86 p_so_lin_num IN VARCHAR2,
87 x_po_num IN OUT NOCOPY VARCHAR2,
88 x_po_line_num IN OUT NOCOPY VARCHAR2,
89 x_po_ship_num IN OUT NOCOPY VARCHAR2);
90
91 END CLN_NTFYINVC_PKG;