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.

[Home] [Help]

APPS.IGS_UC_TRAN_PROCESSOR_PKG dependencies on IGS_UC_U_TRANIN_2004

Line 1693: FROM igs_uc_u_tranin_2004

1689:
1690: CURSOR cur_update_info(cp_appno igs_uc_transactions.app_no%TYPE) IS
1691: SELECT appno, choiceno, transactionID, errorcode,
1692: timestamp, updater, return1, return2, soc, roundno
1693: FROM igs_uc_u_tranin_2004
1694: WHERE appno = cp_appno
1695: AND transactionID = (SELECT MAX(TransactionID)
1696: FROM igs_uc_u_tranin_2004
1697: WHERE appno = cp_appno);

Line 1696: FROM igs_uc_u_tranin_2004

1692: timestamp, updater, return1, return2, soc, roundno
1693: FROM igs_uc_u_tranin_2004
1694: WHERE appno = cp_appno
1695: AND transactionID = (SELECT MAX(TransactionID)
1696: FROM igs_uc_u_tranin_2004
1697: WHERE appno = cp_appno);
1698:
1699: CURSOR cur_offer_conds(cp_test_cond_cat igs_uc_transactions.test_cond_cat%TYPE,
1700: cp_test_cond_name igs_uc_transactions.test_cond_name%TYPE) IS

Line 1718: l_appno igs_uc_u_tranin_2004.appno%TYPE;

1714: WHERE app_no = cp_appno;
1715:
1716: l_user_id Varchar2(20) := fnd_global.user_id;
1717: l_soc igs_uc_transactions.soc%TYPE;
1718: l_appno igs_uc_u_tranin_2004.appno%TYPE;
1719:
1720: BEGIN
1721:
1722: --When the Interface is Hercules then get the Transaction records from IGS_UC_TRANSACTIONS table and insert into Hercules igs_uc_u_tranin_2004 .

Line 1722: --When the Interface is Hercules then get the Transaction records from IGS_UC_TRANSACTIONS table and insert into Hercules igs_uc_u_tranin_2004 .

1718: l_appno igs_uc_u_tranin_2004.appno%TYPE;
1719:
1720: BEGIN
1721:
1722: --When the Interface is Hercules then get the Transaction records from IGS_UC_TRANSACTIONS table and insert into Hercules igs_uc_u_tranin_2004 .
1723: FOR uc_transaction_rec IN cur_records_to_write(p_conf_cycle)
1724: LOOP
1725:
1726: -- For cycle 2004 syscode, roundno, modular, parttime columns are added in tranin table

Line 1739: INSERT INTO igs_uc_u_tranin_2004(transactionid,

1735: END IF;
1736:
1737: IF uc_transaction_rec.system_code = 'G' THEN
1738:
1739: INSERT INTO igs_uc_u_tranin_2004(transactionid,
1740: timestamp,
1741: updater,
1742: errorcode,
1743: transactiontype,

Line 1786: INSERT INTO igs_uc_u_tranin_2004(transactionid,

1782: uc_transaction_rec.part_time);
1783:
1784: ELSE
1785:
1786: INSERT INTO igs_uc_u_tranin_2004(transactionid,
1787: timestamp,
1788: updater,
1789: errorcode,
1790: transactiontype,

Line 1834: -- the newly inserted record from igs_uc_u_tranin_2004 and Update the IGS_UC_TRANSACTIONS Table.

1830:
1831: END IF;
1832:
1833: -- Get back the values for transactionID,errorcode,timestamp,updater,return1,return2 columns for
1834: -- the newly inserted record from igs_uc_u_tranin_2004 and Update the IGS_UC_TRANSACTIONS Table.
1835:
1836: FOR tranin_rec IN cur_update_info(l_appno)
1837: LOOP
1838: