APPS.IGS_UC_MV_DATA_UPLD dependencies on IGS_UC_ISTARG_INTS

Line 736: || replaced igs_uc_mv_ivstarg with igs_uc_istarg_ints

732: || Known limitations, enhancements or remarks :
733: || Change History :
734: || Who When What
735: || smaddali 30-jun-03 Modified for ucfd203- multiple cycles build , bug#2669208
736: || replaced igs_uc_mv_ivstarg with igs_uc_istarg_ints
737: || (reverse chronological order - newest change first)
738: ||
739: */
740:

Line 743: ln_appno igs_uc_istarg_ints.appno%TYPE := TO_NUMBER(TRIM(SUBSTR(p_record_data,1,8)));

739: */
740:
741: l_char_choice VARCHAR2(1) := TRIM(SUBSTR(p_record_data,17,1));
742: l_num_choice NUMBER(2);
743: ln_appno igs_uc_istarg_ints.appno%TYPE := TO_NUMBER(TRIM(SUBSTR(p_record_data,1,8)));
744:
745:
746: BEGIN
747:

Line 764: UPDATE igs_uc_istarg_ints SET record_status = 'O'

760: l_num_choice := TO_NUMBER(l_char_choice);
761: END IF;
762:
763: -- Obsolete matching records in interface table with status N
764: UPDATE igs_uc_istarg_ints SET record_status = 'O'
765: WHERE record_status = 'N' AND appno = ln_appno
766: AND roundno = l_num_choice ;
767:
768:

Line 769: INSERT INTO igs_uc_istarg_ints(

765: WHERE record_status = 'N' AND appno = ln_appno
766: AND roundno = l_num_choice ;
767:
768:
769: INSERT INTO igs_uc_istarg_ints(
770: appno ,
771: roundno ,
772: ucas_cycle ,
773: lastchange ,