1 PACKAGE jai_ar_match_tax_pkg
2 /* $Header: jai_ar_match_tax.pls 120.11.12020000.2 2012/12/18 09:30:13 mmurtuza ship $ */
3 AS
4 --+=======================================================================+
5 --| Copyright (c) 1998 Oracle Corporation |
6 --| Redwood Shores, CA, USA |
7 --| All rights reserved. |
8 --+=======================================================================+
9 --| FILENAME |
10 --| jai_ar_match_tax.pls |
11 --| |
12 --| DESCRIPTION |
13 --| This package is mainly used for posting the |
14 --| taxes, VAT/excise invoice num to base AR table. |
15 --| |
16 --| TDD REFERENCE |
17 --| The procedure "display_vat_invoice_no" is referenced by |
18 --| the "VAT Invoice Number on AR Invoice Technical Design.doc" |
19 --| |
20 --| |
21 --| PURPOSE |
22 --| PROCEDURE process_batch |
23 --| PROCEDURE process_from_order_line |
24 --| PROCEDURE process_manual_invoice |
25 --| PROCEDURE acct_inclu_taxes |
26 --| PROCEDURE display_vat_invoice_no is used for updating the |
27 --| reference field in AR transaction workbench to show the |
28 --| VAT/Excise invoice numbers |
29 --| |
30 --| HISTORY |
31 --| 08-Jun-2005 Version 116.1 jai_ar_match_tax -Object is Modified |
32 --| to refer to New DB Entity names in place of Old DB |
33 --| Entity Names as required for CASE COMPLAINCE. |
34 --| |
35 --| 25-Apr-2007 cbabu for Bug#6012570 (5876390), File Version |
36 --| 120.2 (115.3) FP: Project billing implementation. |
37 --| |
38 --| 21-Aug-2007 brathod for Bug# 6012570, File Version 120.6 |
39 --| Reimplemented the Project Billing changes by |
40 --| removing the comments |
41 --| |
42 --| 19-Jan-2010 Bo Li for VAT/Excise Number shown in AR workbench ER |
43 --| Add a procedure display_vat_invoice_no and |
44 --| Bug 9303168# can be tracked |
45 --| |
46 --| 01-Sep-2010 Bo Li for bug#10043656 |
47 --| GST Enhancement for R12.1.3 |
48 --| |
49 --+======================================================================*/
50
51 PROCEDURE process_batch (
52 ERRBUF OUT NOCOPY VARCHAR2,
53 RETCODE OUT NOCOPY VARCHAR2,
54 P_ORG_ID IN NUMBER,
55 p_all_orgs IN Varchar2
56 ,p_debug in varchar2 default 'N'
57 --commented by kunkumar for bug#6066813
58 , p_called_from IN VARCHAR2 default null /* parameter added for bug#6012570 (5876390) */ -- revoked the comments for 6012570
59 );
60
61 PROCEDURE process_from_order_line(
62 p_customer_trx_id IN NUMBER ,
63 p_debug IN VARCHAR2 DEFAULT 'N',
64 p_process_status OUT NOCOPY VARCHAR2,
65 p_process_message OUT NOCOPY VARCHAR2
66 );
67
68 PROCEDURE process_manual_invoice(ERRBUF OUT NOCOPY VARCHAR2,
69 RETCODE OUT NOCOPY VARCHAR2,
70 P_CUSTOMER_TRX_ID IN NUMBER,
71 P_LINK_LINE_ID IN NUMBER);
72 /*Start commented by kunkumar for bug#6066813
73 following function added for bug#6012570 (5876390) */ -- revoked the comments, 6012570
74 function is_this_projects_context(pv_context in varchar2) return varchar2;
75 -- End commented by kunkumar*/
76
77
78 -- Added by Jia Li on tax inclusive computation on 2007/11/30
79 ------------------------------------------------------
80 PROCEDURE acct_inclu_taxes
81 ( pn_customer_trx_id IN NUMBER
82 , pn_org_id IN NUMBER
83 , pn_cust_trx_type_id IN NUMBER
84 , xv_process_flag OUT NOCOPY VARCHAR2
85 , xv_process_message OUT NOCOPY VARCHAR2
86 );
87 ------------------------------------------------------
88
89 --==========================================================================
90 -- PROCEDURE NAME:
91 -- Display_Vat_Invoice_No Public
92 --
93 -- DESCRIPTION:
94 -- This procedure is written that update the ra_customer_trx_all ct_reference column
95 -- to display the VAT/Excise Number in AR
96 --
97 -- ER NAME/BUG#
98 -- VAT/Excise Number shown in AR transaction workbench'
99 -- Bug 9303168
100 --
101 -- PARAMETERS:
102 -- In: pn_customer_trx_id Indicates the customer trx id
103 -- pv_excise_invoice_no Indicates the excise invoice number
104 -- pv_vat_invoice_no Indicates vat invoice number
105 --
106 --
107 -- DESIGN REFERENCES:
108 -- TD named "VAT Invoice Number on AR Invoice Technical Design.doc" has been
109 -- referenced in the section 6.1
110 --
111 -- CALL FROM
112 -- JAI_AR_MATCH_TAX_PKG.process_batch
113 -- JAI_AR_TRX.update_excise_invoice_no
114 -- JAI_AR_TRX.update_reference
115 --
116 -- CHANGE HISTORY:
117 -- 19-Jan-2010 Created by Bo Li
118
119 --==========================================================================
120 -- Added by Bo Li for VAT/Excise Number shown in AR workbench on 19-JAN-2010 and in Bug 9303168# ,Begin
121 -------------------------------------------------------------------------------------------------------
122 PROCEDURE display_vat_invoice_no
123 ( pn_customer_trx_id IN NUMBER
124 , pv_excise_invoice_no IN VARCHAR2
125 , pv_vat_invoice_no IN VARCHAR2
126 );
127 --------------------------------------------------------------------------------------------------------
128 -- Added by Bo Li for VAT/Excise Number shown in AR workbench on 19-JAN-2010 Bug 9303168# ,End
129
130 -- Added by Bo Li for GST ER bug#10043656,Begin
131 -------------------------------------------------------------------------------------------------------
132
133 /*Start Commenting by mmurtuza for removing GST Changes*/
134
135 /*PROCEDURE update_gst_invoice_no
136 ( pn_customer_trx_id IN NUMBER
137 , pv_gst_invoice_no IN VARCHAR2
138 );
139
140 PROCEDURE update_reference
141 ( retcode OUT NOCOPY VARCHAR2
142 , errbuf OUT NOCOPY VARCHAR2
143 , pn_customer_trx_id NUMBER);*/
144
145 /*Start Commenting by mmurtuza for removing GST Changes*/
146
147 --------------------------------------------------------------------------------------------------------
148 -- Added by Bo Li for GST ER bug#10043656 ,End
149 END jai_ar_match_tax_pkg;