eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_HE_SUBMSN_RETURN_PKG dependencies on IGS_HE_SUBMSN_RETURN_S

Line 156: CURSOR cur_check_record_exist (cp_submission_name igs_he_submsn_return.submission_name%type)

152: || (reverse chronological order - newest change first)
153: || smaddali 9-jan-04 added condition to check rowid also, bug#2966258
154: */
155: --cursor to check for the existence of the submission return record for 'DLHE' system return class
156: CURSOR cur_check_record_exist (cp_submission_name igs_he_submsn_return.submission_name%type)
157: IS
158: SELECT hsr.rowid
159: FROM IGS_HE_SUBMSN_RETURN hsr, IGS_HE_USR_RTN_CLAS hurc
160: WHERE hsr.submission_name = cp_submission_name AND

Line 444: SELECT igs_he_submsn_return_s.NEXTVAL

440: igs_ge_msg_stack.add;
441: app_exception.raise_exception;
442: END IF;
443:
444: SELECT igs_he_submsn_return_s.NEXTVAL
445: INTO x_sub_rtn_id
446: FROM dual;
447:
448: before_dml(