APPS.IGS_UC_MV_DATA_UPLD dependencies on IGS_UC_ISTARX_INTS

Line 1793: || replaced igs_uc_mv_ivstarx with igs_uc_istarx_ints which

1789: ||
1790: || rgangara 11-Nov-02 Added logic to insert into IVSTARX extension table to hold
1791: || additional *X data for small systems support. Bug 2643048
1792: || smaddali 30-jun-03 Modified for ucfd203- multiple cycles build , bug#2669208
1793: || replaced igs_uc_mv_ivstarx with igs_uc_istarx_ints which
1794: || includes columns of igs_uc_ss_ivstarx table also
1795: */
1796:
1797: ln_appno igs_uc_istarx_ints.appno%TYPE := TO_NUMBER(TRIM(SUBSTR(p_record_data,1,8)));

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

1793: || replaced igs_uc_mv_ivstarx with igs_uc_istarx_ints which
1794: || includes columns of igs_uc_ss_ivstarx table also
1795: */
1796:
1797: ln_appno igs_uc_istarx_ints.appno%TYPE := TO_NUMBER(TRIM(SUBSTR(p_record_data,1,8)));
1798:
1799: BEGIN
1800:
1801: fnd_message.set_name('IGS', 'IGS_UC_TRAN_PROC_APP');

Line 1807: UPDATE igs_uc_istarx_ints SET record_status = 'O'

1803: fnd_message.set_token('APPNO', ln_appno);
1804: fnd_file.put_line( fnd_file.log, fnd_message.get());
1805:
1806: -- Obsolete matching records in interface table with status N
1807: UPDATE igs_uc_istarx_ints SET record_status = 'O'
1808: WHERE record_status = 'N' AND appno = ln_appno ;
1809:
1810:
1811: INSERT INTO igs_uc_istarx_ints(

Line 1811: INSERT INTO igs_uc_istarx_ints(

1807: UPDATE igs_uc_istarx_ints SET record_status = 'O'
1808: WHERE record_status = 'N' AND appno = ln_appno ;
1809:
1810:
1811: INSERT INTO igs_uc_istarx_ints(
1812: appno,
1813: ethnic,
1814: pocceduchangedate,
1815: socialclass,