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.OKC_REP_UTIL_PVT dependencies on OKC_REP_CONTRACTS_ALL

Line 52: l_org_id OKC_REP_CONTRACTS_ALL.ORG_ID%type;

48: x_return_status OUT NOCOPY VARCHAR2)
49: IS
50:
51: l_api_name VARCHAR2(30);
52: l_org_id OKC_REP_CONTRACTS_ALL.ORG_ID%type;
53: l_result VARCHAR2(1);
54:
55: CURSOR intents_csr(p_contract_type IN VARCHAR2) IS
56: SELECT NULL

Line 438: l_org_id OKC_REP_CONTRACTS_ALL.ORG_ID%type;

434: x_return_status OUT NOCOPY VARCHAR2)
435: IS
436:
437: l_api_name VARCHAR2(30);
438: l_org_id OKC_REP_CONTRACTS_ALL.ORG_ID%type;
439: l_owner_id OKC_REP_CONTRACTS_ALL.OWNER_ID%type;
440: l_contract_type OKC_REP_CONTRACTS_ALL.CONTRACT_TYPE%type;
441: l_use_acl_flag OKC_REP_CONTRACTS_ALL.USE_ACL_FLAG%type;
442: l_result VARCHAR2(1);

Line 439: l_owner_id OKC_REP_CONTRACTS_ALL.OWNER_ID%type;

435: IS
436:
437: l_api_name VARCHAR2(30);
438: l_org_id OKC_REP_CONTRACTS_ALL.ORG_ID%type;
439: l_owner_id OKC_REP_CONTRACTS_ALL.OWNER_ID%type;
440: l_contract_type OKC_REP_CONTRACTS_ALL.CONTRACT_TYPE%type;
441: l_use_acl_flag OKC_REP_CONTRACTS_ALL.USE_ACL_FLAG%type;
442: l_result VARCHAR2(1);
443: l_user_id FND_USER.USER_ID%type;

Line 440: l_contract_type OKC_REP_CONTRACTS_ALL.CONTRACT_TYPE%type;

436:
437: l_api_name VARCHAR2(30);
438: l_org_id OKC_REP_CONTRACTS_ALL.ORG_ID%type;
439: l_owner_id OKC_REP_CONTRACTS_ALL.OWNER_ID%type;
440: l_contract_type OKC_REP_CONTRACTS_ALL.CONTRACT_TYPE%type;
441: l_use_acl_flag OKC_REP_CONTRACTS_ALL.USE_ACL_FLAG%type;
442: l_result VARCHAR2(1);
443: l_user_id FND_USER.USER_ID%type;
444: l_user_name FND_USER.USER_NAME%type;

Line 441: l_use_acl_flag OKC_REP_CONTRACTS_ALL.USE_ACL_FLAG%type;

437: l_api_name VARCHAR2(30);
438: l_org_id OKC_REP_CONTRACTS_ALL.ORG_ID%type;
439: l_owner_id OKC_REP_CONTRACTS_ALL.OWNER_ID%type;
440: l_contract_type OKC_REP_CONTRACTS_ALL.CONTRACT_TYPE%type;
441: l_use_acl_flag OKC_REP_CONTRACTS_ALL.USE_ACL_FLAG%type;
442: l_result VARCHAR2(1);
443: l_user_id FND_USER.USER_ID%type;
444: l_user_name FND_USER.USER_NAME%type;
445:

Line 464: FROM okc_rep_contracts_all

460: SELECT org_id,
461: owner_id,
462: use_acl_flag,
463: contract_type
464: FROM okc_rep_contracts_all
465: WHERE contract_id = p_contract_id;
466:
467: CURSOR grants_csr(p_contract_id1 in number, p_contract_id2 in number, p_grantee_key in FND_GRANTS.grantee_key%TYPE, p_grantee_orig_system in FND_GRANTS.grantee_orig_system%TYPE) IS
468: SELECT

Line 997: UPDATE okc_rep_contracts_all

993: 'Before updating Contract Status');
994: END IF;
995:
996: -- Update the contract status
997: UPDATE okc_rep_contracts_all
998: SET contract_status_code = p_status_code,
999: contract_last_update_date = sysdate,
1000: contract_last_updated_by = FND_GLOBAL.user_id()
1001: WHERE contract_id = p_contract_id

Line 3654: SELECT OKC_REP_CONTRACTS_ALL_S1.NEXTVAL

3650: -- Used for storing contract intent code
3651: l_contract_intent VARCHAR2(30);
3652:
3653: CURSOR CONTRACT_ID_CSR IS
3654: SELECT OKC_REP_CONTRACTS_ALL_S1.NEXTVAL
3655: FROM DUAL;
3656:
3657: CURSOR CONTRACT_NUMBER_CSR IS
3658: SELECT OKC_REP_CONTRACTS_ALL_S2.NEXTVAL

Line 3658: SELECT OKC_REP_CONTRACTS_ALL_S2.NEXTVAL

3654: SELECT OKC_REP_CONTRACTS_ALL_S1.NEXTVAL
3655: FROM DUAL;
3656:
3657: CURSOR CONTRACT_NUMBER_CSR IS
3658: SELECT OKC_REP_CONTRACTS_ALL_S2.NEXTVAL
3659: FROM DUAL;
3660:
3661: CURSOR CONTRACT_NUMBER_UNIQUE_CSR (p_contract_number VARCHAR2, p_imp_contract_id NUMBER) IS
3662: SELECT CONTRACT_NUMBER

Line 3663: FROM OKC_REP_CONTRACTS_ALL

3659: FROM DUAL;
3660:
3661: CURSOR CONTRACT_NUMBER_UNIQUE_CSR (p_contract_number VARCHAR2, p_imp_contract_id NUMBER) IS
3662: SELECT CONTRACT_NUMBER
3663: FROM OKC_REP_CONTRACTS_ALL
3664: WHERE UPPER(CONTRACT_NUMBER) = UPPER(p_contract_number)
3665: UNION
3666: SELECT CONTRACT_NUMBER
3667: FROM OKC_REP_IMP_CONTRACTS_T

Line 4894: -- to OKC_REP_CONTRACTS_ALL AND OKC_REP_CONTRACT_PARTIES

4890: --API name : insert_prod_data
4891: --Type : Private.
4892: --Function : Insert validated contracts and parties into production tables
4893: -- i.e., move from OKC_REP_IMP_CONTRACTS_T and OKC_REP_IMP_PARTIES_T
4894: -- to OKC_REP_CONTRACTS_ALL AND OKC_REP_CONTRACT_PARTIES
4895: -- It also insert a record into OKC_REP_CON_STATUS_HIST for every record
4896: -- inserted into OKC_REP_CONTRACTS_ALL.
4897: --Pre-reqs : Currently only called from repository import.
4898: -- Contracts should be saved to the OKC_REP_IMP_CONTRACTS_T table

Line 4896: -- inserted into OKC_REP_CONTRACTS_ALL.

4892: --Function : Insert validated contracts and parties into production tables
4893: -- i.e., move from OKC_REP_IMP_CONTRACTS_T and OKC_REP_IMP_PARTIES_T
4894: -- to OKC_REP_CONTRACTS_ALL AND OKC_REP_CONTRACT_PARTIES
4895: -- It also insert a record into OKC_REP_CON_STATUS_HIST for every record
4896: -- inserted into OKC_REP_CONTRACTS_ALL.
4897: --Pre-reqs : Currently only called from repository import.
4898: -- Contracts should be saved to the OKC_REP_IMP_CONTRACTS_T table
4899: -- Date should all be validated in OKC_REP_IMP_CONTRACTS_T,
4900: -- : OKC_REP_IMP_PARTIES_T, and OKC_REP_IMP_DOCUMENTS_T

Line 4939: FROM okc_rep_contracts_all

4935: l_insert_batch_size NUMBER;
4936:
4937: CURSOR number_inserted_csr IS
4938: SELECT COUNT(contract_id)
4939: FROM okc_rep_contracts_all
4940: WHERE request_id = p_request_id;
4941:
4942: CURSOR contract_id_cur IS
4943: SELECT

Line 5012: INSERT INTO okc_rep_contracts_all

5008:
5009: FND_FILE.PUT_LINE(FND_FILE.LOG, '***** SAVEPOINT before_insert_contracts *****');
5010:
5011: --Bulk insert contracts
5012: INSERT INTO okc_rep_contracts_all
5013: (contract_id,
5014: contract_version_num,
5015: contract_name,
5016: contract_number,

Line 5085: FND_FILE.PUT_LINE(FND_FILE.LOG, '* INSERT INTO okc_rep_contracts_all *');

5081: AND valid_flag = 'Y'
5082: AND contract_id >= l_start_contract_id
5083: AND contract_id < l_start_contract_id + l_insert_batch_size;
5084:
5085: FND_FILE.PUT_LINE(FND_FILE.LOG, '***** INSERT INTO okc_rep_contracts_all *****');
5086:
5087: --insert into contract parties
5088: INSERT INTO okc_rep_contract_parties
5089: (

Line 5204: FROM okc_rep_contracts_all

5200: creation_date,
5201: last_updated_by,
5202: last_update_date,
5203: last_update_login
5204: FROM okc_rep_contracts_all
5205: WHERE request_id = p_request_id
5206: AND created_by = FND_GLOBAL.USER_ID
5207: AND contract_id >= l_start_contract_id
5208: AND contract_id < l_start_contract_id + l_insert_batch_size;

Line 5357: -- okc_rep_contracts_all and okc_rep_contract_parties

5353: --API name : validate_and_insert_contracts
5354: --Type : Private.
5355: --Function : Validates contracts in the interface tables, and then insert
5356: -- the valid ones into production tables:
5357: -- okc_rep_contracts_all and okc_rep_contract_parties
5358: -- Note that contract documents are inserted in the Java layer after this
5359: --Pre-reqs : Currently only called from repository import.
5360: -- : Contracts should be saved to the OKC_REP_IMP_CONTRACTS_T table
5361: --Parameters :

Line 6625: FROM okc_rep_contracts_all

6621:
6622:
6623: CURSOR l_contract_exist_csr IS
6624: SELECT contract_id
6625: FROM okc_rep_contracts_all
6626: WHERE contract_id=p_doc_id;
6627:
6628: CURSOR l_contract_updatable_csr IS
6629: SELECT contract_id

Line 6630: FROM okc_rep_contracts_all

6626: WHERE contract_id=p_doc_id;
6627:
6628: CURSOR l_contract_updatable_csr IS
6629: SELECT contract_id
6630: FROM okc_rep_contracts_all
6631: WHERE contract_id=p_doc_id
6632: AND contract_status_code in (G_STATUS_REJECTED, G_STATUS_DRAFT);
6633:
6634:

Line 6679: -- UPDATE okc_rep_contracts_all

6675: CLOSE l_contract_exist_csr;
6676: ELSE
6677: -- Update the CONTRACT_LAST_UPDATE_DATE and CONTRACT_LAST_UPDATE_BY columns
6678: -- No need to updated these columns. These are updated upon View Contract.
6679: -- UPDATE okc_rep_contracts_all
6680: -- SET CONTRACT_LAST_UPDATE_DATE = sysdate,
6681: -- CONTRACT_LAST_UPDATED_BY = FND_GLOBAL.user_id()
6682: -- WHERE contract_id = p_doc_id;
6683: l_ok_to_commit := FND_API.G_TRUE;

Line 6699: -- UPDATE okc_rep_contracts_all

6695: CLOSE l_contract_updatable_csr;
6696: ELSE
6697: -- Update the CONTRACT_LAST_UPDATE_DATE and CONTRACT_LAST_UPDATE_BY columns
6698: -- No need to updated these columns. These are updated upon View Contract.
6699: -- UPDATE okc_rep_contracts_all
6700: -- SET CONTRACT_LAST_UPDATE_DATE = sysdate,
6701: -- CONTRACT_LAST_UPDATED_BY = FND_GLOBAL.user_id()
6702: -- WHERE contract_id = p_doc_id;
6703: l_ok_to_commit := FND_API.G_TRUE;

Line 6953: l_org_id okc_rep_contracts_all.org_id%TYPE;

6949: l_rel_party_id NUMBER;
6950: l_rel_id NUMBER;
6951: l_org_contact_id NUMBER;
6952: l_party_site_id NUMBER;
6953: l_org_id okc_rep_contracts_all.org_id%TYPE;
6954:
6955: CURSOR contract_org_csr IS
6956: SELECT org_id
6957: FROM okc_rep_contracts_all

Line 6957: FROM okc_rep_contracts_all

6953: l_org_id okc_rep_contracts_all.org_id%TYPE;
6954:
6955: CURSOR contract_org_csr IS
6956: SELECT org_id
6957: FROM okc_rep_contracts_all
6958: WHERE contract_id = p_contract_id;
6959:
6960: BEGIN
6961: l_api_name := 'insert_new_vendor_contact';

Line 7079: l_desc okc_rep_contracts_all.contract_desc%TYPE;

7075: IS
7076: l_api_name VARCHAR2(32);
7077: l_api_version NUMBER;
7078:
7079: l_desc okc_rep_contracts_all.contract_desc%TYPE;
7080: l_use_acl_flag okc_rep_contracts_all.use_acl_flag%TYPE;
7081: l_expire_ntf_flag okc_rep_contracts_all.expire_ntf_flag%TYPE;
7082: l_expire_ntf_period okc_rep_contracts_all.expire_ntf_period%TYPE;
7083: l_ntf_contact_role_id okc_rep_contracts_all.notify_contact_role_id%TYPE;

Line 7080: l_use_acl_flag okc_rep_contracts_all.use_acl_flag%TYPE;

7076: l_api_name VARCHAR2(32);
7077: l_api_version NUMBER;
7078:
7079: l_desc okc_rep_contracts_all.contract_desc%TYPE;
7080: l_use_acl_flag okc_rep_contracts_all.use_acl_flag%TYPE;
7081: l_expire_ntf_flag okc_rep_contracts_all.expire_ntf_flag%TYPE;
7082: l_expire_ntf_period okc_rep_contracts_all.expire_ntf_period%TYPE;
7083: l_ntf_contact_role_id okc_rep_contracts_all.notify_contact_role_id%TYPE;
7084:

Line 7081: l_expire_ntf_flag okc_rep_contracts_all.expire_ntf_flag%TYPE;

7077: l_api_version NUMBER;
7078:
7079: l_desc okc_rep_contracts_all.contract_desc%TYPE;
7080: l_use_acl_flag okc_rep_contracts_all.use_acl_flag%TYPE;
7081: l_expire_ntf_flag okc_rep_contracts_all.expire_ntf_flag%TYPE;
7082: l_expire_ntf_period okc_rep_contracts_all.expire_ntf_period%TYPE;
7083: l_ntf_contact_role_id okc_rep_contracts_all.notify_contact_role_id%TYPE;
7084:
7085: CURSOR contract_attribs_csr IS

Line 7082: l_expire_ntf_period okc_rep_contracts_all.expire_ntf_period%TYPE;

7078:
7079: l_desc okc_rep_contracts_all.contract_desc%TYPE;
7080: l_use_acl_flag okc_rep_contracts_all.use_acl_flag%TYPE;
7081: l_expire_ntf_flag okc_rep_contracts_all.expire_ntf_flag%TYPE;
7082: l_expire_ntf_period okc_rep_contracts_all.expire_ntf_period%TYPE;
7083: l_ntf_contact_role_id okc_rep_contracts_all.notify_contact_role_id%TYPE;
7084:
7085: CURSOR contract_attribs_csr IS
7086: SELECT contract_desc,

Line 7083: l_ntf_contact_role_id okc_rep_contracts_all.notify_contact_role_id%TYPE;

7079: l_desc okc_rep_contracts_all.contract_desc%TYPE;
7080: l_use_acl_flag okc_rep_contracts_all.use_acl_flag%TYPE;
7081: l_expire_ntf_flag okc_rep_contracts_all.expire_ntf_flag%TYPE;
7082: l_expire_ntf_period okc_rep_contracts_all.expire_ntf_period%TYPE;
7083: l_ntf_contact_role_id okc_rep_contracts_all.notify_contact_role_id%TYPE;
7084:
7085: CURSOR contract_attribs_csr IS
7086: SELECT contract_desc,
7087: use_acl_flag,

Line 7091: FROM okc_rep_contracts_all

7087: use_acl_flag,
7088: expire_ntf_flag,
7089: expire_ntf_period,
7090: notify_contact_role_id
7091: FROM okc_rep_contracts_all
7092: WHERE contract_id = p_contract_id;
7093:
7094: BEGIN
7095: l_api_name := 'sync_con_header_attributes';

Line 7210: l_status_code OKC_REP_CONTRACTS_ALL.CONTRACT_STATUS_CODE%TYPE;

7206: x_msg_count OUT NOCOPY NUMBER,
7207: x_return_status OUT NOCOPY VARCHAR2)
7208: IS
7209:
7210: l_status_code OKC_REP_CONTRACTS_ALL.CONTRACT_STATUS_CODE%TYPE;
7211: l_archived_yn OKC_REP_DOC_VERSIONS_V.ARCHIVED_YN%TYPE;
7212:
7213: BEGIN
7214: