APPS.IGS_UC_MV_DATA_UPLD dependencies on IGS_UC_ISTARC_INTS

Line 532: || replaced igs_uc_mv_ivstarc with igs_uc_istarc_ints which

528: || additional *C data for small systems support. Bug 2643048.
529: || Changed the Inst field positions from 18,4 to 18,3 after discussing with Martin
530: || as the table has it as 3 chars and was erroring out.
531: || smaddali 30-jun-03 Modified for ucfd203- multiple cycles build , bug#2669208
532: || replaced igs_uc_mv_ivstarc with igs_uc_istarc_ints which
533: || includes columns of igs_uc_ss_ivstarc table also
534: || rbezawad 13-Oct-03 Modified for ucfd209- Substitution Support build , bug#2669228
535: */
536:

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

535: */
536:
537: l_char_choice VARCHAR2(1) := TRIM(SUBSTR(p_record_data,17,1));
538: l_num_choice NUMBER(2);
539: ln_appno igs_uc_istarc_ints.appno%TYPE := TO_NUMBER(TRIM(SUBSTR(p_record_data,1,8)));
540: l_reason_for_transmission VARCHAR2(1) := TRIM(SUBSTR(p_record_data,10,1));
541: l_rowid VARCHAR2(25);
542: l_sql_stmt VARCHAR2(500);
543:

Line 627: UPDATE igs_uc_istarc_ints SET record_status = 'O'

623:
624: ELSE
625: --When Reason For Transmission i.e Character position 10 <> 'R'
626: -- Obsolete matching records in interface table with status N
627: UPDATE igs_uc_istarc_ints SET record_status = 'O'
628: WHERE record_status = 'N' AND appno = ln_appno
629: AND choiceno = l_num_choice AND ucas_cycle= g_c_cycles.configured_cycle;
630:
631: INSERT INTO igs_uc_istarc_ints(

Line 631: INSERT INTO igs_uc_istarc_ints(

627: UPDATE igs_uc_istarc_ints SET record_status = 'O'
628: WHERE record_status = 'N' AND appno = ln_appno
629: AND choiceno = l_num_choice AND ucas_cycle= g_c_cycles.configured_cycle;
630:
631: INSERT INTO igs_uc_istarc_ints(
632: appno,
633: choiceno,
634: ucas_cycle,
635: lastchange,