APPS.OKC_REP_CONTRACT_IMP_PVT dependencies on OKC_REP_IMP_RISKS_T

Line 588: INSERT INTO okc_rep_imp_risks_t(imp_contract_id,

584: THEN
585: FOR i IN p_risks_tbl.FIRST .. p_risks_tbl.LAST
586: LOOP
587:
588: INSERT INTO okc_rep_imp_risks_t(imp_contract_id,
589: imp_risk_id,
590: risk_event_txt,
591: probability_txt,
592: risk_impact_txt,

Line 600: OKC_REP_IMP_RISKS_T_S.nextval,

596: run_id)
597: --created_by)
598:
599: VALUES(p_imp_contract_id,
600: OKC_REP_IMP_RISKS_T_S.nextval,
601: p_risks_tbl(i).risk_event_txt,
602: p_risks_tbl(i).probability_txt,
603: p_risks_tbl(i).risk_impact_txt,
604: p_risks_tbl(i).risk_comments,

Line 879: --update okc_rep_imp_risks_t

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
881: SET run_id = l_run_id,
882: request_id = l_request_id
883: WHERE imp_contract_id IN (SELECT imp_contract_id

Line 880: UPDATE okc_rep_imp_risks_t

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
881: SET run_id = l_run_id,
882: request_id = l_request_id
883: WHERE imp_contract_id IN (SELECT imp_contract_id
884: FROM OKC_REP_IMP_CONTRACTS_T

Line 888: okc_debug.log('900: After UPDATE okc_rep_imp_risks_t ', 1);

884: FROM OKC_REP_IMP_CONTRACTS_T
885: WHERE run_id = l_run_id);
886:
887: IF (l_debug = 'Y') THEN
888: okc_debug.log('900: After UPDATE okc_rep_imp_risks_t ', 1);
889: END IF;
890:
891:
892: --update OKC_REP_IMP_DOCUMENTS_T