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_IMP_PARTIES_T

Line 1617: FROM okc_rep_imp_parties_t

1613: AND party_role_code IN (p_party_role_code, l_party_role_code2);
1614:
1615: CURSOR imp_party_unique_csr IS
1616: SELECT 1
1617: FROM okc_rep_imp_parties_t
1618: WHERE imp_contract_id = p_contract_id
1619: AND party_id = p_party_id
1620: AND party_role_code = p_party_role_code;
1621:

Line 3347: -- : Contracts should be saved to the OKC_REP_IMP_PARTIES_T table

3343: --API name : validate_import_parties
3344: --Type : Private.
3345: --Function : Validates contract parties during import
3346: --Pre-reqs : Currently only called from repository import.
3347: -- : Contracts should be saved to the OKC_REP_IMP_PARTIES_T table
3348: --Parameters :
3349: --IN : p_api_version IN NUMBER Required
3350: -- : p_init_msg_list IN VARCHAR2 Optional
3351: -- Default = FND_API.G_FALSE

Line 3395: FROM OKC_REP_IMP_PARTIES_T

3391: PROGRAM_ID,
3392: PROGRAM_LOGIN_ID,
3393: PROGRAM_APPLICATION_ID,
3394: REQUEST_ID
3395: FROM OKC_REP_IMP_PARTIES_T
3396: WHERE run_id = p_run_id
3397: AND Nvl(VALID_FLAG, 'U') IN ('U', 'Y');
3398:
3399: l_import_parties_rec IMPORT_PARTIES_CSR%ROWTYPE;

Line 3770: UPDATE OKC_REP_IMP_PARTIES_T

3766:
3767:
3768: --Update the record
3769: IF (l_valid_flag = 'Y') THEN
3770: UPDATE OKC_REP_IMP_PARTIES_T
3771: SET
3772: PARTY_ID = l_party_id,
3773: PARTY_ROLE_CODE = l_party_role_code,
3774: --SIGNED_DATE = l_signed_date,

Line 3780: UPDATE OKC_REP_IMP_PARTIES_T

3776: WHERE IMP_PARTY_ID = l_import_parties_rec.imp_party_id;
3777: END IF;
3778:
3779: IF (l_valid_flag = 'N') THEN
3780: UPDATE OKC_REP_IMP_PARTIES_T
3781: SET
3782: VALID_FLAG = l_valid_flag
3783: WHERE IMP_PARTY_ID = l_import_parties_rec.imp_party_id;
3784: END IF;

Line 4093: FROM OKC_REP_IMP_PARTIES_T

4089: AND UPPER(MEANING) = UPPER(p_authoring_party_txt);
4090:
4091: CURSOR CONTRACT_PARTIES_CSR (p_contract_id VARCHAR2) IS
4092: SELECT PARTY_ROLE_CODE, PARTY_NAME_TXT
4093: FROM OKC_REP_IMP_PARTIES_T
4094: WHERE IMP_CONTRACT_ID = p_contract_id;
4095:
4096: l_contract_parties_rec CONTRACT_PARTIES_CSR%ROWTYPE;
4097: l_int_party_name OKC_REP_IMP_PARTIES_T.PARTY_NAME_TXT%TYPE;

Line 4097: l_int_party_name OKC_REP_IMP_PARTIES_T.PARTY_NAME_TXT%TYPE;

4093: FROM OKC_REP_IMP_PARTIES_T
4094: WHERE IMP_CONTRACT_ID = p_contract_id;
4095:
4096: l_contract_parties_rec CONTRACT_PARTIES_CSR%ROWTYPE;
4097: l_int_party_name OKC_REP_IMP_PARTIES_T.PARTY_NAME_TXT%TYPE;
4098:
4099: --CURSOR PARTY_INTENT_CSR (p_contract_type VARCHAR2, p_party_role_code VARCHAR2) IS
4100: --SELECT INTERNAL_EXTERNAL_FLAG
4101: --FROM OKC_RESP_PARTIES_B RESP_PARTIES,

Line 4110: FROM OKC_REP_IMP_PARTIES_T

4106: --AND DOC_TYPES.DOCUMENT_TYPE = p_contract_type;
4107:
4108: CURSOR VALID_PARTIES_CSR (p_contract_id VARCHAR2) IS
4109: SELECT VALID_FLAG, IMP_PARTY_ID
4110: FROM OKC_REP_IMP_PARTIES_T
4111: WHERE IMP_CONTRACT_ID = p_contract_id;
4112:
4113: l_valid_parties_rec VALID_PARTIES_CSR%ROWTYPE;
4114:

Line 5315: --Also update okc_rep_imp_parties_t and okc_rep_imp_documents_t

5311: OPEN CONTRACT_ID_CSR;
5312: FETCH CONTRACT_ID_CSR INTO l_contract_id;
5313: CLOSE CONTRACT_ID_CSR;
5314:
5315: --Also update okc_rep_imp_parties_t and okc_rep_imp_documents_t
5316: --with the new contract_id
5317: UPDATE OKC_REP_IMP_PARTIES_T
5318: SET CONTRACT_ID = l_contract_id
5319: WHERE IMP_CONTRACT_ID = l_import_contracts_rec.imp_contract_id;

Line 5317: UPDATE OKC_REP_IMP_PARTIES_T

5313: CLOSE CONTRACT_ID_CSR;
5314:
5315: --Also update okc_rep_imp_parties_t and okc_rep_imp_documents_t
5316: --with the new contract_id
5317: UPDATE OKC_REP_IMP_PARTIES_T
5318: SET CONTRACT_ID = l_contract_id
5319: WHERE IMP_CONTRACT_ID = l_import_contracts_rec.imp_contract_id;
5320:
5321: UPDATE OKC_REP_IMP_DOCUMENTS_T

Line 5589: -- i.e., move from OKC_REP_IMP_CONTRACTS_T and OKC_REP_IMP_PARTIES_T

5585: -- Start of comments
5586: --API name : insert_prod_data
5587: --Type : Private.
5588: --Function : Insert validated contracts and parties into production tables
5589: -- i.e., move from OKC_REP_IMP_CONTRACTS_T and OKC_REP_IMP_PARTIES_T
5590: -- to OKC_REP_CONTRACTS_ALL AND OKC_REP_CONTRACT_PARTIES
5591: -- It also insert a record into OKC_REP_CON_STATUS_HIST for every record
5592: -- inserted into OKC_REP_CONTRACTS_ALL.
5593: --Pre-reqs : Currently only called from repository import.

Line 5596: -- : OKC_REP_IMP_PARTIES_T, and OKC_REP_IMP_DOCUMENTS_T

5592: -- inserted into OKC_REP_CONTRACTS_ALL.
5593: --Pre-reqs : Currently only called from repository import.
5594: -- Contracts should be saved to the OKC_REP_IMP_CONTRACTS_T table
5595: -- Date should all be validated in OKC_REP_IMP_CONTRACTS_T,
5596: -- : OKC_REP_IMP_PARTIES_T, and OKC_REP_IMP_DOCUMENTS_T
5597: --Parameters :
5598: --IN : p_api_version IN NUMBER Required
5599: -- : p_init_msg_list IN VARCHAR2 Optional
5600: -- Default = FND_API.G_FALSE

Line 5876: FROM okc_rep_imp_parties_t

5872: program_id,
5873: program_login_id,
5874: program_application_id,
5875: request_id
5876: FROM okc_rep_imp_parties_t
5877: WHERE valid_flag = 'Y'
5878: AND run_id = p_run_id
5879: AND contract_id IS NOT NULL
5880: AND contract_id >= l_start_contract_id

Line 5922: FROM okc_rep_imp_parties_t sig, okc_rep_imp_contracts_t con

5918: sig.program_id,
5919: sig.program_login_id,
5920: sig.program_application_id,
5921: sig.request_id
5922: FROM okc_rep_imp_parties_t sig, okc_rep_imp_contracts_t con
5923: WHERE sig.valid_flag = 'Y'
5924: AND sig.run_id = p_run_id
5925: AND sig.contract_id IS NOT NULL
5926: AND con.contract_status_code = 'SIGNED'

Line 6723: FROM OKC_REP_IMP_PARTIES_T

6719: PARTY_NAME_TXT,
6720: PARTY_ROLE_TXT,
6721: SIGNED_BY_TXT,
6722: SIGNED_DATE
6723: FROM OKC_REP_IMP_PARTIES_T
6724: WHERE IMP_CONTRACT_ID = p_imp_contract_id
6725: ORDER BY PARTY_INDEX;
6726:
6727: l_imp_parties_rec IMP_PARTIES_CSR%ROWTYPE;

Line 8474: FROM okc_rep_imp_parties_t

8470: l_import_contacts_rec IMPORT_CONTACTS_CSR%ROWTYPE;
8471:
8472: CURSOR c_party_exists_csr(p_party_role_txt VARCHAR2, p_party_name_txt VARCHAR2, p_imp_contract_id number) IS
8473: SELECT party_id, party_role_code
8474: FROM okc_rep_imp_parties_t
8475: WHERE Upper(party_role_txt) = Upper(p_party_role_txt)
8476: AND Upper(party_name_txt) = Upper(p_party_name_txt)
8477: AND imp_contract_id = p_imp_contract_id;
8478: