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_UTIL_PVT dependencies on OKC_REP_IMP_CONTRACTS_T

Line 3404: OKC_REP_IMP_CONTRACTS_T temp

3400:
3401: CURSOR CONTRACT_INTENT_CSR (p_imp_contract_id NUMBER) IS
3402: SELECT INTENT
3403: FROM OKC_BUS_DOC_TYPES_V bus_doc,
3404: OKC_REP_IMP_CONTRACTS_T temp
3405: WHERE bus_doc.name = temp.contract_type_txt
3406: AND temp.imp_contract_id = p_imp_contract_id
3407: AND bus_doc.document_type_class = 'REPOSITORY';
3408:

Line 3411: FROM FND_LOOKUPS fnd, OKC_REP_IMP_CONTRACTS_T con

3407: AND bus_doc.document_type_class = 'REPOSITORY';
3408:
3409: CURSOR c_get_contract_status(p_imp_contract_id NUMBER) IS
3410: SELECT LOOKUP_CODE
3411: FROM FND_LOOKUPS fnd, OKC_REP_IMP_CONTRACTS_T con
3412: WHERE con.imp_contract_id = p_imp_contract_id
3413: AND fnd.LOOKUP_TYPE = 'OKC_REP_CONTRACT_STATUSES'
3414: AND fnd.LOOKUP_CODE IN ('SIGNED', 'APPROVED', 'DRAFT')
3415: AND UPPER(fnd.MEANING) = UPPER(con.CONTRACT_STATUS_TXT);

Line 3721: UPDATE OKC_REP_IMP_CONTRACTS_T

3717: END IF;
3718: --contract intent does not exist
3719: --this means that contract_type_txt is invalid
3720: --we need to flag the contract header as invalid
3721: UPDATE OKC_REP_IMP_CONTRACTS_T
3722: SET VALID_FLAG = 'N'
3723: WHERE IMP_CONTRACT_ID = l_import_parties_rec.imp_contract_id;
3724:
3725: --Also populate the error table

Line 3868: -- : Contracts should be saved to the OKC_REP_IMP_CONTRACTS_T table

3864: --API name : validate_import_contracts
3865: --Type : Private.
3866: --Function : Validates contracts during import
3867: --Pre-reqs : Currently only called from repository import.
3868: -- : Contracts should be saved to the OKC_REP_IMP_CONTRACTS_T table
3869: --Parameters :
3870: --IN : p_api_version IN NUMBER Required
3871: -- : p_init_msg_list IN VARCHAR2 Optional
3872: -- Default = FND_API.G_FALSE

Line 3966: FROM OKC_REP_IMP_CONTRACTS_T

3962: AND UPPER(CONTRACT_TYPE) = UPPER(p_contract_type)
3963: AND org_id= p_org_id
3964: UNION
3965: SELECT CONTRACT_NUMBER
3966: FROM OKC_REP_IMP_CONTRACTS_T
3967: WHERE UPPER(CONTRACT_NUMBER) = UPPER(p_contract_number)
3968: AND UPPER(CONTRACT_TYPE_TXT) = UPPER(p_contract_type_txt)
3969: AND Upper(ORG_NAME)= p_org_name
3970: AND IMP_CONTRACT_ID <> p_imp_contract_id

Line 4031: OKC_REP_IMP_CONTRACTS_T

4027: reference_document_id,
4028: run_id,
4029: source_code
4030: FROM
4031: OKC_REP_IMP_CONTRACTS_T
4032: WHERE
4033: run_id = p_run_id
4034: AND Nvl(VALID_FLAG, 'U') IN ('U', 'Y');
4035:

Line 4059: OKC_REP_IMP_CONTRACTS_T temp

4055:
4056: CURSOR CONTRACT_INTENT_CSR (p_imp_contract_id NUMBER) IS
4057: SELECT INTENT
4058: FROM OKC_BUS_DOC_TYPES_V bus_doc,
4059: OKC_REP_IMP_CONTRACTS_T temp
4060: WHERE bus_doc.name = temp.contract_type_txt
4061: AND temp.imp_contract_id = p_imp_contract_id
4062: AND bus_doc.document_type_class = 'REPOSITORY';
4063:

Line 5337: UPDATE OKC_REP_IMP_CONTRACTS_T

5333: END IF;
5334:
5335: IF (l_valid_flag = 'Y') THEN
5336: --Update the record
5337: UPDATE OKC_REP_IMP_CONTRACTS_T
5338: SET
5339: CONTRACT_ID = l_contract_id,
5340: CONTRACT_NUMBER = l_contract_number,
5341: CONTRACT_STATUS_CODE = l_status_code,

Line 5366: UPDATE OKC_REP_IMP_CONTRACTS_T

5362: END IF;
5363:
5364:
5365: IF(l_valid_flag = 'N') THEN
5366: UPDATE OKC_REP_IMP_CONTRACTS_T
5367: SET
5368: VALID_FLAG = l_valid_flag
5369: WHERE IMP_CONTRACT_ID = l_import_contracts_rec.imp_contract_id;
5370: END IF;

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 5594: -- Contracts should be saved to the OKC_REP_IMP_CONTRACTS_T table

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.
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

Line 5595: -- Date should all be validated in OKC_REP_IMP_CONTRACTS_T,

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.
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

Line 5643: FROM okc_rep_imp_contracts_t

5639: SELECT
5640: MIN(contract_id) AS min_contract_id,
5641: MAX(contract_id) AS max_contract_id,
5642: COUNT(contract_id)
5643: FROM okc_rep_imp_contracts_t
5644: WHERE run_id = p_run_id
5645: AND valid_flag = 'Y';
5646:
5647: BEGIN

Line 5833: FROM okc_rep_imp_contracts_t

5829: reference_document_number,
5830: reference_document_id,
5831: run_id,
5832: source_code
5833: FROM okc_rep_imp_contracts_t
5834: WHERE run_id = p_run_id
5835: AND valid_flag = 'Y'
5836: AND contract_id >= l_start_contract_id
5837: AND contract_id < l_start_contract_id + l_insert_batch_size;

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 6212: -- : Contracts should be saved to the OKC_REP_IMP_CONTRACTS_T table

6208: -- the valid ones into production tables:
6209: -- okc_rep_contracts_all and okc_rep_contract_parties
6210: -- Note that contract documents are inserted in the Java layer after this
6211: --Pre-reqs : Currently only called from repository import.
6212: -- : Contracts should be saved to the OKC_REP_IMP_CONTRACTS_T table
6213: --Parameters :
6214: --IN : p_api_version IN NUMBER Required
6215: -- : p_init_msg_list IN VARCHAR2 Optional
6216: -- Default = FND_API.G_FALSE

Line 6390: -- (2) Set the contract's valid_flag to 'N' in okc_rep_imp_contracts_t

6386: --API name : delete_import_contract
6387: --Type : Private.
6388: --Function : (1) Delete the imported contract and its parties
6389: -- by calling okc_rep_contract_process_pvt.delete_contract
6390: -- (2) Set the contract's valid_flag to 'N' in okc_rep_imp_contracts_t
6391: -- (3) Insert an error message in okc_rep_imp_errors_t
6392: -- This procedure does the cleanup due to an error adding attachments
6393: -- in the Java layer during repository import
6394: --Pre-reqs : None

Line 6494: UPDATE OKC_REP_IMP_CONTRACTS_T

6490: 'Called okc_rep_contract_process_pvt.delete_contract');
6491: END IF;
6492:
6493: -- Update valid_flag
6494: UPDATE OKC_REP_IMP_CONTRACTS_T
6495: SET valid_flag = 'N'
6496: WHERE CONTRACT_ID = p_contract_id;
6497:
6498: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 6667: -- okc_rep_imp_contracts_t.imp_contract_id

6663: --IN : p_api_version IN NUMBER Required
6664: -- : p_init_msg_list IN VARCHAR2 Optional
6665: -- Default = FND_API.G_FALSE
6666: -- : p_imp_contract_id IN NUMBER Required
6667: -- okc_rep_imp_contracts_t.imp_contract_id
6668: -- End of comments
6669: FUNCTION get_csv_error_string(
6670: p_api_version IN NUMBER,
6671: p_init_msg_list IN VARCHAR2,

Line 6710: FROM OKC_REP_IMP_CONTRACTS_T

6706: VERSION_COMMENTS,
6707: ORIG_SYSTEM_REFERENCE_CODE,
6708: ORIG_SYSTEM_REFERENCE_ID1,
6709: ORIG_SYSTEM_REFERENCE_ID2
6710: FROM OKC_REP_IMP_CONTRACTS_T
6711: WHERE IMP_CONTRACT_ID = p_imp_contract_id;
6712:
6713: l_imp_contract_rec IMP_CONTRACT_CSR%ROWTYPE;
6714:

Line 6771: 'p_imp_contract_id does not exist in okc_rep_imp_contracts_t: '||p_imp_contract_id);

6767: FETCH IMP_CONTRACT_CSR INTO l_imp_contract_rec;
6768: IF IMP_CONTRACT_CSR%NOTFOUND THEN
6769: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6770: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
6771: 'p_imp_contract_id does not exist in okc_rep_imp_contracts_t: '||p_imp_contract_id);
6772: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
6773: 'returning null');
6774: END IF;
6775: RETURN l_csv_error_string;

Line 8581: --Party should already exist on the contract (in OKC_REP_IMP_CONTRACTS_T)

8577:
8578: END IF;
8579:
8580: --If l_valid_flag is already set to 'N', we do not perform any more checks
8581: --Party should already exist on the contract (in OKC_REP_IMP_CONTRACTS_T)
8582: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
8583: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
8584: 'Checking if Party exists on the contract');
8585: END IF;

Line 8965: FROM OKC_REP_IMP_CONTRACTS_T

8961: AND Upper(meaning) = Upper(p_risk_txt);
8962:
8963: CURSOR c_get_contract_details_csr(p_imp_contract_id NUMBER) IS
8964: SELECT contract_id, contract_type, contract_version_num
8965: FROM OKC_REP_IMP_CONTRACTS_T
8966: WHERE imp_contract_id = p_imp_contract_id;
8967:
8968: BEGIN
8969: