DBA Data[Home] [Help]

APPS.IGS_UC_UPD_PENDING_TRANS_PKG dependencies on IGS_UC_U_TRANIN_2004

Line 95: cp_app_no igs_uc_u_tranin_2004.appno%TYPE) IS

91: AND TRANS.UCAS_CYCLE = DFLTS.UCAS_CYCLE
92: AND DFLTS.UCAS_INTERFACE = 'H';
93:
94: CURSOR c_tranin_info(cp_trans_id igs_uc_transactions.transaction_id%TYPE,
95: cp_app_no igs_uc_u_tranin_2004.appno%TYPE) IS
96: SELECT APPNO,
97: CHOICENO,
98: TRANSACTIONID,
99: ERRORCODE,

Line 106: IGS_UC_U_TRANIN_2004

102: RETURN1,
103: RETURN2,
104: SOC
105: FROM
106: IGS_UC_U_TRANIN_2004
107: WHERE
108: TRANSACTIONID = cp_trans_id
109: AND APPNO = cp_app_no;
110:

Line 124: l_appno igs_uc_u_tranin_2004.appno%TYPE;

120: l_entry_year igs_uc_defaults.configured_cycle%TYPE;
121: l_pending_cnt NUMBER;
122: l_valid_cnt NUMBER;
123: l_invalid_cnt NUMBER;
124: l_appno igs_uc_u_tranin_2004.appno%TYPE;
125:
126: BEGIN
127:
128: --anwest 18-JAN-2006 Bug# 4950285 R12 Disable OSS Mandate

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

177: fnd_message.set_name('IGS','IGS_UC_INIT_TRAN_PENDING_CNT');
178: fnd_message.set_token('REC_CNT',l_pending_cnt);
179: fnd_file.put_line(fnd_file.log, fnd_message.get());
180:
181: --When the Interface is Hercules then get the Transaction records from IGS_UC_TRANSACTIONS table and insert into Hercules igs_uc_u_tranin_2004 .
182: FOR c_pending_trans_rec IN c_pending_trans(c_cycle_rec.configured_cycle)
183: LOOP
184:
185: -- Determine appno based on configured year.