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

Line 146: p_customer_id IN AR_PAYMENT_SCHEDULES.customer_id%TYPE

142:
143: PROCEDURE insert_recos(p_request_id IN NUMBER);
144:
145: PROCEDURE calc_amount_app_and_disc(
146: p_customer_id IN AR_PAYMENT_SCHEDULES.customer_id%TYPE
147: , p_bill_to_site_use_id IN AR_PAYMENT_SCHEDULES.customer_site_use_id%TYPE
148: , p_invoice_currency_code IN AR_PAYMENT_SCHEDULES.invoice_currency_code%TYPE
149: , p_ps_id IN AR_PAYMENT_SCHEDULES.payment_schedule_id%TYPE
150: , p_term_id IN AR_PAYMENT_SCHEDULES.term_id%TYPE

Line 147: , p_bill_to_site_use_id IN AR_PAYMENT_SCHEDULES.customer_site_use_id%TYPE

143: PROCEDURE insert_recos(p_request_id IN NUMBER);
144:
145: PROCEDURE calc_amount_app_and_disc(
146: p_customer_id IN AR_PAYMENT_SCHEDULES.customer_id%TYPE
147: , p_bill_to_site_use_id IN AR_PAYMENT_SCHEDULES.customer_site_use_id%TYPE
148: , p_invoice_currency_code IN AR_PAYMENT_SCHEDULES.invoice_currency_code%TYPE
149: , p_ps_id IN AR_PAYMENT_SCHEDULES.payment_schedule_id%TYPE
150: , p_term_id IN AR_PAYMENT_SCHEDULES.term_id%TYPE
151: , p_terms_sequence_number IN AR_PAYMENT_SCHEDULES.terms_sequence_number%TYPE

Line 148: , p_invoice_currency_code IN AR_PAYMENT_SCHEDULES.invoice_currency_code%TYPE

144:
145: PROCEDURE calc_amount_app_and_disc(
146: p_customer_id IN AR_PAYMENT_SCHEDULES.customer_id%TYPE
147: , p_bill_to_site_use_id IN AR_PAYMENT_SCHEDULES.customer_site_use_id%TYPE
148: , p_invoice_currency_code IN AR_PAYMENT_SCHEDULES.invoice_currency_code%TYPE
149: , p_ps_id IN AR_PAYMENT_SCHEDULES.payment_schedule_id%TYPE
150: , p_term_id IN AR_PAYMENT_SCHEDULES.term_id%TYPE
151: , p_terms_sequence_number IN AR_PAYMENT_SCHEDULES.terms_sequence_number%TYPE
152: , p_trx_date IN AR_PAYMENT_SCHEDULES.trx_date%TYPE

Line 149: , p_ps_id IN AR_PAYMENT_SCHEDULES.payment_schedule_id%TYPE

145: PROCEDURE calc_amount_app_and_disc(
146: p_customer_id IN AR_PAYMENT_SCHEDULES.customer_id%TYPE
147: , p_bill_to_site_use_id IN AR_PAYMENT_SCHEDULES.customer_site_use_id%TYPE
148: , p_invoice_currency_code IN AR_PAYMENT_SCHEDULES.invoice_currency_code%TYPE
149: , p_ps_id IN AR_PAYMENT_SCHEDULES.payment_schedule_id%TYPE
150: , p_term_id IN AR_PAYMENT_SCHEDULES.term_id%TYPE
151: , p_terms_sequence_number IN AR_PAYMENT_SCHEDULES.terms_sequence_number%TYPE
152: , p_trx_date IN AR_PAYMENT_SCHEDULES.trx_date%TYPE
153: , p_allow_overapp_flag IN RA_CUST_TRX_TYPES.allow_overapplication_flag%TYPE

Line 150: , p_term_id IN AR_PAYMENT_SCHEDULES.term_id%TYPE

146: p_customer_id IN AR_PAYMENT_SCHEDULES.customer_id%TYPE
147: , p_bill_to_site_use_id IN AR_PAYMENT_SCHEDULES.customer_site_use_id%TYPE
148: , p_invoice_currency_code IN AR_PAYMENT_SCHEDULES.invoice_currency_code%TYPE
149: , p_ps_id IN AR_PAYMENT_SCHEDULES.payment_schedule_id%TYPE
150: , p_term_id IN AR_PAYMENT_SCHEDULES.term_id%TYPE
151: , p_terms_sequence_number IN AR_PAYMENT_SCHEDULES.terms_sequence_number%TYPE
152: , p_trx_date IN AR_PAYMENT_SCHEDULES.trx_date%TYPE
153: , p_allow_overapp_flag IN RA_CUST_TRX_TYPES.allow_overapplication_flag%TYPE
154: , p_partial_discount_flag IN RA_TERMS.partial_discount_flag%TYPE

Line 151: , p_terms_sequence_number IN AR_PAYMENT_SCHEDULES.terms_sequence_number%TYPE

147: , p_bill_to_site_use_id IN AR_PAYMENT_SCHEDULES.customer_site_use_id%TYPE
148: , p_invoice_currency_code IN AR_PAYMENT_SCHEDULES.invoice_currency_code%TYPE
149: , p_ps_id IN AR_PAYMENT_SCHEDULES.payment_schedule_id%TYPE
150: , p_term_id IN AR_PAYMENT_SCHEDULES.term_id%TYPE
151: , p_terms_sequence_number IN AR_PAYMENT_SCHEDULES.terms_sequence_number%TYPE
152: , p_trx_date IN AR_PAYMENT_SCHEDULES.trx_date%TYPE
153: , p_allow_overapp_flag IN RA_CUST_TRX_TYPES.allow_overapplication_flag%TYPE
154: , p_partial_discount_flag IN RA_TERMS.partial_discount_flag%TYPE
155: , p_input_amount IN AR_CASH_REMIT_REFS.amount_applied%TYPE

Line 152: , p_trx_date IN AR_PAYMENT_SCHEDULES.trx_date%TYPE

148: , p_invoice_currency_code IN AR_PAYMENT_SCHEDULES.invoice_currency_code%TYPE
149: , p_ps_id IN AR_PAYMENT_SCHEDULES.payment_schedule_id%TYPE
150: , p_term_id IN AR_PAYMENT_SCHEDULES.term_id%TYPE
151: , p_terms_sequence_number IN AR_PAYMENT_SCHEDULES.terms_sequence_number%TYPE
152: , p_trx_date IN AR_PAYMENT_SCHEDULES.trx_date%TYPE
153: , p_allow_overapp_flag IN RA_CUST_TRX_TYPES.allow_overapplication_flag%TYPE
154: , p_partial_discount_flag IN RA_TERMS.partial_discount_flag%TYPE
155: , p_input_amount IN AR_CASH_REMIT_REFS.amount_applied%TYPE
156: , p_amount_due_original IN AR_PAYMENT_SCHEDULES.amount_due_original%TYPE

Line 156: , p_amount_due_original IN AR_PAYMENT_SCHEDULES.amount_due_original%TYPE

152: , p_trx_date IN AR_PAYMENT_SCHEDULES.trx_date%TYPE
153: , p_allow_overapp_flag IN RA_CUST_TRX_TYPES.allow_overapplication_flag%TYPE
154: , p_partial_discount_flag IN RA_TERMS.partial_discount_flag%TYPE
155: , p_input_amount IN AR_CASH_REMIT_REFS.amount_applied%TYPE
156: , p_amount_due_original IN AR_PAYMENT_SCHEDULES.amount_due_original%TYPE
157: , p_amount_due_remaining IN AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE
158: , p_discount_taken_earned IN AR_PAYMENT_SCHEDULES.discount_taken_earned%TYPE
159: , p_discount_taken_unearned IN AR_PAYMENT_SCHEDULES.discount_taken_unearned%TYPE
160: , p_cash_receipt_id IN AR_CASH_RECEIPTS.cash_receipt_id%TYPE

Line 157: , p_amount_due_remaining IN AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE

153: , p_allow_overapp_flag IN RA_CUST_TRX_TYPES.allow_overapplication_flag%TYPE
154: , p_partial_discount_flag IN RA_TERMS.partial_discount_flag%TYPE
155: , p_input_amount IN AR_CASH_REMIT_REFS.amount_applied%TYPE
156: , p_amount_due_original IN AR_PAYMENT_SCHEDULES.amount_due_original%TYPE
157: , p_amount_due_remaining IN AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE
158: , p_discount_taken_earned IN AR_PAYMENT_SCHEDULES.discount_taken_earned%TYPE
159: , p_discount_taken_unearned IN AR_PAYMENT_SCHEDULES.discount_taken_unearned%TYPE
160: , p_cash_receipt_id IN AR_CASH_RECEIPTS.cash_receipt_id%TYPE
161: , x_out_amount_to_apply OUT NOCOPY NUMBER

Line 158: , p_discount_taken_earned IN AR_PAYMENT_SCHEDULES.discount_taken_earned%TYPE

154: , p_partial_discount_flag IN RA_TERMS.partial_discount_flag%TYPE
155: , p_input_amount IN AR_CASH_REMIT_REFS.amount_applied%TYPE
156: , p_amount_due_original IN AR_PAYMENT_SCHEDULES.amount_due_original%TYPE
157: , p_amount_due_remaining IN AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE
158: , p_discount_taken_earned IN AR_PAYMENT_SCHEDULES.discount_taken_earned%TYPE
159: , p_discount_taken_unearned IN AR_PAYMENT_SCHEDULES.discount_taken_unearned%TYPE
160: , p_cash_receipt_id IN AR_CASH_RECEIPTS.cash_receipt_id%TYPE
161: , x_out_amount_to_apply OUT NOCOPY NUMBER
162: , x_out_discount_to_take OUT NOCOPY NUMBER);

Line 159: , p_discount_taken_unearned IN AR_PAYMENT_SCHEDULES.discount_taken_unearned%TYPE

155: , p_input_amount IN AR_CASH_REMIT_REFS.amount_applied%TYPE
156: , p_amount_due_original IN AR_PAYMENT_SCHEDULES.amount_due_original%TYPE
157: , p_amount_due_remaining IN AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE
158: , p_discount_taken_earned IN AR_PAYMENT_SCHEDULES.discount_taken_earned%TYPE
159: , p_discount_taken_unearned IN AR_PAYMENT_SCHEDULES.discount_taken_unearned%TYPE
160: , p_cash_receipt_id IN AR_CASH_RECEIPTS.cash_receipt_id%TYPE
161: , x_out_amount_to_apply OUT NOCOPY NUMBER
162: , x_out_discount_to_take OUT NOCOPY NUMBER);
163:

Line 650: l_from_clause := l_from_clause || ' , AR_PAYMENT_SCHEDULES ps ';

646: l_where_clause := l_where_clause || ' AND bat.name <= :b_batch_name_h ';
647: l_use_bat := 'Y';
648: END IF;
649: IF p_min_unapp_amt IS NOT NULL THEN
650: l_from_clause := l_from_clause || ' , AR_PAYMENT_SCHEDULES ps ';
651: l_where_clause := l_where_clause || ' AND ps.amount_due_remaining * -1 >= :b_min_unapp_amt
652: AND ps.cash_receipt_id = ref.cash_receipt_id ';
653: END IF;
654: IF p_receipt_date_l IS NOT NULL THEN

Line 1234: ar_payment_schedules ps,

1230: FROM ar_cash_automatches am,
1231: ar_cash_automatch_rule_map amp,
1232: ar_cash_remit_refs_interim ref,
1233: ar_cash_receipts cr,
1234: ar_payment_schedules ps,
1235: ra_customer_trx trx,
1236: ra_cust_trx_types ctt,
1237: ra_terms tr
1238: WHERE am.automatch_id = p_automatch_id

Line 1482: ar_payment_schedules ps,

1478: ar_cash_automatch_rule_map amp,
1479: ar_cash_remit_refs_interim ref,
1480: ar_cash_receipts cr,
1481: ra_customer_trx trx,
1482: ar_payment_schedules ps,
1483: ra_cust_trx_types ctt,
1484: ra_terms tr
1485: WHERE am.automatch_id = p_automatch_id
1486: AND amp.automatch_id = am.automatch_id

Line 1723: ar_payment_schedules ps,

1719: ar_cash_automatch_rule_map amp,
1720: ar_cash_remit_refs_interim ref,
1721: ar_cash_receipts cr,
1722: ra_customer_trx_lines lin,
1723: ar_payment_schedules ps,
1724: ra_customer_trx trx,
1725: ra_cust_trx_types ctt,
1726: ra_terms tr
1727: WHERE am.automatch_id = p_automatch_id

Line 1967: ar_payment_schedules ps,

1963: ar_cash_automatch_rule_map amp,
1964: ar_cash_remit_refs_interim ref,
1965: ar_cash_receipts cr,
1966: ra_customer_trx_lines lin,
1967: ar_payment_schedules ps,
1968: ra_customer_trx trx,
1969: ra_cust_trx_types ctt,
1970: ra_terms tr
1971: WHERE am.automatch_id = p_automatch_id

Line 2214: ar_payment_schedules ps,

2210: ar_cash_automatch_rule_map amp,
2211: ar_cash_remit_refs_interim ref,
2212: ar_cash_receipts cr,
2213: ra_customer_trx trx,
2214: ar_payment_schedules ps,
2215: ra_cust_trx_types ctt,
2216: ra_terms tr
2217: WHERE am.automatch_id = :b_automatch_id
2218: AND amp.automatch_id = am.automatch_id

Line 2475: ar_payment_schedules ps,

2471: ar_cash_automatch_rule_map amp,
2472: ar_cash_remit_refs_interim ref,
2473: ar_cash_receipts cr,
2474: ra_customer_trx trx,
2475: ar_payment_schedules ps,
2476: ra_cust_trx_types ctt,
2477: ra_terms tr
2478: WHERE am.automatch_id = p_automatch_id
2479: AND amp.automatch_id = am.automatch_id

Line 2696: ar_payment_schedules ps,

2692: ar_cash_automatch_rule_map amp,
2693: ar_cash_remit_refs_interim ref,
2694: ar_cash_receipts cr,
2695: ar_cons_inv ci,
2696: ar_payment_schedules ps,
2697: ra_customer_trx trx,
2698: ra_cust_trx_types ctt,
2699: ra_terms tr
2700: WHERE am.automatch_id = p_automatch_id

Line 2941: ar_payment_schedules ps,

2937: FROM ar_cash_automatches am,
2938: ar_cash_automatch_rule_map amp,
2939: ar_cash_remit_refs_interim ref,
2940: ar_cash_receipts cr,
2941: ar_payment_schedules ps,
2942: ra_customer_trx trx,
2943: ra_cust_trx_types ctt,
2944: ra_terms tr
2945: WHERE am.automatch_id = p_automatch_id

Line 3114: TYPE psid_tab IS TABLE OF ar_payment_schedules.payment_schedule_id%TYPE INDEX BY PLS_INTEGER;

3110: * *
3111: +===========================================================================*/
3112: PROCEDURE validate_trx_recos( p_req_id IN NUMBER
3113: , p_worker_number IN NUMBER) IS
3114: TYPE psid_tab IS TABLE OF ar_payment_schedules.payment_schedule_id%TYPE INDEX BY PLS_INTEGER;
3115: locked_ps_records psid_tab;
3116: BEGIN
3117: IF (PG_DEBUG IN ('Y', 'C')) THEN
3118: log('arp_autoapply_api.validate_trx_recos(+)');

Line 3196: ar_payment_schedules ps

3192: SET recommendation_reason = 'AR_AA_CURR_NO_MATCH'
3193: WHERE EXISTS (SELECT 'Inconsistent Currency'
3194: FROM ar_cash_recos rec,
3195: ar_cash_remit_refs_interim ref,
3196: ar_payment_schedules ps
3197: WHERE rec.recommendation_id = l.recommendation_id
3198: AND ref.remit_reference_id = rec.remit_reference_id
3199: AND ref.worker_number = p_worker_number
3200: AND ps.payment_schedule_id = l.payment_schedule_id

Line 3215: FROM ar_payment_schedules ps

3211: --is not provided in the reference
3212: UPDATE ar_cash_reco_lines l
3213: SET recommendation_reason = 'AR_AA_NO_XCURR_RATE'
3214: WHERE EXISTS (SELECT 'No X Rate Info'
3215: FROM ar_payment_schedules ps
3216: WHERE l.payment_schedule_id = ps.payment_schedule_id
3217: AND l.receipt_currency_code <> ps.invoice_currency_code
3218: AND (l.trans_to_receipt_rate IS NULL
3219: OR l.trans_to_receipt_rate = -1))

Line 3231: FROM ar_payment_schedules ps

3227: --Invalid rate provided for fixed rate currencies
3228: UPDATE ar_cash_reco_lines l
3229: SET recommendation_reason = 'AR_AA_INVALID_RATE'
3230: WHERE (EXISTS (SELECT 'Same Currency'
3231: FROM ar_payment_schedules ps
3232: WHERE l.payment_schedule_id = ps.payment_schedule_id
3233: AND l.receipt_currency_code = ps.invoice_currency_code
3234: AND l.trans_to_receipt_rate IS NOT NULL)
3235: OR EXISTS (SELECT 'Wrong rate for fixed rate currency'

Line 3236: FROM ar_payment_schedules ps

3232: WHERE l.payment_schedule_id = ps.payment_schedule_id
3233: AND l.receipt_currency_code = ps.invoice_currency_code
3234: AND l.trans_to_receipt_rate IS NOT NULL)
3235: OR EXISTS (SELECT 'Wrong rate for fixed rate currency'
3236: FROM ar_payment_schedules ps
3237: WHERE l.payment_schedule_id = ps.payment_schedule_id
3238: AND GL_CURRENCY_API.IS_FIXED_RATE(ps.invoice_currency_code,
3239: l.receipt_currency_code,
3240: l.receipt_date) = 'Y'

Line 3259: FROM ar_payment_schedules ps

3255: SET recommendation_reason = (SELECT CASE WHEN SIGN(l.amount_applied*ps.amount_due_remaining) = -1
3256: THEN 'AR_AA_NAT_APP_VIO'
3257: ELSE recommendation_reason
3258: END
3259: FROM ar_payment_schedules ps
3260: WHERE ps.payment_schedule_id = l.payment_schedule_id)
3261: WHERE request_id = p_req_id
3262: AND recommendation_reason = 'AR_AM_INV_THRESHOLD';
3263:

Line 3412: ar_payment_schedules ps

3408: FROM ar_cash_recos rec,
3409: ar_cash_reco_lines lin,
3410: ar_cash_remit_refs_interim ref,
3411: ar_cash_automatches am,
3412: ar_payment_schedules ps
3413: WHERE rec.request_id = p_req_id
3414: AND rec.match_reason_code = 'AR_AA_DUPLICATE_RECOS'
3415: AND ref.remit_reference_id = rec.remit_reference_id
3416: AND ref.worker_number = p_worker_number

Line 3595: FROM ar_payment_schedules ps,

3591: (SELECT remit_reference_id
3592: FROM ar_cash_remit_refs_interim
3593: WHERE cash_receipt_id IN (
3594: SELECT ps.cash_receipt_id
3595: FROM ar_payment_schedules ps,
3596: ar_cash_receipts cr,
3597: ar_cash_remit_refs_interim ref,
3598: ar_cash_recos rec,
3599: ar_cash_reco_lines recl

Line 3698: FROM ar_payment_schedules ps,

3694: END;
3695:
3696: SELECT ps.payment_schedule_id
3697: BULK COLLECT INTO locked_ps_records
3698: FROM ar_payment_schedules ps,
3699: ar_cash_reco_lines lines
3700: WHERE lines.request_id = p_req_id
3701: AND lines.recommendation_reason = 'AR_AM_INV_THRESHOLD'
3702: AND ps.payment_schedule_id = lines.payment_schedule_id

Line 3829: ar_payment_schedules ps

3825: lin.amount_applied_from,
3826: lin.trans_to_receipt_rate,
3827: ps.invoice_currency_code
3828: FROM ar_cash_reco_lines lin,
3829: ar_payment_schedules ps
3830: WHERE lin.recommendation_id = p_reco_id
3831: AND lin.request_id = p_req_id
3832: AND lin.recommendation_reason = 'AR_AA_INV_LOCKED'
3833: AND ps.payment_schedule_id = lin.payment_schedule_id

Line 4115: l_res_matching_date AR_PAYMENT_SCHEDULES.trx_date%TYPE;

4111: l_ref_amount_applied_from AR_CASH_REMIT_REFS.amount_applied_from%TYPE;
4112: l_ref_orig_amount AR_CASH_REMIT_REFS.amount_applied%TYPE;
4113: l_ref_rem_amount AR_CASH_REMIT_REFS.amount_applied%TYPE;
4114: l_trans_to_receipt_rate AR_CASH_REMIT_REFS.trans_to_receipt_rate%TYPE;
4115: l_res_matching_date AR_PAYMENT_SCHEDULES.trx_date%TYPE;
4116: l_match_score_value AR_CASH_RECOS.match_score_value%TYPE;
4117: l_receipt_currency_code AR_CASH_RECEIPTS.currency_code%TYPE;
4118: l_resolved_match_currency AR_PAYMENT_SCHEDULES.invoice_currency_code%TYPE;
4119: l_trx_amt_due_rem AR_CASH_REMIT_REFS.amount_applied%TYPE := 0;

Line 4118: l_resolved_match_currency AR_PAYMENT_SCHEDULES.invoice_currency_code%TYPE;

4114: l_trans_to_receipt_rate AR_CASH_REMIT_REFS.trans_to_receipt_rate%TYPE;
4115: l_res_matching_date AR_PAYMENT_SCHEDULES.trx_date%TYPE;
4116: l_match_score_value AR_CASH_RECOS.match_score_value%TYPE;
4117: l_receipt_currency_code AR_CASH_RECEIPTS.currency_code%TYPE;
4118: l_resolved_match_currency AR_PAYMENT_SCHEDULES.invoice_currency_code%TYPE;
4119: l_trx_amt_due_rem AR_CASH_REMIT_REFS.amount_applied%TYPE := 0;
4120: l_discount_taken AR_CASH_RECO_LINES.discount_taken_earned%TYPE := 0;
4121: l_amount_applied AR_CASH_REMIT_REFS.amount_applied%TYPE;
4122: l_out_amount_to_apply AR_CASH_REMIT_REFS.amount_applied%TYPE;

Line 4488: , p_inv_curr_code IN ar_payment_schedules.invoice_currency_code%TYPE

4484: END insert_recos;
4485:
4486: FUNCTION get_cross_curr_rate(p_amount_applied IN ar_cash_remit_refs.amount_applied%TYPE
4487: , p_amount_applied_from IN ar_cash_remit_refs.amount_applied_from%TYPE
4488: , p_inv_curr_code IN ar_payment_schedules.invoice_currency_code%TYPE
4489: , p_rec_curr_code IN ar_cash_receipts.currency_code%TYPE)
4490: RETURN NUMBER IS
4491: l_cross_curr_rate NUMBER;
4492: l_amount_applied ar_cash_remit_refs.amount_applied%TYPE;

Line 4494: l_inv_curr_code ar_payment_schedules.invoice_currency_code%TYPE;

4490: RETURN NUMBER IS
4491: l_cross_curr_rate NUMBER;
4492: l_amount_applied ar_cash_remit_refs.amount_applied%TYPE;
4493: l_amount_applied_from ar_cash_remit_refs.amount_applied_from%TYPE;
4494: l_inv_curr_code ar_payment_schedules.invoice_currency_code%TYPE;
4495: l_rec_curr_code ar_cash_receipts.currency_code%TYPE;
4496: BEGIN
4497: l_amount_applied := NVL(p_amount_applied, 0);
4498: l_amount_applied_from := NVL(p_amount_applied_from, 0);

Line 4513: p_customer_id IN AR_PAYMENT_SCHEDULES.customer_id%TYPE

4509: RETURN l_cross_curr_rate;
4510: END get_cross_curr_rate;
4511:
4512: PROCEDURE calc_amount_app_and_disc(
4513: p_customer_id IN AR_PAYMENT_SCHEDULES.customer_id%TYPE
4514: , p_bill_to_site_use_id IN AR_PAYMENT_SCHEDULES.customer_site_use_id%TYPE
4515: , p_invoice_currency_code IN AR_PAYMENT_SCHEDULES.invoice_currency_code%TYPE
4516: , p_ps_id IN AR_PAYMENT_SCHEDULES.payment_schedule_id%TYPE
4517: , p_term_id IN AR_PAYMENT_SCHEDULES.term_id%TYPE

Line 4514: , p_bill_to_site_use_id IN AR_PAYMENT_SCHEDULES.customer_site_use_id%TYPE

4510: END get_cross_curr_rate;
4511:
4512: PROCEDURE calc_amount_app_and_disc(
4513: p_customer_id IN AR_PAYMENT_SCHEDULES.customer_id%TYPE
4514: , p_bill_to_site_use_id IN AR_PAYMENT_SCHEDULES.customer_site_use_id%TYPE
4515: , p_invoice_currency_code IN AR_PAYMENT_SCHEDULES.invoice_currency_code%TYPE
4516: , p_ps_id IN AR_PAYMENT_SCHEDULES.payment_schedule_id%TYPE
4517: , p_term_id IN AR_PAYMENT_SCHEDULES.term_id%TYPE
4518: , p_terms_sequence_number IN AR_PAYMENT_SCHEDULES.terms_sequence_number%TYPE

Line 4515: , p_invoice_currency_code IN AR_PAYMENT_SCHEDULES.invoice_currency_code%TYPE

4511:
4512: PROCEDURE calc_amount_app_and_disc(
4513: p_customer_id IN AR_PAYMENT_SCHEDULES.customer_id%TYPE
4514: , p_bill_to_site_use_id IN AR_PAYMENT_SCHEDULES.customer_site_use_id%TYPE
4515: , p_invoice_currency_code IN AR_PAYMENT_SCHEDULES.invoice_currency_code%TYPE
4516: , p_ps_id IN AR_PAYMENT_SCHEDULES.payment_schedule_id%TYPE
4517: , p_term_id IN AR_PAYMENT_SCHEDULES.term_id%TYPE
4518: , p_terms_sequence_number IN AR_PAYMENT_SCHEDULES.terms_sequence_number%TYPE
4519: , p_trx_date IN AR_PAYMENT_SCHEDULES.trx_date%TYPE

Line 4516: , p_ps_id IN AR_PAYMENT_SCHEDULES.payment_schedule_id%TYPE

4512: PROCEDURE calc_amount_app_and_disc(
4513: p_customer_id IN AR_PAYMENT_SCHEDULES.customer_id%TYPE
4514: , p_bill_to_site_use_id IN AR_PAYMENT_SCHEDULES.customer_site_use_id%TYPE
4515: , p_invoice_currency_code IN AR_PAYMENT_SCHEDULES.invoice_currency_code%TYPE
4516: , p_ps_id IN AR_PAYMENT_SCHEDULES.payment_schedule_id%TYPE
4517: , p_term_id IN AR_PAYMENT_SCHEDULES.term_id%TYPE
4518: , p_terms_sequence_number IN AR_PAYMENT_SCHEDULES.terms_sequence_number%TYPE
4519: , p_trx_date IN AR_PAYMENT_SCHEDULES.trx_date%TYPE
4520: , p_allow_overapp_flag IN RA_CUST_TRX_TYPES.allow_overapplication_flag%TYPE

Line 4517: , p_term_id IN AR_PAYMENT_SCHEDULES.term_id%TYPE

4513: p_customer_id IN AR_PAYMENT_SCHEDULES.customer_id%TYPE
4514: , p_bill_to_site_use_id IN AR_PAYMENT_SCHEDULES.customer_site_use_id%TYPE
4515: , p_invoice_currency_code IN AR_PAYMENT_SCHEDULES.invoice_currency_code%TYPE
4516: , p_ps_id IN AR_PAYMENT_SCHEDULES.payment_schedule_id%TYPE
4517: , p_term_id IN AR_PAYMENT_SCHEDULES.term_id%TYPE
4518: , p_terms_sequence_number IN AR_PAYMENT_SCHEDULES.terms_sequence_number%TYPE
4519: , p_trx_date IN AR_PAYMENT_SCHEDULES.trx_date%TYPE
4520: , p_allow_overapp_flag IN RA_CUST_TRX_TYPES.allow_overapplication_flag%TYPE
4521: , p_partial_discount_flag IN RA_TERMS.partial_discount_flag%TYPE

Line 4518: , p_terms_sequence_number IN AR_PAYMENT_SCHEDULES.terms_sequence_number%TYPE

4514: , p_bill_to_site_use_id IN AR_PAYMENT_SCHEDULES.customer_site_use_id%TYPE
4515: , p_invoice_currency_code IN AR_PAYMENT_SCHEDULES.invoice_currency_code%TYPE
4516: , p_ps_id IN AR_PAYMENT_SCHEDULES.payment_schedule_id%TYPE
4517: , p_term_id IN AR_PAYMENT_SCHEDULES.term_id%TYPE
4518: , p_terms_sequence_number IN AR_PAYMENT_SCHEDULES.terms_sequence_number%TYPE
4519: , p_trx_date IN AR_PAYMENT_SCHEDULES.trx_date%TYPE
4520: , p_allow_overapp_flag IN RA_CUST_TRX_TYPES.allow_overapplication_flag%TYPE
4521: , p_partial_discount_flag IN RA_TERMS.partial_discount_flag%TYPE
4522: , p_input_amount IN AR_CASH_REMIT_REFS.amount_applied%TYPE

Line 4519: , p_trx_date IN AR_PAYMENT_SCHEDULES.trx_date%TYPE

4515: , p_invoice_currency_code IN AR_PAYMENT_SCHEDULES.invoice_currency_code%TYPE
4516: , p_ps_id IN AR_PAYMENT_SCHEDULES.payment_schedule_id%TYPE
4517: , p_term_id IN AR_PAYMENT_SCHEDULES.term_id%TYPE
4518: , p_terms_sequence_number IN AR_PAYMENT_SCHEDULES.terms_sequence_number%TYPE
4519: , p_trx_date IN AR_PAYMENT_SCHEDULES.trx_date%TYPE
4520: , p_allow_overapp_flag IN RA_CUST_TRX_TYPES.allow_overapplication_flag%TYPE
4521: , p_partial_discount_flag IN RA_TERMS.partial_discount_flag%TYPE
4522: , p_input_amount IN AR_CASH_REMIT_REFS.amount_applied%TYPE
4523: , p_amount_due_original IN AR_PAYMENT_SCHEDULES.amount_due_original%TYPE

Line 4523: , p_amount_due_original IN AR_PAYMENT_SCHEDULES.amount_due_original%TYPE

4519: , p_trx_date IN AR_PAYMENT_SCHEDULES.trx_date%TYPE
4520: , p_allow_overapp_flag IN RA_CUST_TRX_TYPES.allow_overapplication_flag%TYPE
4521: , p_partial_discount_flag IN RA_TERMS.partial_discount_flag%TYPE
4522: , p_input_amount IN AR_CASH_REMIT_REFS.amount_applied%TYPE
4523: , p_amount_due_original IN AR_PAYMENT_SCHEDULES.amount_due_original%TYPE
4524: , p_amount_due_remaining IN AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE
4525: , p_discount_taken_earned IN AR_PAYMENT_SCHEDULES.discount_taken_earned%TYPE
4526: , p_discount_taken_unearned IN AR_PAYMENT_SCHEDULES.discount_taken_unearned%TYPE
4527: , p_cash_receipt_id IN AR_CASH_RECEIPTS.cash_receipt_id%TYPE

Line 4524: , p_amount_due_remaining IN AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE

4520: , p_allow_overapp_flag IN RA_CUST_TRX_TYPES.allow_overapplication_flag%TYPE
4521: , p_partial_discount_flag IN RA_TERMS.partial_discount_flag%TYPE
4522: , p_input_amount IN AR_CASH_REMIT_REFS.amount_applied%TYPE
4523: , p_amount_due_original IN AR_PAYMENT_SCHEDULES.amount_due_original%TYPE
4524: , p_amount_due_remaining IN AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE
4525: , p_discount_taken_earned IN AR_PAYMENT_SCHEDULES.discount_taken_earned%TYPE
4526: , p_discount_taken_unearned IN AR_PAYMENT_SCHEDULES.discount_taken_unearned%TYPE
4527: , p_cash_receipt_id IN AR_CASH_RECEIPTS.cash_receipt_id%TYPE
4528: , x_out_amount_to_apply OUT NOCOPY NUMBER

Line 4525: , p_discount_taken_earned IN AR_PAYMENT_SCHEDULES.discount_taken_earned%TYPE

4521: , p_partial_discount_flag IN RA_TERMS.partial_discount_flag%TYPE
4522: , p_input_amount IN AR_CASH_REMIT_REFS.amount_applied%TYPE
4523: , p_amount_due_original IN AR_PAYMENT_SCHEDULES.amount_due_original%TYPE
4524: , p_amount_due_remaining IN AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE
4525: , p_discount_taken_earned IN AR_PAYMENT_SCHEDULES.discount_taken_earned%TYPE
4526: , p_discount_taken_unearned IN AR_PAYMENT_SCHEDULES.discount_taken_unearned%TYPE
4527: , p_cash_receipt_id IN AR_CASH_RECEIPTS.cash_receipt_id%TYPE
4528: , x_out_amount_to_apply OUT NOCOPY NUMBER
4529: , x_out_discount_to_take OUT NOCOPY NUMBER) IS

Line 4526: , p_discount_taken_unearned IN AR_PAYMENT_SCHEDULES.discount_taken_unearned%TYPE

4522: , p_input_amount IN AR_CASH_REMIT_REFS.amount_applied%TYPE
4523: , p_amount_due_original IN AR_PAYMENT_SCHEDULES.amount_due_original%TYPE
4524: , p_amount_due_remaining IN AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE
4525: , p_discount_taken_earned IN AR_PAYMENT_SCHEDULES.discount_taken_earned%TYPE
4526: , p_discount_taken_unearned IN AR_PAYMENT_SCHEDULES.discount_taken_unearned%TYPE
4527: , p_cash_receipt_id IN AR_CASH_RECEIPTS.cash_receipt_id%TYPE
4528: , x_out_amount_to_apply OUT NOCOPY NUMBER
4529: , x_out_discount_to_take OUT NOCOPY NUMBER) IS
4530: l_customer_id AR_PAYMENT_SCHEDULES.customer_id%TYPE;

Line 4530: l_customer_id AR_PAYMENT_SCHEDULES.customer_id%TYPE;

4526: , p_discount_taken_unearned IN AR_PAYMENT_SCHEDULES.discount_taken_unearned%TYPE
4527: , p_cash_receipt_id IN AR_CASH_RECEIPTS.cash_receipt_id%TYPE
4528: , x_out_amount_to_apply OUT NOCOPY NUMBER
4529: , x_out_discount_to_take OUT NOCOPY NUMBER) IS
4530: l_customer_id AR_PAYMENT_SCHEDULES.customer_id%TYPE;
4531: l_bill_to_site_use_id AR_PAYMENT_SCHEDULES.customer_site_use_id%TYPE;
4532: l_invoice_currency_code AR_PAYMENT_SCHEDULES.invoice_currency_code%TYPE;
4533: l_ps_id AR_PAYMENT_SCHEDULES.payment_schedule_id%TYPE;
4534: l_term_id AR_PAYMENT_SCHEDULES.term_id%TYPE;

Line 4531: l_bill_to_site_use_id AR_PAYMENT_SCHEDULES.customer_site_use_id%TYPE;

4527: , p_cash_receipt_id IN AR_CASH_RECEIPTS.cash_receipt_id%TYPE
4528: , x_out_amount_to_apply OUT NOCOPY NUMBER
4529: , x_out_discount_to_take OUT NOCOPY NUMBER) IS
4530: l_customer_id AR_PAYMENT_SCHEDULES.customer_id%TYPE;
4531: l_bill_to_site_use_id AR_PAYMENT_SCHEDULES.customer_site_use_id%TYPE;
4532: l_invoice_currency_code AR_PAYMENT_SCHEDULES.invoice_currency_code%TYPE;
4533: l_ps_id AR_PAYMENT_SCHEDULES.payment_schedule_id%TYPE;
4534: l_term_id AR_PAYMENT_SCHEDULES.term_id%TYPE;
4535: l_terms_sequence_number AR_PAYMENT_SCHEDULES.terms_sequence_number%TYPE;

Line 4532: l_invoice_currency_code AR_PAYMENT_SCHEDULES.invoice_currency_code%TYPE;

4528: , x_out_amount_to_apply OUT NOCOPY NUMBER
4529: , x_out_discount_to_take OUT NOCOPY NUMBER) IS
4530: l_customer_id AR_PAYMENT_SCHEDULES.customer_id%TYPE;
4531: l_bill_to_site_use_id AR_PAYMENT_SCHEDULES.customer_site_use_id%TYPE;
4532: l_invoice_currency_code AR_PAYMENT_SCHEDULES.invoice_currency_code%TYPE;
4533: l_ps_id AR_PAYMENT_SCHEDULES.payment_schedule_id%TYPE;
4534: l_term_id AR_PAYMENT_SCHEDULES.term_id%TYPE;
4535: l_terms_sequence_number AR_PAYMENT_SCHEDULES.terms_sequence_number%TYPE;
4536: l_trx_date AR_PAYMENT_SCHEDULES.trx_date%TYPE;

Line 4533: l_ps_id AR_PAYMENT_SCHEDULES.payment_schedule_id%TYPE;

4529: , x_out_discount_to_take OUT NOCOPY NUMBER) IS
4530: l_customer_id AR_PAYMENT_SCHEDULES.customer_id%TYPE;
4531: l_bill_to_site_use_id AR_PAYMENT_SCHEDULES.customer_site_use_id%TYPE;
4532: l_invoice_currency_code AR_PAYMENT_SCHEDULES.invoice_currency_code%TYPE;
4533: l_ps_id AR_PAYMENT_SCHEDULES.payment_schedule_id%TYPE;
4534: l_term_id AR_PAYMENT_SCHEDULES.term_id%TYPE;
4535: l_terms_sequence_number AR_PAYMENT_SCHEDULES.terms_sequence_number%TYPE;
4536: l_trx_date AR_PAYMENT_SCHEDULES.trx_date%TYPE;
4537: l_allow_overapp_flag RA_CUST_TRX_TYPES.allow_overapplication_flag%TYPE;

Line 4534: l_term_id AR_PAYMENT_SCHEDULES.term_id%TYPE;

4530: l_customer_id AR_PAYMENT_SCHEDULES.customer_id%TYPE;
4531: l_bill_to_site_use_id AR_PAYMENT_SCHEDULES.customer_site_use_id%TYPE;
4532: l_invoice_currency_code AR_PAYMENT_SCHEDULES.invoice_currency_code%TYPE;
4533: l_ps_id AR_PAYMENT_SCHEDULES.payment_schedule_id%TYPE;
4534: l_term_id AR_PAYMENT_SCHEDULES.term_id%TYPE;
4535: l_terms_sequence_number AR_PAYMENT_SCHEDULES.terms_sequence_number%TYPE;
4536: l_trx_date AR_PAYMENT_SCHEDULES.trx_date%TYPE;
4537: l_allow_overapp_flag RA_CUST_TRX_TYPES.allow_overapplication_flag%TYPE;
4538: l_partial_discount_flag RA_TERMS.partial_discount_flag%TYPE;

Line 4535: l_terms_sequence_number AR_PAYMENT_SCHEDULES.terms_sequence_number%TYPE;

4531: l_bill_to_site_use_id AR_PAYMENT_SCHEDULES.customer_site_use_id%TYPE;
4532: l_invoice_currency_code AR_PAYMENT_SCHEDULES.invoice_currency_code%TYPE;
4533: l_ps_id AR_PAYMENT_SCHEDULES.payment_schedule_id%TYPE;
4534: l_term_id AR_PAYMENT_SCHEDULES.term_id%TYPE;
4535: l_terms_sequence_number AR_PAYMENT_SCHEDULES.terms_sequence_number%TYPE;
4536: l_trx_date AR_PAYMENT_SCHEDULES.trx_date%TYPE;
4537: l_allow_overapp_flag RA_CUST_TRX_TYPES.allow_overapplication_flag%TYPE;
4538: l_partial_discount_flag RA_TERMS.partial_discount_flag%TYPE;
4539: l_input_amount AR_CASH_REMIT_REFS.amount_applied%TYPE;

Line 4536: l_trx_date AR_PAYMENT_SCHEDULES.trx_date%TYPE;

4532: l_invoice_currency_code AR_PAYMENT_SCHEDULES.invoice_currency_code%TYPE;
4533: l_ps_id AR_PAYMENT_SCHEDULES.payment_schedule_id%TYPE;
4534: l_term_id AR_PAYMENT_SCHEDULES.term_id%TYPE;
4535: l_terms_sequence_number AR_PAYMENT_SCHEDULES.terms_sequence_number%TYPE;
4536: l_trx_date AR_PAYMENT_SCHEDULES.trx_date%TYPE;
4537: l_allow_overapp_flag RA_CUST_TRX_TYPES.allow_overapplication_flag%TYPE;
4538: l_partial_discount_flag RA_TERMS.partial_discount_flag%TYPE;
4539: l_input_amount AR_CASH_REMIT_REFS.amount_applied%TYPE;
4540: l_amount_due_original AR_PAYMENT_SCHEDULES.amount_due_original%TYPE;

Line 4540: l_amount_due_original AR_PAYMENT_SCHEDULES.amount_due_original%TYPE;

4536: l_trx_date AR_PAYMENT_SCHEDULES.trx_date%TYPE;
4537: l_allow_overapp_flag RA_CUST_TRX_TYPES.allow_overapplication_flag%TYPE;
4538: l_partial_discount_flag RA_TERMS.partial_discount_flag%TYPE;
4539: l_input_amount AR_CASH_REMIT_REFS.amount_applied%TYPE;
4540: l_amount_due_original AR_PAYMENT_SCHEDULES.amount_due_original%TYPE;
4541: l_amount_due_remaining AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE;
4542: l_discount_taken_earned AR_PAYMENT_SCHEDULES.discount_taken_earned%TYPE;
4543: l_discount_taken_unearned AR_PAYMENT_SCHEDULES.discount_taken_unearned%TYPE;
4544: l_cash_receipt_id AR_CASH_RECEIPTS.cash_receipt_id%TYPE;

Line 4541: l_amount_due_remaining AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE;

4537: l_allow_overapp_flag RA_CUST_TRX_TYPES.allow_overapplication_flag%TYPE;
4538: l_partial_discount_flag RA_TERMS.partial_discount_flag%TYPE;
4539: l_input_amount AR_CASH_REMIT_REFS.amount_applied%TYPE;
4540: l_amount_due_original AR_PAYMENT_SCHEDULES.amount_due_original%TYPE;
4541: l_amount_due_remaining AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE;
4542: l_discount_taken_earned AR_PAYMENT_SCHEDULES.discount_taken_earned%TYPE;
4543: l_discount_taken_unearned AR_PAYMENT_SCHEDULES.discount_taken_unearned%TYPE;
4544: l_cash_receipt_id AR_CASH_RECEIPTS.cash_receipt_id%TYPE;
4545:

Line 4542: l_discount_taken_earned AR_PAYMENT_SCHEDULES.discount_taken_earned%TYPE;

4538: l_partial_discount_flag RA_TERMS.partial_discount_flag%TYPE;
4539: l_input_amount AR_CASH_REMIT_REFS.amount_applied%TYPE;
4540: l_amount_due_original AR_PAYMENT_SCHEDULES.amount_due_original%TYPE;
4541: l_amount_due_remaining AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE;
4542: l_discount_taken_earned AR_PAYMENT_SCHEDULES.discount_taken_earned%TYPE;
4543: l_discount_taken_unearned AR_PAYMENT_SCHEDULES.discount_taken_unearned%TYPE;
4544: l_cash_receipt_id AR_CASH_RECEIPTS.cash_receipt_id%TYPE;
4545:
4546: ln_earned_disc_pct NUMBER;

Line 4543: l_discount_taken_unearned AR_PAYMENT_SCHEDULES.discount_taken_unearned%TYPE;

4539: l_input_amount AR_CASH_REMIT_REFS.amount_applied%TYPE;
4540: l_amount_due_original AR_PAYMENT_SCHEDULES.amount_due_original%TYPE;
4541: l_amount_due_remaining AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE;
4542: l_discount_taken_earned AR_PAYMENT_SCHEDULES.discount_taken_earned%TYPE;
4543: l_discount_taken_unearned AR_PAYMENT_SCHEDULES.discount_taken_unearned%TYPE;
4544: l_cash_receipt_id AR_CASH_RECEIPTS.cash_receipt_id%TYPE;
4545:
4546: ln_earned_disc_pct NUMBER;
4547: ln_best_disc_pct NUMBER;