1 PACKAGE jai_rcv_third_party_pkg AUTHID CURRENT_USER AS
2 /* $Header: jai_rcv_3p_prc.pls 120.3 2006/03/27 14:24:54 hjujjuru ship $ */
3 /* --------------------------------------------------------------------------------------
4 Filename: jai_rcv_third_party_pkg_s.sql
5
6 Change History:
7
8 slno Date Bug Remarks
9 ---- --------- ---------- -------------------------------------------------------------
10
11 1. 14/04/2005 4284505 sumaith - file version 115.1
12
13 Code added for service tax support for 3rd party taxes in a receipt.
14
15 In the package spec , a procedure -populate_tp_invoice_id has been added
16 which updates the invoice id in the jai_rcv_tp_invoices table.
17
18 This patch creates dependency by addition of a new table - jai_rcv_tp_inv_Details
19 and addition of new column (invoice_id) in the table jai_Rcv_tp_invoices table.
20
21 2. 08-Jun-2005 Version 116.1 jai_rcv_3p_prc -Object is Modified to refer to New DB Entity names in place of Old DB Entity Names
22 as required for CASE COMPLAINCE.
23
24
25 Dependency Section
26 ========== =======
27
28 Date Bug Remarks
29 --------- ---------- -------------------------------------------------------------
30 17-oct-04 Bug#3940741 This is a part of correction ER, done in phases. This obsoletes
31 the third party code in the old receiving, namely the procedures,
32 Ja_In_Con_Ap_Req and ja_in_receipt_ap_interface.
33
34 Here procedure Process_pending_receipts is attached to the concurrent
35 for generating third party invoices and it calls the procedure
36 process_receipt for each pending shipment_header_id.
37
38 13-Aug-2005 rchandan for bug#4551623. File version 120.2.
39 Changed the order of parameters of process_batch and added a default NULL to p_simulation.
40
41
42 ----------------------------------------------------------------------------------------- */
43 /* */
44
45
46 procedure process_batch
47 (
48 errbuf out nocopy varchar2,
49 retcode out nocopy varchar2,
50 p_batch_name in varchar2,
51 /* Bug 5096787. Added by LGOPALSA
52 Added parameter p_org_id */
53 p_org_id in number,
54 p_simulation in varchar2 default null,
55 p_debug in number default 1
56 );
57
58 procedure process_receipt
59 (
60 p_batch_id in number,
61 p_shipment_header_id in number,
62 p_process_flag out nocopy varchar2,
63 p_process_message out nocopy varchar2,
64 p_debug in number default 1,
65 p_simulation in varchar2
66 );
67
68 procedure populate_tp_invoice_id
69 (
70 p_invoice_id in ap_invoices_all.invoice_id%TYPE,
71 p_invoice_num in ap_invoices_all.invoice_num%TYPE,
72 p_vendor_id in ap_invoices_all.vendor_id%TYPE,
73 p_vendor_site_id in ap_invoices_all.vendor_site_id%TYPE,
74 p_process_flag out nocopy VARCHAR2,
75 p_process_message out nocopy VARCHAR2
76 );
77
78 end jai_rcv_third_party_pkg;