APPS.IGS_UC_LOAD_HERCULES_DATA dependencies on IGS_UC_CCRSE_INTS

Line 347: igs_uc_ccrse_ints with record status N

343: /******************************************************************
344: Created By : smaddali
345: Date Created By : 11-Jun-03
346: Purpose : loads each record in the hercules view CVCOURSE into the interface table
347: igs_uc_ccrse_ints with record status N
348: Known limitations,enhancements,remarks:
349: Change History
350: Who When What
351: jbaber 15-Sep-05 Replace campus value with '*' if NULL for bug 4589994

Line 352: jbaber 11-Jul-06 Added system_code field to igs_uc_ccrse_ints

348: Known limitations,enhancements,remarks:
349: Change History
350: Who When What
351: jbaber 15-Sep-05 Replace campus value with '*' if NULL for bug 4589994
352: jbaber 11-Jul-06 Added system_code field to igs_uc_ccrse_ints
353: ***************************************************************** */
354:
355: -- Get all the records from hercules view whose timestamp is > passed timestamp
356: -- or get all the records in hercules view if the timestamp passed is null

Line 399: UPDATE igs_uc_ccrse_ints SET record_status = 'O'

395: -- set x_sync_read to true if the loop is entered even once
396: g_sync_reqd := TRUE;
397:
398: -- Obsolete matching records in interface table with status N
399: UPDATE igs_uc_ccrse_ints SET record_status = 'O'
400: WHERE record_status = 'N' AND course = c_cvcourse_rec.course
401: AND campus = c_cvcourse_rec.campus AND inst = c_cvcourse_rec.inst ;
402:
403: -- copy hercules record into interface table with record status N

Line 404: INSERT INTO igs_uc_ccrse_ints ( inst,

400: WHERE record_status = 'N' AND course = c_cvcourse_rec.course
401: AND campus = c_cvcourse_rec.campus AND inst = c_cvcourse_rec.inst ;
402:
403: -- copy hercules record into interface table with record status N
404: INSERT INTO igs_uc_ccrse_ints ( inst,
405: course,
406: campus,
407: faculty,
408: shortname,

Line 468: igs_uc_ccrse_ints with record status N

464: /******************************************************************
465: Created By : jbaber
466: Date Created By : 11-Jun-06
467: Purpose : loads each record in the hercules view CVGCOURSE into the interface table
468: igs_uc_ccrse_ints with record status N
469: Known limitations,enhancements,remarks:
470: Change History
471: Who When What
472: ***************************************************************** */

Line 513: UPDATE igs_uc_ccrse_ints SET record_status = 'O'

509: -- set x_sync_read to true if the loop is entered even once
510: g_sync_reqd := TRUE;
511:
512: -- Obsolete matching records in interface table with status N
513: UPDATE igs_uc_ccrse_ints SET record_status = 'O'
514: WHERE record_status = 'N' AND course = c_cvgcourse_rec.course
515: AND campus = c_cvgcourse_rec.campus AND inst = c_cvgcourse_rec.inst ;
516:
517: -- copy hercules record into interface table with record status N

Line 518: INSERT INTO igs_uc_ccrse_ints ( inst,

514: WHERE record_status = 'N' AND course = c_cvgcourse_rec.course
515: AND campus = c_cvgcourse_rec.campus AND inst = c_cvgcourse_rec.inst ;
516:
517: -- copy hercules record into interface table with record status N
518: INSERT INTO igs_uc_ccrse_ints ( inst,
519: course,
520: campus,
521: shortname,
522: longname,

Line 572: igs_uc_ccrse_ints with record status N

568: /******************************************************************
569: Created By : jbaber
570: Date Created By : 11-Jun-06
571: Purpose : loads each record in the hercules view CVNCOURSE into the interface table
572: igs_uc_ccrse_ints with record status N
573: Known limitations,enhancements,remarks:
574: Change History
575: Who When What
576: ***************************************************************** */

Line 617: UPDATE igs_uc_ccrse_ints SET record_status = 'O'

613: -- set x_sync_read to true if the loop is entered even once
614: g_sync_reqd := TRUE;
615:
616: -- Obsolete matching records in interface table with status N
617: UPDATE igs_uc_ccrse_ints SET record_status = 'O'
618: WHERE record_status = 'N' AND course = c_cvncourse_rec.course
619: AND campus = c_cvncourse_rec.campus AND inst = c_cvncourse_rec.inst ;
620:
621: -- copy hercules record into interface table with record status N

Line 622: INSERT INTO igs_uc_ccrse_ints ( inst,

618: WHERE record_status = 'N' AND course = c_cvncourse_rec.course
619: AND campus = c_cvncourse_rec.campus AND inst = c_cvncourse_rec.inst ;
620:
621: -- copy hercules record into interface table with record status N
622: INSERT INTO igs_uc_ccrse_ints ( inst,
623: course,
624: campus,
625: shortname,
626: longname,