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_TRAN_PROCESSOR_PKG dependencies on IGS_UC_U_TRANIN_2003

Line 1477: FROM igs_uc_u_tranin_2003

1473:
1474: CURSOR cur_update_info(cp_appno igs_uc_transactions.app_no%TYPE) IS
1475: SELECT appno, choiceno, transactionID, errorcode,
1476: timestamp, updater, return1, return2, soc
1477: FROM igs_uc_u_tranin_2003
1478: WHERE appno = cp_appno
1479: AND transactionID = (SELECT MAX(TransactionID)
1480: FROM igs_uc_u_tranin_2003
1481: WHERE appno = cp_appno);

Line 1480: FROM igs_uc_u_tranin_2003

1476: timestamp, updater, return1, return2, soc
1477: FROM igs_uc_u_tranin_2003
1478: WHERE appno = cp_appno
1479: AND transactionID = (SELECT MAX(TransactionID)
1480: FROM igs_uc_u_tranin_2003
1481: WHERE appno = cp_appno);
1482:
1483: CURSOR cur_offer_conds(cp_test_cond_cat igs_uc_transactions.test_cond_cat%TYPE,
1484: cp_test_cond_name igs_uc_transactions.test_cond_name%TYPE) IS

Line 1500: -- get the Transaction records from IGS_UC_TRANSACTIONS table and insert into Hercules igs_uc_u_tranin_2003 View.

1496: l_soc igs_uc_transactions.soc%TYPE;
1497:
1498: BEGIN
1499:
1500: -- get the Transaction records from IGS_UC_TRANSACTIONS table and insert into Hercules igs_uc_u_tranin_2003 View.
1501: FOR uc_transaction_rec IN cur_records_to_write(p_conf_cycle)
1502: LOOP
1503: l_app_no := uc_transaction_rec.app_no;
1504:

Line 1505: INSERT INTO igs_uc_u_tranin_2003(transactionid,

1501: FOR uc_transaction_rec IN cur_records_to_write(p_conf_cycle)
1502: LOOP
1503: l_app_no := uc_transaction_rec.app_no;
1504:
1505: INSERT INTO igs_uc_u_tranin_2003(transactionid,
1506: timestamp,
1507: updater,
1508: errorcode,
1509: transactiontype,