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_CONTRACT_PVT dependencies on OKC_K_LINES_B

Line 275: okc_k_lines_b cle

271: --Cursor to check if the contract is booked
272: Cursor Chr_sts_crs(p_cle_id IN Number) IS
273: SELECT chr.sts_code
274: FROM okc_k_headers_b chr,
275: okc_k_lines_b cle
276: WHERE chr.ID = cle.dnz_chr_id
277: AND cle.ID = p_cle_id;
278:
279: l_sts_code OKC_K_HEADERS_B.STS_CODE%TYPE;

Line 286: okc_k_lines_b cle

282: Cursor Ever_Booked_crs(p_cle_id IN Number) is
283: SELECT 'Y'
284: FROM okc_k_headers_bh chrh,
285: okc_k_headers_b chr,
286: okc_k_lines_b cle
287: WHERE chrh.contract_number = chr.contract_number
288: AND chr.ID = cle.dnz_chr_id
289: AND chrh.sts_code = G_OKL_BOOKED_STS_CODE
290: AND cle.ID = p_cle_id

Line 325: okc_k_lines_b cleb,

321: Cursor l_rbk_asst_csr(p_cle_id IN NUMBER) is
322: Select 'Y' rbk_asst_flag,
323: clet.NAME
324: from okc_k_lines_tl clet,
325: okc_k_lines_b cleb,
326: okc_line_styles_b lseb,
327: okc_k_headers_b chrb
328: where chrb.id = cleb.dnz_chr_id
329: and chrb.scs_code = 'LEASE'

Line 339: okc_k_lines_b orig_cleb

335: and cleb.id = p_cle_id
336: and cleb.orig_system_id1 is not NULL
337: and exists (select '1'
338: from okc_k_headers_b orig_chrb,
339: okc_k_lines_b orig_cleb
340: where orig_chrb.id = chrb.orig_system_id1
341: and orig_cleb.id = cleb.orig_system_id1
342: --Bug# 4375800 :
343: and orig_cleb.sts_code <> 'ABANDONED'

Line 904: from okc_k_lines_b kleb,

900:
901: CURSOR c_okx_asset_lines_v(p_asset_number OKX_ASSETS_V.ASSET_NUMBER%TYPE) is
902: --start modified abhsaxen for performance SQLID 20562304
903: select 'Y'
904: from okc_k_lines_b kleb,
905: okc_k_lines_tl kle,
906: okc_line_styles_b lse
907: where kle.name = p_asset_number
908: and kle.id = kleb.id

Line 932: CURSOR l_is_finasst (p_line_id OKC_K_LINES_B.ID%TYPE) IS

928:
929: l_asset_exists Varchar2(1) default 'N';
930:
931: --cursor to check if line is financial asset top line
932: CURSOR l_is_finasst (p_line_id OKC_K_LINES_B.ID%TYPE) IS
933: Select 'Y'
934: From Dual
935: Where exists (select '1'
936: from okc_k_lines_b cle,

Line 936: from okc_k_lines_b cle,

932: CURSOR l_is_finasst (p_line_id OKC_K_LINES_B.ID%TYPE) IS
933: Select 'Y'
934: From Dual
935: Where exists (select '1'
936: from okc_k_lines_b cle,
937: okc_line_styles_b lse
938: where cle.lse_id = lse.id
939: and lse.lty_code = 'FREE_FORM1'
940: and cle.id = p_line_id);

Line 953: OKC_K_LINES_B cle,

949: CURSOR l_txlv_csr (p_finasst_id IN NUMBER, P_Asstno IN VARCHAR2) is
950: Select txlv.id,
951: txlv.asset_number
952: From OKL_TXL_ASSETS_V txlv,
953: OKC_K_LINES_B cle,
954: OKC_LINE_STYLES_B lse
955: Where txlv.kle_id = cle.id
956: And cle.lse_id = lse.id
957: And lse.lty_code = 'FIXED_ASSET'

Line 970: OKC_K_LINES_B cle,

966: Select txdv.id,
967: txdv.asset_number
968: From OKL_TXD_ASSETS_V txdv,
969: OKL_TXL_ASSETS_V txlv,
970: OKC_K_LINES_B cle,
971: OKC_LINE_STYLES_B lse
972: Where txdv.tal_id = txlv.id
973: And txlv.kle_id = cle.id
974: And cle.lse_id = lse.id

Line 1178: CURSOR l_is_finasst (p_line_id OKC_K_LINES_B.ID%TYPE) IS

1174: p_cle_id IN NUMBER,
1175: p_deletion_type IN VARCHAR2) IS
1176:
1177: --cursor to check if line is financial asset top line
1178: CURSOR l_is_finasst (p_line_id OKC_K_LINES_B.ID%TYPE) IS
1179: Select 'Y'
1180: From Dual
1181: Where exists (select '1'
1182: from okc_k_lines_b cle,

Line 1182: from okc_k_lines_b cle,

1178: CURSOR l_is_finasst (p_line_id OKC_K_LINES_B.ID%TYPE) IS
1179: Select 'Y'
1180: From Dual
1181: Where exists (select '1'
1182: from okc_k_lines_b cle,
1183: okc_line_styles_b lse
1184: where cle.lse_id = lse.id
1185: and lse.lty_code = 'FREE_FORM1'
1186: and cle.id = p_line_id);

Line 1192: CURSOR l_lnk_ast_csr (p_line_id OKC_K_LINES_B.ID%TYPE) IS

1188: l_fin_asst Varchar2(1) default 'N';
1189: l_cle_id Number;
1190:
1191: --cursor to check if financial asset appears as linked asset
1192: CURSOR l_lnk_ast_csr (p_line_id OKC_K_LINES_B.ID%TYPE) IS
1193: Select lnk.id
1194: From okc_k_lines_b lnk,
1195: okc_line_styles_b lnk_lse,
1196: okc_statuses_b sts,

Line 1194: From okc_k_lines_b lnk,

1190:
1191: --cursor to check if financial asset appears as linked asset
1192: CURSOR l_lnk_ast_csr (p_line_id OKC_K_LINES_B.ID%TYPE) IS
1193: Select lnk.id
1194: From okc_k_lines_b lnk,
1195: okc_line_styles_b lnk_lse,
1196: okc_statuses_b sts,
1197: okc_k_items cim
1198: Where lnk.id = cim.cle_id

Line 1208: l_lnk_cle_id OKC_K_LINES_B.ID%TYPE;

1204: and cim.jtot_object1_code = 'OKX_COVASST'
1205: and cim.object1_id1 = to_char(p_line_id)
1206: and cim.object1_id2 = '#';
1207:
1208: l_lnk_cle_id OKC_K_LINES_B.ID%TYPE;
1209: l_clev_rec OKL_OKC_MIGRATION_PVT.clev_rec_type;
1210: l_clev_rec_out OKL_OKC_MIGRATION_PVT.clev_rec_type;
1211: l_deletion_type Varchar2(1);
1212:

Line 1363: from okc_k_lines_b cleb

1359: select cleb.start_date,
1360: cleb.end_date,
1361: cleb.currency_code,
1362: cleb.sts_code
1363: from okc_k_lines_b cleb
1364: where cleb.id = p_cle_id;
1365: l_cle_start_date date;
1366: l_cle_end_date date;
1367: l_cle_curr_code okc_k_lines_b.currency_code%TYPE;

Line 1367: l_cle_curr_code okc_k_lines_b.currency_code%TYPE;

1363: from okc_k_lines_b cleb
1364: where cleb.id = p_cle_id;
1365: l_cle_start_date date;
1366: l_cle_end_date date;
1367: l_cle_curr_code okc_k_lines_b.currency_code%TYPE;
1368: l_cle_sts_code okc_k_lines_b.sts_code%TYPE;
1369:
1370: --cursor to get line style
1371: cursor l_lse_csr (p_lse_id in number ) is

Line 1368: l_cle_sts_code okc_k_lines_b.sts_code%TYPE;

1364: where cleb.id = p_cle_id;
1365: l_cle_start_date date;
1366: l_cle_end_date date;
1367: l_cle_curr_code okc_k_lines_b.currency_code%TYPE;
1368: l_cle_sts_code okc_k_lines_b.sts_code%TYPE;
1369:
1370: --cursor to get line style
1371: cursor l_lse_csr (p_lse_id in number ) is
1372: select lseb.lty_code,

Line 1842: okc_k_lines_b cleb,

1838: p_chr_id in number) is
1839: select txdb.id
1840: from okl_txd_assets_b txdb,
1841: okl_txl_assets_b txlb,
1842: okc_k_lines_b cleb,
1843: okc_line_styles_b lseb
1844: where txdb.tax_book = p_book_type_code
1845: and txdb.tal_id = txlb.id
1846: and txlb.kle_id = cleb.id

Line 1856: okc_k_lines_b cleb,

1852: p_chr_id in number) is
1853: select txdb.id
1854: from okl_txd_assets_b txdb,
1855: okl_txl_assets_b txlb,
1856: okc_k_lines_b cleb,
1857: okc_line_styles_b lseb,
1858: okc_k_lines_b cleb_top,
1859: okl_k_lines kle_top
1860: where txdb.tax_book = p_book_type_code

Line 1858: okc_k_lines_b cleb_top,

1854: from okl_txd_assets_b txdb,
1855: okl_txl_assets_b txlb,
1856: okc_k_lines_b cleb,
1857: okc_line_styles_b lseb,
1858: okc_k_lines_b cleb_top,
1859: okl_k_lines kle_top
1860: where txdb.tax_book = p_book_type_code
1861: and txdb.tal_id = txlb.id
1862: and txlb.kle_id = cleb.id

Line 2979: From okc_k_lines_b cle,

2975: --Cursor to get top lines is lease chr has lines to change effectivity
2976: --bug 4412923: Removed the status 'CANCELLED' from the cursor
2977: Cursor top_cle_csr (p_chr_id IN NUMBER) is
2978: SELECT cle.id
2979: From okc_k_lines_b cle,
2980: okc_statuses_b sts
2981: where cle.dnz_chr_id = cle.chr_id
2982: and cle.chr_id = p_chr_id
2983: and sts.code = cle.sts_code

Line 2986: l_top_cle_id OKC_K_LINES_B.ID%TYPE;

2982: and cle.chr_id = p_chr_id
2983: and sts.code = cle.sts_code
2984: And sts.ste_code not in ('HOLD','EXPIRED','TERMINATED');
2985:
2986: l_top_cle_id OKC_K_LINES_B.ID%TYPE;
2987:
2988: --Cursor to check if lease chr has lines to change effectivity
2989: --bug 4412923: Removed the status 'CANCELLED' from the cursor
2990: Cursor cle_csr(p_cle_id IN NUMBER) is

Line 2997: From okc_k_lines_b cle

2993: cle.end_date,
2994: cle.orig_system_id1,
2995: --Bug#
2996: cle.lse_id
2997: From okc_k_lines_b cle
2998: connect by prior cle.id = cle.cle_id
2999: start with cle.id = p_cle_id
3000: and exists (select 1
3001: from okc_statuses_b sts

Line 3005: l_cle_id OKC_K_LINES_B.ID%TYPE;

3001: from okc_statuses_b sts
3002: where sts.code = cle.sts_code
3003: and sts.ste_code not in ('HOLD','EXPIRED','TERMINATED'));
3004:
3005: l_cle_id OKC_K_LINES_B.ID%TYPE;
3006: l_cle_start_date OKC_K_LINES_B.START_DATE%TYPE;
3007: l_cle_end_date OKC_K_LINES_B.END_DATE%TYPE;
3008: l_parent_cle_id OKC_K_LINES_B.orig_system_id1%TYPE;
3009: --Bug#

Line 3006: l_cle_start_date OKC_K_LINES_B.START_DATE%TYPE;

3002: where sts.code = cle.sts_code
3003: and sts.ste_code not in ('HOLD','EXPIRED','TERMINATED'));
3004:
3005: l_cle_id OKC_K_LINES_B.ID%TYPE;
3006: l_cle_start_date OKC_K_LINES_B.START_DATE%TYPE;
3007: l_cle_end_date OKC_K_LINES_B.END_DATE%TYPE;
3008: l_parent_cle_id OKC_K_LINES_B.orig_system_id1%TYPE;
3009: --Bug#
3010: l_lse_id OKC_K_LINES_B.lse_id%TYPE;

Line 3007: l_cle_end_date OKC_K_LINES_B.END_DATE%TYPE;

3003: and sts.ste_code not in ('HOLD','EXPIRED','TERMINATED'));
3004:
3005: l_cle_id OKC_K_LINES_B.ID%TYPE;
3006: l_cle_start_date OKC_K_LINES_B.START_DATE%TYPE;
3007: l_cle_end_date OKC_K_LINES_B.END_DATE%TYPE;
3008: l_parent_cle_id OKC_K_LINES_B.orig_system_id1%TYPE;
3009: --Bug#
3010: l_lse_id OKC_K_LINES_B.lse_id%TYPE;
3011:

Line 3008: l_parent_cle_id OKC_K_LINES_B.orig_system_id1%TYPE;

3004:
3005: l_cle_id OKC_K_LINES_B.ID%TYPE;
3006: l_cle_start_date OKC_K_LINES_B.START_DATE%TYPE;
3007: l_cle_end_date OKC_K_LINES_B.END_DATE%TYPE;
3008: l_parent_cle_id OKC_K_LINES_B.orig_system_id1%TYPE;
3009: --Bug#
3010: l_lse_id OKC_K_LINES_B.lse_id%TYPE;
3011:
3012:

Line 3010: l_lse_id OKC_K_LINES_B.lse_id%TYPE;

3006: l_cle_start_date OKC_K_LINES_B.START_DATE%TYPE;
3007: l_cle_end_date OKC_K_LINES_B.END_DATE%TYPE;
3008: l_parent_cle_id OKC_K_LINES_B.orig_system_id1%TYPE;
3009: --Bug#
3010: l_lse_id OKC_K_LINES_B.lse_id%TYPE;
3011:
3012:
3013: l_clev_rec OKL_OKC_MIGRATION_PVT.clev_rec_type;
3014: lx_clev_rec OKL_OKC_MIGRATION_PVT.clev_rec_type;

Line 3063: okc_k_lines_b cleb,

3059: p_chr_id in number) is
3060: select txdb.id
3061: from okl_txd_assets_b txdb,
3062: okl_txl_assets_b txlb,
3063: okc_k_lines_b cleb,
3064: okc_line_styles_b lseb
3065: where txdb.tax_book = p_book_type_code
3066: and txdb.tal_id = txlb.id
3067: and txlb.kle_id = cleb.id

Line 3096: From okc_k_lines_b cle

3092: Cursor parent_cle_csr (p_cle_id IN Number) is
3093: SELECT
3094: cle.start_date,
3095: cle.end_date
3096: From okc_k_lines_b cle
3097: Where cle.id = p_cle_id;
3098:
3099: l_parent_cle_start_date OKC_K_HEADERS_B.start_date%TYPE;
3100: l_parent_cle_end_date OKC_K_HEADERS_B.end_date%TYPE;

Line 3138: FROM OKC_K_LINES_B OKC,

3134: SELECT DISTINCT TAS_ID
3135: FROM OKL_TXL_ASSETS_B
3136: WHERE KLE_ID IN
3137: (SELECT OKC.ID
3138: FROM OKC_K_LINES_B OKC,
3139: OKC_LINE_STYLES_B OKC_ST
3140: WHERE OKC_ST.LTY_CODE ='FREE_FORM1'
3141: AND OKC.LSE_ID=OKC_ST.ID
3142: AND OKC.CHR_ID =OKC.DNZ_CHR_ID

Line 4368: CURSOR c_get_k_stream(p_khr_id OKC_K_LINES_B.DNZ_CHR_ID%TYPE) IS

4364: AND chr.id = p_id
4365: AND chrh.sts_code = G_OKL_BOOKED_STS_CODE
4366: AND rownum < 2;
4367:
4368: CURSOR c_get_k_stream(p_khr_id OKC_K_LINES_B.DNZ_CHR_ID%TYPE) IS
4369: SELECT id stm_id
4370: FROM OKL_STREAMS
4371: WHERE khr_id = p_khr_id;
4372:

Line 4373: CURSOR c_get_je_trans(p_khr_id OKC_K_LINES_B.DNZ_CHR_ID%TYPE) IS

4369: SELECT id stm_id
4370: FROM OKL_STREAMS
4371: WHERE khr_id = p_khr_id;
4372:
4373: CURSOR c_get_je_trans(p_khr_id OKC_K_LINES_B.DNZ_CHR_ID%TYPE) IS
4374: SELECT id trx_id
4375: FROM OKL_TRX_CONTRACTS
4376: WHERE khr_id = p_khr_id
4377: AND representation_type = 'PRIMARY';

Line 4379: CURSOR c_get_source_id(p_khr_id OKC_K_LINES_B.DNZ_CHR_ID%TYPE) IS

4375: FROM OKL_TRX_CONTRACTS
4376: WHERE khr_id = p_khr_id
4377: AND representation_type = 'PRIMARY';
4378:
4379: CURSOR c_get_source_id(p_khr_id OKC_K_LINES_B.DNZ_CHR_ID%TYPE) IS
4380: SELECT id
4381: FROM OKL_TXL_CNTRCT_LNS
4382: WHERE khr_id = p_khr_id;
4383:

Line 4384: CURSOR c_get_k_top_line(p_dnz_chr_id OKC_K_LINES_B.DNZ_CHR_ID%TYPE) IS

4380: SELECT id
4381: FROM OKL_TXL_CNTRCT_LNS
4382: WHERE khr_id = p_khr_id;
4383:
4384: CURSOR c_get_k_top_line(p_dnz_chr_id OKC_K_LINES_B.DNZ_CHR_ID%TYPE) IS
4385: SELECT cle.id top_line
4386: FROM okc_line_styles_b lse,
4387: okc_k_lines_b cle
4388: WHERE cle.dnz_chr_id = p_dnz_chr_id

Line 4387: okc_k_lines_b cle

4383:
4384: CURSOR c_get_k_top_line(p_dnz_chr_id OKC_K_LINES_B.DNZ_CHR_ID%TYPE) IS
4385: SELECT cle.id top_line
4386: FROM okc_line_styles_b lse,
4387: okc_k_lines_b cle
4388: WHERE cle.dnz_chr_id = p_dnz_chr_id
4389: AND cle.cle_id IS NULL
4390: AND cle.chr_id = cle.dnz_chr_id
4391: AND cle.lse_id = lse.id

Line 5753: okc_k_lines_b l

5749:
5750: CURSOR curr_ln_csr (p_line_id OKC_K_HEADERS_B.ID%TYPE) IS
5751: SELECT h.currency_code
5752: FROM okc_k_headers_b h,
5753: okc_k_lines_b l
5754: WHERE h.id = l.dnz_chr_id
5755: AND l.id = p_line_id;
5756:
5757: l_conv_amount NUMBER;

Line 5758: l_currency_code OKC_K_LINES_B.CURRENCY_CODE%TYPE;

5754: WHERE h.id = l.dnz_chr_id
5755: AND l.id = p_line_id;
5756:
5757: l_conv_amount NUMBER;
5758: l_currency_code OKC_K_LINES_B.CURRENCY_CODE%TYPE;
5759:
5760: roundoff_error EXCEPTION;
5761:
5762: BEGIN

Line 6228: CURSOR lty_code_csr(p_line_id okc_k_lines_b.id%TYPE) IS

6224: -- vthiruva, 08/19/2004
6225: -- START, Code change to enable Business Event
6226: */
6227: --cursor to fetch the line style code for line style id passed
6228: CURSOR lty_code_csr(p_line_id okc_k_lines_b.id%TYPE) IS
6229: SELECT lse.lty_code
6230: FROM okc_line_styles_b lse,
6231: okc_k_lines_b line
6232: WHERE lse.id = line.lse_id

Line 6231: okc_k_lines_b line

6227: --cursor to fetch the line style code for line style id passed
6228: CURSOR lty_code_csr(p_line_id okc_k_lines_b.id%TYPE) IS
6229: SELECT lse.lty_code
6230: FROM okc_line_styles_b lse,
6231: okc_k_lines_b line
6232: WHERE lse.id = line.lse_id
6233: AND line.id = p_line_id;
6234:
6235: l_lty_code okc_line_styles_b.lty_code%TYPE;

Line 6670: from okc_k_lines_b cleb

6666: cleb.start_date,
6667: cleb.end_date,
6668: cleb.currency_code,
6669: cleb.sts_code
6670: from okc_k_lines_b cleb
6671: where id = p_cle_id;
6672:
6673: l_orig_chr_id okc_k_lines_b.dnz_chr_id%TYPE;
6674: l_orig_cle_id okc_k_lines_b.cle_id%TYPE;

Line 6673: l_orig_chr_id okc_k_lines_b.dnz_chr_id%TYPE;

6669: cleb.sts_code
6670: from okc_k_lines_b cleb
6671: where id = p_cle_id;
6672:
6673: l_orig_chr_id okc_k_lines_b.dnz_chr_id%TYPE;
6674: l_orig_cle_id okc_k_lines_b.cle_id%TYPE;
6675: l_orig_lse_id okc_k_lines_b.lse_id%TYPE;
6676: l_orig_start_date okc_k_lines_b.start_date%TYPE;
6677: l_orig_end_date okc_k_lines_b.end_date%TYPE;

Line 6674: l_orig_cle_id okc_k_lines_b.cle_id%TYPE;

6670: from okc_k_lines_b cleb
6671: where id = p_cle_id;
6672:
6673: l_orig_chr_id okc_k_lines_b.dnz_chr_id%TYPE;
6674: l_orig_cle_id okc_k_lines_b.cle_id%TYPE;
6675: l_orig_lse_id okc_k_lines_b.lse_id%TYPE;
6676: l_orig_start_date okc_k_lines_b.start_date%TYPE;
6677: l_orig_end_date okc_k_lines_b.end_date%TYPE;
6678: l_orig_currency_code okc_k_lines_b.currency_code%TYPE;

Line 6675: l_orig_lse_id okc_k_lines_b.lse_id%TYPE;

6671: where id = p_cle_id;
6672:
6673: l_orig_chr_id okc_k_lines_b.dnz_chr_id%TYPE;
6674: l_orig_cle_id okc_k_lines_b.cle_id%TYPE;
6675: l_orig_lse_id okc_k_lines_b.lse_id%TYPE;
6676: l_orig_start_date okc_k_lines_b.start_date%TYPE;
6677: l_orig_end_date okc_k_lines_b.end_date%TYPE;
6678: l_orig_currency_code okc_k_lines_b.currency_code%TYPE;
6679: l_orig_sts_code okc_k_lines_b.sts_code%TYPE;

Line 6676: l_orig_start_date okc_k_lines_b.start_date%TYPE;

6672:
6673: l_orig_chr_id okc_k_lines_b.dnz_chr_id%TYPE;
6674: l_orig_cle_id okc_k_lines_b.cle_id%TYPE;
6675: l_orig_lse_id okc_k_lines_b.lse_id%TYPE;
6676: l_orig_start_date okc_k_lines_b.start_date%TYPE;
6677: l_orig_end_date okc_k_lines_b.end_date%TYPE;
6678: l_orig_currency_code okc_k_lines_b.currency_code%TYPE;
6679: l_orig_sts_code okc_k_lines_b.sts_code%TYPE;
6680:

Line 6677: l_orig_end_date okc_k_lines_b.end_date%TYPE;

6673: l_orig_chr_id okc_k_lines_b.dnz_chr_id%TYPE;
6674: l_orig_cle_id okc_k_lines_b.cle_id%TYPE;
6675: l_orig_lse_id okc_k_lines_b.lse_id%TYPE;
6676: l_orig_start_date okc_k_lines_b.start_date%TYPE;
6677: l_orig_end_date okc_k_lines_b.end_date%TYPE;
6678: l_orig_currency_code okc_k_lines_b.currency_code%TYPE;
6679: l_orig_sts_code okc_k_lines_b.sts_code%TYPE;
6680:
6681: l_dt_clev_rec okl_okc_migration_pvt.clev_rec_type;

Line 6678: l_orig_currency_code okc_k_lines_b.currency_code%TYPE;

6674: l_orig_cle_id okc_k_lines_b.cle_id%TYPE;
6675: l_orig_lse_id okc_k_lines_b.lse_id%TYPE;
6676: l_orig_start_date okc_k_lines_b.start_date%TYPE;
6677: l_orig_end_date okc_k_lines_b.end_date%TYPE;
6678: l_orig_currency_code okc_k_lines_b.currency_code%TYPE;
6679: l_orig_sts_code okc_k_lines_b.sts_code%TYPE;
6680:
6681: l_dt_clev_rec okl_okc_migration_pvt.clev_rec_type;
6682: lx_dt_clev_rec okl_okc_migration_pvt.clev_rec_type;

Line 6679: l_orig_sts_code okc_k_lines_b.sts_code%TYPE;

6675: l_orig_lse_id okc_k_lines_b.lse_id%TYPE;
6676: l_orig_start_date okc_k_lines_b.start_date%TYPE;
6677: l_orig_end_date okc_k_lines_b.end_date%TYPE;
6678: l_orig_currency_code okc_k_lines_b.currency_code%TYPE;
6679: l_orig_sts_code okc_k_lines_b.sts_code%TYPE;
6680:
6681: l_dt_clev_rec okl_okc_migration_pvt.clev_rec_type;
6682: lx_dt_clev_rec okl_okc_migration_pvt.clev_rec_type;
6683: --Bug# 3143522

Line 6690: CURSOR lty_code_csr(p_line_id okc_k_lines_b.id%TYPE) IS

6686: -- vthiruva, 08/19/2004
6687: -- START, Code change to enable Business Event
6688: */
6689: --cursor to fetch the line style code for line style id passed
6690: CURSOR lty_code_csr(p_line_id okc_k_lines_b.id%TYPE) IS
6691: SELECT lse.lty_code
6692: FROM okc_line_styles_b lse,
6693: okc_k_lines_b line
6694: WHERE lse.id = line.lse_id

Line 6693: okc_k_lines_b line

6689: --cursor to fetch the line style code for line style id passed
6690: CURSOR lty_code_csr(p_line_id okc_k_lines_b.id%TYPE) IS
6691: SELECT lse.lty_code
6692: FROM okc_line_styles_b lse,
6693: okc_k_lines_b line
6694: WHERE lse.id = line.lse_id
6695: AND line.id = p_line_id;
6696:
6697: -- sjalasut. added cursors to get the service contract details

Line 6698: CURSOR get_linked_serv_cle (p_okl_chr_id okc_k_headers_b.id%TYPE, p_okl_cle_id okc_k_lines_b.id%TYPE) IS

6694: WHERE lse.id = line.lse_id
6695: AND line.id = p_line_id;
6696:
6697: -- sjalasut. added cursors to get the service contract details
6698: CURSOR get_linked_serv_cle (p_okl_chr_id okc_k_headers_b.id%TYPE, p_okl_cle_id okc_k_lines_b.id%TYPE) IS
6699: select rlobj.object1_id1
6700: from okc_k_rel_objs_v rlobj
6701: where rlobj.chr_id = p_okl_chr_id
6702: and rlobj.cle_id = p_okl_cle_id

Line 6705: l_linked_serv_cle_id okc_k_lines_b.id%TYPE;

6701: where rlobj.chr_id = p_okl_chr_id
6702: and rlobj.cle_id = p_okl_cle_id
6703: and rlobj.rty_code = 'OKLSRV'
6704: and rlobj.jtot_object1_code = 'OKL_SERVICE_LINE';
6705: l_linked_serv_cle_id okc_k_lines_b.id%TYPE;
6706:
6707: CURSOR get_linked_serv_khr (p_oks_cle_id okc_k_headers_b.id%TYPE) IS
6708: select dnz_chr_id from okc_k_lines_b where id = p_oks_cle_id;
6709: l_linked_serv_chr_id okc_k_headers_b.id%TYPE;

Line 6708: select dnz_chr_id from okc_k_lines_b where id = p_oks_cle_id;

6704: and rlobj.jtot_object1_code = 'OKL_SERVICE_LINE';
6705: l_linked_serv_cle_id okc_k_lines_b.id%TYPE;
6706:
6707: CURSOR get_linked_serv_khr (p_oks_cle_id okc_k_headers_b.id%TYPE) IS
6708: select dnz_chr_id from okc_k_lines_b where id = p_oks_cle_id;
6709: l_linked_serv_chr_id okc_k_headers_b.id%TYPE;
6710:
6711:
6712: l_lty_code okc_line_styles_b.lty_code%TYPE;

Line 7408: FROM OKC_K_LINES_B

7404:
7405: --cursor to find out chr id required to flip status at edit point
7406: CURSOR chr_id_crs (p_cle_id IN NUMBER) is
7407: SELECT DNZ_CHR_ID
7408: FROM OKC_K_LINES_B
7409: WHERE ID = P_CLE_ID;
7410:
7411: l_dnz_chr_id OKC_K_LINES_B.dnz_chr_id%TYPE;
7412:

Line 7411: l_dnz_chr_id OKC_K_LINES_B.dnz_chr_id%TYPE;

7407: SELECT DNZ_CHR_ID
7408: FROM OKC_K_LINES_B
7409: WHERE ID = P_CLE_ID;
7410:
7411: l_dnz_chr_id OKC_K_LINES_B.dnz_chr_id%TYPE;
7412:
7413: --cursor to find out if any transactions hanging off the line to be deleted
7414: CURSOR l_get_txl_crs (p_kle_id IN NUMBER) is
7415: SELECT tas_id,

Line 7502: CURSOR lty_code_csr(p_line_id okc_k_lines_b.id%TYPE) IS

7498: -- vthiruva, 08/19/2004
7499: -- START, Code change to enable Business Event
7500: */
7501: --cursor to fetch the line style code for line style id passed
7502: CURSOR lty_code_csr(p_line_id okc_k_lines_b.id%TYPE) IS
7503: SELECT lse.lty_code
7504: FROM okc_line_styles_b lse,
7505: okc_k_lines_b lns
7506: WHERE lns.id = p_line_id

Line 7505: okc_k_lines_b lns

7501: --cursor to fetch the line style code for line style id passed
7502: CURSOR lty_code_csr(p_line_id okc_k_lines_b.id%TYPE) IS
7503: SELECT lse.lty_code
7504: FROM okc_line_styles_b lse,
7505: okc_k_lines_b lns
7506: WHERE lns.id = p_line_id
7507: AND lse.id = lns.lse_id;
7508:
7509: l_lty_code okc_line_styles_b.lty_code%TYPE;

Line 8219: FROM OKC_K_Lines_b

8215:
8216: -- OKC code removes lines four levels deep
8217: CURSOR l_Child_Cur1_csr(P_Parent_Id IN NUMBER)
8218: IS SELECT ID
8219: FROM OKC_K_Lines_b
8220: WHERE cle_id=P_Parent_Id;
8221:
8222: CURSOR l_Child_Cur2_csr(P_Parent_Id IN NUMBER)
8223: IS SELECT ID

Line 8224: FROM Okc_K_Lines_b

8220: WHERE cle_id=P_Parent_Id;
8221:
8222: CURSOR l_Child_Cur2_csr(P_Parent_Id IN NUMBER)
8223: IS SELECT ID
8224: FROM Okc_K_Lines_b
8225: WHERE cle_Id=P_Parent_Id;
8226:
8227: CURSOR l_Child_Cur3_csr(P_Parent_Id IN NUMBER)
8228: IS SELECT ID

Line 8229: FROM Okc_K_Lines_b

8225: WHERE cle_Id=P_Parent_Id;
8226:
8227: CURSOR l_Child_Cur3_csr(P_Parent_Id IN NUMBER)
8228: IS SELECT ID
8229: FROM Okc_K_Lines_b
8230: WHERE cle_Id=P_Parent_Id;
8231:
8232: CURSOR l_Child_Cur4_csr(P_Parent_Id IN NUMBER)
8233: IS SELECT ID

Line 8234: FROM Okc_K_Lines_b

8230: WHERE cle_Id=P_Parent_Id;
8231:
8232: CURSOR l_Child_Cur4_csr(P_Parent_Id IN NUMBER)
8233: IS SELECT ID
8234: FROM Okc_K_Lines_b
8235: WHERE cle_Id=P_Parent_Id;
8236:
8237: CURSOR l_Child_Cur5_csr(P_Parent_Id IN NUMBER)
8238: IS SELECT ID

Line 8239: FROM Okc_K_Lines_b

8235: WHERE cle_Id=P_Parent_Id;
8236:
8237: CURSOR l_Child_Cur5_csr(P_Parent_Id IN NUMBER)
8238: IS SELECT ID
8239: FROM Okc_K_Lines_b
8240: WHERE cle_Id=P_Parent_Id;
8241:
8242: --cursor to find out chr id required to flip status at edit point
8243: CURSOR chr_id_crs (p_cle_id IN NUMBER) is

Line 8245: FROM OKC_K_LINES_B

8241:
8242: --cursor to find out chr id required to flip status at edit point
8243: CURSOR chr_id_crs (p_cle_id IN NUMBER) is
8244: SELECT DNZ_CHR_ID
8245: FROM OKC_K_LINES_B
8246: WHERE ID = P_CLE_ID;
8247:
8248: l_dnz_chr_id OKC_K_LINES_B.dnz_chr_id%TYPE;
8249:

Line 8248: l_dnz_chr_id OKC_K_LINES_B.dnz_chr_id%TYPE;

8244: SELECT DNZ_CHR_ID
8245: FROM OKC_K_LINES_B
8246: WHERE ID = P_CLE_ID;
8247:
8248: l_dnz_chr_id OKC_K_LINES_B.dnz_chr_id%TYPE;
8249:
8250:
8251: n NUMBER:=0;
8252: l_klev_tbl_in OKL_KLE_PVT.klev_tbl_type;

Line 8361: CURSOR lty_code_csr(p_line_id okc_k_lines_b.id%TYPE) IS

8357: -- vthiruva, 08/19/2004
8358: -- START, Code change to enable Business Event
8359: */
8360: --cursor to fetch the line style code for line style id passed
8361: CURSOR lty_code_csr(p_line_id okc_k_lines_b.id%TYPE) IS
8362: SELECT lse.lty_code
8363: FROM okc_line_styles_b lse,
8364: okc_k_lines_b lns
8365: WHERE lns.id = p_line_id

Line 8364: okc_k_lines_b lns

8360: --cursor to fetch the line style code for line style id passed
8361: CURSOR lty_code_csr(p_line_id okc_k_lines_b.id%TYPE) IS
8362: SELECT lse.lty_code
8363: FROM okc_line_styles_b lse,
8364: okc_k_lines_b lns
8365: WHERE lns.id = p_line_id
8366: AND lse.id = lns.lse_id;
8367:
8368: l_lty_code okc_line_styles_b.lty_code%TYPE;

Line 8384: SELECT COUNT(id) FROM OKC_K_LINES_B

8380: x_return_status OUT NOCOPY VARCHAR2) IS
8381: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
8382: l_count NUMBER;
8383: CURSOR l_cur_line_csr(p_line_id IN NUMBER) IS
8384: SELECT COUNT(id) FROM OKC_K_LINES_B
8385: WHERE id = p_line_id;
8386: BEGIN
8387: IF p_line_id = OKL_API.G_MISS_NUM OR p_line_id IS NULL
8388: THEN

Line 10937: SELECT 'x' FROM okc_k_lines_b cle, okc_line_styles_b lse

10933: SELECT 'x' FROM okc_k_items cim
10934: WHERE cim.object1_id1 = to_char(chr.id)
10935: AND EXISTS
10936: (
10937: SELECT 'x' FROM okc_k_lines_b cle, okc_line_styles_b lse
10938: WHERE cle.lse_id = lse.id
10939: AND lse.lty_code = 'SHARED'
10940: AND cle.id = cim.cle_id
10941: )