APPS.OKL_ACTIVATE_CONTRACT_PUB dependencies on OKC_K_HEADERS_B

Line 199: from okc_k_headers_b chrb

195: --cursor to fetch contract header level BTO and CAN
196: cursor l_chrb_csr(chrId IN NUMBER) is
197: Select chrb.bill_to_site_use_id,
198: chrb.cust_acct_id
199: from okc_k_headers_b chrb
200: where id = ChrId;
201:
202: --cursor to fetch contract line level BTO and CAN
203: cursor l_cleb_csr (chrId In Number) is

Line 403: from okc_k_headers_b

399: l_api_version CONSTANT NUMBER := 1.0;
400:
401: CURSOR chr_csr(p_chr_id NUMBER) IS
402: select start_date
403: from okc_k_headers_b
404: where id = p_chr_id;
405:
406: CURSOR cle_csr(p_rbk_chr_id NUMBER,
407: p_orig_chr_id NUMBER,

Line 497: FROM okc_k_headers_b CHR,

493: --Bug#2835070
494: --cursor to check if the contract is rebooked contract
495: cursor l_chk_rbk_csr(p_chr_id IN NUMBER) is
496: SELECT '!',chr.orig_system_id1, ktrx.date_transaction_occurred,ktrx.id
497: FROM okc_k_headers_b CHR,
498: okl_trx_contracts ktrx
499: WHERE ktrx.khr_id_new = chr.id
500: AND ktrx.tsu_code = 'ENTERED'
501: AND ktrx.rbr_code is NOT NULL

Line 508: l_orig_khr_id okc_k_headers_b.orig_system_id1%Type;

504: AND CHR.ORIG_SYSTEM_SOURCE_CODE = 'OKL_REBOOK'
505: AND ktrx.representation_type = 'PRIMARY'; -- MGAAP 7263041
506:
507: l_rbk_khr VARCHAR2(1) DEFAULT '?';
508: l_orig_khr_id okc_k_headers_b.orig_system_id1%Type;
509: l_rebook_date OKL_TRX_CONTRACTS.date_transaction_occurred%TYPE;
510: l_transaction_id okl_trx_contracts.id%TYPE;
511: --4542290 start
512: l_trx_date OKL_TRX_CONTRACTS.date_transaction_occurred%TYPE;

Line 527: FROM okc_k_headers_b CHR,

523: SELECT '!', ktrx.date_transaction_occurred,
524: --Bug# 4212626
525: ktrx.id,
526: source_trx_id -- 4542290
527: FROM okc_k_headers_b CHR,
528: okl_trx_contracts ktrx
529: where CHR.ID = p_chr_id
530: AND ktrx.KHR_ID = chr.id
531: AND ktrx.tsu_code = 'ENTERED'

Line 566: FROM okc_k_headers_b CHR

562: --4542290
563: --cursor to check if usage line exists on the contract
564: CURSOR l_chk_usage_csr (p_chr_id IN Number) IS
565: SELECT '!'
566: FROM okc_k_headers_b CHR
567: WHERE chr.ID = p_chr_id
568: AND exists (SELECT '1'
569: FROM
570: OKC_LINE_STYLES_B lse,

Line 582: FROM okc_k_headers_b CHR

578:
579: --cursor to check if contract is a re-lease contract
580: CURSOR l_chk_rel_khr_csr (p_chr_id IN Number) IS
581: SELECT '!'
582: FROM okc_k_headers_b CHR
583: where chr.ID = p_chr_id
584: AND nvl(chr.orig_system_source_code,'XXXX') = 'OKL_RELEASE';
585:
586: l_rel_khr VARCHAR2(1) DEFAULT '?';

Line 591: FROM okc_k_headers_b CHR

587:
588: --cursor to check if contract has re-lease assets
589: CURSOR l_chk_rel_ast_csr (p_chr_id IN Number) IS
590: SELECT '!'
591: FROM okc_k_headers_b CHR
592: WHERE nvl(chr.orig_system_source_code,'XXXX') <> 'OKL_RELEASE'
593: and chr.ID = p_chr_id
594: /*AND exists (SELECT '1'
595: FROM OKC_RULES_B rul

Line 616: FROM okc_k_headers_b CHR

612: -- Bug# 15992711 Start of Modifications
613: --cursor to check if contract is a mixed contract
614: CURSOR l_chk_mxd_ast_csr (p_chr_id IN Number) IS
615: SELECT '!'
616: FROM okc_k_headers_b CHR
617: WHERE nvl(chr.orig_system_source_code,'XXXX') <> 'OKL_RELEASE'
618: and chr.ID = p_chr_id
619: AND exists ( SELECT '1'
620: FROM okl_k_lines kle

Line 793: From okc_k_headers_b chr

789:
790: Cursor chr_csr (pchrid number) is
791: Select contract_number
792: ,start_date
793: From okc_k_headers_b chr
794: where chr.id = pchrid;
795:
796: --4542290
797: CURSOR max_bill_date_csr(p_stm_id IN NUMBER) IS

Line 806: l_contract_number okc_k_headers_b.contract_number%type;

802:
803: l_capitalize_interest_flag okc_rules_b.rule_information1%TYPE;
804: l_amount number;
805: l_source_id number;
806: l_contract_number okc_k_headers_b.contract_number%type;
807: l_start_date okc_k_headers_b.start_date%type;
808: -- Bug# 3541098 end
809:
810: l_ignore_flag VARCHAR2(1);

Line 807: l_start_date okc_k_headers_b.start_date%type;

803: l_capitalize_interest_flag okc_rules_b.rule_information1%TYPE;
804: l_amount number;
805: l_source_id number;
806: l_contract_number okc_k_headers_b.contract_number%type;
807: l_start_date okc_k_headers_b.start_date%type;
808: -- Bug# 3541098 end
809:
810: l_ignore_flag VARCHAR2(1);
811: