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.

[Home] [Help]

APPS.OKL_FUNDING_PVT dependencies on OKL_TXL_AP_INV_LNS_B

Line 207: from OKL_TXL_AP_INV_LNS_B ast

203: -- assets request
204: cursor c_fund_asset(p_fund_id OKL_TRX_AP_INVOICES_B.ID%TYPE) is
205: select ast.KLE_ID,
206: ast.AMOUNT
207: from OKL_TXL_AP_INV_LNS_B ast
208: where ast.TAP_ID = p_fund_id;
209:
210:
211: r_khr c_khr%ROWTYPE;

Line 1201: p_fund_line_id IN OKL_TXL_AP_INV_LNS_B.ID%TYPE,

1197: --start:| 21-May-2007 cklee OKLR12B Accounting CR |
1198: p_fund_id IN OKL_TRX_AP_INVOICES_B.ID%TYPE ) IS --,
1199: /*
1200: -- cklee 11.5.10 subsidy
1201: p_fund_line_id IN OKL_TXL_AP_INV_LNS_B.ID%TYPE,
1202: p_subsidy_amt IN NUMBER,
1203: p_sty_id IN NUMBER) IS
1204: */
1205: --end:| 21-May-2007 cklee OKLR12B Accounting CR |

Line 1359: from okl_txl_ap_inv_lns_b txl

1355: -- get sty_id for manual_disb
1356: -- cklee 05/04/2004
1357: Cursor manu_disb( p_fund_id NUMBER) IS
1358: select id, sty_id
1359: from okl_txl_ap_inv_lns_b txl
1360: where txl.tap_id = p_fund_id;
1361:
1362: -- Multi Currency Compliance
1363: CURSOR l_curr_conv_csr( p_khr_id NUMBER ) IS

Line 1380: FROM okl_txl_ap_inv_lns_b tl

1376: --- vpanwar 21/02/2007 Added
1377: --- get the funding line amount based on funding_line_id
1378: CURSOR c_amount(p_fund_line_id NUMBER) IS
1379: SELECT nvl(tl.amount,0)
1380: FROM okl_txl_ap_inv_lns_b tl
1381: WHERE tl.id = p_fund_line_id;
1382: ---- vpanwar 21/02/2007 End
1383:
1384: --start:| 21-May-2007 cklee OKLR12B Accounting CR |

Line 2205: okl_txl_ap_inv_lns_b b

2201: CURSOR c_tot_expense_fund (p_contract_id NUMBER, p_vendor_site_id NUMBER)
2202: IS
2203: select nvl(sum(b.amount),0)
2204: from okl_trx_ap_invoices_b a,
2205: okl_txl_ap_inv_lns_b b
2206: where a.id = b.tap_id
2207: and a.trx_status_code in ('APPROVED', 'PROCESSED')
2208: and a.funding_type_code ='EXPENSE'
2209: and b.amount > 0 --?

Line 2251: okl_txl_ap_inv_lns_b b

2247: CURSOR c_tot_expense_fund (p_contract_id NUMBER)
2248: IS
2249: select nvl(sum(b.amount),0)
2250: from okl_trx_ap_invoices_b a,
2251: okl_txl_ap_inv_lns_b b
2252: where a.id = b.tap_id
2253: and a.trx_status_code in ('APPROVED', 'PROCESSED')
2254: and a.funding_type_code ='EXPENSE'
2255: and b.amount > 0 --?

Line 3233: okl_txl_ap_inv_lns_b b

3229: CURSOR c_curr (p_fund_id NUMBER)
3230: IS
3231: select nvl(sum(b.amount),0)
3232: from okl_trx_ap_invoices_b a,
3233: okl_txl_ap_inv_lns_b b
3234: where a.id = b.tap_id
3235: and b.tap_id = p_fund_id
3236: and a.trx_status_code IN ('ENTERED','SUBMITTED')
3237: ;

Line 5570: from OKL_TXL_AP_INV_LNS_B

5566: --- vpanwar 21/02/2007 Added
5567: --- to get all the funding lines for the funding header
5568: CURSOR funding_line_csr(p_fund_id number) IS
5569: Select id funding_line_id
5570: from OKL_TXL_AP_INV_LNS_B
5571: Where tap_id = p_fund_id;
5572: --- vpanwar 21/02/2007 End
5573:
5574: BEGIN

Line 5959: FROM OKL_TXL_AP_INV_LNS_B

5955:
5956: -- dcshanmu added - 23-Nov-2007 - bug # 6639928 - start
5957: CURSOR c_get_max_line_number(p_tap_id OKL_TRX_AP_INVOICES_B.ID%TYPE) IS
5958: SELECT MAX(LINE_NUMBER)
5959: FROM OKL_TXL_AP_INV_LNS_B
5960: WHERE TAP_ID = P_TAP_ID;
5961:
5962: l_max_line_number NUMBER := 0;
5963: -- dcshanmu added - 23-Nov-2007 - bug # 6639928 - start

Line 6330: from okl_txl_ap_inv_lns_b

6326: --- vpanwar added 28/02/2007 end
6327:
6328: cursor c_sty_id(p_tpl_id number) is
6329: select sty_id
6330: from okl_txl_ap_inv_lns_b
6331: where id = p_tpl_id
6332: ;
6333:
6334: -- smadhava - Bug#5200033 - Added - Start

Line 6552: from okl_txl_ap_inv_lns_b b

6548: where a.FUND_ID = p_fund_id
6549: and a.KLE_AMT > 0
6550: and NOT EXISTS
6551: (select 1
6552: from okl_txl_ap_inv_lns_b b
6553: where a.FUND_ID = b.tap_id
6554: and a.cle_id = b.kle_id)
6555: ;*/
6556: CURSOR c2 (p_fund_id NUMBER)

Line 6570: from okl_txl_ap_inv_lns_b c

6566: WHERE a.chr_id = b.khr_id
6567: AND b.ID = p_fund_id
6568: and NOT EXISTS
6569: (select 1
6570: from okl_txl_ap_inv_lns_b c
6571: where b.ID = c.tap_id
6572: and a.cle_id = c.kle_id)
6573: -- )
6574: --WHERE KLE_AMT > 0

Line 6826: from OKL_TXL_AP_INV_LNS_B

6822: --- vpanwar 21/02/2007 Added
6823: --- to get all the funding lines for the funding header
6824: CURSOR fund_line_csr(p_fund_id number) IS
6825: Select id funding_line_id
6826: from OKL_TXL_AP_INV_LNS_B
6827: Where tap_id = p_fund_id;
6828: --- vpanwar 21/02/2007 End
6829:
6830: BEGIN

Line 7603: okl_txl_ap_inv_lns_b tl

7599: CURSOR c (p_fund_id NUMBER)
7600: IS
7601: SELECT nvl(SUM(tl.amount),0)
7602: FROM okl_trx_ap_invoices_b th,
7603: okl_txl_ap_inv_lns_b tl
7604: WHERE tl.tap_id = th.id
7605: AND th.id = p_fund_id
7606: -- no need for this function. this is used for display at UI site only
7607: -- AND th.TRX_STATUS_CODE NOT IN ('CANCELED', 'ERROR', 'REJECTED')

Line 7710: FROM okl_txl_ap_inv_lns_b t

7706:
7707: CURSOR c (p_fund_id NUMBER, p_kle_id NUMBER)
7708: IS
7709: SELECT 'X'
7710: FROM okl_txl_ap_inv_lns_b t
7711: WHERE t.tap_id = p_fund_id
7712: AND t.kle_id = p_kle_id
7713: ;
7714:

Line 7720: FROM okl_txl_ap_inv_lns_b t

7716: IS
7717:
7718:
7719: SELECT 'X'
7720: FROM okl_txl_ap_inv_lns_b t
7721: WHERE t.tap_id = p_fund_id
7722: AND t.kle_id = p_kle_id
7723:
7724: AND t.id <> p_fund_line_id -- except itself

Line 8293: okl_txl_ap_inv_lns_b subln

8289: -- select nvl(sum(decode(sub.invoice_type, 'CREDIT', -subln.amount, subln.amount)),0)
8290: -- sjalasut, commented the above select as part of OKLR12B disbursements project
8291: select nvl(sum(subln.amount),0)
8292: from okl_trx_ap_invoices_b sub,
8293: okl_txl_ap_inv_lns_b subln
8294: where sub.id = subln.tap_id
8295: and sub.trx_status_code in ('APPROVED', 'PROCESSED')
8296: and sub.funding_type_code = G_MANUAL_DISB
8297: and subln.khr_id = p_contract_id;