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_UC_EXPORT_DECISION_REPLY dependencies on IGS_AD_OFFRESP_BATCH_S

Line 1644: SELECT igs_ad_offresp_batch_s.NEXTVAL

1640: cur_reply_import_error_rec cur_reply_import_error%ROWTYPE ;
1641:
1642: -- Cursor to fetch the value from the sequence for inserting a record into IGS_AD_OFFRESP_BATCH table
1643: CURSOR cur_offresp_batc_s IS
1644: SELECT igs_ad_offresp_batch_s.NEXTVAL
1645: FROM dual ;
1646:
1647: --Cursor to get the Calendar details for the given System, Entry Month and Entry Year.
1648: CURSOR cur_sys_entry_cal_det ( cp_system_code igs_uc_sys_calndrs.system_code%TYPE,

Line 1680: -- Get the Batch ID using the sequence, IGS_AD_OFFRESP_BATCH_S

1676: l_conc_request_id := fnd_global.conc_request_id() ;
1677: l_exp_reply_flag := FALSE ;
1678:
1679: -- Populate the Offer Response Import Interface Batch table,IGS_AD_OFFRESP_BATCH
1680: -- Get the Batch ID using the sequence, IGS_AD_OFFRESP_BATCH_S
1681: l_batch_id := NULL ;
1682: OPEN cur_offresp_batc_s ;
1683: FETCH cur_offresp_batc_s INTO l_batch_id ;
1684: CLOSE cur_offresp_batc_s ;

Line 1728: as the value is taken from igs_ad_offresp_batch_s sequence */

1724: -- Initialize the variable for each Application Choice
1725: l_app_choice_error_code := NULL ;
1726: l_export_to_oss := NULL ;
1727: /* Commented the re-initialization of the batch id variable for bug 2738551
1728: as the value is taken from igs_ad_offresp_batch_s sequence */
1729: -- l_batch_id := NULL ;
1730:
1731: -- Fetch the default values setup for the UCAS in the SYSTEM,
1732: -- These values will be used in this procedure whereever default values requires