DBA Data[Home] [Help]

APPS.IGS_UC_EXPORT_DECISION_REPLY dependencies on IGS_AD_OFFRESP_BATCH

Line 1442: l_batch_id igs_ad_offresp_batch.batch_id%TYPE ;

1438: jbaber 07-Jun-2006 Added decline_ofr_reason for bug 528190/5222716
1439: ******************************************************************/
1440:
1441: -- Local Variables definition
1442: l_batch_id igs_ad_offresp_batch.batch_id%TYPE ;
1443: l_conc_request_id NUMBER(15) ;
1444: l_errbuf VARCHAR2(2000) ;
1445: l_retcode NUMBER(15) ;
1446: l_export_to_oss igs_uc_app_choices.export_to_oss_status%TYPE ;

Line 1642: -- Cursor to fetch the value from the sequence for inserting a record into IGS_AD_OFFRESP_BATCH table

1638: AND sequence_number = p_sequence_number
1639: AND status IN ( 2,3 ) ;
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:

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 1679: -- Populate the Offer Response Import Interface Batch table,IGS_AD_OFFRESP_BATCH

1675: -- OSS admission applications run
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 ;

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 1686: -- Find the WHO columns to insert a record into IGS_AD_OFFRESP_BATCH table

1682: OPEN cur_offresp_batc_s ;
1683: FETCH cur_offresp_batc_s INTO l_batch_id ;
1684: CLOSE cur_offresp_batc_s ;
1685:
1686: -- Find the WHO columns to insert a record into IGS_AD_OFFRESP_BATCH table
1687: l_last_updated_by := NVL(FND_GLOBAL.USER_ID,-1) ;
1688: l_last_update_login := NVL(FND_GLOBAL.LOGIN_ID,-1) ;
1689:
1690: -- Get the Description value from the Message,IGS_UC_OFF_BATCH

Line 1694: INSERT INTO igs_ad_offresp_batch

1690: -- Get the Description value from the Message,IGS_UC_OFF_BATCH
1691: fnd_message.set_name('IGS','IGS_UC_OFF_BATCH');
1692: l_description := fnd_message.get;
1693:
1694: INSERT INTO igs_ad_offresp_batch
1695: ( batch_id,
1696: batch_desc,
1697: created_by,
1698: creation_date,

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