1 package jai_ar_rgm_processing_pkg
2 /* $Header: jai_ar_rgm_proc.pls 120.3 2007/05/14 14:19:13 csahoo ship $ */
3
4 /***********************************************************************************************************************************************
5 Created By : aiyer
6 Created Date : 27-jan-2005
7 Enhancement Bug : 4146634
8 Purpose : Process the Service Tax AR records (Invoices,Credit memo's and Cash Receipts Applications) and populate
9 the jai_rgm_trx_refs and jai_rgms_trx_records appropriately.
10 Called From : jai_rgm_trx_processing.process_batch
11
12 Dependency Due To The Current Bug :
13 This object has been newly created with as a part of the service tax enhancement.
14 Needs to be always released along with the bug 4146708.
15
16 Change History: -
17 =================
18 1 20-Feb-2005 aiyer - Bug # 4193633 - File Version# 115.1
19 Issue
20 The tax earned and unearned discount are not getting apportioned properly of service type of taxes and hence the India - Service Tax concurrent
21 ends up in a warning for records with these issues
22
23 Fix
24 The procedure get_ar_tax_disc_accnt has been modified for the fix of this bug.
25 Please refer the change history of the package body for the details of this bug
26
27 Dependency Due To This Bug:
28 Dependency exists due to specification change of the current procedure.
29 Always sent the following packages together:-
30
31 1. jai_rgm_process_ar_taxes_pkg_s.sql (115.1)
32 2. jai_rgm_process_ar_taxes_pkg_b.sql (115.1)
33 3. jai_rgm_trx_recording_pkg_s.sql version (115.1)
34 4. jai_rgm_trx_recording_pkg_b.sql version (115.1)
35
36
37 2. 08-Jun-2005 Version 116.1 jai_ar_rgm_proc -Object is Modified to refer to New DB Entity names in place of Old DB Entity Names
38 as required for CASE COMPLAINCE.
39
40
41 3. 14-May-2005 CSahoo for bug#5879769. File Version 120.3
42 Forward porting of 11i BUG#5694855
43 SERVICE TAX BY INVENTORY ORGANIZATION AND SERVICE TYPE SOLUTION
44
45 Future Dependencies For the release Of this Object:-
46 (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/
47 A datamodel change )
48
49 ----------------------------------------------------------------------------------------------------------------------------------------------------
50 Current Version Current Bug Dependent Dependency On Files Version Author Date Remarks
51 Of File On Bug/Patchset
52 jai_rgm_process_ar_taxes_pkg_b.sql
53 ----------------------------------------------------------------------------------------------------------------------------------------------------
54 115.1 4146634 IN60105D2 + Aiyer 27-Jan-2005 4146708 is the release bug
55 4146708 for SERVICE/CESS enhancement release
56
57 ----------------------------------------------------------------------------------------------------------------------------------------------------
58 ********************************************************************************************************************************************************/
59
60 AS
61
62 procedure get_regime_info ( p_regime_code JAI_RGM_DEFINITIONS.REGIME_CODE%TYPE ,
63 p_tax_type_code JAI_CMN_TAXES_ALL.TAX_TYPE%TYPE ,
64 p_regime_id OUT NOCOPY JAI_RGM_DEFINITIONS.REGIME_ID%TYPE ,
65 p_error_flag OUT NOCOPY VARCHAR2 ,
66 p_error_message OUT NOCOPY VARCHAR2
67 );
68
69 procedure get_ar_tax_disc_accnt ( p_receivable_application_id AR_RECEIVABLE_APPLICATIONS_ALL.RECEIVABLE_APPLICATION_ID%TYPE ,
70 p_org_id AR_RECEIVABLES_TRX_ALL.ORG_ID%TYPE ,
71 p_total_disc_amount JAI_RGM_TRX_REFS.DISCOUNTED_AMOUNT%TYPE ,
72 p_tax_ediscounted OUT NOCOPY AR_RECEIVABLE_APPLICATIONS_ALL.TAX_EDISCOUNTED%TYPE ,
73 p_earned_disc_ccid OUT NOCOPY AR_RECEIVABLES_TRX_ALL.CODE_COMBINATION_ID%TYPE ,
74 p_tax_uediscounted OUT NOCOPY AR_RECEIVABLE_APPLICATIONS_ALL.TAX_UEDISCOUNTED%TYPE ,
75 p_unearned_disc_ccid OUT NOCOPY AR_RECEIVABLES_TRX_ALL.CODE_COMBINATION_ID%TYPE ,
76 p_process_flag OUT NOCOPY VARCHAR2 ,
77 p_process_message OUT NOCOPY VARCHAR2
78 );
79
80 procedure populate_inv_cm_references ( p_regime_id IN JAI_RGM_DEFINITIONS.REGIME_ID%TYPE ,
81 p_organization_type IN JAI_RGM_PARTIES.ORGANIZATION_TYPE%TYPE ,
82 p_from_date IN DATE ,
83 p_to_date IN DATE ,
84 p_org_id IN RA_CUSTOMER_TRX_ALL.ORG_ID%TYPE ,
85 p_batch_id IN JAI_RGM_TRX_REFS.BATCH_ID%TYPE ,
86 p_source IN varchar2, --File.Sql.35 Cbabu jai_constants.SOURCE_AR%TYPE ,
87 p_process_flag OUT NOCOPY VARCHAR2 ,
88 p_process_message OUT NOCOPY VARCHAR2,
89 p_organization_id IN JAI_RGM_PARTIES.ORGANIZATION_ID%TYPE DEFAULT NULL
90 );
91
92 procedure delete_non_existant_cm ( p_regime_id IN JAI_RGM_DEFINITIONS.REGIME_ID%TYPE ,
93 p_organization_type IN JAI_RGM_PARTIES.ORGANIZATION_TYPE%TYPE ,
94 p_from_date IN DATE ,
95 p_to_date IN DATE ,
96 p_org_id IN RA_CUSTOMER_TRX_ALL.ORG_ID%TYPE ,
97 p_source IN varchar2, --File.Sql.35 Cbabu jai_constants.SOURCE_AR%TYPE ,
98 p_batch_id IN JAI_RGM_TRX_REFS.BATCH_ID%TYPE ,
99 p_process_flag OUT NOCOPY VARCHAR2 ,
100 p_process_message OUT NOCOPY VARCHAR2
101 ,p_organization_id IN JAI_RGM_PARTIES.ORGANIZATION_ID%TYPE DEFAULT NULL );
102
103 procedure populate_cm_app ( p_regime_id IN JAI_RGM_DEFINITIONS.REGIME_ID%TYPE ,
104 p_organization_type IN JAI_RGM_PARTIES.ORGANIZATION_TYPE%TYPE ,
105 p_from_date IN DATE ,
106 p_to_date IN DATE ,
107 p_org_id IN RA_CUSTOMER_TRX_ALL.ORG_ID%TYPE ,
108 p_source IN varchar2, --File.Sql.35 Cbabu jai_constants.SOURCE_AR%TYPE ,
109 p_batch_id IN JAI_RGM_TRX_REFS.BATCH_ID%TYPE ,
110 p_process_flag OUT NOCOPY VARCHAR2 ,
111 p_process_message OUT NOCOPY VARCHAR2
112 ,p_organization_id JAI_RGM_PARTIES.ORGANIZATION_ID%TYPE DEFAULT NULL );
113
114 procedure populate_receipt_records ( p_regime_id IN JAI_RGM_DEFINITIONS.REGIME_ID%TYPE ,
115 p_organization_type IN JAI_RGM_PARTIES.ORGANIZATION_TYPE%TYPE ,
116 p_from_date IN DATE ,
117 p_to_date IN DATE ,
118 p_org_id IN RA_CUSTOMER_TRX_ALL.ORG_ID%TYPE ,
119 p_source IN varchar2, --File.Sql.35 Cbabu JAI_CONSTANTS.SOURCE_AR%TYPE ,
120 p_batch_id IN JAI_RGM_TRX_REFS.BATCH_ID%TYPE ,
121 p_process_flag OUT NOCOPY VARCHAR2 ,
122 p_process_message OUT NOCOPY VARCHAR2
123 ,p_organization_id IN JAI_RGM_PARTIES.ORGANIZATION_ID%TYPE DEFAULT NULL);
124
125 procedure process_records ( p_regime_id IN JAI_RGM_DEFINITIONS.REGIME_ID%TYPE ,
126 p_organization_type IN JAI_RGM_PARTIES.ORGANIZATION_TYPE%TYPE ,
127 p_from_date IN DATE ,
128 p_to_date IN DATE ,
129 p_org_id IN RA_CUSTOMER_TRX_ALL.ORG_ID%TYPE ,
130 p_batch_id IN JAI_RGM_TRX_REFS.BATCH_ID%TYPE ,
131 p_process_flag OUT NOCOPY VARCHAR2 ,
132 p_process_message OUT NOCOPY VARCHAR2 ,
133 p_organization_id IN JAI_RGM_PARTIES.ORGANIZATION_ID%TYPE DEFAULT NULL /*5879769*/
134 );
135
136 END jai_ar_rgm_processing_pkg ;