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_CALCULATE_DISCOUNT dependencies on AR_PAYMENT_SCHEDULES

Line 10: p_ps_rec IN OUT NOCOPY ar_payment_schedules%ROWTYPE

6: PG_DEBUG varchar2(1) := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
7:
8: /*PROCEDURE get_discount_percentages(
9: p_disc_rec IN OUT NOCOPY discount_record_type,
10: p_ps_rec IN OUT NOCOPY ar_payment_schedules%ROWTYPE
11: );
12: PROCEDURE get_payment_schedule_info(
13: p_disc_rec IN OUT NOCOPY discount_record_type,
14: p_ps_rec IN OUT NOCOPY ar_payment_schedules%ROWTYPE

Line 14: p_ps_rec IN OUT NOCOPY ar_payment_schedules%ROWTYPE

10: p_ps_rec IN OUT NOCOPY ar_payment_schedules%ROWTYPE
11: );
12: PROCEDURE get_payment_schedule_info(
13: p_disc_rec IN OUT NOCOPY discount_record_type,
14: p_ps_rec IN OUT NOCOPY ar_payment_schedules%ROWTYPE
15: );
16: */
17: PROCEDURE get_best_discount_percentage(
18: p_disc_rec IN OUT NOCOPY discount_record_type,

Line 19: p_ps_rec IN ar_payment_schedules%ROWTYPE

15: );
16: */
17: PROCEDURE get_best_discount_percentage(
18: p_disc_rec IN OUT NOCOPY discount_record_type,
19: p_ps_rec IN ar_payment_schedules%ROWTYPE
20: );
21:
22: PROCEDURE get_current_discount_percent(
23: p_disc_rec IN OUT NOCOPY discount_record_type,

Line 24: p_ps_rec IN ar_payment_schedules%ROWTYPE

20: );
21:
22: PROCEDURE get_current_discount_percent(
23: p_disc_rec IN OUT NOCOPY discount_record_type,
24: p_ps_rec IN ar_payment_schedules%ROWTYPE
25: );
26:
27: --PROCEDURE correct_lines_only_discounts(
28: -- p_disc_rec IN OUT NOCOPY discount_record_type,

Line 29: -- p_ps_rec IN ar_payment_schedules%ROWTYPE );

25: );
26:
27: --PROCEDURE correct_lines_only_discounts(
28: -- p_disc_rec IN OUT NOCOPY discount_record_type,
29: -- p_ps_rec IN ar_payment_schedules%ROWTYPE );
30: PROCEDURE decrease_discounts_to_adr(
31: p_disc_rec IN OUT NOCOPY discount_record_type,
32: p_ps_rec IN ar_payment_schedules%ROWTYPE,
33: p_earned_disc IN OUT NOCOPY NUMBER,

Line 32: p_ps_rec IN ar_payment_schedules%ROWTYPE,

28: -- p_disc_rec IN OUT NOCOPY discount_record_type,
29: -- p_ps_rec IN ar_payment_schedules%ROWTYPE );
30: PROCEDURE decrease_discounts_to_adr(
31: p_disc_rec IN OUT NOCOPY discount_record_type,
32: p_ps_rec IN ar_payment_schedules%ROWTYPE,
33: p_earned_disc IN OUT NOCOPY NUMBER,
34: p_unearned_disc IN OUT NOCOPY NUMBER);
35: --PROCEDURE determine_max_allowed_disc(
36: -- p_mode IN number,

Line 38: -- p_ps_rec IN ar_payment_schedules%ROWTYPE );

34: p_unearned_disc IN OUT NOCOPY NUMBER);
35: --PROCEDURE determine_max_allowed_disc(
36: -- p_mode IN number,
37: -- p_disc_rec IN OUT NOCOPY discount_record_type,
38: -- p_ps_rec IN ar_payment_schedules%ROWTYPE );
39: /*FP bug 5335376 for 5223829 Leftover changes of bug for case of system option partial discount unchecked*/
40: PROCEDURE calculate_direct_discount(
41: p_mode IN number,
42: p_disc_rec IN OUT NOCOPY discount_record_type,

Line 43: p_ps_rec IN ar_payment_schedules%ROWTYPE,

39: /*FP bug 5335376 for 5223829 Leftover changes of bug for case of system option partial discount unchecked*/
40: PROCEDURE calculate_direct_discount(
41: p_mode IN number,
42: p_disc_rec IN OUT NOCOPY discount_record_type,
43: p_ps_rec IN ar_payment_schedules%ROWTYPE,
44: p_earned_disc IN OUT NOCOPY NUMBER,
45: p_unearned_disc IN OUT NOCOPY NUMBER,
46: p_called_from IN varchar2 default 'AR');
47: /*FP bug 5335376 for 5223829 Leftover changes of bug for case of system option partial discount unchecked*/

Line 51: p_ps_rec IN ar_payment_schedules%ROWTYPE,

47: /*FP bug 5335376 for 5223829 Leftover changes of bug for case of system option partial discount unchecked*/
48: PROCEDURE calculate_default_discount(
49: p_mode IN number,
50: p_disc_rec IN OUT NOCOPY discount_record_type,
51: p_ps_rec IN ar_payment_schedules%ROWTYPE,
52: p_earned_disc IN OUT NOCOPY NUMBER,
53: p_unearned_disc IN OUT NOCOPY NUMBER,
54: p_out_amt_to_apply IN OUT NOCOPY NUMBER,
55: p_called_from IN varchar2 default 'AR' );

Line 59: p_ps_rec IN OUT NOCOPY ar_payment_schedules%ROWTYPE );

55: p_called_from IN varchar2 default 'AR' );
56: PROCEDURE check_input(
57: p_disc_rec IN discount_record_type,
58: p_select_flag IN BOOLEAN,
59: p_ps_rec IN OUT NOCOPY ar_payment_schedules%ROWTYPE );
60: PROCEDURE decrease_discounts_to_maxd(
61: p_disc_rec IN OUT NOCOPY discount_record_type,
62: p_ps_rec IN ar_payment_schedules%ROWTYPE,
63: p_earned_disc IN OUT NOCOPY NUMBER,

Line 62: p_ps_rec IN ar_payment_schedules%ROWTYPE,

58: p_select_flag IN BOOLEAN,
59: p_ps_rec IN OUT NOCOPY ar_payment_schedules%ROWTYPE );
60: PROCEDURE decrease_discounts_to_maxd(
61: p_disc_rec IN OUT NOCOPY discount_record_type,
62: p_ps_rec IN ar_payment_schedules%ROWTYPE,
63: p_earned_disc IN OUT NOCOPY NUMBER,
64: p_unearned_disc IN OUT NOCOPY NUMBER);
65: --
66: --

Line 70: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,

66: --
67: PROCEDURE validate_args_discounts_cover(
68: p_mode IN VARCHAR2,
69: p_invoice_currency_code IN ar_cash_receipts.currency_code%TYPE,
70: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
71: p_trx_date IN ar_payment_schedules.trx_date%TYPE,
72: p_apply_date IN ar_cash_receipts.receipt_date%TYPE );
73: --
74: /*===========================================================================+

Line 71: p_trx_date IN ar_payment_schedules.trx_date%TYPE,

67: PROCEDURE validate_args_discounts_cover(
68: p_mode IN VARCHAR2,
69: p_invoice_currency_code IN ar_cash_receipts.currency_code%TYPE,
70: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
71: p_trx_date IN ar_payment_schedules.trx_date%TYPE,
72: p_apply_date IN ar_cash_receipts.receipt_date%TYPE );
73: --
74: /*===========================================================================+
75: | PROCEDURE |

Line 136: p_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE,

132: p_out_unearned_disc IN OUT NOCOPY NUMBER,
133: p_out_discount_date IN OUT NOCOPY DATE,
134: p_out_amt_to_apply IN OUT NOCOPY NUMBER,
135: p_close_invoice_flag IN VARCHAR2,
136: p_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE,
137: p_term_id IN ar_payment_schedules.term_id%TYPE,
138: p_terms_sequence_number IN ar_payment_schedules.terms_sequence_number%TYPE,
139: p_trx_date IN ar_payment_schedules.trx_date%TYPE,
140: p_amt_due_original IN ar_payment_schedules.amount_due_original%TYPE,

Line 137: p_term_id IN ar_payment_schedules.term_id%TYPE,

133: p_out_discount_date IN OUT NOCOPY DATE,
134: p_out_amt_to_apply IN OUT NOCOPY NUMBER,
135: p_close_invoice_flag IN VARCHAR2,
136: p_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE,
137: p_term_id IN ar_payment_schedules.term_id%TYPE,
138: p_terms_sequence_number IN ar_payment_schedules.terms_sequence_number%TYPE,
139: p_trx_date IN ar_payment_schedules.trx_date%TYPE,
140: p_amt_due_original IN ar_payment_schedules.amount_due_original%TYPE,
141: p_amt_due_remaining IN ar_payment_schedules.amount_due_remaining%TYPE,

Line 138: p_terms_sequence_number IN ar_payment_schedules.terms_sequence_number%TYPE,

134: p_out_amt_to_apply IN OUT NOCOPY NUMBER,
135: p_close_invoice_flag IN VARCHAR2,
136: p_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE,
137: p_term_id IN ar_payment_schedules.term_id%TYPE,
138: p_terms_sequence_number IN ar_payment_schedules.terms_sequence_number%TYPE,
139: p_trx_date IN ar_payment_schedules.trx_date%TYPE,
140: p_amt_due_original IN ar_payment_schedules.amount_due_original%TYPE,
141: p_amt_due_remaining IN ar_payment_schedules.amount_due_remaining%TYPE,
142: p_disc_earned IN ar_payment_schedules.discount_taken_earned%TYPE,

Line 139: p_trx_date IN ar_payment_schedules.trx_date%TYPE,

135: p_close_invoice_flag IN VARCHAR2,
136: p_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE,
137: p_term_id IN ar_payment_schedules.term_id%TYPE,
138: p_terms_sequence_number IN ar_payment_schedules.terms_sequence_number%TYPE,
139: p_trx_date IN ar_payment_schedules.trx_date%TYPE,
140: p_amt_due_original IN ar_payment_schedules.amount_due_original%TYPE,
141: p_amt_due_remaining IN ar_payment_schedules.amount_due_remaining%TYPE,
142: p_disc_earned IN ar_payment_schedules.discount_taken_earned%TYPE,
143: p_disc_unearned IN ar_payment_schedules.discount_taken_unearned%TYPE,

Line 140: p_amt_due_original IN ar_payment_schedules.amount_due_original%TYPE,

136: p_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE,
137: p_term_id IN ar_payment_schedules.term_id%TYPE,
138: p_terms_sequence_number IN ar_payment_schedules.terms_sequence_number%TYPE,
139: p_trx_date IN ar_payment_schedules.trx_date%TYPE,
140: p_amt_due_original IN ar_payment_schedules.amount_due_original%TYPE,
141: p_amt_due_remaining IN ar_payment_schedules.amount_due_remaining%TYPE,
142: p_disc_earned IN ar_payment_schedules.discount_taken_earned%TYPE,
143: p_disc_unearned IN ar_payment_schedules.discount_taken_unearned%TYPE,
144: p_lines_original IN ar_payment_schedules.amount_line_items_original%TYPE,

Line 141: p_amt_due_remaining IN ar_payment_schedules.amount_due_remaining%TYPE,

137: p_term_id IN ar_payment_schedules.term_id%TYPE,
138: p_terms_sequence_number IN ar_payment_schedules.terms_sequence_number%TYPE,
139: p_trx_date IN ar_payment_schedules.trx_date%TYPE,
140: p_amt_due_original IN ar_payment_schedules.amount_due_original%TYPE,
141: p_amt_due_remaining IN ar_payment_schedules.amount_due_remaining%TYPE,
142: p_disc_earned IN ar_payment_schedules.discount_taken_earned%TYPE,
143: p_disc_unearned IN ar_payment_schedules.discount_taken_unearned%TYPE,
144: p_lines_original IN ar_payment_schedules.amount_line_items_original%TYPE,
145: p_invoice_currency_code IN ar_payment_schedules.invoice_currency_code%TYPE,

Line 142: p_disc_earned IN ar_payment_schedules.discount_taken_earned%TYPE,

138: p_terms_sequence_number IN ar_payment_schedules.terms_sequence_number%TYPE,
139: p_trx_date IN ar_payment_schedules.trx_date%TYPE,
140: p_amt_due_original IN ar_payment_schedules.amount_due_original%TYPE,
141: p_amt_due_remaining IN ar_payment_schedules.amount_due_remaining%TYPE,
142: p_disc_earned IN ar_payment_schedules.discount_taken_earned%TYPE,
143: p_disc_unearned IN ar_payment_schedules.discount_taken_unearned%TYPE,
144: p_lines_original IN ar_payment_schedules.amount_line_items_original%TYPE,
145: p_invoice_currency_code IN ar_payment_schedules.invoice_currency_code%TYPE,
146: p_select_flag IN VARCHAR2,

Line 143: p_disc_unearned IN ar_payment_schedules.discount_taken_unearned%TYPE,

139: p_trx_date IN ar_payment_schedules.trx_date%TYPE,
140: p_amt_due_original IN ar_payment_schedules.amount_due_original%TYPE,
141: p_amt_due_remaining IN ar_payment_schedules.amount_due_remaining%TYPE,
142: p_disc_earned IN ar_payment_schedules.discount_taken_earned%TYPE,
143: p_disc_unearned IN ar_payment_schedules.discount_taken_unearned%TYPE,
144: p_lines_original IN ar_payment_schedules.amount_line_items_original%TYPE,
145: p_invoice_currency_code IN ar_payment_schedules.invoice_currency_code%TYPE,
146: p_select_flag IN VARCHAR2,
147: p_mode IN NUMBER,

Line 144: p_lines_original IN ar_payment_schedules.amount_line_items_original%TYPE,

140: p_amt_due_original IN ar_payment_schedules.amount_due_original%TYPE,
141: p_amt_due_remaining IN ar_payment_schedules.amount_due_remaining%TYPE,
142: p_disc_earned IN ar_payment_schedules.discount_taken_earned%TYPE,
143: p_disc_unearned IN ar_payment_schedules.discount_taken_unearned%TYPE,
144: p_lines_original IN ar_payment_schedules.amount_line_items_original%TYPE,
145: p_invoice_currency_code IN ar_payment_schedules.invoice_currency_code%TYPE,
146: p_select_flag IN VARCHAR2,
147: p_mode IN NUMBER,
148: p_error_code IN OUT NOCOPY NUMBER,

Line 145: p_invoice_currency_code IN ar_payment_schedules.invoice_currency_code%TYPE,

141: p_amt_due_remaining IN ar_payment_schedules.amount_due_remaining%TYPE,
142: p_disc_earned IN ar_payment_schedules.discount_taken_earned%TYPE,
143: p_disc_unearned IN ar_payment_schedules.discount_taken_unearned%TYPE,
144: p_lines_original IN ar_payment_schedules.amount_line_items_original%TYPE,
145: p_invoice_currency_code IN ar_payment_schedules.invoice_currency_code%TYPE,
146: p_select_flag IN VARCHAR2,
147: p_mode IN NUMBER,
148: p_error_code IN OUT NOCOPY NUMBER,
149: p_cash_receipt_id IN NUMBER,

Line 151: p_amt_in_dispute IN ar_payment_schedules.amount_in_dispute%TYPE) IS

147: p_mode IN NUMBER,
148: p_error_code IN OUT NOCOPY NUMBER,
149: p_cash_receipt_id IN NUMBER,
150: p_called_from IN VARCHAR2,
151: p_amt_in_dispute IN ar_payment_schedules.amount_in_dispute%TYPE) IS
152: --
153: l_ps_rec ar_payment_schedules%ROWTYPE;
154: l_disc_rec discount_record_type;
155: l_select_flag BOOLEAN;

Line 153: l_ps_rec ar_payment_schedules%ROWTYPE;

149: p_cash_receipt_id IN NUMBER,
150: p_called_from IN VARCHAR2,
151: p_amt_in_dispute IN ar_payment_schedules.amount_in_dispute%TYPE) IS
152: --
153: l_ps_rec ar_payment_schedules%ROWTYPE;
154: l_disc_rec discount_record_type;
155: l_select_flag BOOLEAN;
156: l_precision NUMBER;
157: l_ext_precision NUMBER;

Line 548: p_ps_rec IN OUT NOCOPY ar_payment_schedules%ROWTYPE

544: | P_SELECT_FLAG.
545: +===========================================================================*/
546: PROCEDURE get_discount_percentages(
547: p_disc_rec IN OUT NOCOPY arp_calculate_discount.discount_record_type,
548: p_ps_rec IN OUT NOCOPY ar_payment_schedules%ROWTYPE
549: ) IS
550: BEGIN
551: IF PG_DEBUG in ('Y', 'C') THEN
552: arp_standard.debug( 'arp_calculate_discount.'||

Line 616: p_ps_rec IN OUT NOCOPY ar_payment_schedules%ROWTYPE

612: | |
613: +===========================================================================*/
614: PROCEDURE get_payment_schedule_info(
615: p_disc_rec IN OUT NOCOPY arp_calculate_discount.discount_record_type,
616: p_ps_rec IN OUT NOCOPY ar_payment_schedules%ROWTYPE
617: ) IS
618: l_payment_schedule_id NUMBER;
619: BEGIN
620: IF PG_DEBUG in ('Y', 'C') THEN

Line 653: FROM ar_payment_schedules ps, ra_terms t

649: p_ps_rec.invoice_currency_code,
650: p_ps_rec.amount_in_dispute,/*FP 5335376 for Bug 5223829 assign value of dispute*/
651: p_disc_rec.calc_disc_on_lines,
652: p_disc_rec.disc_partial_pmt_flag
653: FROM ar_payment_schedules ps, ra_terms t
654: WHERE ps.payment_schedule_id = l_payment_schedule_id
655: AND ps.term_id = t.term_id(+);
656:
657: EXCEPTION

Line 661: arp_standard.debug('get_payment_schedule_info: ' || 'No data found in ar_payment_schedules' );

657: EXCEPTION
658: WHEN NO_DATA_FOUND THEN
659: --error_code := AR_M_NO_RECORD ;
660: IF PG_DEBUG in ('Y', 'C') THEN
661: arp_standard.debug('get_payment_schedule_info: ' || 'No data found in ar_payment_schedules' );
662: END IF;
663: RAISE ar_m_no_rec;
664: WHEN OTHERS THEN
665: IF PG_DEBUG in ('Y', 'C') THEN

Line 724: p_ps_rec IN ar_payment_schedules%ROWTYPE

720: | NVL(,0) instead into SELECT.
721: +===========================================================================*/
722: PROCEDURE get_best_discount_percentage(
723: p_disc_rec IN OUT NOCOPY discount_record_type,
724: p_ps_rec IN ar_payment_schedules%ROWTYPE
725: ) IS
726: BEGIN
727: IF PG_DEBUG in ('Y', 'C') THEN
728: arp_standard.debug( 'arp_calculate_discount.'||

Line 795: p_ps_rec IN ar_payment_schedules%ROWTYPE

791: +===========================================================================*/
792:
793: PROCEDURE get_current_discount_percent(
794: p_disc_rec IN OUT NOCOPY discount_record_type,
795: p_ps_rec IN ar_payment_schedules%ROWTYPE
796: ) IS
797:
798: l_terms_sequence_number NUMBER;
799: l_term_id NUMBER;

Line 902: p_ps_rec IN ar_payment_schedules%ROWTYPE ) IS

898: | discount percent is 0, prevent division by 0 |
899: +===========================================================================*/
900: PROCEDURE correct_lines_only_discounts(
901: p_disc_rec IN OUT NOCOPY arp_calculate_discount.discount_record_type,
902: p_ps_rec IN ar_payment_schedules%ROWTYPE ) IS
903: l_line_adjusted NUMBER;
904: l_line_applied NUMBER;
905: l_amount_adjusted NUMBER;
906: l_amount_applied NUMBER;

Line 1013: ar_payment_schedules ps

1009: rctl.extended_amount, 0))),0)
1010: INTO l_numerator
1011: FROM
1012: ra_customer_trx_lines rctl,
1013: ar_payment_schedules ps
1014: WHERE
1015: rctl.line_type IN ('LINE','TAX')
1016: AND nvl(rctl.inventory_item_id,-1) <> l_inventory_item_id
1017: AND nvl(rctl.link_to_cust_trx_line_id,-1)

Line 1022: ar_payment_schedules ps2

1018: NOT IN (
1019: SELECT rctl2.customer_trx_line_id
1020: FROM
1021: ra_customer_trx_lines rctl2,
1022: ar_payment_schedules ps2
1023: WHERE
1024: nvl(rctl2.inventory_item_id,-1) = l_inventory_item_id
1025: AND rctl2.customer_trx_id = ps2.customer_trx_id
1026: AND ps2.payment_schedule_id = p_ps_rec.payment_schedule_id

Line 1061: FROM ar_payment_schedules

1057:
1058: BEGIN
1059: SELECT nvl(tax_original,0)
1060: INTO l_tax_original
1061: FROM ar_payment_schedules
1062: WHERE payment_schedule_id = p_ps_rec.payment_schedule_id;
1063: END;
1064: --
1065: -- Added for bug 657409.

Line 1069: FROM ar_payment_schedules

1065: -- Added for bug 657409.
1066: BEGIN
1067: SELECT nvl(freight_original,0)
1068: INTO l_freight_original
1069: FROM ar_payment_schedules
1070: WHERE payment_schedule_id = p_ps_rec.payment_schedule_id;
1071: END;
1072:
1073: l_numerator := l_numerator + l_tax_original + l_freight_original;

Line 1160: p_ps_rec IN ar_payment_schedules%ROWTYPE,

1156: | |
1157: +===========================================================================*/
1158: PROCEDURE decrease_discounts_to_adr(
1159: p_disc_rec IN OUT NOCOPY discount_record_type,
1160: p_ps_rec IN ar_payment_schedules%ROWTYPE,
1161: p_earned_disc IN OUT NOCOPY NUMBER,
1162: p_unearned_disc IN OUT NOCOPY NUMBER) IS
1163: l_amt_due_remaining NUMBER;
1164: l_amt NUMBER;

Line 1246: p_ps_rec IN ar_payment_schedules%ROWTYPE ) IS

1242: +===========================================================================*/
1243: PROCEDURE determine_max_allowed_disc(
1244: p_mode IN NUMBER,
1245: p_disc_rec IN OUT NOCOPY arp_calculate_discount.discount_record_type,
1246: p_ps_rec IN ar_payment_schedules%ROWTYPE ) IS
1247: l_amount_adjusted NUMBER;
1248: l_amount_applied NUMBER;
1249: l_adjustments BOOLEAN;
1250: l_credit_memos BOOLEAN;

Line 1430: p_ps_rec IN ar_payment_schedules%ROWTYPE,

1426: +===========================================================================*/
1427: PROCEDURE calculate_direct_discount(
1428: p_mode IN NUMBER,
1429: p_disc_rec IN OUT NOCOPY discount_record_type,
1430: p_ps_rec IN ar_payment_schedules%ROWTYPE,
1431: p_earned_disc IN OUT NOCOPY NUMBER,
1432: p_unearned_disc IN OUT NOCOPY NUMBER,
1433: p_called_from IN VARCHAR2 DEFAULT 'AR') IS
1434: l_ado NUMBER;

Line 1796: p_ps_rec IN ar_payment_schedules%ROWTYPE,

1792: --
1793: PROCEDURE calculate_default_discount(
1794: p_mode IN NUMBER,
1795: p_disc_rec IN OUT NOCOPY discount_record_type,
1796: p_ps_rec IN ar_payment_schedules%ROWTYPE,
1797: p_earned_disc IN OUT NOCOPY NUMBER,
1798: p_unearned_disc IN OUT NOCOPY NUMBER,
1799: p_out_amt_to_apply IN OUT NOCOPY NUMBER,
1800: p_called_from IN VARCHAR2 DEFAULT 'AR') IS

Line 2061: p_ps_rec IN OUT NOCOPY ar_payment_schedules%ROWTYPE ) IS

2057: +===========================================================================*/
2058: PROCEDURE check_input(
2059: p_disc_rec IN discount_record_type,
2060: p_select_flag IN BOOLEAN,
2061: p_ps_rec IN OUT NOCOPY ar_payment_schedules%ROWTYPE ) IS
2062: BEGIN
2063: IF PG_DEBUG in ('Y', 'C') THEN
2064: arp_standard.debug( 'arp_calculate_discount.check_input() +' );
2065: END IF;

Line 2281: p_ps_rec IN ar_payment_schedules%ROWTYPE,

2277: +===========================================================================*/
2278: --
2279: PROCEDURE decrease_discounts_to_maxd(
2280: p_disc_rec IN OUT NOCOPY discount_record_type,
2281: p_ps_rec IN ar_payment_schedules%ROWTYPE,
2282: p_earned_disc IN OUT NOCOPY NUMBER,
2283: p_unearned_disc IN OUT NOCOPY NUMBER) IS
2284: l_max_disc NUMBER;
2285: BEGIN

Line 2345: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,

2341: +===========================================================================*/
2342: PROCEDURE discounts_cover(
2343: p_mode IN VARCHAR2,
2344: p_invoice_currency_code IN ar_cash_receipts.currency_code%TYPE,
2345: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
2346: p_term_id IN ra_terms.term_id%TYPE,
2347: p_terms_sequence_number IN ar_payment_schedules.terms_sequence_number%TYPE,
2348: p_trx_date IN ar_payment_schedules.trx_date%TYPE,
2349: p_apply_date IN ar_cash_receipts.receipt_date%TYPE,

Line 2347: p_terms_sequence_number IN ar_payment_schedules.terms_sequence_number%TYPE,

2343: p_mode IN VARCHAR2,
2344: p_invoice_currency_code IN ar_cash_receipts.currency_code%TYPE,
2345: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
2346: p_term_id IN ra_terms.term_id%TYPE,
2347: p_terms_sequence_number IN ar_payment_schedules.terms_sequence_number%TYPE,
2348: p_trx_date IN ar_payment_schedules.trx_date%TYPE,
2349: p_apply_date IN ar_cash_receipts.receipt_date%TYPE,
2350: p_grace_days IN NUMBER,
2351: p_default_amt_apply_flag IN VARCHAR2,

Line 2348: p_trx_date IN ar_payment_schedules.trx_date%TYPE,

2344: p_invoice_currency_code IN ar_cash_receipts.currency_code%TYPE,
2345: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
2346: p_term_id IN ra_terms.term_id%TYPE,
2347: p_terms_sequence_number IN ar_payment_schedules.terms_sequence_number%TYPE,
2348: p_trx_date IN ar_payment_schedules.trx_date%TYPE,
2349: p_apply_date IN ar_cash_receipts.receipt_date%TYPE,
2350: p_grace_days IN NUMBER,
2351: p_default_amt_apply_flag IN VARCHAR2,
2352: p_partial_discount_flag IN VARCHAR2,

Line 2357: ar_payment_schedules.amount_due_original%TYPE,

2353: p_calc_discount_on_lines_flag IN VARCHAR2,
2354: p_allow_overapp_flag IN VARCHAR2,
2355: p_close_invoice_flag IN VARCHAR2,
2356: p_earned_disc_pct IN OUT NOCOPY
2357: ar_payment_schedules.amount_due_original%TYPE,
2358: p_best_disc_pct IN OUT NOCOPY
2359: ar_payment_schedules.amount_due_original%TYPE,
2360: p_input_amount IN ar_payment_schedules.amount_due_original%TYPE,
2361: p_amount_due_original IN ar_payment_schedules.amount_due_original%TYPE,

Line 2359: ar_payment_schedules.amount_due_original%TYPE,

2355: p_close_invoice_flag IN VARCHAR2,
2356: p_earned_disc_pct IN OUT NOCOPY
2357: ar_payment_schedules.amount_due_original%TYPE,
2358: p_best_disc_pct IN OUT NOCOPY
2359: ar_payment_schedules.amount_due_original%TYPE,
2360: p_input_amount IN ar_payment_schedules.amount_due_original%TYPE,
2361: p_amount_due_original IN ar_payment_schedules.amount_due_original%TYPE,
2362: p_amount_due_remaining IN ar_payment_schedules.amount_due_remaining%TYPE,
2363: p_discount_taken_earned IN ar_payment_schedules.amount_due_original%TYPE,

Line 2360: p_input_amount IN ar_payment_schedules.amount_due_original%TYPE,

2356: p_earned_disc_pct IN OUT NOCOPY
2357: ar_payment_schedules.amount_due_original%TYPE,
2358: p_best_disc_pct IN OUT NOCOPY
2359: ar_payment_schedules.amount_due_original%TYPE,
2360: p_input_amount IN ar_payment_schedules.amount_due_original%TYPE,
2361: p_amount_due_original IN ar_payment_schedules.amount_due_original%TYPE,
2362: p_amount_due_remaining IN ar_payment_schedules.amount_due_remaining%TYPE,
2363: p_discount_taken_earned IN ar_payment_schedules.amount_due_original%TYPE,
2364: p_discount_taken_unearned IN

Line 2361: p_amount_due_original IN ar_payment_schedules.amount_due_original%TYPE,

2357: ar_payment_schedules.amount_due_original%TYPE,
2358: p_best_disc_pct IN OUT NOCOPY
2359: ar_payment_schedules.amount_due_original%TYPE,
2360: p_input_amount IN ar_payment_schedules.amount_due_original%TYPE,
2361: p_amount_due_original IN ar_payment_schedules.amount_due_original%TYPE,
2362: p_amount_due_remaining IN ar_payment_schedules.amount_due_remaining%TYPE,
2363: p_discount_taken_earned IN ar_payment_schedules.amount_due_original%TYPE,
2364: p_discount_taken_unearned IN
2365: ar_payment_schedules.amount_due_original%TYPE,

Line 2362: p_amount_due_remaining IN ar_payment_schedules.amount_due_remaining%TYPE,

2358: p_best_disc_pct IN OUT NOCOPY
2359: ar_payment_schedules.amount_due_original%TYPE,
2360: p_input_amount IN ar_payment_schedules.amount_due_original%TYPE,
2361: p_amount_due_original IN ar_payment_schedules.amount_due_original%TYPE,
2362: p_amount_due_remaining IN ar_payment_schedules.amount_due_remaining%TYPE,
2363: p_discount_taken_earned IN ar_payment_schedules.amount_due_original%TYPE,
2364: p_discount_taken_unearned IN
2365: ar_payment_schedules.amount_due_original%TYPE,
2366: p_amount_line_items_original IN

Line 2363: p_discount_taken_earned IN ar_payment_schedules.amount_due_original%TYPE,

2359: ar_payment_schedules.amount_due_original%TYPE,
2360: p_input_amount IN ar_payment_schedules.amount_due_original%TYPE,
2361: p_amount_due_original IN ar_payment_schedules.amount_due_original%TYPE,
2362: p_amount_due_remaining IN ar_payment_schedules.amount_due_remaining%TYPE,
2363: p_discount_taken_earned IN ar_payment_schedules.amount_due_original%TYPE,
2364: p_discount_taken_unearned IN
2365: ar_payment_schedules.amount_due_original%TYPE,
2366: p_amount_line_items_original IN
2367: ar_payment_schedules.amount_line_items_original%TYPE,

Line 2365: ar_payment_schedules.amount_due_original%TYPE,

2361: p_amount_due_original IN ar_payment_schedules.amount_due_original%TYPE,
2362: p_amount_due_remaining IN ar_payment_schedules.amount_due_remaining%TYPE,
2363: p_discount_taken_earned IN ar_payment_schedules.amount_due_original%TYPE,
2364: p_discount_taken_unearned IN
2365: ar_payment_schedules.amount_due_original%TYPE,
2366: p_amount_line_items_original IN
2367: ar_payment_schedules.amount_line_items_original%TYPE,
2368: p_out_discount_date IN OUT NOCOPY DATE,
2369: p_out_earned_discount IN OUT NOCOPY

Line 2367: ar_payment_schedules.amount_line_items_original%TYPE,

2363: p_discount_taken_earned IN ar_payment_schedules.amount_due_original%TYPE,
2364: p_discount_taken_unearned IN
2365: ar_payment_schedules.amount_due_original%TYPE,
2366: p_amount_line_items_original IN
2367: ar_payment_schedules.amount_line_items_original%TYPE,
2368: p_out_discount_date IN OUT NOCOPY DATE,
2369: p_out_earned_discount IN OUT NOCOPY
2370: ar_payment_schedules.amount_due_original%TYPE,
2371: p_out_unearned_discount IN OUT NOCOPY

Line 2370: ar_payment_schedules.amount_due_original%TYPE,

2366: p_amount_line_items_original IN
2367: ar_payment_schedules.amount_line_items_original%TYPE,
2368: p_out_discount_date IN OUT NOCOPY DATE,
2369: p_out_earned_discount IN OUT NOCOPY
2370: ar_payment_schedules.amount_due_original%TYPE,
2371: p_out_unearned_discount IN OUT NOCOPY
2372: ar_payment_schedules.amount_due_original%TYPE,
2373: p_out_amount_to_apply IN OUT NOCOPY
2374: ar_payment_schedules.amount_due_original%TYPE,

Line 2372: ar_payment_schedules.amount_due_original%TYPE,

2368: p_out_discount_date IN OUT NOCOPY DATE,
2369: p_out_earned_discount IN OUT NOCOPY
2370: ar_payment_schedules.amount_due_original%TYPE,
2371: p_out_unearned_discount IN OUT NOCOPY
2372: ar_payment_schedules.amount_due_original%TYPE,
2373: p_out_amount_to_apply IN OUT NOCOPY
2374: ar_payment_schedules.amount_due_original%TYPE,
2375: p_out_discount_to_take IN OUT NOCOPY
2376: ar_payment_schedules.amount_due_original%TYPE,

Line 2374: ar_payment_schedules.amount_due_original%TYPE,

2370: ar_payment_schedules.amount_due_original%TYPE,
2371: p_out_unearned_discount IN OUT NOCOPY
2372: ar_payment_schedules.amount_due_original%TYPE,
2373: p_out_amount_to_apply IN OUT NOCOPY
2374: ar_payment_schedules.amount_due_original%TYPE,
2375: p_out_discount_to_take IN OUT NOCOPY
2376: ar_payment_schedules.amount_due_original%TYPE,
2377: p_module_name IN VARCHAR2,
2378: p_module_version IN VARCHAR2,

Line 2376: ar_payment_schedules.amount_due_original%TYPE,

2372: ar_payment_schedules.amount_due_original%TYPE,
2373: p_out_amount_to_apply IN OUT NOCOPY
2374: ar_payment_schedules.amount_due_original%TYPE,
2375: p_out_discount_to_take IN OUT NOCOPY
2376: ar_payment_schedules.amount_due_original%TYPE,
2377: p_module_name IN VARCHAR2,
2378: p_module_version IN VARCHAR2,
2379: p_cash_receipt_id IN NUMBER ,
2380: p_allow_discount IN VARCHAR2 DEFAULT 'Y' ) IS /* Bug fix 3450317 */

Line 2599: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,

2595:
2596: PROCEDURE discounts_cover(
2597: p_mode IN VARCHAR2,
2598: p_invoice_currency_code IN ar_cash_receipts.currency_code%TYPE,
2599: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
2600: p_term_id IN ra_terms.term_id%TYPE,
2601: p_terms_sequence_number IN ar_payment_schedules.terms_sequence_number%TYPE,
2602: p_trx_date IN ar_payment_schedules.trx_date%TYPE,
2603: p_apply_date IN ar_cash_receipts.receipt_date%TYPE,

Line 2601: p_terms_sequence_number IN ar_payment_schedules.terms_sequence_number%TYPE,

2597: p_mode IN VARCHAR2,
2598: p_invoice_currency_code IN ar_cash_receipts.currency_code%TYPE,
2599: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
2600: p_term_id IN ra_terms.term_id%TYPE,
2601: p_terms_sequence_number IN ar_payment_schedules.terms_sequence_number%TYPE,
2602: p_trx_date IN ar_payment_schedules.trx_date%TYPE,
2603: p_apply_date IN ar_cash_receipts.receipt_date%TYPE,
2604: p_grace_days IN NUMBER,
2605: p_default_amt_apply_flag IN VARCHAR2,

Line 2602: p_trx_date IN ar_payment_schedules.trx_date%TYPE,

2598: p_invoice_currency_code IN ar_cash_receipts.currency_code%TYPE,
2599: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
2600: p_term_id IN ra_terms.term_id%TYPE,
2601: p_terms_sequence_number IN ar_payment_schedules.terms_sequence_number%TYPE,
2602: p_trx_date IN ar_payment_schedules.trx_date%TYPE,
2603: p_apply_date IN ar_cash_receipts.receipt_date%TYPE,
2604: p_grace_days IN NUMBER,
2605: p_default_amt_apply_flag IN VARCHAR2,
2606: p_partial_discount_flag IN VARCHAR2,

Line 2611: ar_payment_schedules.amount_due_original%TYPE,

2607: p_calc_discount_on_lines_flag IN VARCHAR2,
2608: p_allow_overapp_flag IN VARCHAR2,
2609: p_close_invoice_flag IN VARCHAR2,
2610: p_earned_disc_pct IN OUT NOCOPY
2611: ar_payment_schedules.amount_due_original%TYPE,
2612: p_best_disc_pct IN OUT NOCOPY
2613: ar_payment_schedules.amount_due_original%TYPE,
2614: p_input_amount IN ar_payment_schedules.amount_due_original%TYPE,
2615: p_amount_due_original IN ar_payment_schedules.amount_due_original%TYPE,

Line 2613: ar_payment_schedules.amount_due_original%TYPE,

2609: p_close_invoice_flag IN VARCHAR2,
2610: p_earned_disc_pct IN OUT NOCOPY
2611: ar_payment_schedules.amount_due_original%TYPE,
2612: p_best_disc_pct IN OUT NOCOPY
2613: ar_payment_schedules.amount_due_original%TYPE,
2614: p_input_amount IN ar_payment_schedules.amount_due_original%TYPE,
2615: p_amount_due_original IN ar_payment_schedules.amount_due_original%TYPE,
2616: p_amount_due_remaining IN ar_payment_schedules.amount_due_remaining%TYPE,
2617: p_discount_taken_earned IN ar_payment_schedules.amount_due_original%TYPE,

Line 2614: p_input_amount IN ar_payment_schedules.amount_due_original%TYPE,

2610: p_earned_disc_pct IN OUT NOCOPY
2611: ar_payment_schedules.amount_due_original%TYPE,
2612: p_best_disc_pct IN OUT NOCOPY
2613: ar_payment_schedules.amount_due_original%TYPE,
2614: p_input_amount IN ar_payment_schedules.amount_due_original%TYPE,
2615: p_amount_due_original IN ar_payment_schedules.amount_due_original%TYPE,
2616: p_amount_due_remaining IN ar_payment_schedules.amount_due_remaining%TYPE,
2617: p_discount_taken_earned IN ar_payment_schedules.amount_due_original%TYPE,
2618: p_discount_taken_unearned IN

Line 2615: p_amount_due_original IN ar_payment_schedules.amount_due_original%TYPE,

2611: ar_payment_schedules.amount_due_original%TYPE,
2612: p_best_disc_pct IN OUT NOCOPY
2613: ar_payment_schedules.amount_due_original%TYPE,
2614: p_input_amount IN ar_payment_schedules.amount_due_original%TYPE,
2615: p_amount_due_original IN ar_payment_schedules.amount_due_original%TYPE,
2616: p_amount_due_remaining IN ar_payment_schedules.amount_due_remaining%TYPE,
2617: p_discount_taken_earned IN ar_payment_schedules.amount_due_original%TYPE,
2618: p_discount_taken_unearned IN
2619: ar_payment_schedules.amount_due_original%TYPE,

Line 2616: p_amount_due_remaining IN ar_payment_schedules.amount_due_remaining%TYPE,

2612: p_best_disc_pct IN OUT NOCOPY
2613: ar_payment_schedules.amount_due_original%TYPE,
2614: p_input_amount IN ar_payment_schedules.amount_due_original%TYPE,
2615: p_amount_due_original IN ar_payment_schedules.amount_due_original%TYPE,
2616: p_amount_due_remaining IN ar_payment_schedules.amount_due_remaining%TYPE,
2617: p_discount_taken_earned IN ar_payment_schedules.amount_due_original%TYPE,
2618: p_discount_taken_unearned IN
2619: ar_payment_schedules.amount_due_original%TYPE,
2620: p_amount_line_items_original IN

Line 2617: p_discount_taken_earned IN ar_payment_schedules.amount_due_original%TYPE,

2613: ar_payment_schedules.amount_due_original%TYPE,
2614: p_input_amount IN ar_payment_schedules.amount_due_original%TYPE,
2615: p_amount_due_original IN ar_payment_schedules.amount_due_original%TYPE,
2616: p_amount_due_remaining IN ar_payment_schedules.amount_due_remaining%TYPE,
2617: p_discount_taken_earned IN ar_payment_schedules.amount_due_original%TYPE,
2618: p_discount_taken_unearned IN
2619: ar_payment_schedules.amount_due_original%TYPE,
2620: p_amount_line_items_original IN
2621: ar_payment_schedules.amount_line_items_original%TYPE,

Line 2619: ar_payment_schedules.amount_due_original%TYPE,

2615: p_amount_due_original IN ar_payment_schedules.amount_due_original%TYPE,
2616: p_amount_due_remaining IN ar_payment_schedules.amount_due_remaining%TYPE,
2617: p_discount_taken_earned IN ar_payment_schedules.amount_due_original%TYPE,
2618: p_discount_taken_unearned IN
2619: ar_payment_schedules.amount_due_original%TYPE,
2620: p_amount_line_items_original IN
2621: ar_payment_schedules.amount_line_items_original%TYPE,
2622: p_out_discount_date IN OUT NOCOPY DATE,
2623: p_out_earned_discount IN OUT NOCOPY

Line 2621: ar_payment_schedules.amount_line_items_original%TYPE,

2617: p_discount_taken_earned IN ar_payment_schedules.amount_due_original%TYPE,
2618: p_discount_taken_unearned IN
2619: ar_payment_schedules.amount_due_original%TYPE,
2620: p_amount_line_items_original IN
2621: ar_payment_schedules.amount_line_items_original%TYPE,
2622: p_out_discount_date IN OUT NOCOPY DATE,
2623: p_out_earned_discount IN OUT NOCOPY
2624: ar_payment_schedules.amount_due_original%TYPE,
2625: p_out_unearned_discount IN OUT NOCOPY

Line 2624: ar_payment_schedules.amount_due_original%TYPE,

2620: p_amount_line_items_original IN
2621: ar_payment_schedules.amount_line_items_original%TYPE,
2622: p_out_discount_date IN OUT NOCOPY DATE,
2623: p_out_earned_discount IN OUT NOCOPY
2624: ar_payment_schedules.amount_due_original%TYPE,
2625: p_out_unearned_discount IN OUT NOCOPY
2626: ar_payment_schedules.amount_due_original%TYPE,
2627: p_out_amount_to_apply IN OUT NOCOPY
2628: ar_payment_schedules.amount_due_original%TYPE,

Line 2626: ar_payment_schedules.amount_due_original%TYPE,

2622: p_out_discount_date IN OUT NOCOPY DATE,
2623: p_out_earned_discount IN OUT NOCOPY
2624: ar_payment_schedules.amount_due_original%TYPE,
2625: p_out_unearned_discount IN OUT NOCOPY
2626: ar_payment_schedules.amount_due_original%TYPE,
2627: p_out_amount_to_apply IN OUT NOCOPY
2628: ar_payment_schedules.amount_due_original%TYPE,
2629: p_out_discount_to_take IN OUT NOCOPY
2630: ar_payment_schedules.amount_due_original%TYPE,

Line 2628: ar_payment_schedules.amount_due_original%TYPE,

2624: ar_payment_schedules.amount_due_original%TYPE,
2625: p_out_unearned_discount IN OUT NOCOPY
2626: ar_payment_schedules.amount_due_original%TYPE,
2627: p_out_amount_to_apply IN OUT NOCOPY
2628: ar_payment_schedules.amount_due_original%TYPE,
2629: p_out_discount_to_take IN OUT NOCOPY
2630: ar_payment_schedules.amount_due_original%TYPE,
2631: p_module_name IN VARCHAR2,
2632: p_module_version IN VARCHAR2 ,

Line 2630: ar_payment_schedules.amount_due_original%TYPE,

2626: ar_payment_schedules.amount_due_original%TYPE,
2627: p_out_amount_to_apply IN OUT NOCOPY
2628: ar_payment_schedules.amount_due_original%TYPE,
2629: p_out_discount_to_take IN OUT NOCOPY
2630: ar_payment_schedules.amount_due_original%TYPE,
2631: p_module_name IN VARCHAR2,
2632: p_module_version IN VARCHAR2 ,
2633: p_allow_discount IN VARCHAR2 DEFAULT 'Y' ) IS /* Bug fix 3450317 */
2634: BEGIN

Line 2705: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,

2701: +===========================================================================*/
2702: PROCEDURE validate_args_discounts_cover(
2703: p_mode IN VARCHAR2,
2704: p_invoice_currency_code IN ar_cash_receipts.currency_code%TYPE,
2705: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
2706: p_trx_date IN ar_payment_schedules.trx_date%TYPE,
2707: p_apply_date IN ar_cash_receipts.receipt_date%TYPE ) IS
2708: BEGIN
2709: IF PG_DEBUG in ('Y', 'C') THEN

Line 2706: p_trx_date IN ar_payment_schedules.trx_date%TYPE,

2702: PROCEDURE validate_args_discounts_cover(
2703: p_mode IN VARCHAR2,
2704: p_invoice_currency_code IN ar_cash_receipts.currency_code%TYPE,
2705: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
2706: p_trx_date IN ar_payment_schedules.trx_date%TYPE,
2707: p_apply_date IN ar_cash_receipts.receipt_date%TYPE ) IS
2708: BEGIN
2709: IF PG_DEBUG in ('Y', 'C') THEN
2710: arp_standard.debug( 'arp_calculate_discount.validate_args_discounts_cover()+' );