eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_UC_MV_DATA_UPLD dependencies on IGS_UC_ISTARW_INTS

Line 59: | choice6lost, choice7lost of igs_uc_istarw_ints for |

55: | the column names substchoice1, substchoice2, |
56: | substchoice3, substchoice4, substchoice5, |
57: | substchoice6 and substchoice7 with choice1lost, |
58: | choice2lost, choice3lost, choice4lost, choice5lost, |
59: | choice6lost, choice7lost of igs_uc_istarw_ints for |
60: | bug, 2669208. |
61: | smaddali 07-Aug-03 Modified procedure logic for updating *N INTS record |
62: | in *K and *N transaction processing procedures for |
63: | bug 3085770 |

Line 544: -- Check any record with passed AppNo exists in IGS_UC_ISTARW_INTS with record_status = 'N'

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:
544: -- Check any record with passed AppNo exists in IGS_UC_ISTARW_INTS with record_status = 'N'
545: CURSOR cur_wrong_app (cp_appno igs_uc_istarw_ints.appno%TYPE) IS
546: SELECT w.ROWID
547: FROM igs_uc_istarw_ints w
548: WHERE w.appno = cp_appno

Line 545: CURSOR cur_wrong_app (cp_appno igs_uc_istarw_ints.appno%TYPE) IS

541: l_rowid VARCHAR2(25);
542: l_sql_stmt VARCHAR2(500);
543:
544: -- Check any record with passed AppNo exists in IGS_UC_ISTARW_INTS with record_status = 'N'
545: CURSOR cur_wrong_app (cp_appno igs_uc_istarw_ints.appno%TYPE) IS
546: SELECT w.ROWID
547: FROM igs_uc_istarw_ints w
548: WHERE w.appno = cp_appno
549: AND w.record_status = 'N';

Line 547: FROM igs_uc_istarw_ints w

543:
544: -- Check any record with passed AppNo exists in IGS_UC_ISTARW_INTS with record_status = 'N'
545: CURSOR cur_wrong_app (cp_appno igs_uc_istarw_ints.appno%TYPE) IS
546: SELECT w.ROWID
547: FROM igs_uc_istarw_ints w
548: WHERE w.appno = cp_appno
549: AND w.record_status = 'N';
550:
551: BEGIN

Line 576: --Check any record with this AppNo exists in IGS_UC_ISTARW_INTS with record_status = 'N'

572: OPEN cur_wrong_app (ln_appno);
573: FETCH cur_wrong_app INTO l_rowid;
574: CLOSE cur_wrong_app;
575:
576: --Check any record with this AppNo exists in IGS_UC_ISTARW_INTS with record_status = 'N'
577: IF l_rowid IS NOT NULL THEN
578: IF l_num_choice BETWEEN 1 AND 7 THEN
579: --The update should be such that other choicelost fields should retain their existing values
580: -- and only the current choice related choicelost field value should get updated in the IGS_UC_ISTARW_INTS table.

Line 580: -- and only the current choice related choicelost field value should get updated in the IGS_UC_ISTARW_INTS table.

576: --Check any record with this AppNo exists in IGS_UC_ISTARW_INTS with record_status = 'N'
577: IF l_rowid IS NOT NULL THEN
578: IF l_num_choice BETWEEN 1 AND 7 THEN
579: --The update should be such that other choicelost fields should retain their existing values
580: -- and only the current choice related choicelost field value should get updated in the IGS_UC_ISTARW_INTS table.
581: l_sql_stmt := 'UPDATE igs_uc_istarw_ints SET choice'||l_num_choice||'lost = ''Y'' WHERE ROWID = :1';
582: EXECUTE IMMEDIATE l_sql_stmt USING l_rowid;
583: END IF;
584:

Line 581: l_sql_stmt := 'UPDATE igs_uc_istarw_ints SET choice'||l_num_choice||'lost = ''Y'' WHERE ROWID = :1';

577: IF l_rowid IS NOT NULL THEN
578: IF l_num_choice BETWEEN 1 AND 7 THEN
579: --The update should be such that other choicelost fields should retain their existing values
580: -- and only the current choice related choicelost field value should get updated in the IGS_UC_ISTARW_INTS table.
581: l_sql_stmt := 'UPDATE igs_uc_istarw_ints SET choice'||l_num_choice||'lost = ''Y'' WHERE ROWID = :1';
582: EXECUTE IMMEDIATE l_sql_stmt USING l_rowid;
583: END IF;
584:
585: ELSE

Line 586: --Insert a new record into IGS_UC_ISTARW_INTS

582: EXECUTE IMMEDIATE l_sql_stmt USING l_rowid;
583: END IF;
584:
585: ELSE
586: --Insert a new record into IGS_UC_ISTARW_INTS
587: INSERT INTO igs_uc_istarw_ints(
588: appno,
589: miscoded,
590: cancelled,

Line 587: INSERT INTO igs_uc_istarw_ints(

583: END IF;
584:
585: ELSE
586: --Insert a new record into IGS_UC_ISTARW_INTS
587: INSERT INTO igs_uc_istarw_ints(
588: appno,
589: miscoded,
590: cancelled,
591: canceldate,

Line 1704: || replaced igs_uc_mv_ivstarw with igs_uc_istarw_ints

1700: ||
1701: || rbezawad 24-Sep-2002 Added code to populate igs_uc_mv_ivstarw.JOINTADMISSION column value based on value in 17 column position.
1702: || Modified w.r.t. UCFD06 Build 2574566.
1703: || smaddali 30-jun-03 Modified for ucfd203- multiple cycles build , bug#2669208
1704: || replaced igs_uc_mv_ivstarw with igs_uc_istarw_ints
1705: */
1706:
1707: ln_appno igs_uc_istarw_ints.appno%TYPE := TO_NUMBER(TRIM(SUBSTR(p_record_data,1,8)));
1708:

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

1703: || smaddali 30-jun-03 Modified for ucfd203- multiple cycles build , bug#2669208
1704: || replaced igs_uc_mv_ivstarw with igs_uc_istarw_ints
1705: */
1706:
1707: ln_appno igs_uc_istarw_ints.appno%TYPE := TO_NUMBER(TRIM(SUBSTR(p_record_data,1,8)));
1708:
1709: BEGIN
1710:
1711: fnd_message.set_name('IGS', 'IGS_UC_TRAN_PROC_APP');

Line 1717: UPDATE igs_uc_istarw_ints SET record_status = 'O'

1713: fnd_message.set_token('APPNO', ln_appno);
1714: fnd_file.put_line( fnd_file.log, fnd_message.get());
1715:
1716: -- Obsolete matching records in interface table with status N
1717: UPDATE igs_uc_istarw_ints SET record_status = 'O'
1718: WHERE record_status = 'N' AND appno = ln_appno ;
1719:
1720: INSERT INTO igs_uc_istarw_ints(
1721: appno,

Line 1720: INSERT INTO igs_uc_istarw_ints(

1716: -- Obsolete matching records in interface table with status N
1717: UPDATE igs_uc_istarw_ints SET record_status = 'O'
1718: WHERE record_status = 'N' AND appno = ln_appno ;
1719:
1720: INSERT INTO igs_uc_istarw_ints(
1721: appno,
1722: miscoded,
1723: cancelled,
1724: canceldate,