APPS.OKC_REP_CONTRACT_PROCESS_PVT dependencies on OKC_REP_CONTRACTS_ALL_EXT_TL

Line 6717: DELETE FROM OKC_REP_CONTRACTS_ALL_EXT_TL

6713: DELETE FROM OKC_REP_CONTRACTS_ALL_EXT_B
6714: WHERE CONTRACT_ID = p_contract_id
6715: AND contract_version_num = l_con_version;
6716:
6717: DELETE FROM OKC_REP_CONTRACTS_ALL_EXT_TL
6718: WHERE CONTRACT_ID = p_contract_id
6719: AND contract_version_num = l_con_version;
6720: /*
6721: -- Insert the previous version record.

Line 6940: INSERT INTO OKC_REP_CONTRACTS_ALL_EXT_TL(EXTENSION_ID

6936: WHERE contract_id = p_contract_id
6937: AND contract_version_num = l_con_version - 1 ;
6938:
6939:
6940: INSERT INTO OKC_REP_CONTRACTS_ALL_EXT_TL(EXTENSION_ID
6941: ,ATTR_GROUP_ID
6942: ,CONTRACT_ID
6943:
6944: ,DATA_LEVEL_ID

Line 7660: --insert data from okc_rep_contracts_all_ext_tl table to okc_rep_contract_vers_ext_tl

7656: FROM okc_rep_contracts_all_ext_b
7657: WHERE contract_id = p_contract_id
7658: AND extension_id = c_get_uda_attr_for_con_rec.extension_id;
7659:
7660: --insert data from okc_rep_contracts_all_ext_tl table to okc_rep_contract_vers_ext_tl
7661: INSERT INTO okc_rep_contracts_all_ext_tl(EXTENSION_ID
7662: ,ATTR_GROUP_ID
7663: ,CONTRACT_TYPE
7664: ,CONTRACT_ID

Line 7661: INSERT INTO okc_rep_contracts_all_ext_tl(EXTENSION_ID

7657: WHERE contract_id = p_contract_id
7658: AND extension_id = c_get_uda_attr_for_con_rec.extension_id;
7659:
7660: --insert data from okc_rep_contracts_all_ext_tl table to okc_rep_contract_vers_ext_tl
7661: INSERT INTO okc_rep_contracts_all_ext_tl(EXTENSION_ID
7662: ,ATTR_GROUP_ID
7663: ,CONTRACT_TYPE
7664: ,CONTRACT_ID
7665: ,CONTRACT_VERSION_NUM

Line 7769: FROM okc_rep_contracts_all_ext_tl

7765: ,TL_EXT_ATTR37
7766: ,TL_EXT_ATTR38
7767: ,TL_EXT_ATTR39
7768: ,TL_EXT_ATTR40
7769: FROM okc_rep_contracts_all_ext_tl
7770: WHERE contract_id = p_contract_id
7771: AND extension_id = c_get_uda_attr_for_con_rec.extension_id;
7772:
7773: END LOOP;