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.

[Home] [Help]

APPS.OKC_REP_CONTRACT_PROCESS_PVT dependencies on OKC_REP_CONTRACT_VERS

Line 1750: FROM okc_rep_contract_vers

1746: WHERE contract_id = p_contract_id;
1747:
1748: CURSOR prev_con_vers_status (p_contract_id IN NUMBER, p_con_version IN NUMBER) IS
1749: SELECT contract_status_code, esignature_required
1750: FROM okc_rep_contract_vers
1751: WHERE contract_id = p_contract_id
1752: AND contract_version_num = p_con_version - 1;
1753:
1754: contract_rec contract_csr%ROWTYPE;

Line 2389: FROM OKC_REP_CONTRACT_VERS

2385: REFERENCE_DOCUMENT_NUMBER,
2386: ESIGNATURE_REQUIRED,
2387: UDA_TEMPLATE_ID,
2388: SBCR_COORDINATION_TYPE
2389: FROM OKC_REP_CONTRACT_VERS
2390: WHERE contract_id = p_contract_id
2391: AND contract_version_num = l_prev_version;
2392:
2393: -- Also, we need to delete this history table record that has been copied to

Line 2395: DELETE FROM OKC_REP_CONTRACT_VERS

2391: AND contract_version_num = l_prev_version;
2392:
2393: -- Also, we need to delete this history table record that has been copied to
2394: -- the main table
2395: DELETE FROM OKC_REP_CONTRACT_VERS
2396: WHERE contract_id = p_contract_id
2397: AND contract_version_num = l_prev_version;
2398: END IF; -- (contract_rec.contract_version_num > 1)
2399:

Line 4031: 'Populating contract header record in OKC_REP_CONTRACT_VERS');

4027: -----------------------------------------------------
4028:
4029: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4030: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
4031: 'Populating contract header record in OKC_REP_CONTRACT_VERS');
4032: END IF;
4033: -- Copy the header record to versions table
4034: INSERT INTO OKC_REP_CONTRACT_VERS(
4035: CONTRACT_ID,

Line 4034: INSERT INTO OKC_REP_CONTRACT_VERS(

4030: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
4031: 'Populating contract header record in OKC_REP_CONTRACT_VERS');
4032: END IF;
4033: -- Copy the header record to versions table
4034: INSERT INTO OKC_REP_CONTRACT_VERS(
4035: CONTRACT_ID,
4036: CONTRACT_VERSION_NUM,
4037: CONTRACT_NUMBER,
4038: CONTRACT_TYPE,

Line 4530: FROM OKC_REP_CONTRACT_VERS

4526: WHERE contract_id = p_contract_id;
4527:
4528: CURSOR arch_contract_csr (l_contract_version NUMBER) IS
4529: SELECT contract_effective_date, contract_expiration_date
4530: FROM OKC_REP_CONTRACT_VERS
4531: WHERE contract_id = p_contract_id
4532: AND contract_version_num = l_contract_version;
4533:
4534: contract_rec contract_csr%ROWTYPE;

Line 4954: FROM OKC_REP_CONTRACT_VERS

4950: WHERE contract_id = p_contract_id;
4951:
4952: CURSOR arch_contract_csr (l_contract_version NUMBER) IS
4953: SELECT contract_effective_date, contract_expiration_date
4954: FROM OKC_REP_CONTRACT_VERS
4955: WHERE contract_id = p_contract_id
4956: AND contract_version_num = l_contract_version;
4957:
4958: CURSOR fetch_wf_name(p_contract_type varchar2) IS

Line 5974: 'Updating okc_rep_contracts_all and okc_rep_contract_vers with wf_exp_ntf_item_key ' || l_item_key);

5970: itemkey => l_item_key);
5971:
5972: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5973: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
5974: 'Updating okc_rep_contracts_all and okc_rep_contract_vers with wf_exp_ntf_item_key ' || l_item_key);
5975: END IF;
5976:
5977: --update contracts with sent notifications
5978: UPDATE okc_rep_contracts_all c

Line 5984: UPDATE okc_rep_contract_vers c

5980: WHERE c.contract_id = p_contract_id
5981: AND c.contract_version_num = p_contract_version;
5982:
5983: --update contract versions with sent notifications
5984: UPDATE okc_rep_contract_vers c
5985: SET c.wf_exp_ntf_item_key = l_item_key
5986: WHERE c.contract_id = p_contract_id
5987: AND c.contract_version_num = p_contract_version;
5988:

Line 6935: FROM okc_rep_contract_vers_ext_b

6931: D_EXT_ATTR7,
6932: D_EXT_ATTR8,
6933: D_EXT_ATTR9,
6934: D_EXT_ATTR10
6935: FROM okc_rep_contract_vers_ext_b
6936: WHERE contract_id = p_contract_id
6937: AND contract_version_num = l_con_version - 1 ;
6938:
6939:

Line 7047: FROM okc_rep_contract_vers_ext_tl

7043: ,TL_EXT_ATTR37
7044: ,TL_EXT_ATTR38
7045: ,TL_EXT_ATTR39
7046: ,TL_EXT_ATTR40
7047: FROM okc_rep_contract_vers_ext_tl
7048: WHERE contract_id = p_contract_id
7049: AND contract_version_num = l_con_version - 1 ;
7050:
7051: -- Delete last version from versions table.

Line 7052: DELETE FROM OKC_REP_CONTRACT_VERS_EXT_B

7048: WHERE contract_id = p_contract_id
7049: AND contract_version_num = l_con_version - 1 ;
7050:
7051: -- Delete last version from versions table.
7052: DELETE FROM OKC_REP_CONTRACT_VERS_EXT_B
7053: WHERE CONTRACT_ID = p_contract_id
7054: AND contract_version_num = l_con_version - 1 ;
7055:
7056: DELETE FROM OKC_REP_CONTRACT_VERS_EXT_TL

Line 7056: DELETE FROM OKC_REP_CONTRACT_VERS_EXT_TL

7052: DELETE FROM OKC_REP_CONTRACT_VERS_EXT_B
7053: WHERE CONTRACT_ID = p_contract_id
7054: AND contract_version_num = l_con_version - 1 ;
7055:
7056: DELETE FROM OKC_REP_CONTRACT_VERS_EXT_TL
7057: WHERE CONTRACT_ID = p_contract_id
7058: AND contract_version_num = l_con_version - 1 ;
7059: */
7060: -- Standard check of p_commit

Line 7437: --insert data from okc_rep_contracts_all_ext_b table to okc_rep_contract_vers_ext_b

7433: -- Initialize API return status to success
7434: x_return_status := FND_API.G_RET_STS_SUCCESS;
7435:
7436: --No API's in EGO to copy data from one object to another.
7437: --insert data from okc_rep_contracts_all_ext_b table to okc_rep_contract_vers_ext_b
7438:
7439: FOR c_get_uda_attr_for_con_rec IN c_get_uda_attr_for_con LOOP
7440: SELECT EGO_EXTFWK_S.NEXTVAL INTO l_extension_id_vers FROM dual;
7441:

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