APPS.OKC_REP_UTIL_PVT dependencies on OKC_REP_IMP_CONTACTS_T

Line 6003: FROM okc_rep_imp_contacts_t

5999: program_id,
6000: program_login_id,
6001: program_application_id,
6002: request_id
6003: FROM okc_rep_imp_contacts_t
6004: WHERE run_id = p_run_id
6005: AND valid_flag = 'Y'
6006: --AND created_by = FND_GLOBAL.USER_ID
6007: AND contract_id >= l_start_contract_id

Line 8416: -- : Contacts should be saved to the okc_rep_imp_contacts_t table

8412: --API name : validate_import_party_contact
8413: --Type : Private.
8414: --Function : Validates contract party contacts during import
8415: --Pre-reqs : Currently only called from repository import.
8416: -- : Contacts should be saved to the okc_rep_imp_contacts_t table
8417: --Parameters :
8418: --IN : p_api_version IN NUMBER Required
8419: -- : p_init_msg_list IN VARCHAR2 Optional
8420: -- Default = FND_API.G_FALSE

Line 8466: FROM okc_rep_imp_contacts_t

8462: PROGRAM_LOGIN_ID,
8463: PROGRAM_APPLICATION_ID,
8464: REQUEST_ID,
8465: RUN_ID
8466: FROM okc_rep_imp_contacts_t
8467: WHERE RUN_ID = p_run_id
8468: AND Nvl(VALID_FLAG,'U') IN ('U', 'Y');
8469:
8470: l_import_contacts_rec IMPORT_CONTACTS_CSR%ROWTYPE;

Line 8783: UPDATE okc_rep_imp_contacts_t

8779:
8780:
8781: --Update the record
8782: IF (l_valid_flag = 'Y') THEN
8783: UPDATE okc_rep_imp_contacts_t
8784: SET
8785: PARTY_ID = l_party_id,
8786: PARTY_ROLE_CODE = l_party_role_code,
8787: contact_role_id = l_contact_role_id,

Line 8793: UPDATE okc_rep_imp_contacts_t

8789: WHERE IMP_CONTACT_ID = l_import_contacts_rec.imp_contact_id;
8790: END IF;
8791:
8792: IF (l_valid_flag = 'N') THEN
8793: UPDATE okc_rep_imp_contacts_t
8794: SET
8795: VALID_FLAG = l_valid_flag
8796: WHERE IMP_CONTACT_ID = l_import_contacts_rec.imp_contact_id;
8797: END IF;