APPS.IGS_UC_MV_DATA_UPLD dependencies on IGS_UC_ISTARA_INTS

Line 427: || replaced igs_uc_mv_ivstara with igs_uc_istara_ints

423: || Change History :
424: || Who When What
425: || ayedubat 12-DEC-2002 Passed the SYSDATE for TIMESTAMP column for bug fix:2702489
426: || smaddali 30-jun-03 Modified for ucfd203- multiple cycles build , bug#2669208
427: || replaced igs_uc_mv_ivstara with igs_uc_istara_ints
428: || (reverse chronological order - newest change first)
429: */
430:
431: ln_appno igs_uc_istara_ints.appno%TYPE := TO_NUMBER(TRIM(SUBSTR(p_record_data,1,8)));

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

427: || replaced igs_uc_mv_ivstara with igs_uc_istara_ints
428: || (reverse chronological order - newest change first)
429: */
430:
431: ln_appno igs_uc_istara_ints.appno%TYPE := TO_NUMBER(TRIM(SUBSTR(p_record_data,1,8)));
432:
433: BEGIN
434:
435: fnd_message.set_name('IGS', 'IGS_UC_TRAN_PROC_APP');

Line 441: UPDATE igs_uc_istara_ints SET record_status = 'O'

437: fnd_message.set_token('APPNO', ln_appno);
438: fnd_file.put_line( fnd_file.log, fnd_message.get());
439:
440: -- Obsolete matching records in interface table with status N
441: UPDATE igs_uc_istara_ints SET record_status = 'O'
442: WHERE record_status = 'N' AND appno = ln_appno ;
443:
444: INSERT INTO igs_uc_istara_ints(
445: appno,

Line 444: INSERT INTO igs_uc_istara_ints(

440: -- Obsolete matching records in interface table with status N
441: UPDATE igs_uc_istara_ints SET record_status = 'O'
442: WHERE record_status = 'N' AND appno = ln_appno ;
443:
444: INSERT INTO igs_uc_istara_ints(
445: appno,
446: addressarea,
447: address1,
448: address2,