DBA Data[Home] [Help]

APPS.IGS_HE_CREATE_EXTRACT_PKG dependencies on IGS_HE_EXT_RUN_DTLS

Line 136: FROM igs_he_ext_run_dtls dtls,

132: dtls.file_location,
133: dtls.file_name,
134: shd.enrolment_start_date,
135: shd.enrolment_end_date
136: FROM igs_he_ext_run_dtls dtls,
137: igs_he_submsn_header shd,
138: igs_he_submsn_return srt
139: WHERE dtls.extract_run_id = p_extract_run_id
140: AND shd.submission_name = dtls.submission_name

Line 474: UPDATE igs_he_ext_run_dtls

470: RETURN;
471: END;
472:
473: -- Update extract criteria with location file has been written to
474: UPDATE igs_he_ext_run_dtls
475: SET file_location = l_filepath
476: WHERE extract_run_id = p_extract_run_id;
477:
478: -- Log lines written and filename