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_MV_DATA_UPLD dependencies on IGS_UC_UCRSVAC_INTS

Line 2076: || replaced igs_uc_mv_uvcrs_vac with igs_uc_ucrsvac_ints and

2072: || Known limitations, enhancements or remarks :
2073: || Change History :
2074: || Who When What
2075: || smaddali 30-jun-03 Modified for ucfd203- multiple cycles build , bug#2669208
2076: || replaced igs_uc_mv_uvcrs_vac with igs_uc_ucrsvac_ints and
2077: || igs_uc_mv_uvcrs_vop with igs_uc_ucrsvop_ints
2078: || (reverse chronological order - newest change first)
2079: */
2080:

Line 2082: lv_course igs_uc_ucrsvac_ints.course%TYPE;

2078: || (reverse chronological order - newest change first)
2079: */
2080:
2081: ln_position NUMBER;
2082: lv_course igs_uc_ucrsvac_ints.course%TYPE;
2083: lv_campus igs_uc_ucrsvac_ints.campus%TYPE;
2084: lv_vac_status igs_uc_ucrsvac_ints.vacstatus%TYPE;
2085:
2086: BEGIN

Line 2083: lv_campus igs_uc_ucrsvac_ints.campus%TYPE;

2079: */
2080:
2081: ln_position NUMBER;
2082: lv_course igs_uc_ucrsvac_ints.course%TYPE;
2083: lv_campus igs_uc_ucrsvac_ints.campus%TYPE;
2084: lv_vac_status igs_uc_ucrsvac_ints.vacstatus%TYPE;
2085:
2086: BEGIN
2087:

Line 2084: lv_vac_status igs_uc_ucrsvac_ints.vacstatus%TYPE;

2080:
2081: ln_position NUMBER;
2082: lv_course igs_uc_ucrsvac_ints.course%TYPE;
2083: lv_campus igs_uc_ucrsvac_ints.campus%TYPE;
2084: lv_vac_status igs_uc_ucrsvac_ints.vacstatus%TYPE;
2085:
2086: BEGIN
2087:
2088: -- Extract the data into the temporary variables

Line 2094: UPDATE igs_uc_ucrsvac_ints SET record_status = 'O'

2090: lv_campus := TRIM(SUBSTR(p_record_data,7,1));
2091: lv_vac_status := TRIM(SUBSTR(p_record_data,8,1));
2092:
2093: -- Obsolete matching records in interface table with status N
2094: UPDATE igs_uc_ucrsvac_ints SET record_status = 'O'
2095: WHERE record_status = 'N' AND course = lv_course AND campus = lv_campus ;
2096:
2097:
2098: -- Each QC transaction indicates the Vacancy detals and 100 vancancy options details.

Line 2100: INSERT INTO igs_uc_ucrsvac_ints(

2096:
2097:
2098: -- Each QC transaction indicates the Vacancy detals and 100 vancancy options details.
2099: -- All the vacancy option details are stored in igs_uc_mv_uvcrs_vop table
2100: INSERT INTO igs_uc_ucrsvac_ints(
2101: course,
2102: campus,
2103: updater,
2104: clupdated,