APPS.IGS_UC_MV_DATA_UPLD dependencies on IGS_UC_ISTARZ2_INTS

Line 1876: || igs_uc_mv_ivstarz2 with igs_uc_istarz2_ints

1872: || Change History :
1873: || Who When What
1874: || smaddali 30-jun-03 Modified for ucfd203- multiple cycles build , bug#2669208
1875: || replaced igs_uc_mv_ivstarz1 with igs_uc_istarz1_ints and
1876: || igs_uc_mv_ivstarz2 with igs_uc_istarz2_ints
1877: || (reverse chronological order - newest change first)
1878: */
1879:
1880: ln_position NUMBER;

Line 1943: UPDATE igs_uc_istarz2_ints SET record_status = 'O'

1939: FOR i in 1..8 LOOP
1940: IF TRIM(SUBSTR(p_record_data,ln_position,4)) IS NOT NULL THEN
1941:
1942: -- Obsolete matching records in interface table with status N
1943: UPDATE igs_uc_istarz2_ints SET record_status = 'O'
1944: WHERE record_status = 'N' AND appno = ln_appno
1945: AND inst = TRIM(SUBSTR(p_record_data,ln_position,3))
1946: AND course = TRIM(SUBSTR(p_record_data,ln_position+4,6))
1947: AND campus = TRIM(SUBSTR(p_record_data,ln_position+10,1));

Line 1949: INSERT INTO igs_uc_istarz2_ints(

1945: AND inst = TRIM(SUBSTR(p_record_data,ln_position,3))
1946: AND course = TRIM(SUBSTR(p_record_data,ln_position+4,6))
1947: AND campus = TRIM(SUBSTR(p_record_data,ln_position+10,1));
1948:
1949: INSERT INTO igs_uc_istarz2_ints(
1950: appno,
1951: roundno,
1952: inst,
1953: course,