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.FUN_NET_ARAP_PKG dependencies on AR_PAYMENT_SCHEDULES

Line 32: amt_remaining ar_payment_schedules.amount_due_remaining%TYPE,

28: TYPE txnRecType IS RECORD
29: (
30: customer_trx_id ra_customer_trx.customer_trx_id%TYPE,
31: exchange_rate ra_customer_trx.exchange_rate%TYPE,
32: amt_remaining ar_payment_schedules.amount_due_remaining%TYPE,
33: txn_amt fun_net_ar_txns.transaction_amt%TYPE,
34: open_amt fun_net_ar_txns.open_amt%TYPE,
35: txn_curr_open_amt fun_net_ar_txns.txn_curr_open_amt%TYPE,
36: txn_curr_amt ra_customer_trx_lines.extended_amount%TYPE,

Line 268: l_sql_stmt:='SELECT PAYMENT_SCHEDULE_ID,AMOUNT_DUE_REMAINING FROM ar_payment_schedules_all WHERE CUSTOMER_TRX_ID=:v_cst_trx_id';

264: IF(l_net_currency_rule_code = 'ACCOUNTING_CURRENCY') THEN
265: l_amt_to_net := Derive_Conv_Amt(p_batch_id, p_cust_txn_id, l_amt_to_net, 'AR');
266: fun_net_util.Log_String(g_state_level,l_path,'After conversion :'|| l_amt_to_net);
267: END IF;
268: l_sql_stmt:='SELECT PAYMENT_SCHEDULE_ID,AMOUNT_DUE_REMAINING FROM ar_payment_schedules_all WHERE CUSTOMER_TRX_ID=:v_cst_trx_id';
269: l_applieddisc:=0;
270: OPEN pmt_rec FOR l_sql_stmt USING p_cust_txn_id;
271: FETCH pmt_rec BULK COLLECT INTO l_pmtno,l_amt_remaining;
272: FOR j IN 1..l_pmtno.COUNT

Line 503: ar_payment_schedules_all arps,

499: END IF;
500: fun_net_util.Log_String(g_state_level,l_path,'SELECT : '||l_trx_select_clause);
501: l_trx_from_clause :=
502: ' FROM ra_customer_trx_all rct,
503: ar_payment_schedules_all arps,
504: ra_cust_trx_types_all rctt,
505: fun_net_customers_all fnc ';
506: fun_net_util.Log_String(g_state_level,l_path,'FROM : '||l_trx_from_clause);
507: -- Build the WHERE clause --

Line 1744: l_sql_stmt:='SELECT PAYMENT_SCHEDULE_ID,AMOUNT_DUE_REMAINING FROM ar_payment_schedules_all WHERE CUSTOMER_TRX_ID=:v_cst_trx_id';

1740: END LOOP;
1741: ELSE
1742: fun_net_util.Log_String(g_state_level,l_path,'Inside ELSE condition');
1743: MO_GLOBAL.SET_POLICY_CONTEXT('S',g_batch_details.org_id);
1744: l_sql_stmt:='SELECT PAYMENT_SCHEDULE_ID,AMOUNT_DUE_REMAINING FROM ar_payment_schedules_all WHERE CUSTOMER_TRX_ID=:v_cst_trx_id';
1745: l_applieddisc(i):=0;
1746: OPEN pmt_rec FOR l_sql_stmt USING l_trx_id(i);
1747: FETCH pmt_rec BULK COLLECT INTO l_pmtno,l_amt_remaining;
1748: fun_net_util.Log_String(g_state_level,l_path,'l_pmtno.COUNT = ' || l_pmtno.COUNT);

Line 3555: l_amount ar_payment_schedules.amount_due_remaining%TYPE;

3551: p_inv_currency_code IN ra_customer_trx.invoice_currency_code%TYPE,
3552: p_exchange_rate IN ra_customer_trx.exchange_rate%TYPE)
3553: RETURN NUMBER
3554: IS
3555: l_amount ar_payment_schedules.amount_due_remaining%TYPE;
3556: BEGIN
3557: SELECT SUM(decode(p_inv_currency_code,
3558: g_batch_details.batch_currency,
3559: amount_due_remaining,

Line 3562: FROM AR_PAYMENT_SCHEDULES

3558: g_batch_details.batch_currency,
3559: amount_due_remaining,
3560: p_exchange_rate * amount_due_remaining))
3561: INTO l_amount
3562: FROM AR_PAYMENT_SCHEDULES
3563: WHERE due_date <= g_batch_details.transaction_due_date
3564: AND status = 'OP'
3565: AND customer_trx_id = p_customer_trx_id;
3566: RETURN l_amount;

Line 3599: AR_PAYMENT_SCHEDULES ARPS,

3595: arm.payment_type_code AS payment_type_code
3596: FROM FUN_NET_AR_TXNS ftxn,
3597: RA_CUSTOMER_TRX trx,
3598: RA_CUSTOMER_TRX_LINES trx_line,
3599: AR_PAYMENT_SCHEDULES ARPS,
3600: AR_RECEIPT_METHODS arm
3601: WHERE ftxn.customer_trx_id = trx.customer_trx_id
3602: AND trx.customer_trx_id = trx_line.customer_trx_id
3603: AND ARPS.customer_Trx_id = trx.customer_Trx_id

Line 3651: AR_PAYMENT_SCHEDULES ARPS,

3647: arm.payment_type_code AS payment_type_code
3648: BULK COLLECT INTO txnTable
3649: FROM FUN_NET_AR_TXNS ftxn,
3650: RA_CUSTOMER_TRX trx,
3651: AR_PAYMENT_SCHEDULES ARPS,
3652: AR_RECEIPT_METHODS arm,
3653: RA_CUST_TRX_TYPES ctype
3654: WHERE ftxn.customer_trx_id = trx.customer_trx_id
3655: AND ARPS.customer_Trx_id = trx.customer_Trx_id

Line 3700: AR_PAYMENT_SCHEDULES ARPS,

3696: arm.payment_type_code AS payment_type_code
3697: BULK COLLECT INTO txnTable
3698: FROM FUN_NET_AR_TXNS ftxn,
3699: RA_CUSTOMER_TRX trx,
3700: AR_PAYMENT_SCHEDULES ARPS,
3701: AR_RECEIPT_METHODS arm,
3702: RA_CUST_TRX_TYPES ctype
3703: WHERE ftxn.customer_trx_id = trx.customer_trx_id
3704: AND ARPS.customer_Trx_id = trx.customer_Trx_id

Line 3874: current_amt_due AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE;

3870: IS
3871: l_applied_amt ra_customer_trx_lines.extended_amount%TYPE;
3872: l_open_amt ra_customer_trx_lines.extended_amount%TYPE;
3873: l_line_amt ra_customer_trx_lines.extended_amount%TYPE;
3874: current_amt_due AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE;
3875: l_applied_from ra_customer_trx_lines.extended_amount%TYPE;
3876: l_exchange_rate ra_customer_trx_lines.extended_amount%TYPE;
3877: l_return_status VARCHAR2(1);
3878: l_exchange_rate_type varchar2(20);

Line 3889: ar_payment_schedules ps

3885: trx_line.extended_amount AS extended_amount,
3886: ps.payment_schedule_id AS pymt_schedule_id
3887: FROM fun_net_ar_txns ftxn,
3888: ra_customer_trx_lines trx_line,
3889: ar_payment_schedules ps
3890: WHERE ftxn.batch_id = g_batch_details.batch_id
3891: AND ftxn.customer_trx_id = p_cust_trx_id
3892: AND trx_line.customer_trx_id = ftxn.customer_trx_id
3893: AND trx_line.line_type = 'LINE'

Line 3905: FROM ar_payment_schedules ps

3901: --Check if Amount due remaining has changed since it was validated ,as txns
3902: --are not locked. If so raise an error
3903: SELECT SUM(amount_due_remaining)
3904: INTO current_amt_due
3905: FROM ar_payment_schedules ps
3906: WHERE customer_trx_id = txnTable(i).customer_Trx_id
3907: AND due_date <= g_batch_details.TRANSACTION_DUE_DATE
3908: AND due_date between g_agr_start_date and g_agr_end_date
3909: AND ps.status = 'OP';

Line 3979: current_amt_due AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE;

3975: l_applied_line_amt ra_customer_trx_lines.extended_amount%TYPE;
3976: l_tax_amount ra_customer_trx_lines.extended_amount%TYPE;
3977: l_open_amt ra_customer_trx_lines.extended_amount%TYPE;
3978: l_running_amt ra_customer_trx_lines.extended_amount%TYPE;
3979: current_amt_due AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE;
3980: l_applied_from ra_customer_trx_lines.extended_amount%TYPE;
3981: l_exchange_rate fun_net_batches_all.exchange_rate%TYPE;
3982: l_original_amt ra_customer_trx_lines.extended_amount%TYPE;
3983: l_trans_to_func_rate fun_net_batches_all.exchange_rate%TYPE;

Line 4004: FROM ar_payment_schedules ps

4000: CURSOR apply_trx_cur(p_cust_trx_id IN NUMBER)
4001: IS
4002: SELECT ps.payment_schedule_id AS pymt_schedule_id,
4003: ps.amount_due_remaining AS amt_due_remain
4004: FROM ar_payment_schedules ps
4005: WHERE ps.customer_trx_id = p_cust_trx_id
4006: AND ( ( get_esd_flag(g_batch_details.batch_id)='Y' AND ps.terms_sequence_number in (
4007: select rtd.sequence_num
4008: FROM ra_terms_lines_discounts rtd

Line 4042: FROM ar_payment_schedules_all ps

4038: -- as txns are not locked. If so raise an error
4039: IF get_esd_flag(g_batch_details.batch_id)='Y' THEN
4040: SELECT SUM(amount_due_remaining)
4041: INTO current_amt_due
4042: FROM ar_payment_schedules_all ps
4043: WHERE customer_trx_id = txnTable(i).customer_Trx_id
4044: AND due_date between g_agr_start_date and g_agr_end_date
4045: AND ps.status = 'OP'
4046: AND ( ps.terms_sequence_number in (

Line 4057: FROM ar_payment_schedules_all ps

4053: AND ((g_sel_past_due_flag='N') OR (g_sel_past_due_flag='Y' AND TRUNC(ps.due_date) + nvl(g_days_past_due,0) < trunc(sysdate) )); -- Added for Bug No : 8497191
4054: ELSE
4055: SELECT SUM(amount_due_remaining)
4056: INTO current_amt_due
4057: FROM ar_payment_schedules_all ps
4058: WHERE customer_trx_id = txnTable(i).customer_Trx_id
4059: AND due_date between g_agr_start_date and g_agr_end_date
4060: AND ps.status = 'OP'
4061: AND due_date <= g_batch_details.TRANSACTION_DUE_DATE;

Line 4065: FROM AR_PAYMENT_SCHEDULES APS

4061: AND due_date <= g_batch_details.TRANSACTION_DUE_DATE;
4062: END IF;
4063: SELECT sum(APS.amount_due_original)
4064: INTO l_original_amt
4065: FROM AR_PAYMENT_SCHEDULES APS
4066: WHERE APS.customer_Trx_id = txnTable(i).customer_Trx_id;
4067: l_open_amt := txnTable(i).txn_curr_open_amt;
4068: IF l_open_amt <> current_amt_due THEN
4069: x_return_status := FND_API.G_FALSE;

Line 4227: Select distinct Class into l_class from ar_payment_schedules_all where customer_trx_id = txnTable(i).customer_trx_id;

4223: WHERE ct.customer_trx_id = txnTable(i).customer_trx_id AND
4224: ct.batch_Source_id = bs.batch_source_id AND
4225: NVL(gen_line_level_bal_flag,'Y') = 'Y';
4226: fun_net_util.Log_String(g_event_level,l_path,'After calling select for count l_line_or_header = ' || l_line_or_header);
4227: Select distinct Class into l_class from ar_payment_schedules_all where customer_trx_id = txnTable(i).customer_trx_id;
4228: IF l_line_or_header >= 1 and pymt_schedule_count=1 and (l_class = 'INV' OR l_class = 'DM')THEN
4229: --6179308. Call Apply_In_Detail for invoices and Debitmemo, otherwise call Apply API.
4230: fun_net_util.Log_String(g_event_level,l_path,'Inside main iF');
4231: fun_net_util.Log_String(g_event_level,l_path,'Calling APPLY IN DETAIL');

Line 4464: AR_PAYMENT_SCHEDULES ARPS,

4460: arm.payment_type_code AS payment_type_code
4461: BULK COLLECT INTO txnTable2
4462: FROM FUN_NET_AR_TXNS ftxn,
4463: RA_CUSTOMER_TRX trx,
4464: AR_PAYMENT_SCHEDULES ARPS,
4465: AR_RECEIPT_METHODS arm,
4466: RA_CUST_TRX_TYPES ctype
4467: WHERE ftxn.customer_trx_id = trx.customer_trx_id
4468: AND ARPS.customer_Trx_id = trx.customer_Trx_id

Line 4513: AR_PAYMENT_SCHEDULES ARPS,

4509: arm.payment_type_code AS payment_type_code
4510: BULK COLLECT INTO txnTable2
4511: FROM FUN_NET_AR_TXNS ftxn,
4512: RA_CUSTOMER_TRX trx,
4513: AR_PAYMENT_SCHEDULES ARPS,
4514: AR_RECEIPT_METHODS arm,
4515: RA_CUST_TRX_TYPES ctype
4516: WHERE ftxn.customer_trx_id = trx.customer_trx_id
4517: AND ARPS.customer_Trx_id = trx.customer_Trx_id