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 761: l_org_line_remaining ar_payment_schedules.tax_remaining%TYPE:=0;

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

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

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

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

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

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

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

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

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

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

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

Line 1127: | l_amt ar_payment_schedules.amount_due_remaining%TYPE;

1123: | LINE, PRORATE , Rounding Correction : Y
1124: | FREIGHT, NONE , Rounding Correction : N
1125: | CHARGES, NONE , Rounding Correction : N
1126: |
1127: | l_amt ar_payment_schedules.amount_due_remaining%TYPE;
1128: | l_line_remaining ar_payment_schedules.amount_due_remaining%TYPE;
1129: | l_freight_remaining ar_payment_schedules.amount_due_remaining%TYPE;
1130: | l_charges_remaining ar_payment_schedules.amount_due_remaining%TYPE;
1131: | l_gross_remaining ar_payment_schedules.amount_due_remaining%TYPE;

Line 1128: | l_line_remaining ar_payment_schedules.amount_due_remaining%TYPE;

1124: | FREIGHT, NONE , Rounding Correction : N
1125: | CHARGES, NONE , Rounding Correction : N
1126: |
1127: | l_amt ar_payment_schedules.amount_due_remaining%TYPE;
1128: | l_line_remaining ar_payment_schedules.amount_due_remaining%TYPE;
1129: | l_freight_remaining ar_payment_schedules.amount_due_remaining%TYPE;
1130: | l_charges_remaining ar_payment_schedules.amount_due_remaining%TYPE;
1131: | l_gross_remaining ar_payment_schedules.amount_due_remaining%TYPE;
1132: | l_line_applied ar_payment_schedules.amount_due_remaining%TYPE:=0;

Line 1129: | l_freight_remaining ar_payment_schedules.amount_due_remaining%TYPE;

1125: | CHARGES, NONE , Rounding Correction : N
1126: |
1127: | l_amt ar_payment_schedules.amount_due_remaining%TYPE;
1128: | l_line_remaining ar_payment_schedules.amount_due_remaining%TYPE;
1129: | l_freight_remaining ar_payment_schedules.amount_due_remaining%TYPE;
1130: | l_charges_remaining ar_payment_schedules.amount_due_remaining%TYPE;
1131: | l_gross_remaining ar_payment_schedules.amount_due_remaining%TYPE;
1132: | l_line_applied ar_payment_schedules.amount_due_remaining%TYPE:=0;
1133: | l_freight_applied ar_payment_schedules.amount_due_remaining%TYPE:=0;

Line 1130: | l_charges_remaining ar_payment_schedules.amount_due_remaining%TYPE;

1126: |
1127: | l_amt ar_payment_schedules.amount_due_remaining%TYPE;
1128: | l_line_remaining ar_payment_schedules.amount_due_remaining%TYPE;
1129: | l_freight_remaining ar_payment_schedules.amount_due_remaining%TYPE;
1130: | l_charges_remaining ar_payment_schedules.amount_due_remaining%TYPE;
1131: | l_gross_remaining ar_payment_schedules.amount_due_remaining%TYPE;
1132: | l_line_applied ar_payment_schedules.amount_due_remaining%TYPE:=0;
1133: | l_freight_applied ar_payment_schedules.amount_due_remaining%TYPE:=0;
1134: | l_charges_applied ar_payment_schedules.amount_due_remaining%TYPE:=0;

Line 1131: | l_gross_remaining ar_payment_schedules.amount_due_remaining%TYPE;

1127: | l_amt ar_payment_schedules.amount_due_remaining%TYPE;
1128: | l_line_remaining ar_payment_schedules.amount_due_remaining%TYPE;
1129: | l_freight_remaining ar_payment_schedules.amount_due_remaining%TYPE;
1130: | l_charges_remaining ar_payment_schedules.amount_due_remaining%TYPE;
1131: | l_gross_remaining ar_payment_schedules.amount_due_remaining%TYPE;
1132: | l_line_applied ar_payment_schedules.amount_due_remaining%TYPE:=0;
1133: | l_freight_applied ar_payment_schedules.amount_due_remaining%TYPE:=0;
1134: | l_charges_applied ar_payment_schedules.amount_due_remaining%TYPE:=0;
1135: | l_counter number := 0;

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

1128: | l_line_remaining ar_payment_schedules.amount_due_remaining%TYPE;
1129: | l_freight_remaining ar_payment_schedules.amount_due_remaining%TYPE;
1130: | l_charges_remaining ar_payment_schedules.amount_due_remaining%TYPE;
1131: | l_gross_remaining ar_payment_schedules.amount_due_remaining%TYPE;
1132: | l_line_applied ar_payment_schedules.amount_due_remaining%TYPE:=0;
1133: | l_freight_applied ar_payment_schedules.amount_due_remaining%TYPE:=0;
1134: | l_charges_applied ar_payment_schedules.amount_due_remaining%TYPE:=0;
1135: | l_counter number := 0;
1136: | BEGIN l_amt := :amt ;

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

1129: | l_freight_remaining ar_payment_schedules.amount_due_remaining%TYPE;
1130: | l_charges_remaining ar_payment_schedules.amount_due_remaining%TYPE;
1131: | l_gross_remaining ar_payment_schedules.amount_due_remaining%TYPE;
1132: | l_line_applied ar_payment_schedules.amount_due_remaining%TYPE:=0;
1133: | l_freight_applied ar_payment_schedules.amount_due_remaining%TYPE:=0;
1134: | l_charges_applied ar_payment_schedules.amount_due_remaining%TYPE:=0;
1135: | l_counter number := 0;
1136: | BEGIN l_amt := :amt ;
1137: | l_line_remaining := :line_remaining ;

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

1130: | l_charges_remaining ar_payment_schedules.amount_due_remaining%TYPE;
1131: | l_gross_remaining ar_payment_schedules.amount_due_remaining%TYPE;
1132: | l_line_applied ar_payment_schedules.amount_due_remaining%TYPE:=0;
1133: | l_freight_applied ar_payment_schedules.amount_due_remaining%TYPE:=0;
1134: | l_charges_applied ar_payment_schedules.amount_due_remaining%TYPE:=0;
1135: | l_counter number := 0;
1136: | BEGIN l_amt := :amt ;
1137: | l_line_remaining := :line_remaining ;
1138: | l_freight_remaining := :freight_remaining ;

Line 1308: l_amt ar_payment_schedules.amount_due_remaining%TYPE;

1304:
1305: /* 07-SEP-99 J Rautiainen Bugfix for bug 973520. Added boolean variable
1306: * l_force_exit_flag. The flag is used to prevent infinite loops */
1307: l_source := '
1308: l_amt ar_payment_schedules.amount_due_remaining%TYPE;
1309: l_line_remaining ar_payment_schedules.amount_due_remaining%TYPE;
1310: l_freight_remaining ar_payment_schedules.amount_due_remaining%TYPE;
1311: l_charges_remaining ar_payment_schedules.amount_due_remaining%TYPE;
1312: l_gross_remaining ar_payment_schedules.amount_due_remaining%TYPE;

Line 1309: l_line_remaining ar_payment_schedules.amount_due_remaining%TYPE;

1305: /* 07-SEP-99 J Rautiainen Bugfix for bug 973520. Added boolean variable
1306: * l_force_exit_flag. The flag is used to prevent infinite loops */
1307: l_source := '
1308: l_amt ar_payment_schedules.amount_due_remaining%TYPE;
1309: l_line_remaining ar_payment_schedules.amount_due_remaining%TYPE;
1310: l_freight_remaining ar_payment_schedules.amount_due_remaining%TYPE;
1311: l_charges_remaining ar_payment_schedules.amount_due_remaining%TYPE;
1312: l_gross_remaining ar_payment_schedules.amount_due_remaining%TYPE;
1313: l_line_applied ar_payment_schedules.amount_due_remaining%TYPE:=0;

Line 1310: l_freight_remaining ar_payment_schedules.amount_due_remaining%TYPE;

1306: * l_force_exit_flag. The flag is used to prevent infinite loops */
1307: l_source := '
1308: l_amt ar_payment_schedules.amount_due_remaining%TYPE;
1309: l_line_remaining ar_payment_schedules.amount_due_remaining%TYPE;
1310: l_freight_remaining ar_payment_schedules.amount_due_remaining%TYPE;
1311: l_charges_remaining ar_payment_schedules.amount_due_remaining%TYPE;
1312: l_gross_remaining ar_payment_schedules.amount_due_remaining%TYPE;
1313: l_line_applied ar_payment_schedules.amount_due_remaining%TYPE:=0;
1314: l_freight_applied ar_payment_schedules.amount_due_remaining%TYPE:=0;

Line 1311: l_charges_remaining ar_payment_schedules.amount_due_remaining%TYPE;

1307: l_source := '
1308: l_amt ar_payment_schedules.amount_due_remaining%TYPE;
1309: l_line_remaining ar_payment_schedules.amount_due_remaining%TYPE;
1310: l_freight_remaining ar_payment_schedules.amount_due_remaining%TYPE;
1311: l_charges_remaining ar_payment_schedules.amount_due_remaining%TYPE;
1312: l_gross_remaining ar_payment_schedules.amount_due_remaining%TYPE;
1313: l_line_applied ar_payment_schedules.amount_due_remaining%TYPE:=0;
1314: l_freight_applied ar_payment_schedules.amount_due_remaining%TYPE:=0;
1315: l_charges_applied ar_payment_schedules.amount_due_remaining%TYPE:=0;

Line 1312: l_gross_remaining ar_payment_schedules.amount_due_remaining%TYPE;

1308: l_amt ar_payment_schedules.amount_due_remaining%TYPE;
1309: l_line_remaining ar_payment_schedules.amount_due_remaining%TYPE;
1310: l_freight_remaining ar_payment_schedules.amount_due_remaining%TYPE;
1311: l_charges_remaining ar_payment_schedules.amount_due_remaining%TYPE;
1312: l_gross_remaining ar_payment_schedules.amount_due_remaining%TYPE;
1313: l_line_applied ar_payment_schedules.amount_due_remaining%TYPE:=0;
1314: l_freight_applied ar_payment_schedules.amount_due_remaining%TYPE:=0;
1315: l_charges_applied ar_payment_schedules.amount_due_remaining%TYPE:=0;
1316: l_currency ar_payment_schedules.invoice_currency_code%TYPE;

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

1309: l_line_remaining ar_payment_schedules.amount_due_remaining%TYPE;
1310: l_freight_remaining ar_payment_schedules.amount_due_remaining%TYPE;
1311: l_charges_remaining ar_payment_schedules.amount_due_remaining%TYPE;
1312: l_gross_remaining ar_payment_schedules.amount_due_remaining%TYPE;
1313: l_line_applied ar_payment_schedules.amount_due_remaining%TYPE:=0;
1314: l_freight_applied ar_payment_schedules.amount_due_remaining%TYPE:=0;
1315: l_charges_applied ar_payment_schedules.amount_due_remaining%TYPE:=0;
1316: l_currency ar_payment_schedules.invoice_currency_code%TYPE;
1317: l_counter number := 0;

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

1310: l_freight_remaining ar_payment_schedules.amount_due_remaining%TYPE;
1311: l_charges_remaining ar_payment_schedules.amount_due_remaining%TYPE;
1312: l_gross_remaining ar_payment_schedules.amount_due_remaining%TYPE;
1313: l_line_applied ar_payment_schedules.amount_due_remaining%TYPE:=0;
1314: l_freight_applied ar_payment_schedules.amount_due_remaining%TYPE:=0;
1315: l_charges_applied ar_payment_schedules.amount_due_remaining%TYPE:=0;
1316: l_currency ar_payment_schedules.invoice_currency_code%TYPE;
1317: l_counter number := 0;
1318: l_force_exit_flag BOOLEAN := TRUE;

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

1311: l_charges_remaining ar_payment_schedules.amount_due_remaining%TYPE;
1312: l_gross_remaining ar_payment_schedules.amount_due_remaining%TYPE;
1313: l_line_applied ar_payment_schedules.amount_due_remaining%TYPE:=0;
1314: l_freight_applied ar_payment_schedules.amount_due_remaining%TYPE:=0;
1315: l_charges_applied ar_payment_schedules.amount_due_remaining%TYPE:=0;
1316: l_currency ar_payment_schedules.invoice_currency_code%TYPE;
1317: l_counter number := 0;
1318: l_force_exit_flag BOOLEAN := TRUE;
1319:

Line 1316: l_currency ar_payment_schedules.invoice_currency_code%TYPE;

1312: l_gross_remaining ar_payment_schedules.amount_due_remaining%TYPE;
1313: l_line_applied ar_payment_schedules.amount_due_remaining%TYPE:=0;
1314: l_freight_applied ar_payment_schedules.amount_due_remaining%TYPE:=0;
1315: l_charges_applied ar_payment_schedules.amount_due_remaining%TYPE:=0;
1316: l_currency ar_payment_schedules.invoice_currency_code%TYPE;
1317: l_counter number := 0;
1318: l_force_exit_flag BOOLEAN := TRUE;
1319:
1320: BEGIN l_amt := :amt ;

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

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