DBA Data[Home] [Help]

APPS.OKC_REP_CONTRACT_IMP_PVT dependencies on OKC_REP_IMP_DOCUMENTS_T

Line 892: --update OKC_REP_IMP_DOCUMENTS_T

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
893: UPDATE OKC_REP_IMP_DOCUMENTS_T
894: SET run_id = l_run_id,
895: request_id = l_request_id
896: WHERE imp_contract_id IN (SELECT imp_contract_id

Line 893: UPDATE OKC_REP_IMP_DOCUMENTS_T

889: END IF;
890:
891:
892: --update OKC_REP_IMP_DOCUMENTS_T
893: UPDATE OKC_REP_IMP_DOCUMENTS_T
894: SET run_id = l_run_id,
895: request_id = l_request_id
896: WHERE imp_contract_id IN (SELECT imp_contract_id
897: FROM OKC_REP_IMP_CONTRACTS_T

Line 901: okc_debug.log('1000: After UPDATE OKC_REP_IMP_DOCUMENTS_T ', 1);

897: FROM OKC_REP_IMP_CONTRACTS_T
898: WHERE run_id = l_run_id);
899:
900: IF (l_debug = 'Y') THEN
901: okc_debug.log('1000: After UPDATE OKC_REP_IMP_DOCUMENTS_T ', 1);
902: END IF;
903:
904: --call the OKC_REP_UTIL_PVT.validate_and_insert_contracts
905: