APPS.FUN_NET_ARAP_PKG dependencies on AP_PAYMENT_SCHEDULES_ALL

Line 25: min_payment_num ap_payment_schedules_all.payment_num%TYPE,

21: g_idx BINARY_INTEGER;
22: -- TYPE txnCurType IS REF CURSOR;
23: TYPE pymt_sch_rec IS RECORD
24: (invoice_id ap_invoices_all.invoice_id%TYPE,
25: min_payment_num ap_payment_schedules_all.payment_num%TYPE,
26: max_payment_num ap_payment_schedules_all.payment_num%TYPE);
27: TYPE pymt_sch_tab IS TABLE OF pymt_sch_rec INDEX BY BINARY_INTEGER;
28: TYPE txnRecType IS RECORD
29: (

Line 26: max_payment_num ap_payment_schedules_all.payment_num%TYPE);

22: -- TYPE txnCurType IS REF CURSOR;
23: TYPE pymt_sch_rec IS RECORD
24: (invoice_id ap_invoices_all.invoice_id%TYPE,
25: min_payment_num ap_payment_schedules_all.payment_num%TYPE,
26: max_payment_num ap_payment_schedules_all.payment_num%TYPE);
27: TYPE pymt_sch_tab IS TABLE OF pymt_sch_rec INDEX BY BINARY_INTEGER;
28: TYPE txnRecType IS RECORD
29: (
30: customer_trx_id ra_customer_trx.customer_trx_id%TYPE,

Line 178: l_sql_stmt:='select PAYMENT_NUM,AMOUNT_REMAINING FROM ap_payment_schedules_all WHERE invoice_id=:v_invoice_id ';

174: l_invoice_currency_code AP_INVOICES_ALL.INVOICE_CURRENCY_CODE%TYPE;
175: l_path VARCHAR2(100);
176: BEGIN
177: l_path := g_path||'get_ap_discount';
178: l_sql_stmt:='select PAYMENT_NUM,AMOUNT_REMAINING FROM ap_payment_schedules_all WHERE invoice_id=:v_invoice_id ';
179: l_applieddisc := 0;
180: l_amt_to_net := p_amt_to_net;
181: fun_net_util.Log_String(g_state_level,l_path,'l_amt_to_net :'|| l_amt_to_net);
182: SELECT FNA.net_currency_rule_code, FNB.batch_currency, FNB.exchange_rate_type, FNB.settlement_date

Line 743: ap_payment_schedules_all aps';

739: /* Build the from clause */
740: l_inv_from_clause :=
741: ' FROM ap_invoices_all api,
742: fun_net_suppliers_all fns,
743: ap_payment_schedules_all aps';
744: fun_net_util.Log_String(g_state_level,l_path,'FROM : '||l_inv_from_clause);
745: /* Build where clause */
746: /* Do not select invoices that are on hold */
747: /* Select invoices that have been approved */

Line 1038: TYPE payment_num IS TABLE OF ap_payment_schedules_all.payment_num%TYPE INDEX BY BINARY_INTEGER;

1034: TYPE InvCurTyp IS REF CURSOR;
1035: inv_rec InvCurTyp;
1036: TYPE amt_type IS TABLE OF fun_net_batches_all.total_netted_amt%TYPE INDEX BY BINARY_INTEGER;
1037: TYPE trx_type IS TABLE OF fun_net_ar_txns_all.customer_trx_id%TYPE INDEX BY BINARY_INTEGER;
1038: TYPE payment_num IS TABLE OF ap_payment_schedules_all.payment_num%TYPE INDEX BY BINARY_INTEGER;
1039: TYPE inv_rank IS TABLE OF fun_net_ap_invs_all.ap_txn_rank%TYPE INDEX BY BINARY_INTEGER;
1040: TYPE exchange_rate IS TABLE OF ap_invoices_all.exchange_rate%TYPE INDEX BY BINARY_INTEGER;
1041: TYPE precision_tab IS TABLE OF fnd_currencies.precision%TYPE INDEX BY BINARY_INTEGER;
1042: --l_invoice_id fun_net_ap_invs_all.invoice_id%TYPE;

Line 1722: l_sql_stmt:='select PAYMENT_NUM,AMOUNT_REMAINING FROM ap_payment_schedules_all WHERE invoice_id=:v_invoice_id ';

1718: l_inv_curr_net_amt(i) := l_amt_to_net;
1719: END IF;
1720: /* PRORATING THE DISCOUNT FOR PARTIALLY NETTED TRANSACTIONS IN AP/AR */
1721: IF p_appln = 'AP' THEN
1722: l_sql_stmt:='select PAYMENT_NUM,AMOUNT_REMAINING FROM ap_payment_schedules_all WHERE invoice_id=:v_invoice_id ';
1723: l_applieddisc(i):=0;
1724: OPEN pmt_rec FOR l_sql_stmt USING l_trx_id(i);
1725: FETCH pmt_rec BULK COLLECT INTO l_pmtno,l_amt_remaining;
1726: FOR j IN 1..l_pmtno.COUNT

Line 3135: UPDATE AP_PAYMENT_SCHEDULES_ALL

3131: SELECT checkrun_id , org_id
3132: INTO l_checkrun_id , l_org_id
3133: FROM fun_net_batches_all
3134: WHERE batch_id = p_batch_id ;
3135: UPDATE AP_PAYMENT_SCHEDULES_ALL
3136: SET checkrun_id = NULL
3137: WHERE checkrun_id =l_checkrun_id
3138: AND org_id = l_org_id;
3139: IF SQL%FOUND THEN