APPS.OKC_REP_CLOSEOUT_PVT dependencies on OKC_REP_CONTRACT_PARTIES

Line 22: l_internal_party_id OKC_REP_CONTRACT_PARTIES.PARTY_ID%TYPE;

18: IS
19:
20: l_api_name VARCHAR2(30);
21: l_api_version NUMBER;
22: l_internal_party_id OKC_REP_CONTRACT_PARTIES.PARTY_ID%TYPE;
23:
24:
25: CURSOR target_contract_csr IS
26: SELECT contract_type, owner_id, contract_number

Line 34: FROM OKC_REP_CONTRACT_PARTIES

30: target_contract_rec target_contract_csr%ROWTYPE;
31:
32: CURSOR party_csr IS
33: SELECT party_id
34: FROM OKC_REP_CONTRACT_PARTIES
35: WHERE contract_id = p_target_contract_id
36: AND party_role_code = 'INTERNAL_ORG';
37:
38: BEGIN

Line 234: l_internal_party_id OKC_REP_CONTRACT_PARTIES.PARTY_ID%TYPE;

230: IS
231:
232: l_api_name VARCHAR2(30);
233: l_api_version NUMBER;
234: l_internal_party_id OKC_REP_CONTRACT_PARTIES.PARTY_ID%TYPE;
235:
236: l_document_rec OKC_IMP_RECORD_TYPES.document_rec_type;
237:
238: CURSOR c_get_doc_details IS

Line 416: l_internal_party_id OKC_REP_CONTRACT_PARTIES.PARTY_ID%TYPE;

412: IS
413:
414: l_api_name VARCHAR2(30);
415: l_api_version NUMBER;
416: l_internal_party_id OKC_REP_CONTRACT_PARTIES.PARTY_ID%TYPE;
417: l_physical_completion_date DATE;
418: l_task_status VARCHAR2(30);
419: l_document_rec OKC_IMP_RECORD_TYPES.document_rec_type;
420:

Line 591: l_internal_party_id OKC_REP_CONTRACT_PARTIES.PARTY_ID%TYPE;

587: IS
588:
589: l_api_name VARCHAR2(30);
590: l_api_version NUMBER;
591: l_internal_party_id OKC_REP_CONTRACT_PARTIES.PARTY_ID%TYPE;
592: l_error_found Boolean := FALSE;
593: l_warning_found Boolean := FALSE;
594: l_document_rec OKC_IMP_RECORD_TYPES.document_rec_type;
595: l_bus_doc_date_events_tbl OKC_TERMS_QA_GRP.BUSDOCDATES_TBL_TYPE;

Line 1868: l_internal_party_id OKC_REP_CONTRACT_PARTIES.PARTY_ID%TYPE;

1864: IS
1865:
1866: l_api_name VARCHAR2(30);
1867: l_api_version NUMBER;
1868: l_internal_party_id OKC_REP_CONTRACT_PARTIES.PARTY_ID%TYPE;
1869: l_error_found Boolean := FALSE;
1870: l_warning_found Boolean := FALSE;
1871: l_document_rec OKC_IMP_RECORD_TYPES.document_rec_type;
1872: l_bus_doc_date_events_tbl OKC_TERMS_QA_GRP.BUSDOCDATES_TBL_TYPE;

Line 2266: FROM okc_rep_contract_parties

2262: --update supplier information on the individual Po Del
2263:
2264: UPDATE okc_deliverables set EXTERNAL_PARTY_ID =
2265: (SELECT PARTY_ID
2266: FROM okc_rep_contract_parties
2267: WHERE contract_id = l_target_contract_id
2268: AND PARTY_ROLE_CODE = 'SUPPLIER_ORG')
2269: WHERE business_document_type = 'REP_CCC'
2270: AND business_document_id = l_target_contract_id