[Home] [Help]
1348: AND UPPER(hp.party_name) = UPPER(p_party_name);
1349:
1350: CURSOR rep_party_unique_csr(l_party_role_code2 varchar2) IS
1351: SELECT 1
1352: FROM okc_rep_contract_parties
1353: WHERE contract_id = p_contract_id
1354: AND party_id = p_party_id
1355: AND party_role_code IN (p_party_role_code, l_party_role_code2);
1356:
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
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: (
5090: contract_id,
5091: party_role_code,
5092: party_id,
5125: AND contract_id IS NOT NULL
5126: AND contract_id >= l_start_contract_id
5127: AND contract_id < l_start_contract_id + l_insert_batch_size;
5128:
5129: FND_FILE.PUT_LINE(FND_FILE.LOG, '***** INSERT INTO okc_rep_contract_parties *****');
5130:
5131: --insert into okc_rep_signature_details
5132: INSERT INTO OKC_REP_SIGNATURE_DETAILS
5133: (
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 :