APPS.OKC_REP_CONTRACT_IMP_PVT dependencies on OKC_REP_IMP_CONTACTS_T

Line 527: INSERT INTO okc_rep_imp_contacts_t(imp_contract_id,

523: l_error_msg := fnd_message.get;
524:
525: END;
526:
527: INSERT INTO okc_rep_imp_contacts_t(imp_contract_id,
528: imp_party_id,
529: imp_contact_id,
530: contact_index,
531: contact_id,

Line 539: OKC_REP_IMP_CONTACTS_T_S.NEXTVAL,

535: contact_role_txt,
536: run_id)
537: VALUES (p_imp_contract_id,
538: l_party_id,
539: OKC_REP_IMP_CONTACTS_T_S.NEXTVAL,
540: p_party_contacts_tbl(i).contact_index,
541: p_party_contacts_tbl(i).contact_id,
542: p_party_contacts_tbl(i).party_role_txt,
543: p_party_contacts_tbl(i).party_name_txt,

Line 867: --update okc_rep_imp_contacts_t

863: IF (l_debug = 'Y') THEN
864: okc_debug.log('700: After UPDATE okc_rep_imp_parties_t ', 1);
865: END IF;
866:
867: --update okc_rep_imp_contacts_t
868: UPDATE okc_rep_imp_contacts_t
869: SET run_id = l_run_id,
870: request_id = l_request_id
871: WHERE imp_contract_id IN (SELECT imp_contract_id

Line 868: UPDATE okc_rep_imp_contacts_t

864: okc_debug.log('700: After UPDATE okc_rep_imp_parties_t ', 1);
865: END IF;
866:
867: --update okc_rep_imp_contacts_t
868: UPDATE okc_rep_imp_contacts_t
869: SET run_id = l_run_id,
870: request_id = l_request_id
871: WHERE imp_contract_id IN (SELECT imp_contract_id
872: FROM OKC_REP_IMP_CONTRACTS_T

Line 876: okc_debug.log('800: After UPDATE okc_rep_imp_contacts_t ', 1);

872: FROM OKC_REP_IMP_CONTRACTS_T
873: WHERE run_id = l_run_id);
874:
875: IF (l_debug = 'Y') THEN
876: okc_debug.log('800: After UPDATE okc_rep_imp_contacts_t ', 1);
877: END IF;
878:
879: --update okc_rep_imp_risks_t
880: UPDATE okc_rep_imp_risks_t