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.OKL_PAY_INVOICES_CONS_PVT dependencies on OKL_TRX_AP_INVS_ALL_B

Line 1849: p_ipvs_id okl_trx_ap_invs_all_b.ipvs_id%type,

1845: --
1846: -- details cursor to get all invoice lines
1847: CURSOR c_invoice (
1848: p_vendor_id po_vendor_sites_all.vendor_id%type,
1849: p_ipvs_id okl_trx_ap_invs_all_b.ipvs_id%type,
1850: p_pay_group_lookup_code okl_trx_ap_invs_all_b.pay_group_lookup_code%type,
1851: p_payment_method_code okl_trx_ap_invs_all_b.payment_method_code%type,
1852: p_ippt_id okl_trx_ap_invs_all_b.ippt_id%type,
1853: p_set_of_books_id okl_trx_ap_invs_all_b.set_of_books_id%type,

Line 1850: p_pay_group_lookup_code okl_trx_ap_invs_all_b.pay_group_lookup_code%type,

1846: -- details cursor to get all invoice lines
1847: CURSOR c_invoice (
1848: p_vendor_id po_vendor_sites_all.vendor_id%type,
1849: p_ipvs_id okl_trx_ap_invs_all_b.ipvs_id%type,
1850: p_pay_group_lookup_code okl_trx_ap_invs_all_b.pay_group_lookup_code%type,
1851: p_payment_method_code okl_trx_ap_invs_all_b.payment_method_code%type,
1852: p_ippt_id okl_trx_ap_invs_all_b.ippt_id%type,
1853: p_set_of_books_id okl_trx_ap_invs_all_b.set_of_books_id%type,
1854: p_code_combination_id okl_trns_acc_dstrs.code_combination_id%type,

Line 1851: p_payment_method_code okl_trx_ap_invs_all_b.payment_method_code%type,

1847: CURSOR c_invoice (
1848: p_vendor_id po_vendor_sites_all.vendor_id%type,
1849: p_ipvs_id okl_trx_ap_invs_all_b.ipvs_id%type,
1850: p_pay_group_lookup_code okl_trx_ap_invs_all_b.pay_group_lookup_code%type,
1851: p_payment_method_code okl_trx_ap_invs_all_b.payment_method_code%type,
1852: p_ippt_id okl_trx_ap_invs_all_b.ippt_id%type,
1853: p_set_of_books_id okl_trx_ap_invs_all_b.set_of_books_id%type,
1854: p_code_combination_id okl_trns_acc_dstrs.code_combination_id%type,
1855: p_currency_code okl_trx_ap_invs_all_b.currency_code%type,

Line 1852: p_ippt_id okl_trx_ap_invs_all_b.ippt_id%type,

1848: p_vendor_id po_vendor_sites_all.vendor_id%type,
1849: p_ipvs_id okl_trx_ap_invs_all_b.ipvs_id%type,
1850: p_pay_group_lookup_code okl_trx_ap_invs_all_b.pay_group_lookup_code%type,
1851: p_payment_method_code okl_trx_ap_invs_all_b.payment_method_code%type,
1852: p_ippt_id okl_trx_ap_invs_all_b.ippt_id%type,
1853: p_set_of_books_id okl_trx_ap_invs_all_b.set_of_books_id%type,
1854: p_code_combination_id okl_trns_acc_dstrs.code_combination_id%type,
1855: p_currency_code okl_trx_ap_invs_all_b.currency_code%type,
1856: p_currency_conversion_type okl_trx_ap_invs_all_b.currency_conversion_type%type,

Line 1853: p_set_of_books_id okl_trx_ap_invs_all_b.set_of_books_id%type,

1849: p_ipvs_id okl_trx_ap_invs_all_b.ipvs_id%type,
1850: p_pay_group_lookup_code okl_trx_ap_invs_all_b.pay_group_lookup_code%type,
1851: p_payment_method_code okl_trx_ap_invs_all_b.payment_method_code%type,
1852: p_ippt_id okl_trx_ap_invs_all_b.ippt_id%type,
1853: p_set_of_books_id okl_trx_ap_invs_all_b.set_of_books_id%type,
1854: p_code_combination_id okl_trns_acc_dstrs.code_combination_id%type,
1855: p_currency_code okl_trx_ap_invs_all_b.currency_code%type,
1856: p_currency_conversion_type okl_trx_ap_invs_all_b.currency_conversion_type%type,
1857: p_currency_conversion_rate okl_trx_ap_invs_all_b.currency_conversion_rate%type,

Line 1855: p_currency_code okl_trx_ap_invs_all_b.currency_code%type,

1851: p_payment_method_code okl_trx_ap_invs_all_b.payment_method_code%type,
1852: p_ippt_id okl_trx_ap_invs_all_b.ippt_id%type,
1853: p_set_of_books_id okl_trx_ap_invs_all_b.set_of_books_id%type,
1854: p_code_combination_id okl_trns_acc_dstrs.code_combination_id%type,
1855: p_currency_code okl_trx_ap_invs_all_b.currency_code%type,
1856: p_currency_conversion_type okl_trx_ap_invs_all_b.currency_conversion_type%type,
1857: p_currency_conversion_rate okl_trx_ap_invs_all_b.currency_conversion_rate%type,
1858: p_currency_conversion_date date,
1859: p_legal_entity_id okl_trx_ap_invs_all_b.legal_entity_id%type,

Line 1856: p_currency_conversion_type okl_trx_ap_invs_all_b.currency_conversion_type%type,

1852: p_ippt_id okl_trx_ap_invs_all_b.ippt_id%type,
1853: p_set_of_books_id okl_trx_ap_invs_all_b.set_of_books_id%type,
1854: p_code_combination_id okl_trns_acc_dstrs.code_combination_id%type,
1855: p_currency_code okl_trx_ap_invs_all_b.currency_code%type,
1856: p_currency_conversion_type okl_trx_ap_invs_all_b.currency_conversion_type%type,
1857: p_currency_conversion_rate okl_trx_ap_invs_all_b.currency_conversion_rate%type,
1858: p_currency_conversion_date date,
1859: p_legal_entity_id okl_trx_ap_invs_all_b.legal_entity_id%type,
1860: p_vpa_id okl_trx_ap_invs_all_b.vpa_id%type,

Line 1857: p_currency_conversion_rate okl_trx_ap_invs_all_b.currency_conversion_rate%type,

1853: p_set_of_books_id okl_trx_ap_invs_all_b.set_of_books_id%type,
1854: p_code_combination_id okl_trns_acc_dstrs.code_combination_id%type,
1855: p_currency_code okl_trx_ap_invs_all_b.currency_code%type,
1856: p_currency_conversion_type okl_trx_ap_invs_all_b.currency_conversion_type%type,
1857: p_currency_conversion_rate okl_trx_ap_invs_all_b.currency_conversion_rate%type,
1858: p_currency_conversion_date date,
1859: p_legal_entity_id okl_trx_ap_invs_all_b.legal_entity_id%type,
1860: p_vpa_id okl_trx_ap_invs_all_b.vpa_id%type,
1861: p_invoice_type okl_trx_ap_invs_all_b.invoice_type%type,

Line 1859: p_legal_entity_id okl_trx_ap_invs_all_b.legal_entity_id%type,

1855: p_currency_code okl_trx_ap_invs_all_b.currency_code%type,
1856: p_currency_conversion_type okl_trx_ap_invs_all_b.currency_conversion_type%type,
1857: p_currency_conversion_rate okl_trx_ap_invs_all_b.currency_conversion_rate%type,
1858: p_currency_conversion_date date,
1859: p_legal_entity_id okl_trx_ap_invs_all_b.legal_entity_id%type,
1860: p_vpa_id okl_trx_ap_invs_all_b.vpa_id%type,
1861: p_invoice_type okl_trx_ap_invs_all_b.invoice_type%type,
1862: -- p_contract_group okc_k_headers_all_b.contract_number%type,
1863: p_disbursement_rule varchar2,

Line 1860: p_vpa_id okl_trx_ap_invs_all_b.vpa_id%type,

1856: p_currency_conversion_type okl_trx_ap_invs_all_b.currency_conversion_type%type,
1857: p_currency_conversion_rate okl_trx_ap_invs_all_b.currency_conversion_rate%type,
1858: p_currency_conversion_date date,
1859: p_legal_entity_id okl_trx_ap_invs_all_b.legal_entity_id%type,
1860: p_vpa_id okl_trx_ap_invs_all_b.vpa_id%type,
1861: p_invoice_type okl_trx_ap_invs_all_b.invoice_type%type,
1862: -- p_contract_group okc_k_headers_all_b.contract_number%type,
1863: p_disbursement_rule varchar2,
1864: p_disbursement_group varchar2,

Line 1861: p_invoice_type okl_trx_ap_invs_all_b.invoice_type%type,

1857: p_currency_conversion_rate okl_trx_ap_invs_all_b.currency_conversion_rate%type,
1858: p_currency_conversion_date date,
1859: p_legal_entity_id okl_trx_ap_invs_all_b.legal_entity_id%type,
1860: p_vpa_id okl_trx_ap_invs_all_b.vpa_id%type,
1861: p_invoice_type okl_trx_ap_invs_all_b.invoice_type%type,
1862: -- p_contract_group okc_k_headers_all_b.contract_number%type,
1863: p_disbursement_rule varchar2,
1864: p_disbursement_group varchar2,
1865: p_cin_date_invoiced date

Line 2262: UPDATE OKL_TRX_AP_INVS_ALL_B trx

2258: --------------------------------------------------------------------
2259: IF l_tplv_tbl.COUNT > 0 THEN
2260: FOR k in l_tplv_tbl.FIRST..l_tplv_tbl.LAST
2261: LOOP
2262: UPDATE OKL_TRX_AP_INVS_ALL_B trx
2263: SET trx.TRX_STATUS_CODE = 'PROCESSED',
2264: trx.REQUEST_ID = Fnd_Global.CONC_REQUEST_ID -- 11-Dec-2007 cklee -- Fixed bug: 6682348 -- stamped request_id when insert/UPDATE
2265: WHERE trx.ID = l_tplv_tbl(k).tap_id
2266: AND trx.TRX_STATUS_CODE IN ('ENTERED', 'APPROVED');

Line 2267: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' UPDATE OKL_TRX_AP_INVS_ALL_B with Processed status.l_tplv_tbl('

2263: SET trx.TRX_STATUS_CODE = 'PROCESSED',
2264: trx.REQUEST_ID = Fnd_Global.CONC_REQUEST_ID -- 11-Dec-2007 cklee -- Fixed bug: 6682348 -- stamped request_id when insert/UPDATE
2265: WHERE trx.ID = l_tplv_tbl(k).tap_id
2266: AND trx.TRX_STATUS_CODE IN ('ENTERED', 'APPROVED');
2267: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' UPDATE OKL_TRX_AP_INVS_ALL_B with Processed status.l_tplv_tbl('
2268: ||k||').tap_id'|| l_tplv_tbl(k).tap_id);
2269:
2270: END LOOP;
2271: END IF;

Line 2280: UPDATE OKL_TRX_AP_INVS_ALL_B trx

2276: IF l_tplv_tbl.COUNT > 0 THEN
2277: FOR j in l_tplv_tbl.FIRST..l_tplv_tbl.LAST
2278: LOOP
2279:
2280: UPDATE OKL_TRX_AP_INVS_ALL_B trx
2281: SET trx.TRX_STATUS_CODE = 'ERROR',
2282: trx.REQUEST_ID = Fnd_Global.CONC_REQUEST_ID -- 11-Dec-2007 cklee -- Fixed bug: 6682348 -- stamped request_id when insert/UPDATE
2283: WHERE trx.ID = l_tplv_tbl(j).tap_id
2284: AND trx.TRX_STATUS_CODE IN ('ENTERED', 'APPROVED');

Line 2285: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' UPDATE OKL_TRX_AP_INVS_ALL_B with Error status.l_tplv_tbl(' ||j||').tap_id'|| l_tplv_tbl(j).tap_id);

2281: SET trx.TRX_STATUS_CODE = 'ERROR',
2282: trx.REQUEST_ID = Fnd_Global.CONC_REQUEST_ID -- 11-Dec-2007 cklee -- Fixed bug: 6682348 -- stamped request_id when insert/UPDATE
2283: WHERE trx.ID = l_tplv_tbl(j).tap_id
2284: AND trx.TRX_STATUS_CODE IN ('ENTERED', 'APPROVED');
2285: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' UPDATE OKL_TRX_AP_INVS_ALL_B with Error status.l_tplv_tbl(' ||j||').tap_id'|| l_tplv_tbl(j).tap_id);
2286:
2287: END LOOP;
2288: END IF;
2289: END;

Line 2364: FROM OKL_TRX_AP_INVS_ALL_B TAP

2360: /*
2361: -- find existing 'no further processing" flag
2362: CURSOR c_no_adv_grp(p_cnsld_ap_invs_id okl_cnsld_ap_invs_all.cnsld_ap_inv_id%type) IS
2363: SELECT 1
2364: FROM OKL_TRX_AP_INVS_ALL_B TAP
2365: where NVL(TAP.ADV_GROUPING_FLAG, 'Y') = 'N'
2366: and tap.id in
2367: (select txl.tap_id
2368: from okl_txl_ap_invs_all_b txl,

Line 4525: UPDATE OKL_TRX_AP_INVS_ALL_B

4521:
4522: For j in l_tplv_tbl.FIRST..l_tplv_tbl.LAST
4523: LOOP
4524:
4525: UPDATE OKL_TRX_AP_INVS_ALL_B
4526: SET TRX_STATUS_CODE = 'PROCESSED'
4527: WHERE ID = l_tplv_tbl(j).tap_id;
4528:
4529: END LOOP;

Line 4537: UPDATE OKL_TRX_AP_INVS_ALL_B

4533:
4534: For j in l_tplv_tbl.FIRST..l_tplv_tbl.LAST
4535: LOOP
4536:
4537: UPDATE OKL_TRX_AP_INVS_ALL_B
4538: SET TRX_STATUS_CODE = 'ERROR'
4539: WHERE ID = l_tplv_tbl(j).tap_id;
4540:
4541: END LOOP;