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.

APPS.ARP_APP_CALC_PKG dependencies on AR_PAYMENT_SCHEDULES

Line 731: l_ms_gross_remaining ar_payment_schedules.tax_remaining%TYPE:=0;

727: */
728: l_no_of_balance_components CONSTANT number:= 6;
729:
730: l_mixed_sign_count number:= 0;
731: l_ms_gross_remaining ar_payment_schedules.tax_remaining%TYPE:=0;
732: l_amt_remaining ar_payment_schedules.tax_remaining%TYPE:=0;
733: l_ms_applied_amt ar_receivable_applications.tax_applied%TYPE:=0;
734:
735: l_ms_use_line number:= 0;

Line 732: l_amt_remaining ar_payment_schedules.tax_remaining%TYPE:=0;

728: l_no_of_balance_components CONSTANT number:= 6;
729:
730: l_mixed_sign_count number:= 0;
731: l_ms_gross_remaining ar_payment_schedules.tax_remaining%TYPE:=0;
732: l_amt_remaining ar_payment_schedules.tax_remaining%TYPE:=0;
733: l_ms_applied_amt ar_receivable_applications.tax_applied%TYPE:=0;
734:
735: l_ms_use_line number:= 0;
736: l_ms_use_line_tax number:= 0;

Line 759: l_org_line_remaining ar_payment_schedules.tax_remaining%TYPE:=0;

755: l_nonms_applied_charges ar_receivable_applications.tax_applied%TYPE:=0;
756: l_nonms_applied_charges_tax ar_receivable_applications.tax_applied%TYPE:=0;
757:
758: /* To hold original values */
759: l_org_line_remaining ar_payment_schedules.tax_remaining%TYPE:=0;
760: l_org_line_tax_remaining ar_payment_schedules.tax_remaining%TYPE:=0;
761: l_org_fr_remaining ar_payment_schedules.tax_remaining%TYPE:=0;
762: l_org_fr_tax_remaining ar_payment_schedules.tax_remaining%TYPE:=0;
763: l_org_ch_remaining ar_payment_schedules.tax_remaining%TYPE:=0;

Line 760: l_org_line_tax_remaining ar_payment_schedules.tax_remaining%TYPE:=0;

756: l_nonms_applied_charges_tax ar_receivable_applications.tax_applied%TYPE:=0;
757:
758: /* To hold original values */
759: l_org_line_remaining ar_payment_schedules.tax_remaining%TYPE:=0;
760: l_org_line_tax_remaining ar_payment_schedules.tax_remaining%TYPE:=0;
761: l_org_fr_remaining ar_payment_schedules.tax_remaining%TYPE:=0;
762: l_org_fr_tax_remaining ar_payment_schedules.tax_remaining%TYPE:=0;
763: l_org_ch_remaining ar_payment_schedules.tax_remaining%TYPE:=0;
764: l_org_ch_tax_remaining ar_payment_schedules.tax_remaining%TYPE:=0;

Line 761: l_org_fr_remaining ar_payment_schedules.tax_remaining%TYPE:=0;

757:
758: /* To hold original values */
759: l_org_line_remaining ar_payment_schedules.tax_remaining%TYPE:=0;
760: l_org_line_tax_remaining ar_payment_schedules.tax_remaining%TYPE:=0;
761: l_org_fr_remaining ar_payment_schedules.tax_remaining%TYPE:=0;
762: l_org_fr_tax_remaining ar_payment_schedules.tax_remaining%TYPE:=0;
763: l_org_ch_remaining ar_payment_schedules.tax_remaining%TYPE:=0;
764: l_org_ch_tax_remaining ar_payment_schedules.tax_remaining%TYPE:=0;
765:

Line 762: l_org_fr_tax_remaining ar_payment_schedules.tax_remaining%TYPE:=0;

758: /* To hold original values */
759: l_org_line_remaining ar_payment_schedules.tax_remaining%TYPE:=0;
760: l_org_line_tax_remaining ar_payment_schedules.tax_remaining%TYPE:=0;
761: l_org_fr_remaining ar_payment_schedules.tax_remaining%TYPE:=0;
762: l_org_fr_tax_remaining ar_payment_schedules.tax_remaining%TYPE:=0;
763: l_org_ch_remaining ar_payment_schedules.tax_remaining%TYPE:=0;
764: l_org_ch_tax_remaining ar_payment_schedules.tax_remaining%TYPE:=0;
765:
766: /*

Line 763: l_org_ch_remaining ar_payment_schedules.tax_remaining%TYPE:=0;

759: l_org_line_remaining ar_payment_schedules.tax_remaining%TYPE:=0;
760: l_org_line_tax_remaining ar_payment_schedules.tax_remaining%TYPE:=0;
761: l_org_fr_remaining ar_payment_schedules.tax_remaining%TYPE:=0;
762: l_org_fr_tax_remaining ar_payment_schedules.tax_remaining%TYPE:=0;
763: l_org_ch_remaining ar_payment_schedules.tax_remaining%TYPE:=0;
764: l_org_ch_tax_remaining ar_payment_schedules.tax_remaining%TYPE:=0;
765:
766: /*
767: * Currently FREIGHT_TAX and CHARGES_TAX are not treated, so they

Line 764: l_org_ch_tax_remaining ar_payment_schedules.tax_remaining%TYPE:=0;

760: l_org_line_tax_remaining ar_payment_schedules.tax_remaining%TYPE:=0;
761: l_org_fr_remaining ar_payment_schedules.tax_remaining%TYPE:=0;
762: l_org_fr_tax_remaining ar_payment_schedules.tax_remaining%TYPE:=0;
763: l_org_ch_remaining ar_payment_schedules.tax_remaining%TYPE:=0;
764: l_org_ch_tax_remaining ar_payment_schedules.tax_remaining%TYPE:=0;
765:
766: /*
767: * Currently FREIGHT_TAX and CHARGES_TAX are not treated, so they
768: * appear as local variables.

Line 1117: | l_amt ar_payment_schedules.amount_due_remaining%TYPE;

1113: | LINE, PRORATE , Rounding Correction : Y
1114: | FREIGHT, NONE , Rounding Correction : N
1115: | CHARGES, NONE , Rounding Correction : N
1116: |
1117: | l_amt ar_payment_schedules.amount_due_remaining%TYPE;
1118: | l_line_remaining ar_payment_schedules.amount_due_remaining%TYPE;
1119: | l_freight_remaining ar_payment_schedules.amount_due_remaining%TYPE;
1120: | l_charges_remaining ar_payment_schedules.amount_due_remaining%TYPE;
1121: | l_gross_remaining ar_payment_schedules.amount_due_remaining%TYPE;

Line 1118: | l_line_remaining ar_payment_schedules.amount_due_remaining%TYPE;

1114: | FREIGHT, NONE , Rounding Correction : N
1115: | CHARGES, NONE , Rounding Correction : N
1116: |
1117: | l_amt ar_payment_schedules.amount_due_remaining%TYPE;
1118: | l_line_remaining ar_payment_schedules.amount_due_remaining%TYPE;
1119: | l_freight_remaining ar_payment_schedules.amount_due_remaining%TYPE;
1120: | l_charges_remaining ar_payment_schedules.amount_due_remaining%TYPE;
1121: | l_gross_remaining ar_payment_schedules.amount_due_remaining%TYPE;
1122: | l_line_applied ar_payment_schedules.amount_due_remaining%TYPE:=0;

Line 1119: | l_freight_remaining ar_payment_schedules.amount_due_remaining%TYPE;

1115: | CHARGES, NONE , Rounding Correction : N
1116: |
1117: | l_amt ar_payment_schedules.amount_due_remaining%TYPE;
1118: | l_line_remaining ar_payment_schedules.amount_due_remaining%TYPE;
1119: | l_freight_remaining ar_payment_schedules.amount_due_remaining%TYPE;
1120: | l_charges_remaining ar_payment_schedules.amount_due_remaining%TYPE;
1121: | l_gross_remaining ar_payment_schedules.amount_due_remaining%TYPE;
1122: | l_line_applied ar_payment_schedules.amount_due_remaining%TYPE:=0;
1123: | l_freight_applied ar_payment_schedules.amount_due_remaining%TYPE:=0;

Line 1120: | l_charges_remaining ar_payment_schedules.amount_due_remaining%TYPE;

1116: |
1117: | l_amt ar_payment_schedules.amount_due_remaining%TYPE;
1118: | l_line_remaining ar_payment_schedules.amount_due_remaining%TYPE;
1119: | l_freight_remaining ar_payment_schedules.amount_due_remaining%TYPE;
1120: | l_charges_remaining ar_payment_schedules.amount_due_remaining%TYPE;
1121: | l_gross_remaining ar_payment_schedules.amount_due_remaining%TYPE;
1122: | l_line_applied ar_payment_schedules.amount_due_remaining%TYPE:=0;
1123: | l_freight_applied ar_payment_schedules.amount_due_remaining%TYPE:=0;
1124: | l_charges_applied ar_payment_schedules.amount_due_remaining%TYPE:=0;

Line 1121: | l_gross_remaining ar_payment_schedules.amount_due_remaining%TYPE;

1117: | l_amt ar_payment_schedules.amount_due_remaining%TYPE;
1118: | l_line_remaining ar_payment_schedules.amount_due_remaining%TYPE;
1119: | l_freight_remaining ar_payment_schedules.amount_due_remaining%TYPE;
1120: | l_charges_remaining ar_payment_schedules.amount_due_remaining%TYPE;
1121: | l_gross_remaining ar_payment_schedules.amount_due_remaining%TYPE;
1122: | l_line_applied ar_payment_schedules.amount_due_remaining%TYPE:=0;
1123: | l_freight_applied ar_payment_schedules.amount_due_remaining%TYPE:=0;
1124: | l_charges_applied ar_payment_schedules.amount_due_remaining%TYPE:=0;
1125: | l_counter number := 0;

Line 1122: | l_line_applied ar_payment_schedules.amount_due_remaining%TYPE:=0;

1118: | l_line_remaining ar_payment_schedules.amount_due_remaining%TYPE;
1119: | l_freight_remaining ar_payment_schedules.amount_due_remaining%TYPE;
1120: | l_charges_remaining ar_payment_schedules.amount_due_remaining%TYPE;
1121: | l_gross_remaining ar_payment_schedules.amount_due_remaining%TYPE;
1122: | l_line_applied ar_payment_schedules.amount_due_remaining%TYPE:=0;
1123: | l_freight_applied ar_payment_schedules.amount_due_remaining%TYPE:=0;
1124: | l_charges_applied ar_payment_schedules.amount_due_remaining%TYPE:=0;
1125: | l_counter number := 0;
1126: | BEGIN l_amt := :amt ;

Line 1123: | l_freight_applied ar_payment_schedules.amount_due_remaining%TYPE:=0;

1119: | l_freight_remaining ar_payment_schedules.amount_due_remaining%TYPE;
1120: | l_charges_remaining ar_payment_schedules.amount_due_remaining%TYPE;
1121: | l_gross_remaining ar_payment_schedules.amount_due_remaining%TYPE;
1122: | l_line_applied ar_payment_schedules.amount_due_remaining%TYPE:=0;
1123: | l_freight_applied ar_payment_schedules.amount_due_remaining%TYPE:=0;
1124: | l_charges_applied ar_payment_schedules.amount_due_remaining%TYPE:=0;
1125: | l_counter number := 0;
1126: | BEGIN l_amt := :amt ;
1127: | l_line_remaining := :line_remaining ;

Line 1124: | l_charges_applied ar_payment_schedules.amount_due_remaining%TYPE:=0;

1120: | l_charges_remaining ar_payment_schedules.amount_due_remaining%TYPE;
1121: | l_gross_remaining ar_payment_schedules.amount_due_remaining%TYPE;
1122: | l_line_applied ar_payment_schedules.amount_due_remaining%TYPE:=0;
1123: | l_freight_applied ar_payment_schedules.amount_due_remaining%TYPE:=0;
1124: | l_charges_applied ar_payment_schedules.amount_due_remaining%TYPE:=0;
1125: | l_counter number := 0;
1126: | BEGIN l_amt := :amt ;
1127: | l_line_remaining := :line_remaining ;
1128: | l_freight_remaining := :freight_remaining ;

Line 1298: l_amt ar_payment_schedules.amount_due_remaining%TYPE;

1294:
1295: /* 07-SEP-99 J Rautiainen Bugfix for bug 973520. Added boolean variable
1296: * l_force_exit_flag. The flag is used to prevent infinite loops */
1297: l_source := '
1298: l_amt ar_payment_schedules.amount_due_remaining%TYPE;
1299: l_line_remaining ar_payment_schedules.amount_due_remaining%TYPE;
1300: l_freight_remaining ar_payment_schedules.amount_due_remaining%TYPE;
1301: l_charges_remaining ar_payment_schedules.amount_due_remaining%TYPE;
1302: l_gross_remaining ar_payment_schedules.amount_due_remaining%TYPE;

Line 1299: l_line_remaining ar_payment_schedules.amount_due_remaining%TYPE;

1295: /* 07-SEP-99 J Rautiainen Bugfix for bug 973520. Added boolean variable
1296: * l_force_exit_flag. The flag is used to prevent infinite loops */
1297: l_source := '
1298: l_amt ar_payment_schedules.amount_due_remaining%TYPE;
1299: l_line_remaining ar_payment_schedules.amount_due_remaining%TYPE;
1300: l_freight_remaining ar_payment_schedules.amount_due_remaining%TYPE;
1301: l_charges_remaining ar_payment_schedules.amount_due_remaining%TYPE;
1302: l_gross_remaining ar_payment_schedules.amount_due_remaining%TYPE;
1303: l_line_applied ar_payment_schedules.amount_due_remaining%TYPE:=0;

Line 1300: l_freight_remaining ar_payment_schedules.amount_due_remaining%TYPE;

1296: * l_force_exit_flag. The flag is used to prevent infinite loops */
1297: l_source := '
1298: l_amt ar_payment_schedules.amount_due_remaining%TYPE;
1299: l_line_remaining ar_payment_schedules.amount_due_remaining%TYPE;
1300: l_freight_remaining ar_payment_schedules.amount_due_remaining%TYPE;
1301: l_charges_remaining ar_payment_schedules.amount_due_remaining%TYPE;
1302: l_gross_remaining ar_payment_schedules.amount_due_remaining%TYPE;
1303: l_line_applied ar_payment_schedules.amount_due_remaining%TYPE:=0;
1304: l_freight_applied ar_payment_schedules.amount_due_remaining%TYPE:=0;

Line 1301: l_charges_remaining ar_payment_schedules.amount_due_remaining%TYPE;

1297: l_source := '
1298: l_amt ar_payment_schedules.amount_due_remaining%TYPE;
1299: l_line_remaining ar_payment_schedules.amount_due_remaining%TYPE;
1300: l_freight_remaining ar_payment_schedules.amount_due_remaining%TYPE;
1301: l_charges_remaining ar_payment_schedules.amount_due_remaining%TYPE;
1302: l_gross_remaining ar_payment_schedules.amount_due_remaining%TYPE;
1303: l_line_applied ar_payment_schedules.amount_due_remaining%TYPE:=0;
1304: l_freight_applied ar_payment_schedules.amount_due_remaining%TYPE:=0;
1305: l_charges_applied ar_payment_schedules.amount_due_remaining%TYPE:=0;

Line 1302: l_gross_remaining ar_payment_schedules.amount_due_remaining%TYPE;

1298: l_amt ar_payment_schedules.amount_due_remaining%TYPE;
1299: l_line_remaining ar_payment_schedules.amount_due_remaining%TYPE;
1300: l_freight_remaining ar_payment_schedules.amount_due_remaining%TYPE;
1301: l_charges_remaining ar_payment_schedules.amount_due_remaining%TYPE;
1302: l_gross_remaining ar_payment_schedules.amount_due_remaining%TYPE;
1303: l_line_applied ar_payment_schedules.amount_due_remaining%TYPE:=0;
1304: l_freight_applied ar_payment_schedules.amount_due_remaining%TYPE:=0;
1305: l_charges_applied ar_payment_schedules.amount_due_remaining%TYPE:=0;
1306: l_currency ar_payment_schedules.invoice_currency_code%TYPE;

Line 1303: l_line_applied ar_payment_schedules.amount_due_remaining%TYPE:=0;

1299: l_line_remaining ar_payment_schedules.amount_due_remaining%TYPE;
1300: l_freight_remaining ar_payment_schedules.amount_due_remaining%TYPE;
1301: l_charges_remaining ar_payment_schedules.amount_due_remaining%TYPE;
1302: l_gross_remaining ar_payment_schedules.amount_due_remaining%TYPE;
1303: l_line_applied ar_payment_schedules.amount_due_remaining%TYPE:=0;
1304: l_freight_applied ar_payment_schedules.amount_due_remaining%TYPE:=0;
1305: l_charges_applied ar_payment_schedules.amount_due_remaining%TYPE:=0;
1306: l_currency ar_payment_schedules.invoice_currency_code%TYPE;
1307: l_counter number := 0;

Line 1304: l_freight_applied ar_payment_schedules.amount_due_remaining%TYPE:=0;

1300: l_freight_remaining ar_payment_schedules.amount_due_remaining%TYPE;
1301: l_charges_remaining ar_payment_schedules.amount_due_remaining%TYPE;
1302: l_gross_remaining ar_payment_schedules.amount_due_remaining%TYPE;
1303: l_line_applied ar_payment_schedules.amount_due_remaining%TYPE:=0;
1304: l_freight_applied ar_payment_schedules.amount_due_remaining%TYPE:=0;
1305: l_charges_applied ar_payment_schedules.amount_due_remaining%TYPE:=0;
1306: l_currency ar_payment_schedules.invoice_currency_code%TYPE;
1307: l_counter number := 0;
1308: l_force_exit_flag BOOLEAN := TRUE;

Line 1305: l_charges_applied ar_payment_schedules.amount_due_remaining%TYPE:=0;

1301: l_charges_remaining ar_payment_schedules.amount_due_remaining%TYPE;
1302: l_gross_remaining ar_payment_schedules.amount_due_remaining%TYPE;
1303: l_line_applied ar_payment_schedules.amount_due_remaining%TYPE:=0;
1304: l_freight_applied ar_payment_schedules.amount_due_remaining%TYPE:=0;
1305: l_charges_applied ar_payment_schedules.amount_due_remaining%TYPE:=0;
1306: l_currency ar_payment_schedules.invoice_currency_code%TYPE;
1307: l_counter number := 0;
1308: l_force_exit_flag BOOLEAN := TRUE;
1309:

Line 1306: l_currency ar_payment_schedules.invoice_currency_code%TYPE;

1302: l_gross_remaining ar_payment_schedules.amount_due_remaining%TYPE;
1303: l_line_applied ar_payment_schedules.amount_due_remaining%TYPE:=0;
1304: l_freight_applied ar_payment_schedules.amount_due_remaining%TYPE:=0;
1305: l_charges_applied ar_payment_schedules.amount_due_remaining%TYPE:=0;
1306: l_currency ar_payment_schedules.invoice_currency_code%TYPE;
1307: l_counter number := 0;
1308: l_force_exit_flag BOOLEAN := TRUE;
1309:
1310: BEGIN l_amt := :amt ;

Line 1540: * ar_payment_schedules is populated is 0. As a result updates in ar_payment_schedules

1536: * following 'IF' condition for overapplication fails, because it checks to see
1537: * whether any of the line_remaining,freight_remaining,charges_remaining is > 0.
1538: * Consequently the statement l_line_applied := l_line_applied + l_amt is never
1539: * executed, and hence l_line_applied from which AMOUNT_LINE_ITEMS_REMAINING column
1540: * ar_payment_schedules is populated is 0. As a result updates in ar_payment_schedules
1541: * are incorrect.
1542: * Fix is to remove the condition 'and ((l_line_remaining >0) OR (l_freight_remaining >0)
1543: * OR (l_charges_remaining >0))' introduced as part of bug fix 840642, while retaining the
1544: * fix made for bug 973520. Such a fix would resolve all three bugs 840642, 973520 and 1105018.