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 544: p_ps_rec IN OUT NOCOPY ar_payment_schedules%ROWTYPE

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

Line 612: p_ps_rec IN OUT NOCOPY ar_payment_schedules%ROWTYPE

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

Line 649: FROM ar_payment_schedules ps, ra_terms t

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

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

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

Line 720: p_ps_rec IN ar_payment_schedules%ROWTYPE

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

Line 791: p_ps_rec IN ar_payment_schedules%ROWTYPE

787: +===========================================================================*/
788:
789: PROCEDURE get_current_discount_percent(
790: p_disc_rec IN OUT NOCOPY discount_record_type,
791: p_ps_rec IN ar_payment_schedules%ROWTYPE
792: ) IS
793:
794: l_terms_sequence_number NUMBER;
795: l_term_id NUMBER;

Line 898: p_ps_rec IN ar_payment_schedules%ROWTYPE ) IS

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

Line 1009: ar_payment_schedules ps

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

Line 1018: ar_payment_schedules ps2

1014: NOT IN (
1015: SELECT rctl2.customer_trx_line_id
1016: FROM
1017: ra_customer_trx_lines rctl2,
1018: ar_payment_schedules ps2
1019: WHERE
1020: nvl(rctl2.inventory_item_id,-1) = l_inventory_item_id
1021: AND rctl2.customer_trx_id = ps2.customer_trx_id
1022: AND ps2.payment_schedule_id = p_ps_rec.payment_schedule_id

Line 1057: FROM ar_payment_schedules

1053:
1054: BEGIN
1055: SELECT nvl(tax_original,0)
1056: INTO l_tax_original
1057: FROM ar_payment_schedules
1058: WHERE payment_schedule_id = p_ps_rec.payment_schedule_id;
1059: END;
1060: --
1061: -- Added for bug 657409.

Line 1065: FROM ar_payment_schedules

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

Line 1156: p_ps_rec IN ar_payment_schedules%ROWTYPE,

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

Line 1242: p_ps_rec IN ar_payment_schedules%ROWTYPE ) IS

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

Line 1426: p_ps_rec IN ar_payment_schedules%ROWTYPE,

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

Line 1787: p_ps_rec IN ar_payment_schedules%ROWTYPE,

1783: --
1784: PROCEDURE calculate_default_discount(
1785: p_mode IN NUMBER,
1786: p_disc_rec IN OUT NOCOPY discount_record_type,
1787: p_ps_rec IN ar_payment_schedules%ROWTYPE,
1788: p_earned_disc IN OUT NOCOPY NUMBER,
1789: p_unearned_disc IN OUT NOCOPY NUMBER,
1790: p_out_amt_to_apply IN OUT NOCOPY NUMBER,
1791: p_called_from IN VARCHAR2 DEFAULT 'AR') IS

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

2048: +===========================================================================*/
2049: PROCEDURE check_input(
2050: p_disc_rec IN discount_record_type,
2051: p_select_flag IN BOOLEAN,
2052: p_ps_rec IN OUT NOCOPY ar_payment_schedules%ROWTYPE ) IS
2053: BEGIN
2054: IF PG_DEBUG in ('Y', 'C') THEN
2055: arp_standard.debug( 'arp_calculate_discount.check_input() +' );
2056: END IF;

Line 2272: p_ps_rec IN ar_payment_schedules%ROWTYPE,

2268: +===========================================================================*/
2269: --
2270: PROCEDURE decrease_discounts_to_maxd(
2271: p_disc_rec IN OUT NOCOPY discount_record_type,
2272: p_ps_rec IN ar_payment_schedules%ROWTYPE,
2273: p_earned_disc IN OUT NOCOPY NUMBER,
2274: p_unearned_disc IN OUT NOCOPY NUMBER) IS
2275: l_max_disc NUMBER;
2276: BEGIN

Line 2336: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,

2332: +===========================================================================*/
2333: PROCEDURE discounts_cover(
2334: p_mode IN VARCHAR2,
2335: p_invoice_currency_code IN ar_cash_receipts.currency_code%TYPE,
2336: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
2337: p_term_id IN ra_terms.term_id%TYPE,
2338: p_terms_sequence_number IN ar_payment_schedules.terms_sequence_number%TYPE,
2339: p_trx_date IN ar_payment_schedules.trx_date%TYPE,
2340: p_apply_date IN ar_cash_receipts.receipt_date%TYPE,

Line 2338: p_terms_sequence_number IN ar_payment_schedules.terms_sequence_number%TYPE,

2334: p_mode IN VARCHAR2,
2335: p_invoice_currency_code IN ar_cash_receipts.currency_code%TYPE,
2336: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
2337: p_term_id IN ra_terms.term_id%TYPE,
2338: p_terms_sequence_number IN ar_payment_schedules.terms_sequence_number%TYPE,
2339: p_trx_date IN ar_payment_schedules.trx_date%TYPE,
2340: p_apply_date IN ar_cash_receipts.receipt_date%TYPE,
2341: p_grace_days IN NUMBER,
2342: p_default_amt_apply_flag IN VARCHAR2,

Line 2339: p_trx_date IN ar_payment_schedules.trx_date%TYPE,

2335: p_invoice_currency_code IN ar_cash_receipts.currency_code%TYPE,
2336: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
2337: p_term_id IN ra_terms.term_id%TYPE,
2338: p_terms_sequence_number IN ar_payment_schedules.terms_sequence_number%TYPE,
2339: p_trx_date IN ar_payment_schedules.trx_date%TYPE,
2340: p_apply_date IN ar_cash_receipts.receipt_date%TYPE,
2341: p_grace_days IN NUMBER,
2342: p_default_amt_apply_flag IN VARCHAR2,
2343: p_partial_discount_flag IN VARCHAR2,

Line 2348: ar_payment_schedules.amount_due_original%TYPE,

2344: p_calc_discount_on_lines_flag IN VARCHAR2,
2345: p_allow_overapp_flag IN VARCHAR2,
2346: p_close_invoice_flag IN VARCHAR2,
2347: p_earned_disc_pct IN OUT NOCOPY
2348: ar_payment_schedules.amount_due_original%TYPE,
2349: p_best_disc_pct IN OUT NOCOPY
2350: ar_payment_schedules.amount_due_original%TYPE,
2351: p_input_amount IN ar_payment_schedules.amount_due_original%TYPE,
2352: p_amount_due_original IN ar_payment_schedules.amount_due_original%TYPE,

Line 2350: ar_payment_schedules.amount_due_original%TYPE,

2346: p_close_invoice_flag IN VARCHAR2,
2347: p_earned_disc_pct IN OUT NOCOPY
2348: ar_payment_schedules.amount_due_original%TYPE,
2349: p_best_disc_pct IN OUT NOCOPY
2350: ar_payment_schedules.amount_due_original%TYPE,
2351: p_input_amount IN ar_payment_schedules.amount_due_original%TYPE,
2352: p_amount_due_original IN ar_payment_schedules.amount_due_original%TYPE,
2353: p_amount_due_remaining IN ar_payment_schedules.amount_due_remaining%TYPE,
2354: p_discount_taken_earned IN ar_payment_schedules.amount_due_original%TYPE,

Line 2351: p_input_amount IN ar_payment_schedules.amount_due_original%TYPE,

2347: p_earned_disc_pct IN OUT NOCOPY
2348: ar_payment_schedules.amount_due_original%TYPE,
2349: p_best_disc_pct IN OUT NOCOPY
2350: ar_payment_schedules.amount_due_original%TYPE,
2351: p_input_amount IN ar_payment_schedules.amount_due_original%TYPE,
2352: p_amount_due_original IN ar_payment_schedules.amount_due_original%TYPE,
2353: p_amount_due_remaining IN ar_payment_schedules.amount_due_remaining%TYPE,
2354: p_discount_taken_earned IN ar_payment_schedules.amount_due_original%TYPE,
2355: p_discount_taken_unearned IN

Line 2352: p_amount_due_original IN ar_payment_schedules.amount_due_original%TYPE,

2348: ar_payment_schedules.amount_due_original%TYPE,
2349: p_best_disc_pct IN OUT NOCOPY
2350: ar_payment_schedules.amount_due_original%TYPE,
2351: p_input_amount IN ar_payment_schedules.amount_due_original%TYPE,
2352: p_amount_due_original IN ar_payment_schedules.amount_due_original%TYPE,
2353: p_amount_due_remaining IN ar_payment_schedules.amount_due_remaining%TYPE,
2354: p_discount_taken_earned IN ar_payment_schedules.amount_due_original%TYPE,
2355: p_discount_taken_unearned IN
2356: ar_payment_schedules.amount_due_original%TYPE,

Line 2353: p_amount_due_remaining IN ar_payment_schedules.amount_due_remaining%TYPE,

2349: p_best_disc_pct IN OUT NOCOPY
2350: ar_payment_schedules.amount_due_original%TYPE,
2351: p_input_amount IN ar_payment_schedules.amount_due_original%TYPE,
2352: p_amount_due_original IN ar_payment_schedules.amount_due_original%TYPE,
2353: p_amount_due_remaining IN ar_payment_schedules.amount_due_remaining%TYPE,
2354: p_discount_taken_earned IN ar_payment_schedules.amount_due_original%TYPE,
2355: p_discount_taken_unearned IN
2356: ar_payment_schedules.amount_due_original%TYPE,
2357: p_amount_line_items_original IN

Line 2354: p_discount_taken_earned IN ar_payment_schedules.amount_due_original%TYPE,

2350: ar_payment_schedules.amount_due_original%TYPE,
2351: p_input_amount IN ar_payment_schedules.amount_due_original%TYPE,
2352: p_amount_due_original IN ar_payment_schedules.amount_due_original%TYPE,
2353: p_amount_due_remaining IN ar_payment_schedules.amount_due_remaining%TYPE,
2354: p_discount_taken_earned IN ar_payment_schedules.amount_due_original%TYPE,
2355: p_discount_taken_unearned IN
2356: ar_payment_schedules.amount_due_original%TYPE,
2357: p_amount_line_items_original IN
2358: ar_payment_schedules.amount_line_items_original%TYPE,

Line 2356: ar_payment_schedules.amount_due_original%TYPE,

2352: p_amount_due_original IN ar_payment_schedules.amount_due_original%TYPE,
2353: p_amount_due_remaining IN ar_payment_schedules.amount_due_remaining%TYPE,
2354: p_discount_taken_earned IN ar_payment_schedules.amount_due_original%TYPE,
2355: p_discount_taken_unearned IN
2356: ar_payment_schedules.amount_due_original%TYPE,
2357: p_amount_line_items_original IN
2358: ar_payment_schedules.amount_line_items_original%TYPE,
2359: p_out_discount_date IN OUT NOCOPY DATE,
2360: p_out_earned_discount IN OUT NOCOPY

Line 2358: ar_payment_schedules.amount_line_items_original%TYPE,

2354: p_discount_taken_earned IN ar_payment_schedules.amount_due_original%TYPE,
2355: p_discount_taken_unearned IN
2356: ar_payment_schedules.amount_due_original%TYPE,
2357: p_amount_line_items_original IN
2358: ar_payment_schedules.amount_line_items_original%TYPE,
2359: p_out_discount_date IN OUT NOCOPY DATE,
2360: p_out_earned_discount IN OUT NOCOPY
2361: ar_payment_schedules.amount_due_original%TYPE,
2362: p_out_unearned_discount IN OUT NOCOPY

Line 2361: ar_payment_schedules.amount_due_original%TYPE,

2357: p_amount_line_items_original IN
2358: ar_payment_schedules.amount_line_items_original%TYPE,
2359: p_out_discount_date IN OUT NOCOPY DATE,
2360: p_out_earned_discount IN OUT NOCOPY
2361: ar_payment_schedules.amount_due_original%TYPE,
2362: p_out_unearned_discount IN OUT NOCOPY
2363: ar_payment_schedules.amount_due_original%TYPE,
2364: p_out_amount_to_apply IN OUT NOCOPY
2365: ar_payment_schedules.amount_due_original%TYPE,

Line 2363: ar_payment_schedules.amount_due_original%TYPE,

2359: p_out_discount_date IN OUT NOCOPY DATE,
2360: p_out_earned_discount IN OUT NOCOPY
2361: ar_payment_schedules.amount_due_original%TYPE,
2362: p_out_unearned_discount IN OUT NOCOPY
2363: ar_payment_schedules.amount_due_original%TYPE,
2364: p_out_amount_to_apply IN OUT NOCOPY
2365: ar_payment_schedules.amount_due_original%TYPE,
2366: p_out_discount_to_take IN OUT NOCOPY
2367: ar_payment_schedules.amount_due_original%TYPE,

Line 2365: ar_payment_schedules.amount_due_original%TYPE,

2361: ar_payment_schedules.amount_due_original%TYPE,
2362: p_out_unearned_discount IN OUT NOCOPY
2363: ar_payment_schedules.amount_due_original%TYPE,
2364: p_out_amount_to_apply IN OUT NOCOPY
2365: ar_payment_schedules.amount_due_original%TYPE,
2366: p_out_discount_to_take IN OUT NOCOPY
2367: ar_payment_schedules.amount_due_original%TYPE,
2368: p_module_name IN VARCHAR2,
2369: p_module_version IN VARCHAR2,

Line 2367: ar_payment_schedules.amount_due_original%TYPE,

2363: ar_payment_schedules.amount_due_original%TYPE,
2364: p_out_amount_to_apply IN OUT NOCOPY
2365: ar_payment_schedules.amount_due_original%TYPE,
2366: p_out_discount_to_take IN OUT NOCOPY
2367: ar_payment_schedules.amount_due_original%TYPE,
2368: p_module_name IN VARCHAR2,
2369: p_module_version IN VARCHAR2,
2370: p_cash_receipt_id IN NUMBER ,
2371: p_allow_discount IN VARCHAR2 DEFAULT 'Y' ) IS /* Bug fix 3450317 */

Line 2578: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,

2574:
2575: PROCEDURE discounts_cover(
2576: p_mode IN VARCHAR2,
2577: p_invoice_currency_code IN ar_cash_receipts.currency_code%TYPE,
2578: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
2579: p_term_id IN ra_terms.term_id%TYPE,
2580: p_terms_sequence_number IN ar_payment_schedules.terms_sequence_number%TYPE,
2581: p_trx_date IN ar_payment_schedules.trx_date%TYPE,
2582: p_apply_date IN ar_cash_receipts.receipt_date%TYPE,

Line 2580: p_terms_sequence_number IN ar_payment_schedules.terms_sequence_number%TYPE,

2576: p_mode IN VARCHAR2,
2577: p_invoice_currency_code IN ar_cash_receipts.currency_code%TYPE,
2578: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
2579: p_term_id IN ra_terms.term_id%TYPE,
2580: p_terms_sequence_number IN ar_payment_schedules.terms_sequence_number%TYPE,
2581: p_trx_date IN ar_payment_schedules.trx_date%TYPE,
2582: p_apply_date IN ar_cash_receipts.receipt_date%TYPE,
2583: p_grace_days IN NUMBER,
2584: p_default_amt_apply_flag IN VARCHAR2,

Line 2581: p_trx_date IN ar_payment_schedules.trx_date%TYPE,

2577: p_invoice_currency_code IN ar_cash_receipts.currency_code%TYPE,
2578: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
2579: p_term_id IN ra_terms.term_id%TYPE,
2580: p_terms_sequence_number IN ar_payment_schedules.terms_sequence_number%TYPE,
2581: p_trx_date IN ar_payment_schedules.trx_date%TYPE,
2582: p_apply_date IN ar_cash_receipts.receipt_date%TYPE,
2583: p_grace_days IN NUMBER,
2584: p_default_amt_apply_flag IN VARCHAR2,
2585: p_partial_discount_flag IN VARCHAR2,

Line 2590: ar_payment_schedules.amount_due_original%TYPE,

2586: p_calc_discount_on_lines_flag IN VARCHAR2,
2587: p_allow_overapp_flag IN VARCHAR2,
2588: p_close_invoice_flag IN VARCHAR2,
2589: p_earned_disc_pct IN OUT NOCOPY
2590: ar_payment_schedules.amount_due_original%TYPE,
2591: p_best_disc_pct IN OUT NOCOPY
2592: ar_payment_schedules.amount_due_original%TYPE,
2593: p_input_amount IN ar_payment_schedules.amount_due_original%TYPE,
2594: p_amount_due_original IN ar_payment_schedules.amount_due_original%TYPE,

Line 2592: ar_payment_schedules.amount_due_original%TYPE,

2588: p_close_invoice_flag IN VARCHAR2,
2589: p_earned_disc_pct IN OUT NOCOPY
2590: ar_payment_schedules.amount_due_original%TYPE,
2591: p_best_disc_pct IN OUT NOCOPY
2592: ar_payment_schedules.amount_due_original%TYPE,
2593: p_input_amount IN ar_payment_schedules.amount_due_original%TYPE,
2594: p_amount_due_original IN ar_payment_schedules.amount_due_original%TYPE,
2595: p_amount_due_remaining IN ar_payment_schedules.amount_due_remaining%TYPE,
2596: p_discount_taken_earned IN ar_payment_schedules.amount_due_original%TYPE,

Line 2593: p_input_amount IN ar_payment_schedules.amount_due_original%TYPE,

2589: p_earned_disc_pct IN OUT NOCOPY
2590: ar_payment_schedules.amount_due_original%TYPE,
2591: p_best_disc_pct IN OUT NOCOPY
2592: ar_payment_schedules.amount_due_original%TYPE,
2593: p_input_amount IN ar_payment_schedules.amount_due_original%TYPE,
2594: p_amount_due_original IN ar_payment_schedules.amount_due_original%TYPE,
2595: p_amount_due_remaining IN ar_payment_schedules.amount_due_remaining%TYPE,
2596: p_discount_taken_earned IN ar_payment_schedules.amount_due_original%TYPE,
2597: p_discount_taken_unearned IN

Line 2594: p_amount_due_original IN ar_payment_schedules.amount_due_original%TYPE,

2590: ar_payment_schedules.amount_due_original%TYPE,
2591: p_best_disc_pct IN OUT NOCOPY
2592: ar_payment_schedules.amount_due_original%TYPE,
2593: p_input_amount IN ar_payment_schedules.amount_due_original%TYPE,
2594: p_amount_due_original IN ar_payment_schedules.amount_due_original%TYPE,
2595: p_amount_due_remaining IN ar_payment_schedules.amount_due_remaining%TYPE,
2596: p_discount_taken_earned IN ar_payment_schedules.amount_due_original%TYPE,
2597: p_discount_taken_unearned IN
2598: ar_payment_schedules.amount_due_original%TYPE,

Line 2595: p_amount_due_remaining IN ar_payment_schedules.amount_due_remaining%TYPE,

2591: p_best_disc_pct IN OUT NOCOPY
2592: ar_payment_schedules.amount_due_original%TYPE,
2593: p_input_amount IN ar_payment_schedules.amount_due_original%TYPE,
2594: p_amount_due_original IN ar_payment_schedules.amount_due_original%TYPE,
2595: p_amount_due_remaining IN ar_payment_schedules.amount_due_remaining%TYPE,
2596: p_discount_taken_earned IN ar_payment_schedules.amount_due_original%TYPE,
2597: p_discount_taken_unearned IN
2598: ar_payment_schedules.amount_due_original%TYPE,
2599: p_amount_line_items_original IN

Line 2596: p_discount_taken_earned IN ar_payment_schedules.amount_due_original%TYPE,

2592: ar_payment_schedules.amount_due_original%TYPE,
2593: p_input_amount IN ar_payment_schedules.amount_due_original%TYPE,
2594: p_amount_due_original IN ar_payment_schedules.amount_due_original%TYPE,
2595: p_amount_due_remaining IN ar_payment_schedules.amount_due_remaining%TYPE,
2596: p_discount_taken_earned IN ar_payment_schedules.amount_due_original%TYPE,
2597: p_discount_taken_unearned IN
2598: ar_payment_schedules.amount_due_original%TYPE,
2599: p_amount_line_items_original IN
2600: ar_payment_schedules.amount_line_items_original%TYPE,

Line 2598: ar_payment_schedules.amount_due_original%TYPE,

2594: p_amount_due_original IN ar_payment_schedules.amount_due_original%TYPE,
2595: p_amount_due_remaining IN ar_payment_schedules.amount_due_remaining%TYPE,
2596: p_discount_taken_earned IN ar_payment_schedules.amount_due_original%TYPE,
2597: p_discount_taken_unearned IN
2598: ar_payment_schedules.amount_due_original%TYPE,
2599: p_amount_line_items_original IN
2600: ar_payment_schedules.amount_line_items_original%TYPE,
2601: p_out_discount_date IN OUT NOCOPY DATE,
2602: p_out_earned_discount IN OUT NOCOPY

Line 2600: ar_payment_schedules.amount_line_items_original%TYPE,

2596: p_discount_taken_earned IN ar_payment_schedules.amount_due_original%TYPE,
2597: p_discount_taken_unearned IN
2598: ar_payment_schedules.amount_due_original%TYPE,
2599: p_amount_line_items_original IN
2600: ar_payment_schedules.amount_line_items_original%TYPE,
2601: p_out_discount_date IN OUT NOCOPY DATE,
2602: p_out_earned_discount IN OUT NOCOPY
2603: ar_payment_schedules.amount_due_original%TYPE,
2604: p_out_unearned_discount IN OUT NOCOPY

Line 2603: ar_payment_schedules.amount_due_original%TYPE,

2599: p_amount_line_items_original IN
2600: ar_payment_schedules.amount_line_items_original%TYPE,
2601: p_out_discount_date IN OUT NOCOPY DATE,
2602: p_out_earned_discount IN OUT NOCOPY
2603: ar_payment_schedules.amount_due_original%TYPE,
2604: p_out_unearned_discount IN OUT NOCOPY
2605: ar_payment_schedules.amount_due_original%TYPE,
2606: p_out_amount_to_apply IN OUT NOCOPY
2607: ar_payment_schedules.amount_due_original%TYPE,

Line 2605: ar_payment_schedules.amount_due_original%TYPE,

2601: p_out_discount_date IN OUT NOCOPY DATE,
2602: p_out_earned_discount IN OUT NOCOPY
2603: ar_payment_schedules.amount_due_original%TYPE,
2604: p_out_unearned_discount IN OUT NOCOPY
2605: ar_payment_schedules.amount_due_original%TYPE,
2606: p_out_amount_to_apply IN OUT NOCOPY
2607: ar_payment_schedules.amount_due_original%TYPE,
2608: p_out_discount_to_take IN OUT NOCOPY
2609: ar_payment_schedules.amount_due_original%TYPE,

Line 2607: ar_payment_schedules.amount_due_original%TYPE,

2603: ar_payment_schedules.amount_due_original%TYPE,
2604: p_out_unearned_discount IN OUT NOCOPY
2605: ar_payment_schedules.amount_due_original%TYPE,
2606: p_out_amount_to_apply IN OUT NOCOPY
2607: ar_payment_schedules.amount_due_original%TYPE,
2608: p_out_discount_to_take IN OUT NOCOPY
2609: ar_payment_schedules.amount_due_original%TYPE,
2610: p_module_name IN VARCHAR2,
2611: p_module_version IN VARCHAR2 ,

Line 2609: ar_payment_schedules.amount_due_original%TYPE,

2605: ar_payment_schedules.amount_due_original%TYPE,
2606: p_out_amount_to_apply IN OUT NOCOPY
2607: ar_payment_schedules.amount_due_original%TYPE,
2608: p_out_discount_to_take IN OUT NOCOPY
2609: ar_payment_schedules.amount_due_original%TYPE,
2610: p_module_name IN VARCHAR2,
2611: p_module_version IN VARCHAR2 ,
2612: p_allow_discount IN VARCHAR2 DEFAULT 'Y' ) IS /* Bug fix 3450317 */
2613: BEGIN

Line 2684: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,

2680: +===========================================================================*/
2681: PROCEDURE validate_args_discounts_cover(
2682: p_mode IN VARCHAR2,
2683: p_invoice_currency_code IN ar_cash_receipts.currency_code%TYPE,
2684: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
2685: p_trx_date IN ar_payment_schedules.trx_date%TYPE,
2686: p_apply_date IN ar_cash_receipts.receipt_date%TYPE ) IS
2687: BEGIN
2688: IF PG_DEBUG in ('Y', 'C') THEN

Line 2685: p_trx_date IN ar_payment_schedules.trx_date%TYPE,

2681: PROCEDURE validate_args_discounts_cover(
2682: p_mode IN VARCHAR2,
2683: p_invoice_currency_code IN ar_cash_receipts.currency_code%TYPE,
2684: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
2685: p_trx_date IN ar_payment_schedules.trx_date%TYPE,
2686: p_apply_date IN ar_cash_receipts.receipt_date%TYPE ) IS
2687: BEGIN
2688: IF PG_DEBUG in ('Y', 'C') THEN
2689: arp_standard.debug( 'arp_calculate_discount.validate_args_discounts_cover()+' );