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 899: l_chr_id OKC_K_HEADERS_B.ID%TYPE;

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

Line 1604: p_chr_id IN OKC_K_HEADERS_B.ID%TYPE,

1600: p_init_msg_list IN VARCHAR2,
1601: x_return_status OUT NOCOPY VARCHAR2,
1602: x_msg_count OUT NOCOPY NUMBER,
1603: x_msg_data OUT NOCOPY VARCHAR2,
1604: p_chr_id IN OKC_K_HEADERS_B.ID%TYPE,
1605: p_new_chr_id IN OKC_K_HEADERS_B.ID%TYPE,
1606: p_reason_code IN VARCHAR2,
1607: p_description IN VARCHAR2,
1608: p_trx_date IN DATE,

Line 1605: p_new_chr_id IN OKC_K_HEADERS_B.ID%TYPE,

1601: x_return_status OUT NOCOPY VARCHAR2,
1602: x_msg_count OUT NOCOPY NUMBER,
1603: x_msg_data OUT NOCOPY VARCHAR2,
1604: p_chr_id IN OKC_K_HEADERS_B.ID%TYPE,
1605: p_new_chr_id IN OKC_K_HEADERS_B.ID%TYPE,
1606: p_reason_code IN VARCHAR2,
1607: p_description IN VARCHAR2,
1608: p_trx_date IN DATE,
1609: p_source_trx_id IN NUMBER,

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

1613: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1614: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_RELEASE_TRANSACTION';
1615: l_api_version CONSTANT NUMBER := 1.0;
1616:
1617: CURSOR con_header_csr (p_chr_id OKC_K_HEADERS_B.ID%TYPE) IS
1618: SELECT currency_code,
1619: authoring_org_id
1620: FROM okc_k_headers_b
1621: WHERE id = p_chr_id;

Line 1620: FROM okc_k_headers_b

1616:
1617: CURSOR con_header_csr (p_chr_id OKC_K_HEADERS_B.ID%TYPE) IS
1618: SELECT currency_code,
1619: authoring_org_id
1620: FROM okc_k_headers_b
1621: WHERE id = p_chr_id;
1622:
1623: CURSOR try_csr(p_trx_type_name VARCHAR2) IS
1624: SELECT id

Line 1633: l_currency_code okc_k_headers_b.currency_code%TYPE;

1629: l_dummy VARCHAR2(1);
1630: l_try_id NUMBER;
1631: l_tcnv_rec tcnv_rec_type;
1632: l_out_tcnv_rec tcnv_rec_type;
1633: l_currency_code okc_k_headers_b.currency_code%TYPE;
1634: l_org_id okc_k_headers_b.authoring_org_id%TYPE;
1635:
1636: --Added by dpsingh for LE uptake
1637: CURSOR contract_num_csr (p_ctr_id1 NUMBER) IS

Line 1634: l_org_id okc_k_headers_b.authoring_org_id%TYPE;

1630: l_try_id NUMBER;
1631: l_tcnv_rec tcnv_rec_type;
1632: l_out_tcnv_rec tcnv_rec_type;
1633: l_currency_code okc_k_headers_b.currency_code%TYPE;
1634: l_org_id okc_k_headers_b.authoring_org_id%TYPE;
1635:
1636: --Added by dpsingh for LE uptake
1637: CURSOR contract_num_csr (p_ctr_id1 NUMBER) IS
1638: SELECT contract_number

Line 1639: FROM OKC_K_HEADERS_B

1635:
1636: --Added by dpsingh for LE uptake
1637: CURSOR contract_num_csr (p_ctr_id1 NUMBER) IS
1638: SELECT contract_number
1639: FROM OKC_K_HEADERS_B
1640: WHERE id = p_ctr_id1;
1641:
1642: l_cntrct_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE;
1643: l_legal_entity_id NUMBER;

Line 1642: l_cntrct_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE;

1638: SELECT contract_number
1639: FROM OKC_K_HEADERS_B
1640: WHERE id = p_ctr_id1;
1641:
1642: l_cntrct_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE;
1643: l_legal_entity_id NUMBER;
1644:
1645: BEGIN
1646: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

Line 1887: okc_k_headers_b chr

1883: p_chr_id IN NUMBER) is
1884: SELECT 'Y'
1885: FROM okx_cust_site_uses_v site_use,
1886: hz_cust_acct_sites_all site,
1887: okc_k_headers_b chr
1888: WHERE chr.id = p_chr_id
1889: AND site.cust_acct_site_id = site_use.cust_acct_site_id
1890: AND site_use.party_id = p_party_id
1891: AND site_use.id1 = p_bill_to_site_id

Line 1905: okc_k_headers_b chr

1901: p_cust_acc_id IN NUMBER,
1902: p_chr_id IN NUMBER) is
1903: SELECT 'Y'
1904: FROM okx_rcpt_method_accounts_v rma,
1905: okc_k_headers_b chr
1906: WHERE chr.id = p_chr_id
1907: AND rma.id1 = p_bank_acc_id
1908: AND rma.customer_id = p_cust_acc_id
1909: --Commented and added by jjuneja for Bug #14211467

Line 1937: FROM okc_k_headers_b chr

1933: AND NVL(end_date,TRUNC(SYSDATE));
1934:
1935: CURSOR chk_mla_csr(p_mla_id IN NUMBER) is
1936: SELECT 'Y'
1937: FROM okc_k_headers_b chr
1938: WHERE chr.id = p_mla_id
1939: AND chr.scs_code = 'MASTER_LEASE'
1940: AND chr.sts_code = 'ACTIVE'
1941: AND chr.template_yn = 'N'

Line 1950: okc_k_headers_b chr

1946: p_cust_acct_id IN NUMBER,
1947: p_currency_code IN VARCHAR2) is
1948: SELECT 'Y'
1949: FROM okl_k_hdr_crdtln_uv crd,
1950: okc_k_headers_b chr
1951: WHERE crd.id = p_credit_line_id
1952: AND chr.id = crd.id
1953: AND crd.end_date >= p_release_date
1954: AND crd.cust_object1_id1 = p_cust_id

Line 2288: FROM okc_k_headers_b chr,

2284: --Bug# 4173345
2285: chr.orig_system_source_code,
2286: --Bug# 4631549
2287: chr.currency_code
2288: FROM okc_k_headers_b chr,
2289: okl_k_headers khr
2290: WHERE chr.id = p_chr_id
2291: AND chr.id = khr.id;
2292:

Line 2323: okc_k_headers_b chr,

2319: IS
2320: SELECT fin_ast_cle.id,
2321: fin_ast_cle.name
2322: FROM okc_k_lines_v fin_ast_cle,
2323: okc_k_headers_b chr,
2324: okc_line_styles_b fin_ast_lse,
2325: okl_trx_quotes_b qte,
2326: okl_txl_quote_lines_b tql
2327: WHERE chr.id = p_orig_chr_id

Line 2366: okc_k_headers_b chr,

2362: IS
2363: SELECT fin_ast_cle.id,
2364: fin_ast_cle.name
2365: FROM okc_k_lines_v fin_ast_cle,
2366: okc_k_headers_b chr,
2367: okc_line_styles_b fin_ast_lse,
2368: okl_trx_assets ota,
2369: okl_txl_assets_b otl
2370: WHERE chr.id = p_orig_chr_id

Line 2459: okc_k_headers_b chrb

2455: cleb.id new_cle_id
2456: From
2457: okc_k_lines_b cleb,
2458: okl_k_lines kle,
2459: okc_k_headers_b chrb
2460: where kle.id = cleb.id
2461: and cleb.dnz_chr_id = chrb.id
2462: and cleb.lse_id = 33 --financial asset line
2463: and cleb.sts_code = 'APPROVED'

Line 2538: from okc_k_headers_b

2534:
2535: --cursor to fetch new contract currency
2536: cursor l_new_chr_hdr_csr (p_chr_id in number) is
2537: select currency_code
2538: from okc_k_headers_b
2539: where id = p_chr_id;
2540:
2541: l_new_chr_hdr_rec l_new_chr_hdr_csr%ROWTYPE;
2542: --End Bug# 4631549

Line 2574: okc_k_headers_b oks,

2570:
2571: cursor l_ubb_contract_csr(p_orig_chr_id number) IS
2572: SELECT oks.date_terminated,sts.ste_code
2573: FROM okc_k_rel_objs_v krelobj ,
2574: okc_k_headers_b oks,
2575: okc_statuses_b sts
2576: WHERE krelobj.JTOT_OBJECT1_CODE = 'OKL_SERVICE'
2577: AND krelobj.RTY_CODE = 'OKLUBB'
2578: and krelobj.OBJECT1_ID1 = oks.id

Line 2595: OKC_K_HEADERS_B CN

2591: FROM AR_PAYMENT_SCHEDULES_ALL PS,
2592: OKL_CNSLD_AR_STRMS_B ST,
2593: OKL_CNSLD_AR_LINES_B LN,
2594: OKL_CNSLD_AR_HDRS_B HD,
2595: OKC_K_HEADERS_B CN
2596: WHERE PS.CLASS = 'INV'
2597: AND ST.RECEIVABLES_INVOICE_ID = PS.CUSTOMER_TRX_ID
2598: AND LN.ID = ST.LLN_ID
2599: AND HD.ID = LN.CNR_ID

Line 2609: okc_k_headers_b chr

2605: SELECT max(ractrx.trx_date) INVOICE_DATE
2606: FROM ra_customer_trx_all ractrx,
2607: ra_customer_trx_lines_all ractrl,
2608: ar_payment_schedules_all ps,
2609: okc_k_headers_b chr
2610: WHERE chr.id = p_khr_id
2611: AND chr.contract_number = ractrl.interface_line_attribute6
2612: AND ractrx.customer_trx_id = ractrl.customer_trx_id
2613: AND ractrl.line_type = 'LINE'

Line 3220: FROM okc_k_headers_b chr,

3216: khr.deal_type,
3217: sts_code,
3218: --Bug# 5005869
3219: chr.currency_code
3220: FROM okc_k_headers_b chr,
3221: okl_k_headers khr
3222: WHERE chr.id = p_chr_id
3223: AND chr.id = khr.id;
3224:

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

3237: AND crg.dnz_chr_id = p_chr_id;
3238:
3239: rul_rec rul_csr%ROWTYPE;
3240:
3241: CURSOR chk_usage_csr(p_chr_id OKC_K_HEADERS_B.ID%TYPE)
3242: IS
3243: SELECT 'Y'
3244: FROM okc_k_lines_b cle,
3245: okc_line_styles_b lse

Line 3276: okc_k_headers_b chr,

3272: IS
3273: SELECT fin_ast_cle.id,
3274: fin_ast_cle.name
3275: FROM okc_k_lines_v fin_ast_cle,
3276: okc_k_headers_b chr,
3277: okc_line_styles_b fin_ast_lse
3278: WHERE chr.id = p_orig_chr_id
3279: AND fin_ast_cle.chr_id = chr.id
3280: AND fin_ast_cle.dnz_chr_id = chr.id

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

4333: l_rlvr_sub_amt NUMBER;
4334: l_rlvr_sub_total NUMBER;
4335: l_sum NUMBER;
4336:
4337: CURSOR curr_hdr_csr (p_chr_id OKC_K_HEADERS_B.ID%TYPE) IS
4338: SELECT currency_code
4339: FROM okc_k_headers_b
4340: WHERE id = p_chr_id;
4341:

Line 4339: FROM okc_k_headers_b

4335: l_sum NUMBER;
4336:
4337: CURSOR curr_hdr_csr (p_chr_id OKC_K_HEADERS_B.ID%TYPE) IS
4338: SELECT currency_code
4339: FROM okc_k_headers_b
4340: WHERE id = p_chr_id;
4341:
4342: l_currency_code OKC_K_LINES_B.CURRENCY_CODE%TYPE;
4343:

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

5729: WHERE cle.cle_id = p_cle_id
5730: AND cle.dnz_chr_id = p_chr_id
5731: AND cle.id = kle.id;
5732:
5733: CURSOR curr_hdr_csr (p_chr_id OKC_K_HEADERS_B.ID%TYPE) IS
5734: SELECT currency_code
5735: FROM okc_k_headers_b
5736: WHERE id = p_chr_id;
5737:

Line 5735: FROM okc_k_headers_b

5731: AND cle.id = kle.id;
5732:
5733: CURSOR curr_hdr_csr (p_chr_id OKC_K_HEADERS_B.ID%TYPE) IS
5734: SELECT currency_code
5735: FROM okc_k_headers_b
5736: WHERE id = p_chr_id;
5737:
5738: l_currency_code OKC_K_LINES_B.CURRENCY_CODE%TYPE;
5739:

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

6390: AND rgp.rgd_code = 'LALEVL'
6391: AND sll.rule_information_category = 'LASLL'
6392: AND sll.rgp_id = rgp.id;
6393:
6394: CURSOR curr_hdr_csr (p_chr_id OKC_K_HEADERS_B.ID%TYPE) IS
6395: SELECT currency_code
6396: FROM okc_k_headers_b
6397: WHERE id = p_chr_id;
6398:

Line 6396: FROM okc_k_headers_b

6392: AND sll.rgp_id = rgp.id;
6393:
6394: CURSOR curr_hdr_csr (p_chr_id OKC_K_HEADERS_B.ID%TYPE) IS
6395: SELECT currency_code
6396: FROM okc_k_headers_b
6397: WHERE id = p_chr_id;
6398:
6399: l_currency_code OKC_K_LINES_B.CURRENCY_CODE%TYPE;
6400:

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

7006: lp_klev_temp_rec okl_kle_pvt.klev_rec_type;
7007: lp_clev_temp_rec okl_okc_migration_pvt.clev_rec_type;
7008:
7009: --Bug# 3950089
7010: CURSOR curr_hdr_csr (p_chr_id OKC_K_HEADERS_B.ID%TYPE) IS
7011: SELECT currency_code
7012: FROM okc_k_headers_b
7013: WHERE id = p_chr_id;
7014:

Line 7012: FROM okc_k_headers_b

7008:
7009: --Bug# 3950089
7010: CURSOR curr_hdr_csr (p_chr_id OKC_K_HEADERS_B.ID%TYPE) IS
7011: SELECT currency_code
7012: FROM okc_k_headers_b
7013: WHERE id = p_chr_id;
7014:
7015: l_currency_code OKC_K_LINES_B.CURRENCY_CODE%TYPE;
7016:

Line 7554: FROM okc_k_headers_b chr

7550: FROM okc_governances gve
7551: WHERE chr_id = p_chr_id
7552: AND dnz_chr_id = p_chr_id
7553: AND EXISTS (SELECT 1
7554: FROM okc_k_headers_b chr
7555: WHERE chr.id = gve.chr_id_referred
7556: AND chr.scs_code = p_scs_code);
7557:
7558: governance_rec governance_csr%ROWTYPE;

Line 8178: p_chr_id IN OKC_K_HEADERS_B.ID%TYPE,

8174: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
8175: x_return_status OUT NOCOPY VARCHAR2,
8176: x_msg_count OUT NOCOPY NUMBER,
8177: x_msg_data OUT NOCOPY VARCHAR2,
8178: p_chr_id IN OKC_K_HEADERS_B.ID%TYPE,
8179: p_release_reason_code IN VARCHAR2,
8180: p_release_description IN VARCHAR2,
8181: p_trx_date IN DATE,
8182: p_source_trx_id IN NUMBER,

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

8181: p_trx_date IN DATE,
8182: p_source_trx_id IN NUMBER,
8183: p_source_trx_type IN VARCHAR2,
8184: x_tcnv_rec OUT NOCOPY tcnv_rec_type,
8185: x_release_chr_id OUT NOCOPY OKC_K_HEADERS_B.ID%TYPE)
8186: IS
8187: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_RELEASE_CONTRACT';
8188: l_chrv_rec chrv_rec_type;
8189: l_khrv_rec khrv_rec_type;

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

8196: lt_top_line_tbl g_top_line_tbl;
8197: lt_asset_num_tbl g_asset_num_tbl;
8198: l_return_status VARCHAR2(3) := OKL_API.G_RET_STS_SUCCESS;
8199:
8200: CURSOR c_fetch_header_line_id(p_chr_id OKC_K_HEADERS_B.ID%TYPE)
8201: IS
8202: SELECT chr.id,
8203: chr.contract_number,
8204: chr.end_date,

Line 8207: FROM OKC_K_HEADERS_B chr,

8203: chr.contract_number,
8204: chr.end_date,
8205: st.ste_code sts_code,
8206: chr.authoring_org_id
8207: FROM OKC_K_HEADERS_B chr,
8208: okc_statuses_b st
8209: WHERE chr.id = p_chr_id
8210: and st.code = chr.sts_code;
8211:

Line 8212: l_new_contract_number okc_k_headers_b.contract_number%TYPE;

8208: okc_statuses_b st
8209: WHERE chr.id = p_chr_id
8210: and st.code = chr.sts_code;
8211:
8212: l_new_contract_number okc_k_headers_b.contract_number%TYPE;
8213: x_new_chrv_rec chrv_rec_type;
8214: x_new_khrv_rec khrv_rec_type;
8215:
8216: CURSOR taa_request_dtl_csr(p_source_trx_id IN NUMBER)

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

8712: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
8713: x_return_status OUT NOCOPY VARCHAR2,
8714: x_msg_count OUT NOCOPY NUMBER,
8715: x_msg_data OUT NOCOPY VARCHAR2,
8716: p_chr_id IN OKC_K_HEADERS_B.ID%TYPE) IS
8717: l_api_name VARCHAR2(35) := 'ACTIVATE_RELEASE_CONTRACT';
8718: l_proc_name VARCHAR2(35) := 'ACTIVATE_RELEASE_CONTRACT';
8719: ln_orig_system_source_code OKC_K_HEADERS_B.ORIG_SYSTEM_SOURCE_CODE%TYPE;
8720: ln_orig_system_id1 OKC_K_HEADERS_B.ORIG_SYSTEM_ID1%TYPE;

Line 8719: ln_orig_system_source_code OKC_K_HEADERS_B.ORIG_SYSTEM_SOURCE_CODE%TYPE;

8715: x_msg_data OUT NOCOPY VARCHAR2,
8716: p_chr_id IN OKC_K_HEADERS_B.ID%TYPE) IS
8717: l_api_name VARCHAR2(35) := 'ACTIVATE_RELEASE_CONTRACT';
8718: l_proc_name VARCHAR2(35) := 'ACTIVATE_RELEASE_CONTRACT';
8719: ln_orig_system_source_code OKC_K_HEADERS_B.ORIG_SYSTEM_SOURCE_CODE%TYPE;
8720: ln_orig_system_id1 OKC_K_HEADERS_B.ORIG_SYSTEM_ID1%TYPE;
8721: ln_orig_contract_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE;
8722: l_cimv_rec cimv_rec_type;
8723: lx_cimv_rec cimv_rec_type;

Line 8720: ln_orig_system_id1 OKC_K_HEADERS_B.ORIG_SYSTEM_ID1%TYPE;

8716: p_chr_id IN OKC_K_HEADERS_B.ID%TYPE) IS
8717: l_api_name VARCHAR2(35) := 'ACTIVATE_RELEASE_CONTRACT';
8718: l_proc_name VARCHAR2(35) := 'ACTIVATE_RELEASE_CONTRACT';
8719: ln_orig_system_source_code OKC_K_HEADERS_B.ORIG_SYSTEM_SOURCE_CODE%TYPE;
8720: ln_orig_system_id1 OKC_K_HEADERS_B.ORIG_SYSTEM_ID1%TYPE;
8721: ln_orig_contract_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE;
8722: l_cimv_rec cimv_rec_type;
8723: lx_cimv_rec cimv_rec_type;
8724: l_trxv_rec trxv_rec_type;

Line 8721: ln_orig_contract_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE;

8717: l_api_name VARCHAR2(35) := 'ACTIVATE_RELEASE_CONTRACT';
8718: l_proc_name VARCHAR2(35) := 'ACTIVATE_RELEASE_CONTRACT';
8719: ln_orig_system_source_code OKC_K_HEADERS_B.ORIG_SYSTEM_SOURCE_CODE%TYPE;
8720: ln_orig_system_id1 OKC_K_HEADERS_B.ORIG_SYSTEM_ID1%TYPE;
8721: ln_orig_contract_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE;
8722: l_cimv_rec cimv_rec_type;
8723: lx_cimv_rec cimv_rec_type;
8724: l_trxv_rec trxv_rec_type;
8725: lx_trxv_rec trxv_rec_type;

Line 8727: ln_new_contract_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE;

8723: lx_cimv_rec cimv_rec_type;
8724: l_trxv_rec trxv_rec_type;
8725: lx_trxv_rec trxv_rec_type;
8726: --Bug# 4072796
8727: ln_new_contract_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE;
8728:
8729: -- To get the orig system id for p_chr_id
8730: CURSOR get_orig_sys_code(p_chr_id OKC_K_HEADERS_B.ID%TYPE) IS
8731: SELECT chr_new.orig_system_source_code,

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

8726: --Bug# 4072796
8727: ln_new_contract_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE;
8728:
8729: -- To get the orig system id for p_chr_id
8730: CURSOR get_orig_sys_code(p_chr_id OKC_K_HEADERS_B.ID%TYPE) IS
8731: SELECT chr_new.orig_system_source_code,
8732: chr_new.orig_system_id1,
8733: chr_old.contract_number,
8734: --Bug# 4072796

Line 8736: FROM okc_k_headers_b chr_new,

8732: chr_new.orig_system_id1,
8733: chr_old.contract_number,
8734: --Bug# 4072796
8735: chr_new.contract_number
8736: FROM okc_k_headers_b chr_new,
8737: okc_k_headers_b chr_old
8738: WHERE chr_new.id = p_chr_id
8739: AND chr_old.id = chr_new.orig_system_id1;
8740:

Line 8737: okc_k_headers_b chr_old

8733: chr_old.contract_number,
8734: --Bug# 4072796
8735: chr_new.contract_number
8736: FROM okc_k_headers_b chr_new,
8737: okc_k_headers_b chr_old
8738: WHERE chr_new.id = p_chr_id
8739: AND chr_old.id = chr_new.orig_system_id1;
8740:
8741: -- To get the orig system id for Fixed Asset lines of p_chr_id

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

8738: WHERE chr_new.id = p_chr_id
8739: AND chr_old.id = chr_new.orig_system_id1;
8740:
8741: -- To get the orig system id for Fixed Asset lines of p_chr_id
8742: CURSOR get_orig_fa(p_chr_id OKC_K_HEADERS_B.ID%TYPE) IS
8743: SELECT cle.orig_system_id1 orig_cle_fa,
8744: cle.id id
8745: FROM OKC_K_LINES_B cle,
8746: OKC_LINE_STYLES_B lse

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

8748: AND cle.lse_id = lse.id
8749: AND lse.lty_code = 'FIXED_ASSET';
8750:
8751: -- To get the orig system id for Install Base lines of p_chr_id
8752: CURSOR get_orig_ib(p_chr_id OKC_K_HEADERS_B.ID%TYPE) IS
8753: SELECT cle.orig_system_id1 orig_cle_ib,
8754: cle.id id
8755: FROM OKC_K_LINES_B cle,
8756: OKC_LINE_STYLES_B lse

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

8758: AND cle.lse_id = lse.id
8759: AND lse.lty_code = 'INST_ITEM';
8760:
8761: -- To get the item information from original line id and original contract id
8762: CURSOR get_item_info(p_orig_chr_id OKC_K_HEADERS_B.ID%TYPE,
8763: p_orig_cle_id OKC_K_LINES_B.ID%TYPE) IS
8764: SELECT object1_id1,
8765: object1_id2
8766: FROM okc_k_items