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_FUNDING_WF dependencies on OKL_TRX_AP_INVOICES_B

Line 135: p_funding_status IN OKL_TRX_AP_INVOICES_B.TRX_STATUS_CODE%TYPE,

131: p_init_msg_list IN VARCHAR2,
132: x_return_status OUT NOCOPY VARCHAR2,
133: x_msg_count OUT NOCOPY NUMBER,
134: x_msg_data OUT NOCOPY VARCHAR2,
135: p_funding_status IN OKL_TRX_AP_INVOICES_B.TRX_STATUS_CODE%TYPE,
136: p_funding_id IN OKL_TRX_AP_INVOICES_B.ID%TYPE) IS
137:
138: l_tapv_rec tapv_rec_type;
139: x_tapv_rec tapv_rec_type;

Line 136: p_funding_id IN OKL_TRX_AP_INVOICES_B.ID%TYPE) IS

132: x_return_status OUT NOCOPY VARCHAR2,
133: x_msg_count OUT NOCOPY NUMBER,
134: x_msg_data OUT NOCOPY VARCHAR2,
135: p_funding_status IN OKL_TRX_AP_INVOICES_B.TRX_STATUS_CODE%TYPE,
136: p_funding_id IN OKL_TRX_AP_INVOICES_B.ID%TYPE) IS
137:
138: l_tapv_rec tapv_rec_type;
139: x_tapv_rec tapv_rec_type;
140: l_api_name CONSTANT VARCHAR2(30) := 'LOCAL_STATUS';

Line 145: CURSOR c_tap (p_funding_id OKL_TRX_AP_INVOICES_B.ID%TYPE)

141:
142: funding_line_id number;
143:
144: -- Fix BPD Bug. these columns will be overridden by tapi
145: CURSOR c_tap (p_funding_id OKL_TRX_AP_INVOICES_B.ID%TYPE)
146: IS
147: SELECT h.VENDOR_INVOICE_NUMBER,
148: h.PAY_GROUP_LOOKUP_CODE,
149: h.NETTABLE_YN,

Line 154: FROM OKL_TRX_AP_INVOICES_B h

150: h.FUNDING_TYPE_CODE,
151: h.INVOICE_TYPE,
152: --Bug# 5690875
153: h.KHR_ID
154: FROM OKL_TRX_AP_INVOICES_B h
155: WHERE h.id = p_funding_id
156: ;
157:
158: r_tap c_tap%ROWTYPE;

Line 372: p_funding_id IN OKL_TRX_AP_INVOICES_B.ID%TYPE)

368: p_init_msg_list IN VARCHAR2,
369: x_return_status OUT NOCOPY VARCHAR2,
370: x_msg_count OUT NOCOPY NUMBER,
371: x_msg_data OUT NOCOPY VARCHAR2,
372: p_funding_id IN OKL_TRX_AP_INVOICES_B.ID%TYPE)
373: IS
374:
375: CURSOR c_fetch_funding_number(p_funding_id OKL_TRX_AP_INVOICES_B.ID%TYPE)
376: IS

Line 375: CURSOR c_fetch_funding_number(p_funding_id OKL_TRX_AP_INVOICES_B.ID%TYPE)

371: x_msg_data OUT NOCOPY VARCHAR2,
372: p_funding_id IN OKL_TRX_AP_INVOICES_B.ID%TYPE)
373: IS
374:
375: CURSOR c_fetch_funding_number(p_funding_id OKL_TRX_AP_INVOICES_B.ID%TYPE)
376: IS
377: SELECT tap.vendor_invoice_number
378: FROM okl_trx_ap_invoices_b tap
379: WHERE tap.id = p_funding_id;

Line 378: FROM okl_trx_ap_invoices_b tap

374:
375: CURSOR c_fetch_funding_number(p_funding_id OKL_TRX_AP_INVOICES_B.ID%TYPE)
376: IS
377: SELECT tap.vendor_invoice_number
378: FROM okl_trx_ap_invoices_b tap
379: WHERE tap.id = p_funding_id;
380:
381: --Added by dpsingh for LE uptake
382: -- sjalasut, modified the cursor to include okl_txl_ap_inv_lns_all_b as khr_id

Line 384: CURSOR contract_num_csr (p_funding_id OKL_TRX_AP_INVOICES_B.ID%TYPE) IS

380:
381: --Added by dpsingh for LE uptake
382: -- sjalasut, modified the cursor to include okl_txl_ap_inv_lns_all_b as khr_id
383: -- now resides in this table. changes made as part of OKLR12B disbursements project
384: CURSOR contract_num_csr (p_funding_id OKL_TRX_AP_INVOICES_B.ID%TYPE) IS
385: SELECT con.contract_number,con.id
386: FROM OKL_TRX_AP_INVOICES_B ap_inv
387: ,OKC_K_HEADERS_B con
388: ,okl_txl_ap_inv_lns_all_b tpl

Line 386: FROM OKL_TRX_AP_INVOICES_B ap_inv

382: -- sjalasut, modified the cursor to include okl_txl_ap_inv_lns_all_b as khr_id
383: -- now resides in this table. changes made as part of OKLR12B disbursements project
384: CURSOR contract_num_csr (p_funding_id OKL_TRX_AP_INVOICES_B.ID%TYPE) IS
385: SELECT con.contract_number,con.id
386: FROM OKL_TRX_AP_INVOICES_B ap_inv
387: ,OKC_K_HEADERS_B con
388: ,okl_txl_ap_inv_lns_all_b tpl
389: WHERE ap_inv.id = tpl.tap_id
390: AND tpl.khr_id = con.id

Line 440: l_invoice_number OKL_TRX_AP_INVOICES_B.VENDOR_INVOICE_NUMBER%TYPE;

436: l_application_id FND_APPLICATION.APPLICATION_ID%TYPE;
437: l_trans_appl_id AME_CALLING_APPS.APPLICATION_ID%TYPE;
438: l_trans_type_id AME_CALLING_APPS.TRANSACTION_TYPE_ID%TYPE;
439:
440: l_invoice_number OKL_TRX_AP_INVOICES_B.VENDOR_INVOICE_NUMBER%TYPE;
441: l_sts_code OKC_K_HEADERS_V.STS_CODE%TYPE;
442:
443: l_requester VARCHAR2(200);
444: l_name VARCHAR2(200);

Line 542: p_token1_value => 'OKL_TRX_AP_INVOICES_B.VENDOR_INVOICE_NUMBER');

538: IF c_fetch_funding_number%NOTFOUND THEN
539: OKL_API.set_message(p_app_name => G_APP_NAME,
540: p_msg_name => G_NO_MATCHING_RECORD,
541: p_token1 => G_COL_NAME_TOKEN,
542: p_token1_value => 'OKL_TRX_AP_INVOICES_B.VENDOR_INVOICE_NUMBER');
543: RAISE OKL_API.G_EXCEPTION_ERROR;
544: END IF;
545: CLOSE c_fetch_funding_number;
546:

Line 754: -- as references of khr_id is now moved to this table from okl_trx_ap_invoices_b

750: WHERE chrb.id = p_creditline_id
751: ;
752:
753: -- sjalasut, modified the cursor to include okl_txl_ap_inv_lns_all_b
754: -- as references of khr_id is now moved to this table from okl_trx_ap_invoices_b
755: -- changes made as part of OKLR12B disbursments project
756: CURSOR c_funding_req(p_funding_id OKL_TRX_AP_INVOICES_B.ID%TYPE)
757: IS
758: SELECT h.id,

Line 756: CURSOR c_funding_req(p_funding_id OKL_TRX_AP_INVOICES_B.ID%TYPE)

752:
753: -- sjalasut, modified the cursor to include okl_txl_ap_inv_lns_all_b
754: -- as references of khr_id is now moved to this table from okl_trx_ap_invoices_b
755: -- changes made as part of OKLR12B disbursments project
756: CURSOR c_funding_req(p_funding_id OKL_TRX_AP_INVOICES_B.ID%TYPE)
757: IS
758: SELECT h.id,
759: h.funding_type_code,
760: h.vendor_invoice_number fund_number,

Line 794: CURSOR l_okl_list_contents_csr(p_funding_id OKL_TRX_AP_INVOICES_B.ID%TYPE)

790: AND look2.LOOKUP_TYPE = 'OKL_FUNDING_TYPE'
791: AND h.id = p_funding_id;
792:
793: -- start: cklee 31-May-2005 okl.h Lease App IA Authoring
794: CURSOR l_okl_list_contents_csr(p_funding_id OKL_TRX_AP_INVOICES_B.ID%TYPE)
795: IS
796: SELECT KHR_ID,
797: TODO_ITEM_CODE,
798: TODO_ITEM_MEANING,

Line 1302: l_funding_number OKL_TRX_AP_INVOICES_B.vendor_invoice_number%TYPE;

1298:
1299: l_api_name VARCHAR2(200) := 'Get_Approver';
1300:
1301: l_user_id VARCHAR2(200);
1302: l_funding_number OKL_TRX_AP_INVOICES_B.vendor_invoice_number%TYPE;
1303:
1304: l_return_status VARCHAR2(1);
1305:
1306: BEGIN

Line 1375: l_funding_number okl_trx_ap_invoices_b.vendor_invoice_number%TYPE;

1371: l_parent_key VARCHAR2(240);
1372: l_parent_type VARCHAR2(240);
1373: l_result VARCHAR2(30);
1374: l_api_name VARCHAR2(30) := 'Set_Parent_Attributes';
1375: l_funding_number okl_trx_ap_invoices_b.vendor_invoice_number%TYPE;
1376:
1377: BEGIN
1378: SAVEPOINT set_atts;
1379: IF (funcmode = 'RUN') THEN

Line 1474: CURSOR c_get_org_id(p_funding_id IN okl_trx_ap_invoices_b.id%TYPE)

1470: AND representation_type = 'PRIMARY';
1471: --
1472:
1473: --For bug 8788410 - NIKSHAH: START
1474: CURSOR c_get_org_id(p_funding_id IN okl_trx_ap_invoices_b.id%TYPE)
1475: IS
1476: SELECT org_id
1477: FROM OKL_TRX_AP_INVS_ALL_B
1478: where ID = p_funding_id;

Line 1488: l_funding_id okl_trx_ap_invoices_b.id%TYPE;

1484: l_init_msg_list VARCHAR2(10) := OKL_API.G_FALSE;
1485: l_msg_data VARCHAR2(2000);
1486: l_api_name VARCHAR2(30) := 'update_approval_status';
1487:
1488: l_funding_id okl_trx_ap_invoices_b.id%TYPE;
1489: l_approved_yn VARCHAR2(30);
1490: l_trx_number VARCHAR2(100);
1491:
1492: l_trxH_in_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;

Line 1690: l_funding_number okl_trx_ap_invoices_b.vendor_invoice_number%TYPE;

1686: resultout OUT NOCOPY VARCHAR2 )
1687: IS
1688: l_approval_option VARCHAR2(5);
1689: l_funding_id VARCHAR2(240);
1690: l_funding_number okl_trx_ap_invoices_b.vendor_invoice_number%TYPE;
1691:
1692: l_api_name VARCHAR2(30) := 'check_approval_process';
1693: l_message VARCHAR2(4000);
1694:

Line 1811: l_funding_number okl_trx_ap_invoices_b.vendor_invoice_number%TYPE;

1807: l_process VARCHAR2(30) := G_APPROVAL_PROCESS_WF;
1808: l_item_type VARCHAR2(10) := G_ITEM_TYPE_WF;
1809:
1810: l_funding_id VARCHAR2(240);
1811: l_funding_number okl_trx_ap_invoices_b.vendor_invoice_number%TYPE;
1812: l_requester VARCHAR2(240);
1813: l_requester_id VARCHAR2(240);
1814:
1815: l_api_name VARCHAR2(30) := 'wf_Approval_Process';