1 package jai_cmn_rgm_vat_accnt_pkg AUTHID CURRENT_USER AS
2 /* $Header: jai_cmn_rgm_vat.pls 120.1.12010000.3 2010/04/21 03:10:54 haoyang ship $ */
3 /*****************************************************************************************************************************************************************
4 Created By : aiyer
5 Created Date : 17-Mar-2005
6 Enhancement Bug : 4247989
7 Purpose : Process the VAT Tax AR records (Invoice,Debit Memo and Credit memo) and populate the jai_rgms_trx_records and gl_interface appropriately.
8 Called From : India VAT Invoice Number/Accouting Concurrent Program:-
9 =====================================================
10 Procedure
11
12 AR Invoice Completion:-
13 =======================
14 Trigger ja_in_loc_ar_hdr_update_trg for Invoice and Debit Memo
15 Trigger ja_in_loc_ar_hdr_update_trg_vat for Credit Memo
16
17
18 Dependency Due To The Current Bug :
19 This object has been newly created with as a part of the VAT enhancement.
20 Needs to be always released along with the bug 4247989.Lot of Datamodel changes in this enhancement.
21 For details refer base bug 4245089
22
23
24
25 1. 08-Jun-2005 Version 116.1 jai_cmn_rgm_vat -Object is Modified to refer to New DB Entity names in place of Old DB Entity Names
26 as required for CASE COMPLAINCE.
27
28 2. 02-Apr-2010 Allen Yang modified for bug 9485355 (12.1.3 non-shippable Enhancement)
29 added parameter p_order_line_id in procedure process_order_invoice
30 Version 120.1.12010000.2
31 3. 20-Apr-2010 Allen Yang modified for bug 9602968
32 Modified procedure definition of process_order_invoice added 'DEFAULT NULL' for p_order_line_id
33 Version 120.1.12010000.3
34
35
36 Future Dependencies For the release Of this Object:-
37 (Please add a row in the section below only if your bug introduces a dependency due to spec change/ A new call to a object/
38 A datamodel change )
39
40 ----------------------------------------------------------------------------------------------------------------------------------------------------
41 Current Version Current Bug Dependent Dependency On Files Version Author Date Remarks
42 Of File On Bug/Patchset
43 jai_cmn_rgm_vat_accnt_pkg_pkg_s.sql.sql
44 ----------------------------------------------------------------------------------------------------------------------------------------------------
45 115.0 4247989 IN60106 + Aiyer 17-Mar-2005 4146708 is the release bug for SERVICE/CESS
46 4146708 + enhancement.
47 4245089 4245089 - Base bug for VAT Enhancement.
48
49 ----------------------------------------------------------------------------------------------------------------------------------------------------
50
51
52 *****************************************************************************************************************************************************************/
53
54 p_record_debug VARCHAR2(3); -- File.Sql.35 by Brathod := jai_constants.yes ; --
55 gv_transaction_type_dflt CONSTANT VARCHAR2(3) := 'INV' ;
56
57 PROCEDURE record_debug_messages
58 (
59 p_message VARCHAR2
60 );
61
62 PROCEDURE process_order_invoice
63 (
64 p_regime_id IN JAI_RGM_DEFINITIONS.REGIME_ID%TYPE ,
65 p_source IN VARCHAR2 ,
66 p_organization_id IN JAI_OM_WSH_LINES_ALL.ORGANIZATION_id%TYPE ,
67 p_location_id IN JAI_OM_WSH_LINES_ALL.LOCATION_ID%TYPE ,
68 p_delivery_id IN JAI_OM_WSH_LINES_ALL.DELIVERY_ID%TYPE ,
69 -- added by Allen Yang for bug 9485355 (12.1.3 non-shippable Enhancement), begin
70 -- 20-Apr-2010, add 'DEFAULT NULL' by Allen Yang for bug 9602968, begin
71 p_order_line_id IN JAI_OM_WSH_LINES_ALL.ORDER_LINE_ID%TYPE DEFAULT NULL ,
72 -- 20-Apr-2010, add 'DEFAULT NULL' by Allen Yang for bug 9602968, end
73 -- added by Allen Yang for bug 9485355 (12.1.3 non-shippable Enhancement), end
74 p_customer_trx_id IN RA_CUSTOMER_TRX_ALL.CUSTOMER_TRX_ID%TYPE ,
75 p_transaction_type IN RA_CUST_TRX_TYPES.TYPE%TYPE, -- DEFAULT 'INV' /* This parameter is used only for AR Accounting */ File.Sql.35 by Brathod
76 p_vat_invoice_no IN JAI_OM_WSH_LINES_ALL.VAT_INVOICE_NO%TYPE ,
77 p_default_invoice_date IN DATE ,
78 p_batch_id IN NUMBER ,
79 p_called_from IN VARCHAR2 ,
80 p_debug IN VARCHAR2, -- DEFAULT 'N' File.Sql.35 by Brathod
81 p_process_flag OUT NOCOPY VARCHAR2 ,
82 p_process_message OUT NOCOPY VARCHAR2
83 ) ;
84
85 END jai_cmn_rgm_vat_accnt_pkg;