APPS.IGS_UC_LOAD_HERCULES_DATA dependencies on IGS_UC_IOFFER_INTS

Line 4524: igs_uc_ioffer_ints with record status N

4520: /******************************************************************
4521: Created By : smaddali
4522: Date Created By : 11-Jun-03
4523: Purpose : loads each record in the hercules view ivoffer into the interface table
4524: igs_uc_ioffer_ints with record status N
4525: Known limitations,enhancements,remarks:
4526: Change History
4527: Who When What
4528: ***************************************************************** */

Line 4556: l_appno igs_uc_ioffer_ints.appno%TYPE;

4552: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;
4553: l_new_max_timestamp igs_uc_ivoffer_2003_v.timestamp%TYPE ;
4554: l_count NUMBER ;
4555:
4556: l_appno igs_uc_ioffer_ints.appno%TYPE;
4557: l_checkdigit NUMBER;
4558:
4559: BEGIN
4560: -- set syncronization required to false

Line 4581: UPDATE igs_uc_ioffer_ints SET record_status = 'O'

4577: -- Determine actual appno
4578: get_appno(c_ivoffer_rec.appno, NULL, l_appno, l_checkdigit);
4579:
4580: -- Obsolete matching records in interface table with status N
4581: UPDATE igs_uc_ioffer_ints SET record_status = 'O'
4582: WHERE record_status = 'N' AND appno = l_appno
4583: AND choiceno = c_ivoffer_rec.choiceno ;
4584:
4585:

Line 4587: INSERT INTO igs_uc_ioffer_ints ( appno,

4583: AND choiceno = c_ivoffer_rec.choiceno ;
4584:
4585:
4586: -- copy hercules record into interface table with record status N
4587: INSERT INTO igs_uc_ioffer_ints ( appno,
4588: choiceno,
4589: offercourse,
4590: offercampus,
4591: offercourselength,

Line 4652: igs_uc_ioffer_ints with record status N

4648: /******************************************************************
4649: Created By : jtmathew
4650: Date Created By : 08-Jul-05
4651: Purpose : loads each record in the odbc-link view ivgoffer into the interface table
4652: igs_uc_ioffer_ints with record status N
4653: Known limitations,enhancements,remarks:
4654: Change History
4655: Who When What
4656: ***************************************************************** */

Line 4676: l_appno igs_uc_ioffer_ints.appno%TYPE;

4672:
4673: -- Variables
4674: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;
4675: l_new_max_timestamp igs_uc_ivgoffer_2006_v.timestamp%TYPE ;
4676: l_appno igs_uc_ioffer_ints.appno%TYPE;
4677: l_checkdigit NUMBER;
4678: l_count NUMBER ;
4679:
4680:

Line 4703: UPDATE igs_uc_ioffer_ints SET record_status = 'O'

4699: -- Determine actual appno
4700: get_appno(c_ivgoffer_rec.appno, NULL, l_appno, l_checkdigit);
4701:
4702: -- Obsolete matching records in interface table with status N
4703: UPDATE igs_uc_ioffer_ints SET record_status = 'O'
4704: WHERE record_status = 'N' AND appno = c_ivgoffer_rec.appno
4705: AND choiceno = c_ivgoffer_rec.roundno ;
4706:
4707: -- copy hercules record into interface table with record status N

Line 4708: INSERT INTO igs_uc_ioffer_ints ( appno,

4704: WHERE record_status = 'N' AND appno = c_ivgoffer_rec.appno
4705: AND choiceno = c_ivgoffer_rec.roundno ;
4706:
4707: -- copy hercules record into interface table with record status N
4708: INSERT INTO igs_uc_ioffer_ints ( appno,
4709: choiceno,
4710: offertext,
4711: record_status,
4712: error_code,

Line 4761: igs_uc_ioffer_ints with record status N

4757: /******************************************************************
4758: Created By : jtmathew
4759: Date Created By : 08-Jul-05
4760: Purpose : loads each record in the odbc-link view ivnoffer into the interface table
4761: igs_uc_ioffer_ints with record status N
4762: Known limitations,enhancements,remarks:
4763: Change History
4764: Who When What
4765: ***************************************************************** */

Line 4785: l_appno igs_uc_ioffer_ints.appno%TYPE;

4781:
4782: -- Variables
4783: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;
4784: l_new_max_timestamp igs_uc_ivnoffer_2006_v.timestamp%TYPE ;
4785: l_appno igs_uc_ioffer_ints.appno%TYPE;
4786: l_checkdigit NUMBER;
4787: l_count NUMBER ;
4788:
4789:

Line 4812: UPDATE igs_uc_ioffer_ints SET record_status = 'O'

4808: -- Determine actual appno
4809: get_appno(c_ivnoffer_rec.appno, NULL, l_appno, l_checkdigit);
4810:
4811: -- Obsolete matching records in interface table with status N
4812: UPDATE igs_uc_ioffer_ints SET record_status = 'O'
4813: WHERE record_status = 'N' AND appno = c_ivnoffer_rec.appno
4814: AND choiceno = c_ivnoffer_rec.choiceno ;
4815:
4816: -- copy hercules record into interface table with record status N

Line 4817: INSERT INTO igs_uc_ioffer_ints ( appno,

4813: WHERE record_status = 'N' AND appno = c_ivnoffer_rec.appno
4814: AND choiceno = c_ivnoffer_rec.choiceno ;
4815:
4816: -- copy hercules record into interface table with record status N
4817: INSERT INTO igs_uc_ioffer_ints ( appno,
4818: choiceno,
4819: offertext,
4820: record_status,
4821: error_code,