APPS.IGS_UC_MV_DATA_UPLD dependencies on IGS_UC_UCRSVOP_INTS

Line 2077: || igs_uc_mv_uvcrs_vop with igs_uc_ucrsvop_ints

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:
2081: ln_position NUMBER;

Line 2135: UPDATE igs_uc_ucrsvop_ints SET record_status = 'O'

2131:
2132: FOR i In 1..100 LOOP
2133: IF TRIM(SUBSTR(p_record_data,ln_position,2)) IS NOT NULL THEN
2134: -- Obsolete matching records in interface table with status N
2135: UPDATE igs_uc_ucrsvop_ints SET record_status = 'O'
2136: WHERE record_status = 'N' AND course = lv_course
2137: AND campus = lv_campus AND optioncode = TRIM(SUBSTR(p_record_data,ln_position,2)) ;
2138:
2139:

Line 2140: INSERT INTO igs_uc_ucrsvop_ints(

2136: WHERE record_status = 'N' AND course = lv_course
2137: AND campus = lv_campus AND optioncode = TRIM(SUBSTR(p_record_data,ln_position,2)) ;
2138:
2139:
2140: INSERT INTO igs_uc_ucrsvop_ints(
2141: course,
2142: campus,
2143: optioncode,
2144: updater,