APPS.IGS_UC_MV_DATA_UPLD dependencies on IGS_UC_ISTART_INTS

Line 1622: || replaced igs_uc_mv_ivstart with igs_uc_istart_ints

1618: || Known limitations, enhancements or remarks :
1619: || Change History :
1620: || Who When What
1621: || smaddali 30-jun-03 Modified for ucfd203- multiple cycles build , bug#2669208
1622: || replaced igs_uc_mv_ivstart with igs_uc_istart_ints
1623: || (reverse chronological order - newest change first)
1624: ||
1625: */
1626:

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

1623: || (reverse chronological order - newest change first)
1624: ||
1625: */
1626:
1627: ln_appno igs_uc_istart_ints.appno%TYPE := TO_NUMBER(TRIM(SUBSTR(p_record_data,1,8)));
1628:
1629: BEGIN
1630:
1631: fnd_message.set_name('IGS', 'IGS_UC_TRAN_PROC_APP');

Line 1637: UPDATE igs_uc_istart_ints SET record_status = 'O'

1633: fnd_message.set_token('APPNO', ln_appno);
1634: fnd_file.put_line( fnd_file.log, fnd_message.get());
1635:
1636: -- Obsolete matching records in interface table with status N
1637: UPDATE igs_uc_istart_ints SET record_status = 'O'
1638: WHERE record_status = 'N' AND appno = ln_appno ;
1639:
1640: INSERT INTO igs_uc_istart_ints(
1641: appno ,

Line 1640: INSERT INTO igs_uc_istart_ints(

1636: -- Obsolete matching records in interface table with status N
1637: UPDATE igs_uc_istart_ints SET record_status = 'O'
1638: WHERE record_status = 'N' AND appno = ln_appno ;
1639:
1640: INSERT INTO igs_uc_istart_ints(
1641: appno ,
1642: lastchange ,
1643: futureserv ,
1644: futureset ,