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

Line 101: FROM OKC_K_HEADERS_B

97: ---------------------------------------------------------------------------------------------------------------
98: --Added by dpsingh for LE uptake
99: CURSOR contract_num_csr (p_ctr_id1 NUMBER) IS
100: SELECT contract_number
101: FROM OKC_K_HEADERS_B
102: WHERE id = p_ctr_id1;
103:
104: FUNCTION is_duplicate_serial_number(p_serial_number OKL_TXL_ITM_INSTS.SERIAL_NUMBER%TYPE,
105: p_item_id OKL_TXL_ITM_INSTS.INVENTORY_ITEM_ID%TYPE)

Line 328: x_sts_code OUT NOCOPY OKC_K_HEADERS_B.STS_CODE%TYPE)

324: END generate_asset_number;
325: ----------------------------------------------------------------------------------------------------------
326: FUNCTION get_sts_code(p_dnz_chr_id IN OKC_K_LINES_B.DNZ_CHR_ID%TYPE DEFAULT OKL_API.G_MISS_NUM,
327: p_cle_id IN OKC_K_LINES_B.CLE_ID%TYPE DEFAULT OKL_API.G_MISS_NUM,
328: x_sts_code OUT NOCOPY OKC_K_HEADERS_B.STS_CODE%TYPE)
329: RETURN VARCHAR2 IS
330: x_return_status VARCHAR2(3) := OKL_API.G_RET_STS_SUCCESS;
331: CURSOR c_get_tls_sts_code(p_dnz_chr_id OKC_K_LINES_B.DNZ_CHR_ID%TYPE) IS
332: SELECT chrv.sts_code

Line 440: x_end_date OUT NOCOPY OKC_K_HEADERS_B.END_DATE%TYPE)

436: END get_sts_code;
437: ----------------------------------------------------------------------------------------------------------------
438: FUNCTION get_end_date(p_dnz_chr_id IN OKC_K_LINES_B.DNZ_CHR_ID%TYPE DEFAULT OKL_API.G_MISS_NUM,
439: p_cle_id IN OKC_K_LINES_B.CLE_ID%TYPE DEFAULT OKL_API.G_MISS_NUM,
440: x_end_date OUT NOCOPY OKC_K_HEADERS_B.END_DATE%TYPE)
441: RETURN VARCHAR2 IS
442: x_return_status VARCHAR2(3) := OKL_API.G_RET_STS_SUCCESS;
443: CURSOR c_get_tls_end_date(p_dnz_chr_id OKC_K_LINES_B.DNZ_CHR_ID%TYPE) IS
444: SELECT chrv.end_Date

Line 536: x_start_date OUT NOCOPY OKC_K_HEADERS_B.START_DATE%TYPE)

532: END get_end_date;
533: ----------------------------------------------------------------------------------------------------------------
534: FUNCTION get_start_date(p_dnz_chr_id IN OKC_K_LINES_B.DNZ_CHR_ID%TYPE DEFAULT OKL_API.G_MISS_NUM,
535: p_cle_id IN OKC_K_LINES_B.CLE_ID%TYPE DEFAULT OKL_API.G_MISS_NUM,
536: x_start_date OUT NOCOPY OKC_K_HEADERS_B.START_DATE%TYPE)
537: RETURN VARCHAR2 IS
538: x_return_status VARCHAR2(3) := OKL_API.G_RET_STS_SUCCESS;
539: lv_orig_sys_source_code OKC_K_HEADERS_B.ORIG_SYSTEM_SOURCE_CODE%TYPE;
540: ln_orig_system_id1 OKC_K_HEADERS_B.ORIG_SYSTEM_ID1%TYPE;

Line 539: lv_orig_sys_source_code OKC_K_HEADERS_B.ORIG_SYSTEM_SOURCE_CODE%TYPE;

535: p_cle_id IN OKC_K_LINES_B.CLE_ID%TYPE DEFAULT OKL_API.G_MISS_NUM,
536: x_start_date OUT NOCOPY OKC_K_HEADERS_B.START_DATE%TYPE)
537: RETURN VARCHAR2 IS
538: x_return_status VARCHAR2(3) := OKL_API.G_RET_STS_SUCCESS;
539: lv_orig_sys_source_code OKC_K_HEADERS_B.ORIG_SYSTEM_SOURCE_CODE%TYPE;
540: ln_orig_system_id1 OKC_K_HEADERS_B.ORIG_SYSTEM_ID1%TYPE;
541: ld_start_date OKC_K_LINES_B.START_DATE%TYPE;
542: CURSOR c_get_tls_start_date(p_dnz_chr_id OKC_K_LINES_B.DNZ_CHR_ID%TYPE) IS
543: SELECT chrv.start_Date,

Line 540: ln_orig_system_id1 OKC_K_HEADERS_B.ORIG_SYSTEM_ID1%TYPE;

536: x_start_date OUT NOCOPY OKC_K_HEADERS_B.START_DATE%TYPE)
537: RETURN VARCHAR2 IS
538: x_return_status VARCHAR2(3) := OKL_API.G_RET_STS_SUCCESS;
539: lv_orig_sys_source_code OKC_K_HEADERS_B.ORIG_SYSTEM_SOURCE_CODE%TYPE;
540: ln_orig_system_id1 OKC_K_HEADERS_B.ORIG_SYSTEM_ID1%TYPE;
541: ld_start_date OKC_K_LINES_B.START_DATE%TYPE;
542: CURSOR c_get_tls_start_date(p_dnz_chr_id OKC_K_LINES_B.DNZ_CHR_ID%TYPE) IS
543: SELECT chrv.start_Date,
544: chrv.orig_system_source_code,

Line 655: x_currency_code OUT NOCOPY OKC_K_HEADERS_B.CURRENCY_CODE%TYPE)

651: END get_start_date;
652: ----------------------------------------------------------------------------------------------------------------
653: FUNCTION get_currency_code(p_dnz_chr_id IN OKC_K_LINES_B.DNZ_CHR_ID%TYPE DEFAULT OKL_API.G_MISS_NUM,
654: p_cle_id IN OKC_K_LINES_B.CLE_ID%TYPE DEFAULT OKL_API.G_MISS_NUM,
655: x_currency_code OUT NOCOPY OKC_K_HEADERS_B.CURRENCY_CODE%TYPE)
656: RETURN VARCHAR2 IS
657: x_return_status VARCHAR2(3) := OKL_API.G_RET_STS_SUCCESS;
658: CURSOR c_get_tls_currency_code(p_dnz_chr_id OKC_K_LINES_B.DNZ_CHR_ID%TYPE) IS
659: SELECT chrv.currency_code

Line 763: lv_orig_sys_source_code OKC_K_HEADERS_B.ORIG_SYSTEM_SOURCE_CODE%TYPE;

759: p_cle_id IN OKC_K_LINES_B.CLE_ID%TYPE DEFAULT OKL_API.G_MISS_NUM,
760: p_clev_rec IN OUT NOCOPY clev_rec_type)
761: RETURN VARCHAR2 IS
762: x_return_status VARCHAR2(3) := OKL_API.G_RET_STS_SUCCESS;
763: lv_orig_sys_source_code OKC_K_HEADERS_B.ORIG_SYSTEM_SOURCE_CODE%TYPE;
764: ln_orig_system_id1 OKC_K_HEADERS_B.ORIG_SYSTEM_ID1%TYPE;
765: ld_start_date OKC_K_LINES_B.START_DATE%TYPE;
766: ld_end_date OKC_K_LINES_B.END_DATE%TYPE;
767: lv_currency_code OKC_K_HEADERS_B.CURRENCY_CODE%TYPE;

Line 764: ln_orig_system_id1 OKC_K_HEADERS_B.ORIG_SYSTEM_ID1%TYPE;

760: p_clev_rec IN OUT NOCOPY clev_rec_type)
761: RETURN VARCHAR2 IS
762: x_return_status VARCHAR2(3) := OKL_API.G_RET_STS_SUCCESS;
763: lv_orig_sys_source_code OKC_K_HEADERS_B.ORIG_SYSTEM_SOURCE_CODE%TYPE;
764: ln_orig_system_id1 OKC_K_HEADERS_B.ORIG_SYSTEM_ID1%TYPE;
765: ld_start_date OKC_K_LINES_B.START_DATE%TYPE;
766: ld_end_date OKC_K_LINES_B.END_DATE%TYPE;
767: lv_currency_code OKC_K_HEADERS_B.CURRENCY_CODE%TYPE;
768: lv_sts_code OKC_K_HEADERS_B.STS_CODE%TYPE;

Line 767: lv_currency_code OKC_K_HEADERS_B.CURRENCY_CODE%TYPE;

763: lv_orig_sys_source_code OKC_K_HEADERS_B.ORIG_SYSTEM_SOURCE_CODE%TYPE;
764: ln_orig_system_id1 OKC_K_HEADERS_B.ORIG_SYSTEM_ID1%TYPE;
765: ld_start_date OKC_K_LINES_B.START_DATE%TYPE;
766: ld_end_date OKC_K_LINES_B.END_DATE%TYPE;
767: lv_currency_code OKC_K_HEADERS_B.CURRENCY_CODE%TYPE;
768: lv_sts_code OKC_K_HEADERS_B.STS_CODE%TYPE;
769:
770: CURSOR c_get_contract_header_details(p_dnz_chr_id OKC_K_LINES_B.DNZ_CHR_ID%TYPE) IS
771: SELECT chrv.sts_code,

Line 768: lv_sts_code OKC_K_HEADERS_B.STS_CODE%TYPE;

764: ln_orig_system_id1 OKC_K_HEADERS_B.ORIG_SYSTEM_ID1%TYPE;
765: ld_start_date OKC_K_LINES_B.START_DATE%TYPE;
766: ld_end_date OKC_K_LINES_B.END_DATE%TYPE;
767: lv_currency_code OKC_K_HEADERS_B.CURRENCY_CODE%TYPE;
768: lv_sts_code OKC_K_HEADERS_B.STS_CODE%TYPE;
769:
770: CURSOR c_get_contract_header_details(p_dnz_chr_id OKC_K_LINES_B.DNZ_CHR_ID%TYPE) IS
771: SELECT chrv.sts_code,
772: chrv.end_date,

Line 2492: p_dnz_chr_id IN OKC_K_HEADERS_B.ID%TYPE) IS

2488: -- End of Commnets
2489: PROCEDURE validate_new_ast_num_update(x_return_status OUT NOCOPY VARCHAR2,
2490: p_asset_number IN OKL_TXL_ASSETS_V.ASSET_NUMBER%TYPE,
2491: p_kle_Id IN OKL_TXL_ASSETS_V.KLE_ID%TYPE,
2492: p_dnz_chr_id IN OKC_K_HEADERS_B.ID%TYPE) IS
2493: ln_okl_txl_assets_v NUMBER := 0;
2494: ln_okx_assets_v NUMBER := 0;
2495: ln_okx_asset_lines_v NUMBER := 0;
2496: ln_okl_txd_assets_v NUMBER := 0;

Line 2497: lv_source_code OKC_K_HEADERS_B.ORIG_SYSTEM_SOURCE_CODE%TYPE;

2493: ln_okl_txl_assets_v NUMBER := 0;
2494: ln_okx_assets_v NUMBER := 0;
2495: ln_okx_asset_lines_v NUMBER := 0;
2496: ln_okl_txd_assets_v NUMBER := 0;
2497: lv_source_code OKC_K_HEADERS_B.ORIG_SYSTEM_SOURCE_CODE%TYPE;
2498: lv_asset_source_code OKC_K_LINES_B.ORIG_SYSTEM_SOURCE_CODE%TYPE;
2499: lv_asset_number OKL_TXL_ASSETS_V.ASSET_NUMBER%TYPE;
2500: lv_release_asset OKC_RULES_V.RULE_INFORMATION1%TYPE := 'N';
2501: x_msg_count NUMBER;

Line 2552: FROM okc_k_headers_b chr,

2548: AND TAS.TSU_CODE = 'ENTERED'; --);
2549:
2550: CURSOR c_source_code(p_kle_Id OKL_TXL_ASSETS_V.KLE_ID%TYPE) is
2551: SELECT nvl(chr.orig_system_source_code,'x')
2552: FROM okc_k_headers_b chr,
2553: okc_k_lines_b cle
2554: WHERE cle.id = p_kle_Id
2555: AND cle.dnz_chr_id = chr.id;
2556:

Line 2560: /*CURSOR c_check_release_asset(p_dnz_chr_id OKC_K_HEADERS_B.ID%TYPE) is

2556:
2557: --Bug# 15992711 : The re-leased flag is no longer checked at contract header
2558: -- but needs to be validated at contract line
2559: -- Cursor modified to include validation at asset line level
2560: /*CURSOR c_check_release_asset(p_dnz_chr_id OKC_K_HEADERS_B.ID%TYPE) is
2561: SELECT RULE_INFORMATION1
2562: FROM OKC_RULES_V
2563: WHERE DNZ_CHR_ID = p_dnz_chr_id
2564: AND RULE_INFORMATION_CATEGORY = 'LARLES';*/

Line 3455: FROM OKC_K_HEADERS_B chrv

3451: CURSOR c_dnz_chr_id_validate(p_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS
3452: SELECT 1
3453: --FROM DUAL
3454: --WHERE EXISTS (SELECT 1
3455: FROM OKC_K_HEADERS_B chrv
3456: WHERE chrv.id = p_dnz_chr_id; --);
3457: BEGIN
3458: -- initialize return status
3459: x_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 3550: l_orig_system_source_code okc_k_headers_b.orig_system_source_code%TYPE;

3546: ln3_dummy NUMBER := p_units;
3547: lv_deal_type OKL_K_HEADERS_V.DEAL_TYPE%TYPE := null;
3548: lv_scs_code OKC_K_HEADERS_V.SCS_CODE%TYPE := null;
3549: --Bug# 4419339
3550: l_orig_system_source_code okc_k_headers_b.orig_system_source_code%TYPE;
3551: CURSOR get_deal_type(p_dnz_chr_id OKC_K_LINES_B.DNZ_CHR_ID%TYPE)
3552: IS
3553: SELECT khr.deal_type,
3554: chr.scs_code,

Line 3558: OKC_K_HEADERS_B chr

3554: chr.scs_code,
3555: --Bug# 4419339
3556: chr.orig_system_source_code
3557: FROM OKL_K_HEADERS_V khr,
3558: OKC_K_HEADERS_B chr
3559: WHERE khr.id = p_dnz_chr_id
3560: AND chr.id = khr.id;
3561: BEGIN
3562: IF (p_chr_id <> OKL_API.G_MISS_NUM OR

Line 4216: l_cntrct_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE;

4212: l_trxv_rec trxv_rec_type;
4213: l_talv_rec talv_rec_type;
4214:
4215: --Added by dpsingh for LE uptake
4216: l_cntrct_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE;
4217: l_legal_entity_id NUMBER;
4218:
4219: BEGIN
4220: x_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 4751: FROM okc_k_headers_b CHR,

4747: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_ASSET_COST';
4748:
4749: CURSOR l_chk_rbk_csr(p_chr_id IN NUMBER) is
4750: SELECT '!'
4751: FROM okc_k_headers_b CHR,
4752: okl_trx_contracts ktrx
4753: WHERE ktrx.khr_id_new = chr.id
4754: AND ktrx.tsu_code = 'ENTERED'
4755: AND ktrx.rbr_code is NOT NULL

Line 4918: l_cntrct_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE;

4914: FROM OKC_K_LINES_B
4915: WHERE ID = p_kle_id1;
4916:
4917: l_chr_id NUMBER;
4918: l_cntrct_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE;
4919: l_legal_entity_id NUMBER;
4920:
4921: BEGIN
4922: x_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 8692: FROM okc_k_headers_b CHR,

8688:
8689: --Bug# 8652738
8690: CURSOR l_chk_rbk_csr(p_chr_id IN NUMBER) is
8691: SELECT '!'
8692: FROM okc_k_headers_b CHR,
8693: okl_trx_contracts ktrx
8694: WHERE ktrx.khr_id_new = chr.id
8695: AND ktrx.tsu_code = 'ENTERED'
8696: AND ktrx.rbr_code is NOT NULL

Line 12295: FROM OKC_K_HEADERS_B chrb,

12291: --cursor to get pdt_id and k_start date
12292: cursor l_chr_csr (p_chr_id in number) is
12293: SELECT chrb.start_date,
12294: khr.pdt_id
12295: FROM OKC_K_HEADERS_B chrb,
12296: OKL_K_HEADERS khr
12297: WHERE khr.id = chrb.id
12298: AND chrb.id = p_chr_id;
12299:

Line 12727: FROM okc_k_headers_b chrb,

12723: --Bug# 4869443
12724: chrb.orig_system_source_code,
12725: --Bug# 6328924
12726: khr.legal_entity_id
12727: FROM okc_k_headers_b chrb,
12728: okl_k_headers khr
12729: WHERE chrb.id = p_chr_id
12730: AND khr.id = chrb.id;
12731:

Line 12824: from okc_k_headers_b chrb

12820:
12821: --Bug# 3783518 :
12822: CURSOR l_chk_rbk_csr (p_chr_id in NUMBER) is
12823: select 'Y'
12824: from okc_k_headers_b chrb
12825: where nvl(chrb.orig_system_source_code,'XXXX') = 'OKL_REBOOK'
12826: and chrb.id = p_chr_id;
12827:
12828: l_rbk_yn varchar2(1);

Line 14057: okc_k_headers_b chrb

14053: from fa_additions_b fab,
14054: okl_txl_assets_b txlb,
14055: okc_k_lines_b fa_cleb,
14056: okc_line_styles_b fa_lseb,
14057: okc_k_headers_b chrb
14058: where fab.asset_number = txlb.asset_number
14059: and fab.asset_id = p_asset_id
14060: and txlb.kle_id = fa_cleb.id
14061: and fa_cleb.dnz_chr_id = chrb.id

Line 14069: l_k_source okc_k_headers_b.orig_system_source_code%TYPE;

14065: and chrb.id = p_chr_id
14066: and chrb.orig_system_source_code = 'OKL_REBOOK';
14067:
14068: l_rbk_ast_change_yn varchar2(1);
14069: l_k_source okc_k_headers_b.orig_system_source_code%TYPE;
14070:
14071: BEGIN
14072: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
14073: -- Call start_activity to create savepoint, check compatibility

Line 14641: FROM okc_k_headers_b chr,

14637:
14638: --cursor to check if the contract is undergoing on-line rebook
14639: CURSOR l_chk_rbk_csr(p_chr_id IN NUMBER) is
14640: SELECT '!'
14641: FROM okc_k_headers_b chr,
14642: okl_trx_contracts ktrx
14643: WHERE ktrx.khr_id_new = chr.id
14644: AND ktrx.tsu_code = 'ENTERED'
14645: AND ktrx.rbr_code is NOT NULL

Line 15216: ln_chr_id OKC_K_HEADERS_B.ID%TYPE;

15212: n NUMBER := 0;
15213: p NUMBER := 0;
15214:
15215: -- added by rravikir (Estimated property tax)
15216: ln_chr_id OKC_K_HEADERS_B.ID%TYPE;
15217: ln_cle_id OKL_K_LINES_V.ID%TYPE;
15218: -- end
15219: TYPE instance_id_tbl IS TABLE OF NUMBER
15220: INDEX BY BINARY_INTEGER;

Line 15222: CURSOR c_get_scs_code(p_dnz_chr_id OKC_K_HEADERS_B.ID%TYPE)

15218: -- end
15219: TYPE instance_id_tbl IS TABLE OF NUMBER
15220: INDEX BY BINARY_INTEGER;
15221: lt_instance_id_tbl instance_id_tbl;
15222: CURSOR c_get_scs_code(p_dnz_chr_id OKC_K_HEADERS_B.ID%TYPE)
15223: IS
15224: SELECT scs_code,
15225: --Bug# 4419339
15226: orig_system_source_code

Line 15227: FROM OKC_K_HEADERS_B

15223: IS
15224: SELECT scs_code,
15225: --Bug# 4419339
15226: orig_system_source_code
15227: FROM OKC_K_HEADERS_B
15228: WHERE id = p_dnz_chr_id;
15229:
15230:
15231: --Bug# 4419339

Line 15232: l_orig_system_source_code okc_k_headers_b.orig_system_source_code%TYPE;

15228: WHERE id = p_dnz_chr_id;
15229:
15230:
15231: --Bug# 4419339
15232: l_orig_system_source_code okc_k_headers_b.orig_system_source_code%TYPE;
15233:
15234: CURSOR c_ib_sno_asset(p_asset_number OKL_TXL_ASSETS_B.ASSET_NUMBER%TYPE)
15235: IS
15236: SELECT CII.SERIAL_NUMBER IB_SERIAL_NUMBER,

Line 15262: FROM okc_k_headers_b CHR

15258: -- but needs to be validated at contract line
15259: -- Cursor modified to include validation at asset line level
15260: /*CURSOR l_chk_rel_ast_csr (p_chr_id IN Number) IS
15261: SELECT 'Y'
15262: FROM okc_k_headers_b CHR
15263: WHERE nvl(chr.orig_system_source_code,'XXXX') <> 'OKL_RELEASE'
15264: and chr.ID = p_chr_id
15265: AND exists (SELECT '1'
15266: FROM OKC_RULES_B rul

Line 15274: FROM okc_k_headers_b CHR

15270:
15271: CURSOR l_chk_rel_ast_csr (p_chr_id IN Number
15272: ,p_asset_number IN OKX_ASSETS_V.ASSET_NUMBER%TYPE) IS
15273: SELECT 'Y'
15274: FROM okc_k_headers_b CHR
15275: WHERE nvl(chr.orig_system_source_code,'XXXX') <> 'OKL_RELEASE'
15276: and chr.ID = p_chr_id
15277: AND EXISTS (
15278: SELECT '1'

Line 16440: FROM okc_k_headers_b CHR,

16436: --Bug# 4631549
16437: chr.orig_system_source_code,
16438: chr.orig_system_id1 orig_chr_id,
16439: chr.start_date
16440: FROM okc_k_headers_b CHR,
16441: okc_rules_b rul
16442: WHERE CHR.ID = p_chr_id
16443: AND rul.dnz_chr_id = CHR.id
16444: AND rul.rule_information_category = 'LARLES'

Line 16454: FROM okc_k_headers_b CHR,

16450: --Bug# 4631549
16451: chr.orig_system_source_code,
16452: chr.orig_system_id1 orig_chr_id,
16453: chr.start_date
16454: FROM okc_k_headers_b CHR,
16455: okl_txl_assets_b txlb,
16456: okc_line_styles_b lseb,
16457: okc_k_lines_b cleb_top,
16458: okl_k_lines kle_top

Line 16470: l_orig_system_source_code OKC_K_HEADERS_B.orig_system_source_code%TYPE;

16466: -- Bug# 15992711 : End of Modifications
16467:
16468: l_chk_rel_ast Varchar2(1) default 'N';
16469: --Bug# 4631549
16470: l_orig_system_source_code OKC_K_HEADERS_B.orig_system_source_code%TYPE;
16471: l_orig_chr_id OKC_K_HEADERS_B.ID%TYPE;
16472: l_start_date OKC_K_HEADERS_B.START_DATE%TYPE;
16473:
16474: l_rel_ast_clev_fin_rec clev_rec_type;

Line 16471: l_orig_chr_id OKC_K_HEADERS_B.ID%TYPE;

16467:
16468: l_chk_rel_ast Varchar2(1) default 'N';
16469: --Bug# 4631549
16470: l_orig_system_source_code OKC_K_HEADERS_B.orig_system_source_code%TYPE;
16471: l_orig_chr_id OKC_K_HEADERS_B.ID%TYPE;
16472: l_start_date OKC_K_HEADERS_B.START_DATE%TYPE;
16473:
16474: l_rel_ast_clev_fin_rec clev_rec_type;
16475: l_rel_ast_klev_fin_rec klev_rec_type;

Line 16472: l_start_date OKC_K_HEADERS_B.START_DATE%TYPE;

16468: l_chk_rel_ast Varchar2(1) default 'N';
16469: --Bug# 4631549
16470: l_orig_system_source_code OKC_K_HEADERS_B.orig_system_source_code%TYPE;
16471: l_orig_chr_id OKC_K_HEADERS_B.ID%TYPE;
16472: l_start_date OKC_K_HEADERS_B.START_DATE%TYPE;
16473:
16474: l_rel_ast_clev_fin_rec clev_rec_type;
16475: l_rel_ast_klev_fin_rec klev_rec_type;
16476: l_rel_ast_clev_model_rec clev_rec_type;

Line 16504: FROM okc_k_headers_b CHR,

16500: --Bug# 4899328
16501: --cursor to check if the contract is undergoing on-line rebook
16502: cursor l_chk_rbk_csr(p_chr_id IN NUMBER) is
16503: SELECT '!'
16504: FROM okc_k_headers_b CHR,
16505: okl_trx_contracts ktrx
16506: WHERE ktrx.khr_id_new = chr.id
16507: AND ktrx.tsu_code = 'ENTERED'
16508: AND ktrx.rbr_code is NOT NULL

Line 18221: FROM okc_k_headers_b chr,

18217:
18218: --cursor to check if the contract is undergoing on-line rebook
18219: cursor l_chk_rbk_csr(p_chr_id IN NUMBER) is
18220: SELECT '!'
18221: FROM okc_k_headers_b chr,
18222: okl_trx_contracts ktrx
18223: WHERE ktrx.khr_id_new = chr.id
18224: AND ktrx.tsu_code = 'ENTERED'
18225: AND ktrx.rbr_code is NOT NULL

Line 19265: FROM okc_k_headers_b chr,

19261:
19262: --cursor to check if the contract is undergoing on-line rebook
19263: cursor l_chk_rbk_csr(p_chr_id IN NUMBER) is
19264: SELECT '!'
19265: FROM okc_k_headers_b chr,
19266: okl_trx_contracts ktrx
19267: WHERE ktrx.khr_id_new = chr.id
19268: AND ktrx.tsu_code = 'ENTERED'
19269: AND ktrx.rbr_code is NOT NULL

Line 20172: FROM okc_k_headers_b chr,

20168:
20169: --cursor to check if the contract is undergoing on-line rebook
20170: cursor l_chk_rbk_csr(p_chr_id IN NUMBER) is
20171: SELECT '!'
20172: FROM okc_k_headers_b chr,
20173: okl_trx_contracts ktrx
20174: WHERE ktrx.khr_id_new = chr.id
20175: AND ktrx.tsu_code = 'ENTERED'
20176: AND ktrx.rbr_code is NOT NULL