1 package jai_cmn_rgm_vat_accnt_pkg AS
2 /* $Header: jai_cmn_rgm_vat.pls 120.1 2005/07/20 12:57:38 avallabh 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
29 Future Dependencies For the release Of this Object:-
30 (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/
31 A datamodel change )
32
33 ----------------------------------------------------------------------------------------------------------------------------------------------------
34 Current Version Current Bug Dependent Dependency On Files Version Author Date Remarks
35 Of File On Bug/Patchset
36 jai_cmn_rgm_vat_accnt_pkg_pkg_s.sql.sql
37 ----------------------------------------------------------------------------------------------------------------------------------------------------
38 115.0 4247989 IN60106 + Aiyer 17-Mar-2005 4146708 is the release bug for SERVICE/CESS
39 4146708 + enhancement.
40 4245089 4245089 - Base bug for VAT Enhancement.
41
42 ----------------------------------------------------------------------------------------------------------------------------------------------------
43
44
45 *****************************************************************************************************************************************************************/
46
47 p_record_debug VARCHAR2(3); -- File.Sql.35 by Brathod := jai_constants.yes ; --
48 gv_transaction_type_dflt CONSTANT VARCHAR2(3) := 'INV' ;
49
50 PROCEDURE record_debug_messages
51 (
52 p_message VARCHAR2
53 );
54
55 PROCEDURE process_order_invoice
56 (
57 p_regime_id IN JAI_RGM_DEFINITIONS.REGIME_ID%TYPE ,
58 p_source IN VARCHAR2 ,
59 p_organization_id IN JAI_OM_WSH_LINES_ALL.ORGANIZATION_id%TYPE ,
60 p_location_id IN JAI_OM_WSH_LINES_ALL.LOCATION_ID%TYPE ,
61 p_delivery_id IN JAI_OM_WSH_LINES_ALL.DELIVERY_ID%TYPE ,
62 p_customer_trx_id IN RA_CUSTOMER_TRX_ALL.CUSTOMER_TRX_ID%TYPE ,
63 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
64 p_vat_invoice_no IN JAI_OM_WSH_LINES_ALL.VAT_INVOICE_NO%TYPE ,
65 p_default_invoice_date IN DATE ,
66 p_batch_id IN NUMBER ,
67 p_called_from IN VARCHAR2 ,
68 p_debug IN VARCHAR2, -- DEFAULT 'N' File.Sql.35 by Brathod
69 p_process_flag OUT NOCOPY VARCHAR2 ,
70 p_process_message OUT NOCOPY VARCHAR2
71 ) ;
72
73 END jai_cmn_rgm_vat_accnt_pkg;