eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.JAI_AR_RGM_PROCESSING_PKG dependencies on JAI_RGM_TRX_REFS

Line 9: the jai_rgm_trx_refs and jai_rgms_trx_records appropriately.

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.

Line 53: jai_rgm_trx_refs table

49: Issue : Invoice date column in 'India - Service tax pending liability' report
50: is showing creation date. (The reason for making changes in this file is that
51: the service tax processing program's behavior was also wrong w.r.to the date
52: paratmeters passed and the way AR invoices are picked up for populating
53: jai_rgm_trx_refs table
54: Cause : The query in the report is using jai_rgm_trx_refs.creation_date as
55: the invoice date. While checking how this field is populated, observed that
56: the records are populated while running the service tax processor.
57: In the procedure populate_inv_cm_references, the invoices are picked up

Line 54: Cause : The query in the report is using jai_rgm_trx_refs.creation_date as

50: is showing creation date. (The reason for making changes in this file is that
51: the service tax processing program's behavior was also wrong w.r.to the date
52: paratmeters passed and the way AR invoices are picked up for populating
53: jai_rgm_trx_refs table
54: Cause : The query in the report is using jai_rgm_trx_refs.creation_date as
55: the invoice date. While checking how this field is populated, observed that
56: the records are populated while running the service tax processor.
57: In the procedure populate_inv_cm_references, the invoices are picked up
58: based on the creation_date. This is wrong behavior, and by common sense it

Line 241: p_total_disc_amount JAI_RGM_TRX_REFS.DISCOUNTED_AMOUNT%TYPE ,/Parameter added for the bug 4193633 /

237: END get_regime_info;
238:
239: procedure get_ar_tax_disc_accnt ( p_receivable_application_id AR_RECEIVABLE_APPLICATIONS_ALL.RECEIVABLE_APPLICATION_ID%TYPE ,
240: p_org_id AR_RECEIVABLES_TRX_ALL.ORG_ID%TYPE ,
241: p_total_disc_amount JAI_RGM_TRX_REFS.DISCOUNTED_AMOUNT%TYPE ,/*Parameter added for the bug 4193633 */
242: p_tax_ediscounted OUT NOCOPY AR_RECEIVABLE_APPLICATIONS_ALL.TAX_EDISCOUNTED%TYPE ,
243: p_earned_disc_ccid OUT NOCOPY AR_RECEIVABLES_TRX_ALL.CODE_COMBINATION_ID%TYPE ,
244: p_tax_uediscounted OUT NOCOPY AR_RECEIVABLE_APPLICATIONS_ALL.TAX_UEDISCOUNTED%TYPE ,
245: p_unearned_disc_ccid OUT NOCOPY AR_RECEIVABLES_TRX_ALL.CODE_COMBINATION_ID%TYPE ,

Line 255: the jai_rgm_trx_refs and jai_rgms_trx_records appropriately.

251: Created By : aiyer
252: Created Date : 27-jan-2005
253: Enhancement Bug : 4146634
254: Purpose : Gte the tax earned and Unearned discounts associated with the Receivable application
255: the jai_rgm_trx_refs and jai_rgms_trx_records appropriately.
256: Called From : jai_cmn_rgm_recording_pkg.insert_reference
257:
258: Change History: -
259: =================

Line 324: ln_total_rec_disc_amt JAI_RGM_TRX_REFS.DISCOUNTED_AMOUNT%TYPE ;

320: status = p_status; --rchandan for bug#4428980
321:
322: rec_cur_get_receivable_app CUR_GET_RECEIVABLE_APP%ROWTYPE ;
323: rec_cur_get_disc_ccid CUR_GET_DISC_CCID%ROWTYPE ;
324: ln_total_rec_disc_amt JAI_RGM_TRX_REFS.DISCOUNTED_AMOUNT%TYPE ;
325:
326: BEGIN
327:
328: fnd_file.put_line(fnd_file.LOG,'********************* 1 START OF PROCEDURE jai_ar_rgm_processing_pkg.GET_AR_TAX_DISC_ACCNT *********************');

Line 451: p_batch_id IN JAI_RGM_TRX_REFS.BATCH_ID%TYPE ,

447: p_organization_type IN JAI_RGM_PARTIES.ORGANIZATION_TYPE%TYPE ,
448: p_from_date IN DATE ,
449: p_to_date IN DATE ,
450: p_org_id IN RA_CUSTOMER_TRX_ALL.ORG_ID%TYPE ,
451: p_batch_id IN JAI_RGM_TRX_REFS.BATCH_ID%TYPE ,
452: p_source IN varchar2, --File.Sql.35 Cbabu jai_constants.SOURCE_AR%TYPE ,
453: p_process_flag OUT NOCOPY VARCHAR2 ,
454: p_process_message OUT NOCOPY VARCHAR2,
455: p_organization_id IN JAI_RGM_PARTIES.ORGANIZATION_ID%TYPE DEFAULT NULL

Line 461: ln_reference_id JAI_RGM_TRX_REFS.REFERENCE_ID%TYPE ;

457: IS
458: /******************************
459: ||Variable Declaration Section
460: *******************************/
461: ln_reference_id JAI_RGM_TRX_REFS.REFERENCE_ID%TYPE ;
462: lv_process_flag VARCHAR2(2) ;
463: lv_process_message VARCHAR2(1996) ;
464: ln_invoices_processed NUMBER(10) ;
465:

Line 530: FROM jai_rgm_trx_refs rgtr

526: )
527: ) AND
528: NOT EXISTS ( SELECT /*A ref of invoice/cm should not exist in the reference table */
529: 1
530: FROM jai_rgm_trx_refs rgtr
531: WHERE
532: rgtr.source = p_source AND
533: rgtr.invoice_id = trx.customer_trx_id AND
534: rgtr.line_id = jtrxtl.customer_trx_line_id AND

Line 587: ||insert the invoices and credit memo's into the jai_rgm_trx_refs

583: ||', recoverable_amount '||rec_c_fetch_inv_cm_rec.tax_amount * (rec_c_fetch_inv_cm_rec.mod_cr_percentage/100)
584: );
585:
586: /****
587: ||insert the invoices and credit memo's into the jai_rgm_trx_refs
588: ||using the procedure jai_cmn_rgm_recording_pkg.insert_reference
589: *****/
590: fnd_file.put_line(fnd_file.LOG,'3 before call to procedure jai_cmn_rgm_recording_pkg.insert_reference ');
591:

Line 644: fnd_file.put_line(fnd_file.LOG,'6 inserted record in jai_rgm_trx_refs with reference_id '||ln_reference_id );

640: p_process_message := lv_process_message ;
641: END IF;
642:
643: ln_invoices_processed := ln_invoices_processed + 1;
644: fnd_file.put_line(fnd_file.LOG,'6 inserted record in jai_rgm_trx_refs with reference_id '||ln_reference_id );
645:
646: END LOOP;
647:
648: fnd_file.put_line(fnd_file.LOG,'5 End of procedure : jai_rgm_process_ar.populate_inv_cm_references, number of invoices/CM processed '||ln_invoices_processed );

Line 665: p_batch_id IN JAI_RGM_TRX_REFS.BATCH_ID%TYPE ,

661: p_from_date IN DATE ,
662: p_to_date IN DATE ,
663: p_org_id IN RA_CUSTOMER_TRX_ALL.ORG_ID%TYPE ,
664: p_source IN varchar2, --File.Sql.35 Cbabu jai_constants.SOURCE_AR%TYPE ,
665: p_batch_id IN JAI_RGM_TRX_REFS.BATCH_ID%TYPE ,
666: p_process_flag OUT NOCOPY VARCHAR2 ,
667: p_process_message OUT NOCOPY VARCHAR2
668: ,p_organization_id JAI_RGM_PARTIES.ORGANIZATION_ID%TYPE DEFAULT NULL)
669: IS

Line 674: ln_discounted_amount JAI_RGM_TRX_REFS.DISCOUNTED_AMOUNT%TYPE ;

670:
671: ln_eff_cm_tax_amount AR_RECEIVABLE_APPLICATIONS_ALL.TAX_APPLIED%TYPE ;
672: ln_repository_id JAI_RGM_TRX_RECORDS.REPOSITORY_ID%TYPE ;
673: ln_amount JAI_RGM_TRX_RECORDS.DEBIT_AMOUNT%TYPE ;
674: ln_discounted_amount JAI_RGM_TRX_REFS.DISCOUNTED_AMOUNT%TYPE ;
675: ln_err_cm_customer_trx_id JAI_RGM_TRX_REFS.INVOICE_ID%TYPE ;
676: ln_set_save_point JAI_RGM_TRX_REFS.INVOICE_ID%TYPE ;
677: lv_process_flag VARCHAR2(2) ;
678: lv_process_message VARCHAR2(1996) ;

Line 675: ln_err_cm_customer_trx_id JAI_RGM_TRX_REFS.INVOICE_ID%TYPE ;

671: ln_eff_cm_tax_amount AR_RECEIVABLE_APPLICATIONS_ALL.TAX_APPLIED%TYPE ;
672: ln_repository_id JAI_RGM_TRX_RECORDS.REPOSITORY_ID%TYPE ;
673: ln_amount JAI_RGM_TRX_RECORDS.DEBIT_AMOUNT%TYPE ;
674: ln_discounted_amount JAI_RGM_TRX_REFS.DISCOUNTED_AMOUNT%TYPE ;
675: ln_err_cm_customer_trx_id JAI_RGM_TRX_REFS.INVOICE_ID%TYPE ;
676: ln_set_save_point JAI_RGM_TRX_REFS.INVOICE_ID%TYPE ;
677: lv_process_flag VARCHAR2(2) ;
678: lv_process_message VARCHAR2(1996) ;
679: lv_source_trx_type VARCHAR2(50) ;

Line 676: ln_set_save_point JAI_RGM_TRX_REFS.INVOICE_ID%TYPE ;

672: ln_repository_id JAI_RGM_TRX_RECORDS.REPOSITORY_ID%TYPE ;
673: ln_amount JAI_RGM_TRX_RECORDS.DEBIT_AMOUNT%TYPE ;
674: ln_discounted_amount JAI_RGM_TRX_REFS.DISCOUNTED_AMOUNT%TYPE ;
675: ln_err_cm_customer_trx_id JAI_RGM_TRX_REFS.INVOICE_ID%TYPE ;
676: ln_set_save_point JAI_RGM_TRX_REFS.INVOICE_ID%TYPE ;
677: lv_process_flag VARCHAR2(2) ;
678: lv_process_message VARCHAR2(1996) ;
679: lv_source_trx_type VARCHAR2(50) ;
680: ln_uncommitted_transactions NUMBER(10) := 0 ;

Line 688: || Get all the cm's which exist in the reference table jai_rgm_trx_refs and have been incompleted/incompleted and deleted from AR base table

684: /* Added by Ramananda for bug#4407165 */
685: lv_object_name CONSTANT VARCHAR2(61) := 'jai_ar_rgm_processing_pkg.delete_non_existant_cm';
686:
687: /*
688: || Get all the cm's which exist in the reference table jai_rgm_trx_refs and have been incompleted/incompleted and deleted from AR base table
689: || IF a CM has been incompleted then it would exist with complete_flag = 'N' . if a CM has been incompleted and deleted then it would not exist
690: || in the ra_customer_trx_all table.
691: */
692: CURSOR c_get_incompleted_cm

Line 698: jai_rgm_trx_refs rgtr

694: SELECT
695: rgtr.invoice_id cm_customer_trx_id /*,
696: rgtr.reference_id cm_reference_id */
697: FROM
698: jai_rgm_trx_refs rgtr
699: WHERE
700: rgtr.source = p_source AND
701: rgtr.organization_id = p_organization_id AND /*5879769*/
702: rgtr.reversal_flag = 'Y' AND

Line 723: cp_cm_customer_trx_id JAI_RGM_TRX_REFS.INVOICE_ID%TYPE,

719: || Get all the data of the incompleted CM from the
720: || repository, so that the same record with an exactly opposite amount can be passed. This would be the CM-CM-REV record
721: */
722: CURSOR c_get_cm_cm_app_rec ( /*cp_cm_reference_id JAI_RGM_TRX_RECORDS.REFERENCE_ID%TYPE ,*/
723: cp_cm_customer_trx_id JAI_RGM_TRX_REFS.INVOICE_ID%TYPE,
724: cp_attribute_context jai_rgm_trx_records.attribute_context%TYPE --rchandan for bug#4428980
725: )
726: IS
727: SELECT

Line 739: CURSOR cur_upd_cm_ref ( cp_cm_customer_trx_id JAI_RGM_TRX_REFS.INVOICE_ID%TYPE )

735:
736: /*
737: || Update all the credit memo reference records.
738: */
739: CURSOR cur_upd_cm_ref ( cp_cm_customer_trx_id JAI_RGM_TRX_REFS.INVOICE_ID%TYPE )
740: IS
741: SELECT
742: *
743: FROM

Line 744: jai_rgm_trx_refs

740: IS
741: SELECT
742: *
743: FROM
744: jai_rgm_trx_refs
745: WHERE
746: invoice_id = cp_cm_customer_trx_id AND
747: nvl(recovered_amount,0) <> 0 ;
748:

Line 753: CURSOR c_get_cm_inv_app_rec ( cp_cm_customer_trx_id JAI_RGM_TRX_REFS.INVOICE_ID%TYPE,

749: /*
750: || Get all the data of the CM applied to invoices (i.e CM-INV-APP) from the repository.
751: || So that the same record with an exactly opposite amount can be passed. This would be the new CM-INV-REV record
752: */
753: CURSOR c_get_cm_inv_app_rec ( cp_cm_customer_trx_id JAI_RGM_TRX_REFS.INVOICE_ID%TYPE,
754: cp_attribute_context jai_rgm_trx_records.attribute_context%TYPE ) --rchandan for bug#4428980
755: IS
756: SELECT
757: *

Line 1135: p_batch_id IN JAI_RGM_TRX_REFS.BATCH_ID%TYPE ,

1131: p_from_date IN DATE ,
1132: p_to_date IN DATE ,
1133: p_org_id IN RA_CUSTOMER_TRX_ALL.ORG_ID%TYPE ,
1134: p_source IN varchar2, --File.Sql.35 Cbabu jai_constants.SOURCE_AR%TYPE ,
1135: p_batch_id IN JAI_RGM_TRX_REFS.BATCH_ID%TYPE ,
1136: p_process_flag OUT NOCOPY VARCHAR2 ,
1137: p_process_message OUT NOCOPY VARCHAR2
1138: , p_organization_id JAI_RGM_PARTIES.ORGANIZATION_ID%TYPE DEFAULT NULL )
1139: IS

Line 1142: ln_discounted_amount JAI_RGM_TRX_REFS.DISCOUNTED_AMOUNT%TYPE ;

1138: , p_organization_id JAI_RGM_PARTIES.ORGANIZATION_ID%TYPE DEFAULT NULL )
1139: IS
1140:
1141: ln_eff_cm_tax_amount AR_RECEIVABLE_APPLICATIONS_ALL.TAX_APPLIED%TYPE ;
1142: ln_discounted_amount JAI_RGM_TRX_REFS.DISCOUNTED_AMOUNT%TYPE ;
1143: ln_cm_ref_upd JAI_RGM_TRX_REFS.RECOVERED_AMOUNT%TYPE ;
1144: ln_repository_id JAI_RGM_TRX_RECORDS.REPOSITORY_ID%TYPE ;
1145: lv_source_trx_type VARCHAR2(50) ;
1146: ln_eff_cm_tottax_amt JAI_RGM_TRX_REFS.RECOVERABLE_AMOUNT%TYPE ;

Line 1143: ln_cm_ref_upd JAI_RGM_TRX_REFS.RECOVERED_AMOUNT%TYPE ;

1139: IS
1140:
1141: ln_eff_cm_tax_amount AR_RECEIVABLE_APPLICATIONS_ALL.TAX_APPLIED%TYPE ;
1142: ln_discounted_amount JAI_RGM_TRX_REFS.DISCOUNTED_AMOUNT%TYPE ;
1143: ln_cm_ref_upd JAI_RGM_TRX_REFS.RECOVERED_AMOUNT%TYPE ;
1144: ln_repository_id JAI_RGM_TRX_RECORDS.REPOSITORY_ID%TYPE ;
1145: lv_source_trx_type VARCHAR2(50) ;
1146: ln_eff_cm_tottax_amt JAI_RGM_TRX_REFS.RECOVERABLE_AMOUNT%TYPE ;
1147: ln_tot_effcm_rb_amt JAI_RGM_TRX_REFS.RECOVERABLE_AMOUNT%TYPE ;

Line 1146: ln_eff_cm_tottax_amt JAI_RGM_TRX_REFS.RECOVERABLE_AMOUNT%TYPE ;

1142: ln_discounted_amount JAI_RGM_TRX_REFS.DISCOUNTED_AMOUNT%TYPE ;
1143: ln_cm_ref_upd JAI_RGM_TRX_REFS.RECOVERED_AMOUNT%TYPE ;
1144: ln_repository_id JAI_RGM_TRX_RECORDS.REPOSITORY_ID%TYPE ;
1145: lv_source_trx_type VARCHAR2(50) ;
1146: ln_eff_cm_tottax_amt JAI_RGM_TRX_REFS.RECOVERABLE_AMOUNT%TYPE ;
1147: ln_tot_effcm_rb_amt JAI_RGM_TRX_REFS.RECOVERABLE_AMOUNT%TYPE ;
1148: ln_inv_tot_tax_amt JAI_AR_TRX_TAX_LINES.TAX_AMOUNT%TYPE ;
1149: ln_sign_of_credit_memo NUMBER ;
1150: ln_cm_ref_ratio NUMBER ;

Line 1147: ln_tot_effcm_rb_amt JAI_RGM_TRX_REFS.RECOVERABLE_AMOUNT%TYPE ;

1143: ln_cm_ref_upd JAI_RGM_TRX_REFS.RECOVERED_AMOUNT%TYPE ;
1144: ln_repository_id JAI_RGM_TRX_RECORDS.REPOSITORY_ID%TYPE ;
1145: lv_source_trx_type VARCHAR2(50) ;
1146: ln_eff_cm_tottax_amt JAI_RGM_TRX_REFS.RECOVERABLE_AMOUNT%TYPE ;
1147: ln_tot_effcm_rb_amt JAI_RGM_TRX_REFS.RECOVERABLE_AMOUNT%TYPE ;
1148: ln_inv_tot_tax_amt JAI_AR_TRX_TAX_LINES.TAX_AMOUNT%TYPE ;
1149: ln_sign_of_credit_memo NUMBER ;
1150: ln_cm_ref_ratio NUMBER ;
1151: ln_amount JAI_RGM_TRX_RECORDS.DEBIT_AMOUNT%TYPE ;

Line 1171: || 1. Invoice tax line reference exists in the jai_rgm_trx_refs table for the invoice against which the cash receipt is being applied

1167:
1168: /*
1169: || Get the credit memo applications to invoices and the total invoice tax amount .
1170: || Consider only those credit memo applications which follow the following conditions:-
1171: || 1. Invoice tax line reference exists in the jai_rgm_trx_refs table for the invoice against which the cash receipt is being applied
1172: || 2. The cash receipt tax line does not already exist in the repository i.e jai_rgm_trx_records.
1173: || 3. Consider cash receipt application against an invoice only
1174: || 4. Invoice tax line has not been fully recovered i.e recovered_amount < recoverable_amount - discounted_amount in references table
1175: */

Line 1233: jai_rgm_trx_refs rgtf

1229: EXISTS (
1230: SELECT /* A credit memo exists in the reference table with total recoverable amount <> recovered amount*/
1231: 1
1232: FROM
1233: jai_rgm_trx_refs rgtf
1234: WHERE
1235: rgtf.source = cp_source_ar AND
1236: rgtf.invoice_id = aral.customer_trx_id AND
1237: nvl(rgtf.recoverable_amount,0) <> nvl(rgtf.recovered_amount,0)

Line 1243: jai_rgm_trx_refs rgtf

1239: EXISTS (
1240: SELECT /* A invoice exists in the reference table with total recoverable amount > recovered amount*/
1241: 1
1242: FROM
1243: jai_rgm_trx_refs rgtf
1244: WHERE
1245: rgtf.source = cp_source_ar AND
1246: rgtf.invoice_id = aral.applied_customer_trx_id AND
1247: nvl(rgtf.recoverable_amount,0) - nvl(discounted_amount,0) > nvl(rgtf.recovered_amount,0)

Line 1326: jai_rgm_trx_refs

1322: nvl(recovered_amount,0) recovered_amount ,
1323: recoverable_ptg ,
1324: item_line_id /*5879769*/
1325: FROM
1326: jai_rgm_trx_refs
1327: WHERE
1328: source = cp_source_ar AND
1329: invoice_id = cp_inv_customer_trx_id AND
1330: nvl(recoverable_amount,0) - nvl(discounted_amount,0) > nvl(recovered_amount,0)

Line 1346: jai_rgm_trx_refs

1342: nvl(recoverable_amount,0) recoverable_amount ,
1343: nvl(recovered_amount,0) recovered_amount ,
1344: item_line_id /*5879769*/
1345: FROM
1346: jai_rgm_trx_refs
1347: WHERE
1348: source = cp_source_ar AND
1349: invoice_id = cp_cm_customer_trx_id AND
1350: nvl(recoverable_amount,0) <> nvl(recovered_amount,0)

Line 1363: jai_rgm_trx_refs

1359: IS
1360: SELECT
1361: nvl(sum(recoverable_amount - recovered_amount),0) tot_effcm_rb_amt
1362: FROM
1363: jai_rgm_trx_refs
1364: WHERE
1365: source = cp_source_ar AND
1366: invoice_id = cp_cm_customer_trx_id ;
1367:

Line 1853: p_batch_id IN JAI_RGM_TRX_REFS.BATCH_ID%TYPE ,

1849: p_from_date IN DATE ,
1850: p_to_date IN DATE ,
1851: p_org_id IN RA_CUSTOMER_TRX_ALL.ORG_ID%TYPE ,
1852: p_source IN varchar2, --File.Sql.35 Cbabu jai_constants.SOURCE_AR%TYPE ,
1853: p_batch_id IN JAI_RGM_TRX_REFS.BATCH_ID%TYPE ,
1854: p_process_flag OUT NOCOPY VARCHAR2 ,
1855: p_process_message OUT NOCOPY VARCHAR2
1856: ,p_organization_id IN JAI_RGM_PARTIES.ORGANIZATION_ID%TYPE DEFAULT NULL )
1857: IS

Line 1880: || 1. Invoice tax line reference exists in the jai_rgm_trx_refs table for the invoice against which the cash receipt is being applied

1876: ln_inclusive_total_amt NUMBER; --added by walton for inclusive tax 29-Nov-07
1877: /*
1878: || Get the cash receipt, Invoice and Total Effective Invoice Recoverable Amount for them.
1879: || Consider only those cash receipts which follow the conditions as given below:-
1880: || 1. Invoice tax line reference exists in the jai_rgm_trx_refs table for the invoice against which the cash receipt is being applied
1881: || 2. The cash receipt tax line does not already exist in the repository i.e jai_rgm_trx_records.
1882: || 3. Consider cash receipt application against an invoice only
1883: || 4. Invoice tax line has not been fully recovered i.e recovered_amount < recoverable_amount in references table
1884: */

Line 1940: jai_rgm_trx_refs rgtf

1936: EXISTS (
1937: SELECT /* A invoice exists in the reference table with total recoverable amount - discounted_amount > recovered amount*/
1938: 1
1939: FROM
1940: jai_rgm_trx_refs rgtf
1941: WHERE
1942: rgtf.source = jai_constants.SOURCE_AR AND
1943: rgtf.invoice_id = aral.applied_customer_trx_id AND
1944: (

Line 2014: jai_rgm_trx_refs

2010: nvl(recoverable_amount,0) - nvl(discounted_amount,0) recoverable_amount ,
2011: nvl(recovered_amount,0) recovered_amount ,
2012: item_line_id /*5879769*/
2013: FROM
2014: jai_rgm_trx_refs
2015: WHERE
2016: source = cp_source_ar AND
2017: invoice_id = cp_customer_trx_id AND
2018: nvl(recoverable_amount,0) - nvl(discounted_amount,0) >= nvl(recovered_amount,0) /*Modified the comparison condition to >= for Bug 6474509*/

Line 2344: p_batch_id IN JAI_RGM_TRX_REFS.BATCH_ID%TYPE ,

2340: p_organization_type IN JAI_RGM_PARTIES.ORGANIZATION_TYPE%TYPE ,
2341: p_from_date IN DATE ,
2342: p_to_date IN DATE ,
2343: p_org_id IN RA_CUSTOMER_TRX_ALL.ORG_ID%TYPE ,
2344: p_batch_id IN JAI_RGM_TRX_REFS.BATCH_ID%TYPE ,
2345: p_process_flag OUT NOCOPY VARCHAR2 ,
2346: p_process_message OUT NOCOPY VARCHAR2 ,
2347: p_organization_id IN JAI_RGM_PARTIES.ORGANIZATION_ID%TYPE DEFAULT NULL /*5879769*/
2348: )