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_RELEASE_PVT dependencies on OKC_K_HEADERS_B

Line 897: l_chr_id OKC_K_HEADERS_B.ID%TYPE;

893: and sts.code = cle.sts_code;
894:
895:
896: l_top_cle_id OKC_K_LINES_B.ID%TYPE;
897: l_chr_id OKC_K_HEADERS_B.ID%TYPE;
898: l_cle_id OKC_K_LINES_B.ID%TYPE;
899: l_cle_start_date OKC_K_LINES_B.START_DATE%TYPE;
900: l_cle_end_date OKC_K_LINES_B.END_DATE%TYPE;
901: l_clev_rec OKL_OKC_MIGRATION_PVT.clev_rec_type;

Line 1583: p_chr_id IN OKC_K_HEADERS_B.ID%TYPE,

1579: p_init_msg_list IN VARCHAR2,
1580: x_return_status OUT NOCOPY VARCHAR2,
1581: x_msg_count OUT NOCOPY NUMBER,
1582: x_msg_data OUT NOCOPY VARCHAR2,
1583: p_chr_id IN OKC_K_HEADERS_B.ID%TYPE,
1584: p_new_chr_id IN OKC_K_HEADERS_B.ID%TYPE,
1585: p_reason_code IN VARCHAR2,
1586: p_description IN VARCHAR2,
1587: p_trx_date IN DATE,

Line 1584: p_new_chr_id IN OKC_K_HEADERS_B.ID%TYPE,

1580: x_return_status OUT NOCOPY VARCHAR2,
1581: x_msg_count OUT NOCOPY NUMBER,
1582: x_msg_data OUT NOCOPY VARCHAR2,
1583: p_chr_id IN OKC_K_HEADERS_B.ID%TYPE,
1584: p_new_chr_id IN OKC_K_HEADERS_B.ID%TYPE,
1585: p_reason_code IN VARCHAR2,
1586: p_description IN VARCHAR2,
1587: p_trx_date IN DATE,
1588: p_source_trx_id IN NUMBER,

Line 1596: CURSOR con_header_csr (p_chr_id OKC_K_HEADERS_B.ID%TYPE) IS

1592: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1593: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_RELEASE_TRANSACTION';
1594: l_api_version CONSTANT NUMBER := 1.0;
1595:
1596: CURSOR con_header_csr (p_chr_id OKC_K_HEADERS_B.ID%TYPE) IS
1597: SELECT currency_code,
1598: authoring_org_id
1599: FROM okc_k_headers_b
1600: WHERE id = p_chr_id;

Line 1599: FROM okc_k_headers_b

1595:
1596: CURSOR con_header_csr (p_chr_id OKC_K_HEADERS_B.ID%TYPE) IS
1597: SELECT currency_code,
1598: authoring_org_id
1599: FROM okc_k_headers_b
1600: WHERE id = p_chr_id;
1601:
1602: CURSOR try_csr(p_trx_type_name VARCHAR2) IS
1603: SELECT id

Line 1612: l_currency_code okc_k_headers_b.currency_code%TYPE;

1608: l_dummy VARCHAR2(1);
1609: l_try_id NUMBER;
1610: l_tcnv_rec tcnv_rec_type;
1611: l_out_tcnv_rec tcnv_rec_type;
1612: l_currency_code okc_k_headers_b.currency_code%TYPE;
1613: l_org_id okc_k_headers_b.authoring_org_id%TYPE;
1614:
1615: --Added by dpsingh for LE uptake
1616: CURSOR contract_num_csr (p_ctr_id1 NUMBER) IS

Line 1613: l_org_id okc_k_headers_b.authoring_org_id%TYPE;

1609: l_try_id NUMBER;
1610: l_tcnv_rec tcnv_rec_type;
1611: l_out_tcnv_rec tcnv_rec_type;
1612: l_currency_code okc_k_headers_b.currency_code%TYPE;
1613: l_org_id okc_k_headers_b.authoring_org_id%TYPE;
1614:
1615: --Added by dpsingh for LE uptake
1616: CURSOR contract_num_csr (p_ctr_id1 NUMBER) IS
1617: SELECT contract_number

Line 1618: FROM OKC_K_HEADERS_B

1614:
1615: --Added by dpsingh for LE uptake
1616: CURSOR contract_num_csr (p_ctr_id1 NUMBER) IS
1617: SELECT contract_number
1618: FROM OKC_K_HEADERS_B
1619: WHERE id = p_ctr_id1;
1620:
1621: l_cntrct_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE;
1622: l_legal_entity_id NUMBER;

Line 1621: l_cntrct_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE;

1617: SELECT contract_number
1618: FROM OKC_K_HEADERS_B
1619: WHERE id = p_ctr_id1;
1620:
1621: l_cntrct_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE;
1622: l_legal_entity_id NUMBER;
1623:
1624: BEGIN
1625: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

Line 1866: okc_k_headers_b chr

1862: p_chr_id IN NUMBER) is
1863: SELECT 'Y'
1864: FROM okx_cust_site_uses_v site_use,
1865: hz_cust_acct_sites_all site,
1866: okc_k_headers_b chr
1867: WHERE chr.id = p_chr_id
1868: AND site.cust_acct_site_id = site_use.cust_acct_site_id
1869: AND site_use.party_id = p_party_id
1870: AND site_use.id1 = p_bill_to_site_id

Line 1884: okc_k_headers_b chr

1880: p_cust_acc_id IN NUMBER,
1881: p_chr_id IN NUMBER) is
1882: SELECT 'Y'
1883: FROM okx_rcpt_method_accounts_v rma,
1884: okc_k_headers_b chr
1885: WHERE chr.id = p_chr_id
1886: AND rma.id1 = p_bank_acc_id
1887: AND rma.customer_id = p_cust_acc_id
1888: AND rma.org_id = chr.authoring_org_id

Line 1913: FROM okc_k_headers_b chr

1909: AND NVL(end_date,TRUNC(SYSDATE));
1910:
1911: CURSOR chk_mla_csr(p_mla_id IN NUMBER) is
1912: SELECT 'Y'
1913: FROM okc_k_headers_b chr
1914: WHERE chr.id = p_mla_id
1915: AND chr.scs_code = 'MASTER_LEASE'
1916: AND chr.sts_code = 'ACTIVE'
1917: AND chr.template_yn = 'N'

Line 1926: okc_k_headers_b chr

1922: p_cust_acct_id IN NUMBER,
1923: p_currency_code IN VARCHAR2) is
1924: SELECT 'Y'
1925: FROM okl_k_hdr_crdtln_uv crd,
1926: okc_k_headers_b chr
1927: WHERE crd.id = p_credit_line_id
1928: AND chr.id = crd.id
1929: AND crd.end_date >= p_release_date
1930: AND crd.cust_object1_id1 = p_cust_id

Line 2264: FROM okc_k_headers_b chr,

2260: --Bug# 4173345
2261: chr.orig_system_source_code,
2262: --Bug# 4631549
2263: chr.currency_code
2264: FROM okc_k_headers_b chr,
2265: okl_k_headers khr
2266: WHERE chr.id = p_chr_id
2267: AND chr.id = khr.id;
2268:

Line 2299: okc_k_headers_b chr,

2295: IS
2296: SELECT fin_ast_cle.id,
2297: fin_ast_cle.name
2298: FROM okc_k_lines_v fin_ast_cle,
2299: okc_k_headers_b chr,
2300: okc_line_styles_b fin_ast_lse,
2301: okl_trx_quotes_b qte,
2302: okl_txl_quote_lines_b tql
2303: WHERE chr.id = p_orig_chr_id

Line 2342: okc_k_headers_b chr,

2338: IS
2339: SELECT fin_ast_cle.id,
2340: fin_ast_cle.name
2341: FROM okc_k_lines_v fin_ast_cle,
2342: okc_k_headers_b chr,
2343: okc_line_styles_b fin_ast_lse,
2344: okl_trx_assets ota,
2345: okl_txl_assets_b otl
2346: WHERE chr.id = p_orig_chr_id

Line 2435: okc_k_headers_b chrb

2431: cleb.id new_cle_id
2432: From
2433: okc_k_lines_b cleb,
2434: okl_k_lines kle,
2435: okc_k_headers_b chrb
2436: where kle.id = cleb.id
2437: and cleb.dnz_chr_id = chrb.id
2438: and cleb.lse_id = 33 --financial asset line
2439: and cleb.sts_code = 'APPROVED'

Line 2514: from okc_k_headers_b

2510:
2511: --cursor to fetch new contract currency
2512: cursor l_new_chr_hdr_csr (p_chr_id in number) is
2513: select currency_code
2514: from okc_k_headers_b
2515: where id = p_chr_id;
2516:
2517: l_new_chr_hdr_rec l_new_chr_hdr_csr%ROWTYPE;
2518: --End Bug# 4631549

Line 2550: okc_k_headers_b oks,

2546:
2547: cursor l_ubb_contract_csr(p_orig_chr_id number) IS
2548: SELECT oks.date_terminated,sts.ste_code
2549: FROM okc_k_rel_objs_v krelobj ,
2550: okc_k_headers_b oks,
2551: okc_statuses_b sts
2552: WHERE krelobj.JTOT_OBJECT1_CODE = 'OKL_SERVICE'
2553: AND krelobj.RTY_CODE = 'OKLUBB'
2554: and krelobj.OBJECT1_ID1 = oks.id

Line 3166: FROM okc_k_headers_b chr,

3162: khr.deal_type,
3163: sts_code,
3164: --Bug# 5005869
3165: chr.currency_code
3166: FROM okc_k_headers_b chr,
3167: okl_k_headers khr
3168: WHERE chr.id = p_chr_id
3169: AND chr.id = khr.id;
3170:

Line 3187: CURSOR chk_usage_csr(p_chr_id OKC_K_HEADERS_B.ID%TYPE)

3183: AND crg.dnz_chr_id = p_chr_id;
3184:
3185: rul_rec rul_csr%ROWTYPE;
3186:
3187: CURSOR chk_usage_csr(p_chr_id OKC_K_HEADERS_B.ID%TYPE)
3188: IS
3189: SELECT 'Y'
3190: FROM okc_k_lines_b cle,
3191: okc_line_styles_b lse

Line 3222: okc_k_headers_b chr,

3218: IS
3219: SELECT fin_ast_cle.id,
3220: fin_ast_cle.name
3221: FROM okc_k_lines_v fin_ast_cle,
3222: okc_k_headers_b chr,
3223: okc_line_styles_b fin_ast_lse
3224: WHERE chr.id = p_orig_chr_id
3225: AND fin_ast_cle.chr_id = chr.id
3226: AND fin_ast_cle.dnz_chr_id = chr.id

Line 4277: CURSOR curr_hdr_csr (p_chr_id OKC_K_HEADERS_B.ID%TYPE) IS

4273: l_rlvr_sub_amt NUMBER;
4274: l_rlvr_sub_total NUMBER;
4275: l_sum NUMBER;
4276:
4277: CURSOR curr_hdr_csr (p_chr_id OKC_K_HEADERS_B.ID%TYPE) IS
4278: SELECT currency_code
4279: FROM okc_k_headers_b
4280: WHERE id = p_chr_id;
4281:

Line 4279: FROM okc_k_headers_b

4275: l_sum NUMBER;
4276:
4277: CURSOR curr_hdr_csr (p_chr_id OKC_K_HEADERS_B.ID%TYPE) IS
4278: SELECT currency_code
4279: FROM okc_k_headers_b
4280: WHERE id = p_chr_id;
4281:
4282: l_currency_code OKC_K_LINES_B.CURRENCY_CODE%TYPE;
4283:

Line 5424: CURSOR curr_hdr_csr (p_chr_id OKC_K_HEADERS_B.ID%TYPE) IS

5420: WHERE cle.cle_id = p_cle_id
5421: AND cle.dnz_chr_id = p_chr_id
5422: AND cle.id = kle.id;
5423:
5424: CURSOR curr_hdr_csr (p_chr_id OKC_K_HEADERS_B.ID%TYPE) IS
5425: SELECT currency_code
5426: FROM okc_k_headers_b
5427: WHERE id = p_chr_id;
5428:

Line 5426: FROM okc_k_headers_b

5422: AND cle.id = kle.id;
5423:
5424: CURSOR curr_hdr_csr (p_chr_id OKC_K_HEADERS_B.ID%TYPE) IS
5425: SELECT currency_code
5426: FROM okc_k_headers_b
5427: WHERE id = p_chr_id;
5428:
5429: l_currency_code OKC_K_LINES_B.CURRENCY_CODE%TYPE;
5430:

Line 6085: CURSOR curr_hdr_csr (p_chr_id OKC_K_HEADERS_B.ID%TYPE) IS

6081: AND rgp.rgd_code = 'LALEVL'
6082: AND sll.rule_information_category = 'LASLL'
6083: AND sll.rgp_id = rgp.id;
6084:
6085: CURSOR curr_hdr_csr (p_chr_id OKC_K_HEADERS_B.ID%TYPE) IS
6086: SELECT currency_code
6087: FROM okc_k_headers_b
6088: WHERE id = p_chr_id;
6089:

Line 6087: FROM okc_k_headers_b

6083: AND sll.rgp_id = rgp.id;
6084:
6085: CURSOR curr_hdr_csr (p_chr_id OKC_K_HEADERS_B.ID%TYPE) IS
6086: SELECT currency_code
6087: FROM okc_k_headers_b
6088: WHERE id = p_chr_id;
6089:
6090: l_currency_code OKC_K_LINES_B.CURRENCY_CODE%TYPE;
6091:

Line 6701: CURSOR curr_hdr_csr (p_chr_id OKC_K_HEADERS_B.ID%TYPE) IS

6697: lp_klev_temp_rec okl_kle_pvt.klev_rec_type;
6698: lp_clev_temp_rec okl_okc_migration_pvt.clev_rec_type;
6699:
6700: --Bug# 3950089
6701: CURSOR curr_hdr_csr (p_chr_id OKC_K_HEADERS_B.ID%TYPE) IS
6702: SELECT currency_code
6703: FROM okc_k_headers_b
6704: WHERE id = p_chr_id;
6705:

Line 6703: FROM okc_k_headers_b

6699:
6700: --Bug# 3950089
6701: CURSOR curr_hdr_csr (p_chr_id OKC_K_HEADERS_B.ID%TYPE) IS
6702: SELECT currency_code
6703: FROM okc_k_headers_b
6704: WHERE id = p_chr_id;
6705:
6706: l_currency_code OKC_K_LINES_B.CURRENCY_CODE%TYPE;
6707:

Line 7234: FROM okc_k_headers_b chr

7230: FROM okc_governances gve
7231: WHERE chr_id = p_chr_id
7232: AND dnz_chr_id = p_chr_id
7233: AND EXISTS (SELECT 1
7234: FROM okc_k_headers_b chr
7235: WHERE chr.id = gve.chr_id_referred
7236: AND chr.scs_code = p_scs_code);
7237:
7238: governance_rec governance_csr%ROWTYPE;

Line 7854: p_chr_id IN OKC_K_HEADERS_B.ID%TYPE,

7850: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
7851: x_return_status OUT NOCOPY VARCHAR2,
7852: x_msg_count OUT NOCOPY NUMBER,
7853: x_msg_data OUT NOCOPY VARCHAR2,
7854: p_chr_id IN OKC_K_HEADERS_B.ID%TYPE,
7855: p_release_reason_code IN VARCHAR2,
7856: p_release_description IN VARCHAR2,
7857: p_trx_date IN DATE,
7858: p_source_trx_id IN NUMBER,

Line 7861: x_release_chr_id OUT NOCOPY OKC_K_HEADERS_B.ID%TYPE)

7857: p_trx_date IN DATE,
7858: p_source_trx_id IN NUMBER,
7859: p_source_trx_type IN VARCHAR2,
7860: x_tcnv_rec OUT NOCOPY tcnv_rec_type,
7861: x_release_chr_id OUT NOCOPY OKC_K_HEADERS_B.ID%TYPE)
7862: IS
7863: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_RELEASE_CONTRACT';
7864: l_chrv_rec chrv_rec_type;
7865: l_khrv_rec khrv_rec_type;

Line 7876: CURSOR c_fetch_header_line_id(p_chr_id OKC_K_HEADERS_B.ID%TYPE)

7872: lt_top_line_tbl g_top_line_tbl;
7873: lt_asset_num_tbl g_asset_num_tbl;
7874: l_return_status VARCHAR2(3) := OKL_API.G_RET_STS_SUCCESS;
7875:
7876: CURSOR c_fetch_header_line_id(p_chr_id OKC_K_HEADERS_B.ID%TYPE)
7877: IS
7878: SELECT chr.id,
7879: chr.contract_number,
7880: chr.end_date,

Line 7883: FROM OKC_K_HEADERS_B chr,

7879: chr.contract_number,
7880: chr.end_date,
7881: st.ste_code sts_code,
7882: chr.authoring_org_id
7883: FROM OKC_K_HEADERS_B chr,
7884: okc_statuses_b st
7885: WHERE chr.id = p_chr_id
7886: and st.code = chr.sts_code;
7887:

Line 7888: l_new_contract_number okc_k_headers_b.contract_number%TYPE;

7884: okc_statuses_b st
7885: WHERE chr.id = p_chr_id
7886: and st.code = chr.sts_code;
7887:
7888: l_new_contract_number okc_k_headers_b.contract_number%TYPE;
7889: x_new_chrv_rec chrv_rec_type;
7890: x_new_khrv_rec khrv_rec_type;
7891:
7892: CURSOR taa_request_dtl_csr(p_source_trx_id IN NUMBER)

Line 8387: p_chr_id IN OKC_K_HEADERS_B.ID%TYPE) IS

8383: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
8384: x_return_status OUT NOCOPY VARCHAR2,
8385: x_msg_count OUT NOCOPY NUMBER,
8386: x_msg_data OUT NOCOPY VARCHAR2,
8387: p_chr_id IN OKC_K_HEADERS_B.ID%TYPE) IS
8388: l_api_name VARCHAR2(35) := 'ACTIVATE_RELEASE_CONTRACT';
8389: l_proc_name VARCHAR2(35) := 'ACTIVATE_RELEASE_CONTRACT';
8390: ln_orig_system_source_code OKC_K_HEADERS_B.ORIG_SYSTEM_SOURCE_CODE%TYPE;
8391: ln_orig_system_id1 OKC_K_HEADERS_B.ORIG_SYSTEM_ID1%TYPE;

Line 8390: ln_orig_system_source_code OKC_K_HEADERS_B.ORIG_SYSTEM_SOURCE_CODE%TYPE;

8386: x_msg_data OUT NOCOPY VARCHAR2,
8387: p_chr_id IN OKC_K_HEADERS_B.ID%TYPE) IS
8388: l_api_name VARCHAR2(35) := 'ACTIVATE_RELEASE_CONTRACT';
8389: l_proc_name VARCHAR2(35) := 'ACTIVATE_RELEASE_CONTRACT';
8390: ln_orig_system_source_code OKC_K_HEADERS_B.ORIG_SYSTEM_SOURCE_CODE%TYPE;
8391: ln_orig_system_id1 OKC_K_HEADERS_B.ORIG_SYSTEM_ID1%TYPE;
8392: ln_orig_contract_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE;
8393: l_cimv_rec cimv_rec_type;
8394: lx_cimv_rec cimv_rec_type;

Line 8391: ln_orig_system_id1 OKC_K_HEADERS_B.ORIG_SYSTEM_ID1%TYPE;

8387: p_chr_id IN OKC_K_HEADERS_B.ID%TYPE) IS
8388: l_api_name VARCHAR2(35) := 'ACTIVATE_RELEASE_CONTRACT';
8389: l_proc_name VARCHAR2(35) := 'ACTIVATE_RELEASE_CONTRACT';
8390: ln_orig_system_source_code OKC_K_HEADERS_B.ORIG_SYSTEM_SOURCE_CODE%TYPE;
8391: ln_orig_system_id1 OKC_K_HEADERS_B.ORIG_SYSTEM_ID1%TYPE;
8392: ln_orig_contract_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE;
8393: l_cimv_rec cimv_rec_type;
8394: lx_cimv_rec cimv_rec_type;
8395: l_trxv_rec trxv_rec_type;

Line 8392: ln_orig_contract_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE;

8388: l_api_name VARCHAR2(35) := 'ACTIVATE_RELEASE_CONTRACT';
8389: l_proc_name VARCHAR2(35) := 'ACTIVATE_RELEASE_CONTRACT';
8390: ln_orig_system_source_code OKC_K_HEADERS_B.ORIG_SYSTEM_SOURCE_CODE%TYPE;
8391: ln_orig_system_id1 OKC_K_HEADERS_B.ORIG_SYSTEM_ID1%TYPE;
8392: ln_orig_contract_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE;
8393: l_cimv_rec cimv_rec_type;
8394: lx_cimv_rec cimv_rec_type;
8395: l_trxv_rec trxv_rec_type;
8396: lx_trxv_rec trxv_rec_type;

Line 8398: ln_new_contract_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE;

8394: lx_cimv_rec cimv_rec_type;
8395: l_trxv_rec trxv_rec_type;
8396: lx_trxv_rec trxv_rec_type;
8397: --Bug# 4072796
8398: ln_new_contract_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE;
8399:
8400: -- To get the orig system id for p_chr_id
8401: CURSOR get_orig_sys_code(p_chr_id OKC_K_HEADERS_B.ID%TYPE) IS
8402: SELECT chr_new.orig_system_source_code,

Line 8401: CURSOR get_orig_sys_code(p_chr_id OKC_K_HEADERS_B.ID%TYPE) IS

8397: --Bug# 4072796
8398: ln_new_contract_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE;
8399:
8400: -- To get the orig system id for p_chr_id
8401: CURSOR get_orig_sys_code(p_chr_id OKC_K_HEADERS_B.ID%TYPE) IS
8402: SELECT chr_new.orig_system_source_code,
8403: chr_new.orig_system_id1,
8404: chr_old.contract_number,
8405: --Bug# 4072796

Line 8407: FROM okc_k_headers_b chr_new,

8403: chr_new.orig_system_id1,
8404: chr_old.contract_number,
8405: --Bug# 4072796
8406: chr_new.contract_number
8407: FROM okc_k_headers_b chr_new,
8408: okc_k_headers_b chr_old
8409: WHERE chr_new.id = p_chr_id
8410: AND chr_old.id = chr_new.orig_system_id1;
8411:

Line 8408: okc_k_headers_b chr_old

8404: chr_old.contract_number,
8405: --Bug# 4072796
8406: chr_new.contract_number
8407: FROM okc_k_headers_b chr_new,
8408: okc_k_headers_b chr_old
8409: WHERE chr_new.id = p_chr_id
8410: AND chr_old.id = chr_new.orig_system_id1;
8411:
8412: -- To get the orig system id for Fixed Asset lines of p_chr_id

Line 8413: CURSOR get_orig_fa(p_chr_id OKC_K_HEADERS_B.ID%TYPE) IS

8409: WHERE chr_new.id = p_chr_id
8410: AND chr_old.id = chr_new.orig_system_id1;
8411:
8412: -- To get the orig system id for Fixed Asset lines of p_chr_id
8413: CURSOR get_orig_fa(p_chr_id OKC_K_HEADERS_B.ID%TYPE) IS
8414: SELECT cle.orig_system_id1 orig_cle_fa,
8415: cle.id id
8416: FROM OKC_K_LINES_B cle,
8417: OKC_LINE_STYLES_B lse

Line 8423: CURSOR get_orig_ib(p_chr_id OKC_K_HEADERS_B.ID%TYPE) IS

8419: AND cle.lse_id = lse.id
8420: AND lse.lty_code = 'FIXED_ASSET';
8421:
8422: -- To get the orig system id for Install Base lines of p_chr_id
8423: CURSOR get_orig_ib(p_chr_id OKC_K_HEADERS_B.ID%TYPE) IS
8424: SELECT cle.orig_system_id1 orig_cle_ib,
8425: cle.id id
8426: FROM OKC_K_LINES_B cle,
8427: OKC_LINE_STYLES_B lse

Line 8433: CURSOR get_item_info(p_orig_chr_id OKC_K_HEADERS_B.ID%TYPE,

8429: AND cle.lse_id = lse.id
8430: AND lse.lty_code = 'INST_ITEM';
8431:
8432: -- To get the item information from original line id and original contract id
8433: CURSOR get_item_info(p_orig_chr_id OKC_K_HEADERS_B.ID%TYPE,
8434: p_orig_cle_id OKC_K_LINES_B.ID%TYPE) IS
8435: SELECT object1_id1,
8436: object1_id2
8437: FROM okc_k_items