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 262: okc_k_lines_b cle

258: --Cursor to check if the contract is booked
259: Cursor Chr_sts_crs(p_cle_id IN Number) IS
260: SELECT chr.sts_code
261: FROM okc_k_headers_b chr,
262: okc_k_lines_b cle
263: WHERE chr.ID = cle.dnz_chr_id
264: AND cle.ID = p_cle_id;
265:
266: l_sts_code OKC_K_HEADERS_B.STS_CODE%TYPE;

Line 273: okc_k_lines_b cle

269: Cursor Ever_Booked_crs(p_cle_id IN Number) is
270: SELECT 'Y'
271: FROM okc_k_headers_bh chrh,
272: okc_k_headers_b chr,
273: okc_k_lines_b cle
274: WHERE chrh.contract_number = chr.contract_number
275: AND chr.ID = cle.dnz_chr_id
276: AND chrh.sts_code = G_OKL_BOOKED_STS_CODE
277: AND cle.ID = p_cle_id

Line 312: okc_k_lines_b cleb,

308: Cursor l_rbk_asst_csr(p_cle_id IN NUMBER) is
309: Select 'Y' rbk_asst_flag,
310: clet.NAME
311: from okc_k_lines_tl clet,
312: okc_k_lines_b cleb,
313: okc_line_styles_b lseb,
314: okc_k_headers_b chrb
315: where chrb.id = cleb.dnz_chr_id
316: and chrb.scs_code = 'LEASE'

Line 326: okc_k_lines_b orig_cleb

322: and cleb.id = p_cle_id
323: and cleb.orig_system_id1 is not NULL
324: and exists (select '1'
325: from okc_k_headers_b orig_chrb,
326: okc_k_lines_b orig_cleb
327: where orig_chrb.id = chrb.orig_system_id1
328: and orig_cleb.id = cleb.orig_system_id1
329: --Bug# 4375800 :
330: and orig_cleb.sts_code <> 'ABANDONED'

Line 872: from okc_k_lines_b kleb,

868:
869: CURSOR c_okx_asset_lines_v(p_asset_number OKX_ASSETS_V.ASSET_NUMBER%TYPE) is
870: --start modified abhsaxen for performance SQLID 20562304
871: select 'Y'
872: from okc_k_lines_b kleb,
873: okc_k_lines_tl kle,
874: okc_line_styles_b lse
875: where kle.name = p_asset_number
876: and kle.id = kleb.id

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

896:
897: l_asset_exists Varchar2(1) default 'N';
898:
899: --cursor to check if line is financial asset top line
900: CURSOR l_is_finasst (p_line_id OKC_K_LINES_B.ID%TYPE) IS
901: Select 'Y'
902: From Dual
903: Where exists (select '1'
904: from okc_k_lines_b cle,

Line 904: from okc_k_lines_b cle,

900: CURSOR l_is_finasst (p_line_id OKC_K_LINES_B.ID%TYPE) IS
901: Select 'Y'
902: From Dual
903: Where exists (select '1'
904: from okc_k_lines_b cle,
905: okc_line_styles_b lse
906: where cle.lse_id = lse.id
907: and lse.lty_code = 'FREE_FORM1'
908: and cle.id = p_line_id);

Line 921: OKC_K_LINES_B cle,

917: CURSOR l_txlv_csr (p_finasst_id IN NUMBER, P_Asstno IN VARCHAR2) is
918: Select txlv.id,
919: txlv.asset_number
920: From OKL_TXL_ASSETS_V txlv,
921: OKC_K_LINES_B cle,
922: OKC_LINE_STYLES_B lse
923: Where txlv.kle_id = cle.id
924: And cle.lse_id = lse.id
925: And lse.lty_code = 'FIXED_ASSET'

Line 938: OKC_K_LINES_B cle,

934: Select txdv.id,
935: txdv.asset_number
936: From OKL_TXD_ASSETS_V txdv,
937: OKL_TXL_ASSETS_V txlv,
938: OKC_K_LINES_B cle,
939: OKC_LINE_STYLES_B lse
940: Where txdv.tal_id = txlv.id
941: And txlv.kle_id = cle.id
942: And cle.lse_id = lse.id

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

1142: p_cle_id IN NUMBER,
1143: p_deletion_type IN VARCHAR2) IS
1144:
1145: --cursor to check if line is financial asset top line
1146: CURSOR l_is_finasst (p_line_id OKC_K_LINES_B.ID%TYPE) IS
1147: Select 'Y'
1148: From Dual
1149: Where exists (select '1'
1150: from okc_k_lines_b cle,

Line 1150: from okc_k_lines_b cle,

1146: CURSOR l_is_finasst (p_line_id OKC_K_LINES_B.ID%TYPE) IS
1147: Select 'Y'
1148: From Dual
1149: Where exists (select '1'
1150: from okc_k_lines_b cle,
1151: okc_line_styles_b lse
1152: where cle.lse_id = lse.id
1153: and lse.lty_code = 'FREE_FORM1'
1154: and cle.id = p_line_id);

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

1156: l_fin_asst Varchar2(1) default 'N';
1157: l_cle_id Number;
1158:
1159: --cursor to check if financial asset appears as linked asset
1160: CURSOR l_lnk_ast_csr (p_line_id OKC_K_LINES_B.ID%TYPE) IS
1161: Select lnk.id
1162: From okc_k_lines_b lnk,
1163: okc_line_styles_b lnk_lse,
1164: okc_statuses_b sts,

Line 1162: From okc_k_lines_b lnk,

1158:
1159: --cursor to check if financial asset appears as linked asset
1160: CURSOR l_lnk_ast_csr (p_line_id OKC_K_LINES_B.ID%TYPE) IS
1161: Select lnk.id
1162: From okc_k_lines_b lnk,
1163: okc_line_styles_b lnk_lse,
1164: okc_statuses_b sts,
1165: okc_k_items cim
1166: Where lnk.id = cim.cle_id

Line 1176: l_lnk_cle_id OKC_K_LINES_B.ID%TYPE;

1172: and cim.jtot_object1_code = 'OKX_COVASST'
1173: and cim.object1_id1 = to_char(p_line_id)
1174: and cim.object1_id2 = '#';
1175:
1176: l_lnk_cle_id OKC_K_LINES_B.ID%TYPE;
1177: l_clev_rec OKL_OKC_MIGRATION_PVT.clev_rec_type;
1178: l_clev_rec_out OKL_OKC_MIGRATION_PVT.clev_rec_type;
1179: l_deletion_type Varchar2(1);
1180:

Line 1331: from okc_k_lines_b cleb

1327: select cleb.start_date,
1328: cleb.end_date,
1329: cleb.currency_code,
1330: cleb.sts_code
1331: from okc_k_lines_b cleb
1332: where cleb.id = p_cle_id;
1333: l_cle_start_date date;
1334: l_cle_end_date date;
1335: l_cle_curr_code okc_k_lines_b.currency_code%TYPE;

Line 1335: l_cle_curr_code okc_k_lines_b.currency_code%TYPE;

1331: from okc_k_lines_b cleb
1332: where cleb.id = p_cle_id;
1333: l_cle_start_date date;
1334: l_cle_end_date date;
1335: l_cle_curr_code okc_k_lines_b.currency_code%TYPE;
1336: l_cle_sts_code okc_k_lines_b.sts_code%TYPE;
1337:
1338: --cursor to get line style
1339: cursor l_lse_csr (p_lse_id in number ) is

Line 1336: l_cle_sts_code okc_k_lines_b.sts_code%TYPE;

1332: where cleb.id = p_cle_id;
1333: l_cle_start_date date;
1334: l_cle_end_date date;
1335: l_cle_curr_code okc_k_lines_b.currency_code%TYPE;
1336: l_cle_sts_code okc_k_lines_b.sts_code%TYPE;
1337:
1338: --cursor to get line style
1339: cursor l_lse_csr (p_lse_id in number ) is
1340: select lseb.lty_code,

Line 1806: okc_k_lines_b cleb,

1802: p_chr_id in number) is
1803: select txdb.id
1804: from okl_txd_assets_b txdb,
1805: okl_txl_assets_b txlb,
1806: okc_k_lines_b cleb,
1807: okc_line_styles_b lseb
1808: where txdb.tax_book = p_book_type_code
1809: and txdb.tal_id = txlb.id
1810: and txlb.kle_id = cleb.id

Line 2900: From okc_k_lines_b cle,

2896: --Cursor to get top lines is lease chr has lines to change effectivity
2897: --bug 4412923: Removed the status 'CANCELLED' from the cursor
2898: Cursor top_cle_csr (p_chr_id IN NUMBER) is
2899: SELECT cle.id
2900: From okc_k_lines_b cle,
2901: okc_statuses_b sts
2902: where cle.dnz_chr_id = cle.chr_id
2903: and cle.chr_id = p_chr_id
2904: and sts.code = cle.sts_code

Line 2907: l_top_cle_id OKC_K_LINES_B.ID%TYPE;

2903: and cle.chr_id = p_chr_id
2904: and sts.code = cle.sts_code
2905: And sts.ste_code not in ('HOLD','EXPIRED','TERMINATED');
2906:
2907: l_top_cle_id OKC_K_LINES_B.ID%TYPE;
2908:
2909: --Cursor to check if lease chr has lines to change effectivity
2910: --bug 4412923: Removed the status 'CANCELLED' from the cursor
2911: Cursor cle_csr(p_cle_id IN NUMBER) is

Line 2918: From okc_k_lines_b cle

2914: cle.end_date,
2915: cle.orig_system_id1,
2916: --Bug#
2917: cle.lse_id
2918: From okc_k_lines_b cle
2919: connect by prior cle.id = cle.cle_id
2920: start with cle.id = p_cle_id
2921: and exists (select 1
2922: from okc_statuses_b sts

Line 2926: l_cle_id OKC_K_LINES_B.ID%TYPE;

2922: from okc_statuses_b sts
2923: where sts.code = cle.sts_code
2924: and sts.ste_code not in ('HOLD','EXPIRED','TERMINATED'));
2925:
2926: l_cle_id OKC_K_LINES_B.ID%TYPE;
2927: l_cle_start_date OKC_K_LINES_B.START_DATE%TYPE;
2928: l_cle_end_date OKC_K_LINES_B.END_DATE%TYPE;
2929: l_parent_cle_id OKC_K_LINES_B.orig_system_id1%TYPE;
2930: --Bug#

Line 2927: l_cle_start_date OKC_K_LINES_B.START_DATE%TYPE;

2923: where sts.code = cle.sts_code
2924: and sts.ste_code not in ('HOLD','EXPIRED','TERMINATED'));
2925:
2926: l_cle_id OKC_K_LINES_B.ID%TYPE;
2927: l_cle_start_date OKC_K_LINES_B.START_DATE%TYPE;
2928: l_cle_end_date OKC_K_LINES_B.END_DATE%TYPE;
2929: l_parent_cle_id OKC_K_LINES_B.orig_system_id1%TYPE;
2930: --Bug#
2931: l_lse_id OKC_K_LINES_B.lse_id%TYPE;

Line 2928: l_cle_end_date OKC_K_LINES_B.END_DATE%TYPE;

2924: and sts.ste_code not in ('HOLD','EXPIRED','TERMINATED'));
2925:
2926: l_cle_id OKC_K_LINES_B.ID%TYPE;
2927: l_cle_start_date OKC_K_LINES_B.START_DATE%TYPE;
2928: l_cle_end_date OKC_K_LINES_B.END_DATE%TYPE;
2929: l_parent_cle_id OKC_K_LINES_B.orig_system_id1%TYPE;
2930: --Bug#
2931: l_lse_id OKC_K_LINES_B.lse_id%TYPE;
2932:

Line 2929: l_parent_cle_id OKC_K_LINES_B.orig_system_id1%TYPE;

2925:
2926: l_cle_id OKC_K_LINES_B.ID%TYPE;
2927: l_cle_start_date OKC_K_LINES_B.START_DATE%TYPE;
2928: l_cle_end_date OKC_K_LINES_B.END_DATE%TYPE;
2929: l_parent_cle_id OKC_K_LINES_B.orig_system_id1%TYPE;
2930: --Bug#
2931: l_lse_id OKC_K_LINES_B.lse_id%TYPE;
2932:
2933:

Line 2931: l_lse_id OKC_K_LINES_B.lse_id%TYPE;

2927: l_cle_start_date OKC_K_LINES_B.START_DATE%TYPE;
2928: l_cle_end_date OKC_K_LINES_B.END_DATE%TYPE;
2929: l_parent_cle_id OKC_K_LINES_B.orig_system_id1%TYPE;
2930: --Bug#
2931: l_lse_id OKC_K_LINES_B.lse_id%TYPE;
2932:
2933:
2934: l_clev_rec OKL_OKC_MIGRATION_PVT.clev_rec_type;
2935: lx_clev_rec OKL_OKC_MIGRATION_PVT.clev_rec_type;

Line 2984: okc_k_lines_b cleb,

2980: p_chr_id in number) is
2981: select txdb.id
2982: from okl_txd_assets_b txdb,
2983: okl_txl_assets_b txlb,
2984: okc_k_lines_b cleb,
2985: okc_line_styles_b lseb
2986: where txdb.tax_book = p_book_type_code
2987: and txdb.tal_id = txlb.id
2988: and txlb.kle_id = cleb.id

Line 3017: From okc_k_lines_b cle

3013: Cursor parent_cle_csr (p_cle_id IN Number) is
3014: SELECT
3015: cle.start_date,
3016: cle.end_date
3017: From okc_k_lines_b cle
3018: Where cle.id = p_cle_id;
3019:
3020: l_parent_cle_start_date OKC_K_HEADERS_B.start_date%TYPE;
3021: l_parent_cle_end_date OKC_K_HEADERS_B.end_date%TYPE;

Line 3059: FROM OKC_K_LINES_B OKC,

3055: SELECT DISTINCT TAS_ID
3056: FROM OKL_TXL_ASSETS_B
3057: WHERE KLE_ID IN
3058: (SELECT OKC.ID
3059: FROM OKC_K_LINES_B OKC,
3060: OKC_LINE_STYLES_B OKC_ST
3061: WHERE OKC_ST.LTY_CODE ='FREE_FORM1'
3062: AND OKC.LSE_ID=OKC_ST.ID
3063: AND OKC.CHR_ID =OKC.DNZ_CHR_ID

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

4279: AND chr.id = p_id
4280: AND chrh.sts_code = G_OKL_BOOKED_STS_CODE
4281: AND rownum < 2;
4282:
4283: CURSOR c_get_k_stream(p_khr_id OKC_K_LINES_B.DNZ_CHR_ID%TYPE) IS
4284: SELECT id stm_id
4285: FROM OKL_STREAMS
4286: WHERE khr_id = p_khr_id;
4287:

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

4284: SELECT id stm_id
4285: FROM OKL_STREAMS
4286: WHERE khr_id = p_khr_id;
4287:
4288: CURSOR c_get_je_trans(p_khr_id OKC_K_LINES_B.DNZ_CHR_ID%TYPE) IS
4289: SELECT id trx_id
4290: FROM OKL_TRX_CONTRACTS
4291: WHERE khr_id = p_khr_id
4292: AND representation_type = 'PRIMARY';

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

4290: FROM OKL_TRX_CONTRACTS
4291: WHERE khr_id = p_khr_id
4292: AND representation_type = 'PRIMARY';
4293:
4294: CURSOR c_get_source_id(p_khr_id OKC_K_LINES_B.DNZ_CHR_ID%TYPE) IS
4295: SELECT id
4296: FROM OKL_TXL_CNTRCT_LNS
4297: WHERE khr_id = p_khr_id;
4298:

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

4295: SELECT id
4296: FROM OKL_TXL_CNTRCT_LNS
4297: WHERE khr_id = p_khr_id;
4298:
4299: CURSOR c_get_k_top_line(p_dnz_chr_id OKC_K_LINES_B.DNZ_CHR_ID%TYPE) IS
4300: SELECT cle.id top_line
4301: FROM okc_line_styles_b lse,
4302: okc_k_lines_b cle
4303: WHERE cle.dnz_chr_id = p_dnz_chr_id

Line 4302: okc_k_lines_b cle

4298:
4299: CURSOR c_get_k_top_line(p_dnz_chr_id OKC_K_LINES_B.DNZ_CHR_ID%TYPE) IS
4300: SELECT cle.id top_line
4301: FROM okc_line_styles_b lse,
4302: okc_k_lines_b cle
4303: WHERE cle.dnz_chr_id = p_dnz_chr_id
4304: AND cle.cle_id IS NULL
4305: AND cle.chr_id = cle.dnz_chr_id
4306: AND cle.lse_id = lse.id

Line 5668: okc_k_lines_b l

5664:
5665: CURSOR curr_ln_csr (p_line_id OKC_K_HEADERS_B.ID%TYPE) IS
5666: SELECT h.currency_code
5667: FROM okc_k_headers_b h,
5668: okc_k_lines_b l
5669: WHERE h.id = l.dnz_chr_id
5670: AND l.id = p_line_id;
5671:
5672: l_conv_amount NUMBER;

Line 5673: l_currency_code OKC_K_LINES_B.CURRENCY_CODE%TYPE;

5669: WHERE h.id = l.dnz_chr_id
5670: AND l.id = p_line_id;
5671:
5672: l_conv_amount NUMBER;
5673: l_currency_code OKC_K_LINES_B.CURRENCY_CODE%TYPE;
5674:
5675: roundoff_error EXCEPTION;
5676:
5677: BEGIN

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

6122: -- vthiruva, 08/19/2004
6123: -- START, Code change to enable Business Event
6124: */
6125: --cursor to fetch the line style code for line style id passed
6126: CURSOR lty_code_csr(p_line_id okc_k_lines_b.id%TYPE) IS
6127: SELECT lse.lty_code
6128: FROM okc_line_styles_b lse,
6129: okc_k_lines_b line
6130: WHERE lse.id = line.lse_id

Line 6129: okc_k_lines_b line

6125: --cursor to fetch the line style code for line style id passed
6126: CURSOR lty_code_csr(p_line_id okc_k_lines_b.id%TYPE) IS
6127: SELECT lse.lty_code
6128: FROM okc_line_styles_b lse,
6129: okc_k_lines_b line
6130: WHERE lse.id = line.lse_id
6131: AND line.id = p_line_id;
6132:
6133: l_lty_code okc_line_styles_b.lty_code%TYPE;

Line 6568: from okc_k_lines_b cleb

6564: cleb.start_date,
6565: cleb.end_date,
6566: cleb.currency_code,
6567: cleb.sts_code
6568: from okc_k_lines_b cleb
6569: where id = p_cle_id;
6570:
6571: l_orig_chr_id okc_k_lines_b.dnz_chr_id%TYPE;
6572: l_orig_cle_id okc_k_lines_b.cle_id%TYPE;

Line 6571: l_orig_chr_id okc_k_lines_b.dnz_chr_id%TYPE;

6567: cleb.sts_code
6568: from okc_k_lines_b cleb
6569: where id = p_cle_id;
6570:
6571: l_orig_chr_id okc_k_lines_b.dnz_chr_id%TYPE;
6572: l_orig_cle_id okc_k_lines_b.cle_id%TYPE;
6573: l_orig_lse_id okc_k_lines_b.lse_id%TYPE;
6574: l_orig_start_date okc_k_lines_b.start_date%TYPE;
6575: l_orig_end_date okc_k_lines_b.end_date%TYPE;

Line 6572: l_orig_cle_id okc_k_lines_b.cle_id%TYPE;

6568: from okc_k_lines_b cleb
6569: where id = p_cle_id;
6570:
6571: l_orig_chr_id okc_k_lines_b.dnz_chr_id%TYPE;
6572: l_orig_cle_id okc_k_lines_b.cle_id%TYPE;
6573: l_orig_lse_id okc_k_lines_b.lse_id%TYPE;
6574: l_orig_start_date okc_k_lines_b.start_date%TYPE;
6575: l_orig_end_date okc_k_lines_b.end_date%TYPE;
6576: l_orig_currency_code okc_k_lines_b.currency_code%TYPE;

Line 6573: l_orig_lse_id okc_k_lines_b.lse_id%TYPE;

6569: where id = p_cle_id;
6570:
6571: l_orig_chr_id okc_k_lines_b.dnz_chr_id%TYPE;
6572: l_orig_cle_id okc_k_lines_b.cle_id%TYPE;
6573: l_orig_lse_id okc_k_lines_b.lse_id%TYPE;
6574: l_orig_start_date okc_k_lines_b.start_date%TYPE;
6575: l_orig_end_date okc_k_lines_b.end_date%TYPE;
6576: l_orig_currency_code okc_k_lines_b.currency_code%TYPE;
6577: l_orig_sts_code okc_k_lines_b.sts_code%TYPE;

Line 6574: l_orig_start_date okc_k_lines_b.start_date%TYPE;

6570:
6571: l_orig_chr_id okc_k_lines_b.dnz_chr_id%TYPE;
6572: l_orig_cle_id okc_k_lines_b.cle_id%TYPE;
6573: l_orig_lse_id okc_k_lines_b.lse_id%TYPE;
6574: l_orig_start_date okc_k_lines_b.start_date%TYPE;
6575: l_orig_end_date okc_k_lines_b.end_date%TYPE;
6576: l_orig_currency_code okc_k_lines_b.currency_code%TYPE;
6577: l_orig_sts_code okc_k_lines_b.sts_code%TYPE;
6578:

Line 6575: l_orig_end_date okc_k_lines_b.end_date%TYPE;

6571: l_orig_chr_id okc_k_lines_b.dnz_chr_id%TYPE;
6572: l_orig_cle_id okc_k_lines_b.cle_id%TYPE;
6573: l_orig_lse_id okc_k_lines_b.lse_id%TYPE;
6574: l_orig_start_date okc_k_lines_b.start_date%TYPE;
6575: l_orig_end_date okc_k_lines_b.end_date%TYPE;
6576: l_orig_currency_code okc_k_lines_b.currency_code%TYPE;
6577: l_orig_sts_code okc_k_lines_b.sts_code%TYPE;
6578:
6579: l_dt_clev_rec okl_okc_migration_pvt.clev_rec_type;

Line 6576: l_orig_currency_code okc_k_lines_b.currency_code%TYPE;

6572: l_orig_cle_id okc_k_lines_b.cle_id%TYPE;
6573: l_orig_lse_id okc_k_lines_b.lse_id%TYPE;
6574: l_orig_start_date okc_k_lines_b.start_date%TYPE;
6575: l_orig_end_date okc_k_lines_b.end_date%TYPE;
6576: l_orig_currency_code okc_k_lines_b.currency_code%TYPE;
6577: l_orig_sts_code okc_k_lines_b.sts_code%TYPE;
6578:
6579: l_dt_clev_rec okl_okc_migration_pvt.clev_rec_type;
6580: lx_dt_clev_rec okl_okc_migration_pvt.clev_rec_type;

Line 6577: l_orig_sts_code okc_k_lines_b.sts_code%TYPE;

6573: l_orig_lse_id okc_k_lines_b.lse_id%TYPE;
6574: l_orig_start_date okc_k_lines_b.start_date%TYPE;
6575: l_orig_end_date okc_k_lines_b.end_date%TYPE;
6576: l_orig_currency_code okc_k_lines_b.currency_code%TYPE;
6577: l_orig_sts_code okc_k_lines_b.sts_code%TYPE;
6578:
6579: l_dt_clev_rec okl_okc_migration_pvt.clev_rec_type;
6580: lx_dt_clev_rec okl_okc_migration_pvt.clev_rec_type;
6581: --Bug# 3143522

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

6584: -- vthiruva, 08/19/2004
6585: -- START, Code change to enable Business Event
6586: */
6587: --cursor to fetch the line style code for line style id passed
6588: CURSOR lty_code_csr(p_line_id okc_k_lines_b.id%TYPE) IS
6589: SELECT lse.lty_code
6590: FROM okc_line_styles_b lse,
6591: okc_k_lines_b line
6592: WHERE lse.id = line.lse_id

Line 6591: okc_k_lines_b line

6587: --cursor to fetch the line style code for line style id passed
6588: CURSOR lty_code_csr(p_line_id okc_k_lines_b.id%TYPE) IS
6589: SELECT lse.lty_code
6590: FROM okc_line_styles_b lse,
6591: okc_k_lines_b line
6592: WHERE lse.id = line.lse_id
6593: AND line.id = p_line_id;
6594:
6595: -- sjalasut. added cursors to get the service contract details

Line 6596: 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

6592: WHERE lse.id = line.lse_id
6593: AND line.id = p_line_id;
6594:
6595: -- sjalasut. added cursors to get the service contract details
6596: 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
6597: select rlobj.object1_id1
6598: from okc_k_rel_objs_v rlobj
6599: where rlobj.chr_id = p_okl_chr_id
6600: and rlobj.cle_id = p_okl_cle_id

Line 6603: l_linked_serv_cle_id okc_k_lines_b.id%TYPE;

6599: where rlobj.chr_id = p_okl_chr_id
6600: and rlobj.cle_id = p_okl_cle_id
6601: and rlobj.rty_code = 'OKLSRV'
6602: and rlobj.jtot_object1_code = 'OKL_SERVICE_LINE';
6603: l_linked_serv_cle_id okc_k_lines_b.id%TYPE;
6604:
6605: CURSOR get_linked_serv_khr (p_oks_cle_id okc_k_headers_b.id%TYPE) IS
6606: select dnz_chr_id from okc_k_lines_b where id = p_oks_cle_id;
6607: l_linked_serv_chr_id okc_k_headers_b.id%TYPE;

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

6602: and rlobj.jtot_object1_code = 'OKL_SERVICE_LINE';
6603: l_linked_serv_cle_id okc_k_lines_b.id%TYPE;
6604:
6605: CURSOR get_linked_serv_khr (p_oks_cle_id okc_k_headers_b.id%TYPE) IS
6606: select dnz_chr_id from okc_k_lines_b where id = p_oks_cle_id;
6607: l_linked_serv_chr_id okc_k_headers_b.id%TYPE;
6608:
6609:
6610: l_lty_code okc_line_styles_b.lty_code%TYPE;

Line 7306: FROM OKC_K_LINES_B

7302:
7303: --cursor to find out chr id required to flip status at edit point
7304: CURSOR chr_id_crs (p_cle_id IN NUMBER) is
7305: SELECT DNZ_CHR_ID
7306: FROM OKC_K_LINES_B
7307: WHERE ID = P_CLE_ID;
7308:
7309: l_dnz_chr_id OKC_K_LINES_B.dnz_chr_id%TYPE;
7310:

Line 7309: l_dnz_chr_id OKC_K_LINES_B.dnz_chr_id%TYPE;

7305: SELECT DNZ_CHR_ID
7306: FROM OKC_K_LINES_B
7307: WHERE ID = P_CLE_ID;
7308:
7309: l_dnz_chr_id OKC_K_LINES_B.dnz_chr_id%TYPE;
7310:
7311: --cursor to find out if any transactions hanging off the line to be deleted
7312: CURSOR l_get_txl_crs (p_kle_id IN NUMBER) is
7313: SELECT tas_id,

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

7396: -- vthiruva, 08/19/2004
7397: -- START, Code change to enable Business Event
7398: */
7399: --cursor to fetch the line style code for line style id passed
7400: CURSOR lty_code_csr(p_line_id okc_k_lines_b.id%TYPE) IS
7401: SELECT lse.lty_code
7402: FROM okc_line_styles_b lse,
7403: okc_k_lines_b lns
7404: WHERE lns.id = p_line_id

Line 7403: okc_k_lines_b lns

7399: --cursor to fetch the line style code for line style id passed
7400: CURSOR lty_code_csr(p_line_id okc_k_lines_b.id%TYPE) IS
7401: SELECT lse.lty_code
7402: FROM okc_line_styles_b lse,
7403: okc_k_lines_b lns
7404: WHERE lns.id = p_line_id
7405: AND lse.id = lns.lse_id;
7406:
7407: l_lty_code okc_line_styles_b.lty_code%TYPE;

Line 8117: FROM OKC_K_Lines_b

8113:
8114: -- OKC code removes lines four levels deep
8115: CURSOR l_Child_Cur1_csr(P_Parent_Id IN NUMBER)
8116: IS SELECT ID
8117: FROM OKC_K_Lines_b
8118: WHERE cle_id=P_Parent_Id;
8119:
8120: CURSOR l_Child_Cur2_csr(P_Parent_Id IN NUMBER)
8121: IS SELECT ID

Line 8122: FROM Okc_K_Lines_b

8118: WHERE cle_id=P_Parent_Id;
8119:
8120: CURSOR l_Child_Cur2_csr(P_Parent_Id IN NUMBER)
8121: IS SELECT ID
8122: FROM Okc_K_Lines_b
8123: WHERE cle_Id=P_Parent_Id;
8124:
8125: CURSOR l_Child_Cur3_csr(P_Parent_Id IN NUMBER)
8126: IS SELECT ID

Line 8127: FROM Okc_K_Lines_b

8123: WHERE cle_Id=P_Parent_Id;
8124:
8125: CURSOR l_Child_Cur3_csr(P_Parent_Id IN NUMBER)
8126: IS SELECT ID
8127: FROM Okc_K_Lines_b
8128: WHERE cle_Id=P_Parent_Id;
8129:
8130: CURSOR l_Child_Cur4_csr(P_Parent_Id IN NUMBER)
8131: IS SELECT ID

Line 8132: FROM Okc_K_Lines_b

8128: WHERE cle_Id=P_Parent_Id;
8129:
8130: CURSOR l_Child_Cur4_csr(P_Parent_Id IN NUMBER)
8131: IS SELECT ID
8132: FROM Okc_K_Lines_b
8133: WHERE cle_Id=P_Parent_Id;
8134:
8135: CURSOR l_Child_Cur5_csr(P_Parent_Id IN NUMBER)
8136: IS SELECT ID

Line 8137: FROM Okc_K_Lines_b

8133: WHERE cle_Id=P_Parent_Id;
8134:
8135: CURSOR l_Child_Cur5_csr(P_Parent_Id IN NUMBER)
8136: IS SELECT ID
8137: FROM Okc_K_Lines_b
8138: WHERE cle_Id=P_Parent_Id;
8139:
8140: --cursor to find out chr id required to flip status at edit point
8141: CURSOR chr_id_crs (p_cle_id IN NUMBER) is

Line 8143: FROM OKC_K_LINES_B

8139:
8140: --cursor to find out chr id required to flip status at edit point
8141: CURSOR chr_id_crs (p_cle_id IN NUMBER) is
8142: SELECT DNZ_CHR_ID
8143: FROM OKC_K_LINES_B
8144: WHERE ID = P_CLE_ID;
8145:
8146: l_dnz_chr_id OKC_K_LINES_B.dnz_chr_id%TYPE;
8147:

Line 8146: l_dnz_chr_id OKC_K_LINES_B.dnz_chr_id%TYPE;

8142: SELECT DNZ_CHR_ID
8143: FROM OKC_K_LINES_B
8144: WHERE ID = P_CLE_ID;
8145:
8146: l_dnz_chr_id OKC_K_LINES_B.dnz_chr_id%TYPE;
8147:
8148:
8149: n NUMBER:=0;
8150: l_klev_tbl_in OKL_KLE_PVT.klev_tbl_type;

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

8255: -- vthiruva, 08/19/2004
8256: -- START, Code change to enable Business Event
8257: */
8258: --cursor to fetch the line style code for line style id passed
8259: CURSOR lty_code_csr(p_line_id okc_k_lines_b.id%TYPE) IS
8260: SELECT lse.lty_code
8261: FROM okc_line_styles_b lse,
8262: okc_k_lines_b lns
8263: WHERE lns.id = p_line_id

Line 8262: okc_k_lines_b lns

8258: --cursor to fetch the line style code for line style id passed
8259: CURSOR lty_code_csr(p_line_id okc_k_lines_b.id%TYPE) IS
8260: SELECT lse.lty_code
8261: FROM okc_line_styles_b lse,
8262: okc_k_lines_b lns
8263: WHERE lns.id = p_line_id
8264: AND lse.id = lns.lse_id;
8265:
8266: l_lty_code okc_line_styles_b.lty_code%TYPE;

Line 8282: SELECT COUNT(id) FROM OKC_K_LINES_B

8278: x_return_status OUT NOCOPY VARCHAR2) IS
8279: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
8280: l_count NUMBER;
8281: CURSOR l_cur_line_csr(p_line_id IN NUMBER) IS
8282: SELECT COUNT(id) FROM OKC_K_LINES_B
8283: WHERE id = p_line_id;
8284: BEGIN
8285: IF p_line_id = OKL_API.G_MISS_NUM OR p_line_id IS NULL
8286: THEN

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

10831: SELECT 'x' FROM okc_k_items cim
10832: WHERE cim.object1_id1 = to_char(chr.id)
10833: AND EXISTS
10834: (
10835: SELECT 'x' FROM okc_k_lines_b cle, okc_line_styles_b lse
10836: WHERE cle.lse_id = lse.id
10837: AND lse.lty_code = 'SHARED'
10838: AND cle.id = cim.cle_id
10839: )