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.IBY_UPGRADE_PARAM_PVT dependencies on IBY_TRANSMIT_VALUES

Line 63: ci_online_trans_config_id IBY_TRANSMIT_VALUES.TRANSMIT_CONFIGURATION_ID%TYPE,

59: WHERE BEPID=ci_bepid
60: AND BEP_ACCOUNT_ID=ci_bep_account_id;
61:
62: CURSOR c_trans_config_exists(
63: ci_online_trans_config_id IBY_TRANSMIT_VALUES.TRANSMIT_CONFIGURATION_ID%TYPE,
64: ci_settle_trans_config_id IBY_TRANSMIT_VALUES.TRANSMIT_CONFIGURATION_ID%TYPE,
65: ci_query_trans_config_id IBY_TRANSMIT_VALUES.TRANSMIT_CONFIGURATION_ID%TYPE)
66: IS SELECT 1
67: FROM IBY_TRANSMIT_VALUES

Line 64: ci_settle_trans_config_id IBY_TRANSMIT_VALUES.TRANSMIT_CONFIGURATION_ID%TYPE,

60: AND BEP_ACCOUNT_ID=ci_bep_account_id;
61:
62: CURSOR c_trans_config_exists(
63: ci_online_trans_config_id IBY_TRANSMIT_VALUES.TRANSMIT_CONFIGURATION_ID%TYPE,
64: ci_settle_trans_config_id IBY_TRANSMIT_VALUES.TRANSMIT_CONFIGURATION_ID%TYPE,
65: ci_query_trans_config_id IBY_TRANSMIT_VALUES.TRANSMIT_CONFIGURATION_ID%TYPE)
66: IS SELECT 1
67: FROM IBY_TRANSMIT_VALUES
68: WHERE TRANSMIT_CONFIGURATION_ID IN (ci_online_trans_config_id,

Line 65: ci_query_trans_config_id IBY_TRANSMIT_VALUES.TRANSMIT_CONFIGURATION_ID%TYPE)

61:
62: CURSOR c_trans_config_exists(
63: ci_online_trans_config_id IBY_TRANSMIT_VALUES.TRANSMIT_CONFIGURATION_ID%TYPE,
64: ci_settle_trans_config_id IBY_TRANSMIT_VALUES.TRANSMIT_CONFIGURATION_ID%TYPE,
65: ci_query_trans_config_id IBY_TRANSMIT_VALUES.TRANSMIT_CONFIGURATION_ID%TYPE)
66: IS SELECT 1
67: FROM IBY_TRANSMIT_VALUES
68: WHERE TRANSMIT_CONFIGURATION_ID IN (ci_online_trans_config_id,
69: ci_settle_trans_config_id,ci_query_trans_config_id);

Line 67: FROM IBY_TRANSMIT_VALUES

63: ci_online_trans_config_id IBY_TRANSMIT_VALUES.TRANSMIT_CONFIGURATION_ID%TYPE,
64: ci_settle_trans_config_id IBY_TRANSMIT_VALUES.TRANSMIT_CONFIGURATION_ID%TYPE,
65: ci_query_trans_config_id IBY_TRANSMIT_VALUES.TRANSMIT_CONFIGURATION_ID%TYPE)
66: IS SELECT 1
67: FROM IBY_TRANSMIT_VALUES
68: WHERE TRANSMIT_CONFIGURATION_ID IN (ci_online_trans_config_id,
69: ci_settle_trans_config_id,ci_query_trans_config_id);
70:
71:

Line 175: INSERT INTO IBY_TRANSMIT_VALUES(

171: IF(UPPER(TRIM(p_online_param_types(i)))='VARCHAR2') THEN
172: IF ((NOT (TRIM(p_online_param_names(i)) is null))) THEN
173:
174:
175: INSERT INTO IBY_TRANSMIT_VALUES(
176: TRANSMIT_VALUE_ID,
177: TRANSMIT_CONFIGURATION_ID,
178: TRANSMIT_PARAMETER_CODE,
179: TRANSMIT_VARCHAR2_VALUE,

Line 187: iby_transmit_values_s.nextval,

183: LAST_UPDATE_LOGIN,
184: LAST_UPDATED_BY,
185: OBJECT_VERSION_NUMBER)
186: VALUES(
187: iby_transmit_values_s.nextval,
188: l_online_config_id,
189: p_online_param_names(i),
190: p_online_param_values(i),
191: l_user_id,

Line 206: INSERT INTO IBY_TRANSMIT_VALUES(

202: IF(UPPER(TRIM(p_online_param_types(i)))='NUMBER') THEN
203: IF ((NOT (TRIM(p_online_param_names(i)) is null))) THEN
204:
205:
206: INSERT INTO IBY_TRANSMIT_VALUES(
207: TRANSMIT_VALUE_ID,
208: TRANSMIT_CONFIGURATION_ID,
209: TRANSMIT_PARAMETER_CODE,
210: TRANSMIT_NUMBER_VALUE,

Line 218: iby_transmit_values_s.nextval,

214: LAST_UPDATE_LOGIN,
215: LAST_UPDATED_BY,
216: OBJECT_VERSION_NUMBER)
217: VALUES(
218: iby_transmit_values_s.nextval,
219: l_online_config_id,
220: p_online_param_names(i),
221: TO_NUMBER(p_online_param_values(i)),
222: l_user_id,

Line 237: INSERT INTO IBY_TRANSMIT_VALUES(

233:
234: IF(UPPER(TRIM(p_online_param_types(i)))='DATE') THEN
235: IF ((NOT (TRIM(p_online_param_names(i)) is null))) THEN
236:
237: INSERT INTO IBY_TRANSMIT_VALUES(
238: TRANSMIT_VALUE_ID,
239: TRANSMIT_CONFIGURATION_ID,
240: TRANSMIT_PARAMETER_CODE,
241: TRANSMIT_DATE_VALUE,

Line 249: iby_transmit_values_s.nextval,

245: LAST_UPDATE_LOGIN,
246: LAST_UPDATED_BY,
247: OBJECT_VERSION_NUMBER)
248: VALUES(
249: iby_transmit_values_s.nextval,
250: l_online_config_id,
251: p_online_param_names(i),
252: TO_DATE(p_online_param_values(i), 'YYYY/MM/DD'),
253: l_user_id,

Line 278: INSERT INTO IBY_TRANSMIT_VALUES(

274:
275: IF(UPPER(TRIM(p_settle_param_types(i)))='VARCHAR2') THEN
276: IF ((NOT (TRIM(p_settle_param_names(i)) is null))) THEN
277:
278: INSERT INTO IBY_TRANSMIT_VALUES(
279: TRANSMIT_VALUE_ID,
280: TRANSMIT_CONFIGURATION_ID,
281: TRANSMIT_PARAMETER_CODE,
282: TRANSMIT_VARCHAR2_VALUE,

Line 290: iby_transmit_values_s.nextval,

286: LAST_UPDATE_LOGIN,
287: LAST_UPDATED_BY,
288: OBJECT_VERSION_NUMBER)
289: VALUES(
290: iby_transmit_values_s.nextval,
291: l_settle_config_id,
292: p_settle_param_names(i),
293: p_settle_param_values(i),
294: l_user_id,

Line 309: INSERT INTO IBY_TRANSMIT_VALUES(

305: IF(UPPER(TRIM(p_settle_param_types(i)))='NUMBER') THEN
306: IF ((NOT (TRIM(p_settle_param_names(i)) is null))) THEN
307:
308:
309: INSERT INTO IBY_TRANSMIT_VALUES(
310: TRANSMIT_VALUE_ID,
311: TRANSMIT_CONFIGURATION_ID,
312: TRANSMIT_PARAMETER_CODE,
313: TRANSMIT_NUMBER_VALUE,

Line 321: iby_transmit_values_s.nextval,

317: LAST_UPDATE_LOGIN,
318: LAST_UPDATED_BY,
319: OBJECT_VERSION_NUMBER)
320: VALUES(
321: iby_transmit_values_s.nextval,
322: l_settle_config_id,
323: p_settle_param_names(i),
324: p_settle_param_values(i),
325: l_user_id,

Line 340: INSERT INTO IBY_TRANSMIT_VALUES(

336:
337: IF(UPPER(TRIM(p_settle_param_types(i)))='DATE') THEN
338: IF ((NOT (TRIM(p_settle_param_names(i)) is null))) THEN
339:
340: INSERT INTO IBY_TRANSMIT_VALUES(
341: TRANSMIT_VALUE_ID,
342: TRANSMIT_CONFIGURATION_ID,
343: TRANSMIT_PARAMETER_CODE,
344: TRANSMIT_DATE_VALUE,

Line 352: iby_transmit_values_s.nextval,

348: LAST_UPDATE_LOGIN,
349: LAST_UPDATED_BY,
350: OBJECT_VERSION_NUMBER)
351: VALUES(
352: iby_transmit_values_s.nextval,
353: l_settle_config_id,
354: p_settle_param_names(i),
355: TO_DATE(p_settle_param_values(i), 'YYYY/MM/DD'),
356: l_user_id,

Line 384: INSERT INTO IBY_TRANSMIT_VALUES(

380:
381: IF(UPPER(TRIM(p_query_param_types(i)))='VARCHAR2') THEN
382: IF ((NOT (TRIM(p_query_param_names(i)) is null))) THEN
383:
384: INSERT INTO IBY_TRANSMIT_VALUES(
385: TRANSMIT_VALUE_ID,
386: TRANSMIT_CONFIGURATION_ID,
387: TRANSMIT_PARAMETER_CODE,
388: TRANSMIT_VARCHAR2_VALUE,

Line 396: iby_transmit_values_s.nextval,

392: LAST_UPDATE_LOGIN,
393: LAST_UPDATED_BY,
394: OBJECT_VERSION_NUMBER)
395: VALUES(
396: iby_transmit_values_s.nextval,
397: l_query_config_id,
398: p_query_param_names(i),
399: p_query_param_values(i),
400: l_user_id,

Line 414: INSERT INTO IBY_TRANSMIT_VALUES(

410:
411: IF(UPPER(TRIM(p_query_param_types(i)))='NUMBER') THEN
412: IF ((NOT (TRIM(p_query_param_names(i)) is null))) THEN
413:
414: INSERT INTO IBY_TRANSMIT_VALUES(
415: TRANSMIT_VALUE_ID,
416: TRANSMIT_CONFIGURATION_ID,
417: TRANSMIT_PARAMETER_CODE,
418: TRANSMIT_NUMBER_VALUE,

Line 426: iby_transmit_values_s.nextval,

422: LAST_UPDATE_LOGIN,
423: LAST_UPDATED_BY,
424: OBJECT_VERSION_NUMBER)
425: VALUES(
426: iby_transmit_values_s.nextval,
427: l_query_config_id,
428: p_query_param_names(i),
429: p_query_param_values(i),
430: l_user_id,

Line 445: INSERT INTO IBY_TRANSMIT_VALUES(

441:
442: IF(UPPER(TRIM(p_query_param_types(i)))='DATE') THEN
443: IF ((NOT (TRIM(p_query_param_names(i)) is null))) THEN
444:
445: INSERT INTO IBY_TRANSMIT_VALUES(
446: TRANSMIT_VALUE_ID,
447: TRANSMIT_CONFIGURATION_ID,
448: TRANSMIT_PARAMETER_CODE,
449: TRANSMIT_DATE_VALUE,

Line 457: iby_transmit_values_s.nextval,

453: LAST_UPDATE_LOGIN,
454: LAST_UPDATED_BY,
455: OBJECT_VERSION_NUMBER)
456: VALUES(
457: iby_transmit_values_s.nextval,
458: l_query_config_id,
459: p_query_param_names(i),
460: TO_DATE(p_query_param_values(i), 'YYYY/MM/DD'),
461: l_user_id,