APPS.OKL_ACTIVATE_CONTRACT_PUB dependencies on OKC_K_HEADERS_B

Line 481: from okc_k_headers_b chrb

477: --cursor to fetch contract header level BTO and CAN
478: cursor l_chrb_csr(chrId IN NUMBER) is
479: Select chrb.bill_to_site_use_id,
480: chrb.cust_acct_id
481: from okc_k_headers_b chrb
482: where id = ChrId;
483:
484: --cursor to fetch contract line level BTO and CAN
485: cursor l_cleb_csr (chrId In Number) is

Line 685: from okc_k_headers_b

681: l_api_version CONSTANT NUMBER := 1.0;
682:
683: CURSOR chr_csr(p_chr_id NUMBER) IS
684: select start_date
685: from okc_k_headers_b
686: where id = p_chr_id;
687:
688: CURSOR cle_csr(p_rbk_chr_id NUMBER,
689: p_orig_chr_id NUMBER,

Line 779: FROM okc_k_headers_b CHR,

775: --Bug#2835070
776: --cursor to check if the contract is rebooked contract
777: cursor l_chk_rbk_csr(p_chr_id IN NUMBER) is
778: SELECT '!',chr.orig_system_id1, ktrx.date_transaction_occurred,ktrx.id
779: FROM okc_k_headers_b CHR,
780: okl_trx_contracts ktrx
781: WHERE ktrx.khr_id_new = chr.id
782: AND ktrx.tsu_code = 'ENTERED'
783: AND ktrx.rbr_code is NOT NULL

Line 790: l_orig_khr_id okc_k_headers_b.orig_system_id1%Type;

786: AND CHR.ORIG_SYSTEM_SOURCE_CODE = 'OKL_REBOOK'
787: AND ktrx.representation_type = 'PRIMARY'; -- MGAAP 7263041
788:
789: l_rbk_khr VARCHAR2(1) DEFAULT '?';
790: l_orig_khr_id okc_k_headers_b.orig_system_id1%Type;
791: l_rebook_date OKL_TRX_CONTRACTS.date_transaction_occurred%TYPE;
792: l_transaction_id okl_trx_contracts.id%TYPE;
793: --4542290 start
794: l_trx_date OKL_TRX_CONTRACTS.date_transaction_occurred%TYPE;

Line 809: FROM okc_k_headers_b CHR,

805: SELECT '!', ktrx.date_transaction_occurred,
806: --Bug# 4212626
807: ktrx.id,
808: source_trx_id -- 4542290
809: FROM okc_k_headers_b CHR,
810: okl_trx_contracts ktrx
811: where CHR.ID = p_chr_id
812: AND ktrx.KHR_ID = chr.id
813: AND ktrx.tsu_code = 'ENTERED'

Line 848: FROM okc_k_headers_b CHR

844: --4542290
845: --cursor to check if usage line exists on the contract
846: CURSOR l_chk_usage_csr (p_chr_id IN Number) IS
847: SELECT '!'
848: FROM okc_k_headers_b CHR
849: WHERE chr.ID = p_chr_id
850: AND exists (SELECT '1'
851: FROM
852: OKC_LINE_STYLES_B lse,

Line 864: FROM okc_k_headers_b CHR

860:
861: --cursor to check if contract is a re-lease contract
862: CURSOR l_chk_rel_khr_csr (p_chr_id IN Number) IS
863: SELECT '!'
864: FROM okc_k_headers_b CHR
865: where chr.ID = p_chr_id
866: AND nvl(chr.orig_system_source_code,'XXXX') = 'OKL_RELEASE';
867:
868: l_rel_khr VARCHAR2(1) DEFAULT '?';

Line 873: FROM okc_k_headers_b CHR

869:
870: --cursor to check if contract has re-lease assets
871: CURSOR l_chk_rel_ast_csr (p_chr_id IN Number) IS
872: SELECT '!'
873: FROM okc_k_headers_b CHR
874: WHERE nvl(chr.orig_system_source_code,'XXXX') <> 'OKL_RELEASE'
875: and chr.ID = p_chr_id
876: AND exists (SELECT '1'
877: FROM OKC_RULES_B rul

Line 1023: From okc_k_headers_b chr

1019:
1020: Cursor chr_csr (pchrid number) is
1021: Select contract_number
1022: ,start_date
1023: From okc_k_headers_b chr
1024: where chr.id = pchrid;
1025:
1026: --4542290
1027: CURSOR max_bill_date_csr(p_stm_id IN NUMBER) IS

Line 1036: l_contract_number okc_k_headers_b.contract_number%type;

1032:
1033: l_capitalize_interest_flag okc_rules_b.rule_information1%TYPE;
1034: l_amount number;
1035: l_source_id number;
1036: l_contract_number okc_k_headers_b.contract_number%type;
1037: l_start_date okc_k_headers_b.start_date%type;
1038: -- Bug# 3541098 end
1039:
1040: l_ignore_flag VARCHAR2(1);

Line 1037: l_start_date okc_k_headers_b.start_date%type;

1033: l_capitalize_interest_flag okc_rules_b.rule_information1%TYPE;
1034: l_amount number;
1035: l_source_id number;
1036: l_contract_number okc_k_headers_b.contract_number%type;
1037: l_start_date okc_k_headers_b.start_date%type;
1038: -- Bug# 3541098 end
1039:
1040: l_ignore_flag VARCHAR2(1);
1041: