APPS.OKC_REP_UTIL_PVT dependencies on OKC_REP_CONTRACT_PARTIES

Line 1610: FROM okc_rep_contract_parties

1606: AND UPPER(hp.party_name) = UPPER(p_party_name);
1607:
1608: CURSOR rep_party_unique_csr(l_party_role_code2 varchar2) IS
1609: SELECT 1
1610: FROM okc_rep_contract_parties
1611: WHERE contract_id = p_contract_id
1612: AND party_id = p_party_id
1613: AND party_role_code IN (p_party_role_code, l_party_role_code2);
1614:

Line 5590: -- to OKC_REP_CONTRACTS_ALL AND OKC_REP_CONTRACT_PARTIES

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

Line 5842: INSERT INTO okc_rep_contract_parties

5838:
5839: FND_FILE.PUT_LINE(FND_FILE.LOG, '***** INSERT INTO okc_rep_contracts_all *****');
5840:
5841: --insert into contract parties
5842: INSERT INTO okc_rep_contract_parties
5843: (
5844: contract_id,
5845: party_role_code,
5846: party_id,

Line 5883: FND_FILE.PUT_LINE(FND_FILE.LOG, '***** INSERT INTO okc_rep_contract_parties *****');

5879: AND contract_id IS NOT NULL
5880: AND contract_id >= l_start_contract_id
5881: AND contract_id < l_start_contract_id + l_insert_batch_size;
5882:
5883: FND_FILE.PUT_LINE(FND_FILE.LOG, '***** INSERT INTO okc_rep_contract_parties *****');
5884:
5885: --insert into okc_rep_signature_details
5886: INSERT INTO OKC_REP_SIGNATURE_DETAILS
5887: (

Line 6209: -- okc_rep_contracts_all and okc_rep_contract_parties

6205: --API name : validate_and_insert_contracts
6206: --Type : Private.
6207: --Function : Validates contracts in the interface tables, and then insert
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 :

Line 7844: CURSOR get_party_id( okc_contract_id OKC_REP_CONTRACT_PARTIES.contract_id%TYPE ,

7840: FROM okc_rep_contracts_all
7841: WHERE contract_id = p_contract_id;
7842:
7843: /* Bug 8721411 */
7844: CURSOR get_party_id( okc_contract_id OKC_REP_CONTRACT_PARTIES.contract_id%TYPE ,
7845: party_rep_location_id OKC_REP_CONTRACT_PARTIES.party_location_id%TYPE)
7846: IS
7847: SELECT party_id
7848: FROM OKC_REP_CONTRACT_PARTIES

Line 7845: party_rep_location_id OKC_REP_CONTRACT_PARTIES.party_location_id%TYPE)

7841: WHERE contract_id = p_contract_id;
7842:
7843: /* Bug 8721411 */
7844: CURSOR get_party_id( okc_contract_id OKC_REP_CONTRACT_PARTIES.contract_id%TYPE ,
7845: party_rep_location_id OKC_REP_CONTRACT_PARTIES.party_location_id%TYPE)
7846: IS
7847: SELECT party_id
7848: FROM OKC_REP_CONTRACT_PARTIES
7849: WHERE contract_id=okc_contract_id AND

Line 7848: FROM OKC_REP_CONTRACT_PARTIES

7844: CURSOR get_party_id( okc_contract_id OKC_REP_CONTRACT_PARTIES.contract_id%TYPE ,
7845: party_rep_location_id OKC_REP_CONTRACT_PARTIES.party_location_id%TYPE)
7846: IS
7847: SELECT party_id
7848: FROM OKC_REP_CONTRACT_PARTIES
7849: WHERE contract_id=okc_contract_id AND
7850: party_location_id=party_rep_location_id;
7851:
7852: /* Bug 8721411 */