APPS.IGS_UC_MV_DATA_UPLD dependencies on IGS_UC_ISTARH_INTS

Line 861: || replaced igs_uc_mv_ivstarh with igs_uc_istarh_ints which

857: || (reverse chronological order - newest change first)
858: || rgangara 11-Nov-02 Added logic to insert into IVSTARH extension table to hold
859: || additional *H data for small systems support. Bug 2643048
860: || smaddali 30-jun-03 Modified for ucfd203- multiple cycles build , bug#2669208
861: || replaced igs_uc_mv_ivstarh with igs_uc_istarh_ints which
862: || includes columns of igs_uc_ss_ivstarh table also
863: */
864:
865:

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

862: || includes columns of igs_uc_ss_ivstarh table also
863: */
864:
865:
866: ln_appno igs_uc_istarh_ints.appno%TYPE := TO_NUMBER(TRIM(SUBSTR(p_record_data,1,8)));
867:
868:
869: BEGIN
870:

Line 877: UPDATE igs_uc_istarh_ints SET record_status = 'O'

873: fnd_message.set_token('APPNO', ln_appno);
874: fnd_file.put_line( fnd_file.log, fnd_message.get());
875:
876: -- Obsolete matching records in interface table with status N
877: UPDATE igs_uc_istarh_ints SET record_status = 'O'
878: WHERE record_status = 'N' AND appno = ln_appno ;
879:
880: INSERT INTO igs_uc_istarh_ints(
881: appno,

Line 880: INSERT INTO igs_uc_istarh_ints(

876: -- Obsolete matching records in interface table with status N
877: UPDATE igs_uc_istarh_ints SET record_status = 'O'
878: WHERE record_status = 'N' AND appno = ln_appno ;
879:
880: INSERT INTO igs_uc_istarh_ints(
881: appno,
882: ethnic,
883: socialclass,
884: pocceduchangedate,