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_SCHED dependencies on IBY_ECAPP

Line 200: a.APPLICATION_SHORT_NAME FROM IBY_ECAPP_V a

196: l_updapp_success BOOLEAN;
197:
198: CURSOR ecapp_cursor(cin_owner VARCHAR2) IS
199: SELECT distinct(a.ECAPPID),
200: a.APPLICATION_SHORT_NAME FROM IBY_ECAPP_V a
201: WHERE EXISTS
202: (SELECT * FROM dba_objects b WHERE
203: b.object_name = a.application_short_name || '_ECAPP_PKG' and
204: owner=cin_owner);

Line 212: CURSOR c_trans_core (cin_ecappid in iby_ecapp.ecappid%type) IS

208: -- Replaced view with base tables
209: -- Bug# 9397208
210: -- Bug# 13540887
211: -- Adding 11, 100, 111 to the statuses
212: CURSOR c_trans_core (cin_ecappid in iby_ecapp.ecappid%type) IS
213: SELECT /*+ NO_EXPAND use_nl(B C) INDEX (C IBY_TRXN_CORE_TRXNMID_U1)*/
214: b.transactionid,
215: b.status,
216: b.updatedate,

Line 228: CURSOR c_trans_fi (cin_ecappid in iby_ecapp.ecappid%type) IS

224: AND b.status not in (1, 0, 11, 100, 111)
225: AND b.needsupdt IN ('Y','F')
226: AND b.ecappid = DECODE(cin_ecappid, '222', b.ecappid,cin_ecappid);
227:
228: CURSOR c_trans_fi (cin_ecappid in iby_ecapp.ecappid%type) IS
229: SELECT iby_trans_fi_v.TRANSACTIONID,
230: iby_trans_fi_v.STATUS,
231: iby_trans_fi_v.UPDATEDATE,
232: iby_trans_fi_v.REQTYPE,

Line 242: CURSOR c_trans_bankacct (cin_ecappid in iby_ecapp.ecappid%type) IS

238: AND iby_trans_fi_v.status not in (1, 0, 11, 100, 111)
239: AND iby_trans_fi_v.ecappid = cin_ecappid;
240:
241: /* Bug# 10192851
242: CURSOR c_trans_bankacct (cin_ecappid in iby_ecapp.ecappid%type) IS
243: SELECT iby_trans_bankacct_v.TRANSACTIONID,
244: iby_trans_bankacct_v.STATUS,
245: iby_trans_bankacct_v.UPDATEDATE,
246: iby_trans_bankacct_v.REQTYPE,

Line 256: CURSOR c_trans_bankacct (cin_ecappid in iby_ecapp.ecappid%type) IS

252: AND iby_trans_bankacct_v.status <> 0
253: AND iby_trans_bankacct_v.ecappid = cin_ecappid;
254: */
255:
256: CURSOR c_trans_bankacct (cin_ecappid in iby_ecapp.ecappid%type) IS
257: SELECT trxn.TRANSACTIONID,
258: trxn.STATUS,
259: trxn.UPDATEDATE,
260: trxn.REQTYPE,

Line 273: CURSOR c_trans_pcard (cin_ecappid in iby_ecapp.ecappid%type) IS

269: AND trxn.reqtype <> 'ORAPMTREQ'
270: AND trxn.status not in (1, 0, 11, 100, 111)
271: AND trxn.ecappid = cin_ecappid;
272:
273: CURSOR c_trans_pcard (cin_ecappid in iby_ecapp.ecappid%type) IS
274: SELECT iby_trans_pcard_v.TRANSACTIONID,
275: iby_trans_pcard_v.STATUS,
276: iby_trans_pcard_v.UPDATEDATE,
277: iby_trans_pcard_v.REQTYPE,

Line 419: * exist in iby_ecapp_v, or that the procedure ecapp_pkg.update_status

415: EXCEPTION
416: WHEN OTHERS THEN
417: /*
418: * If we reached here it means that either the ecapp name does not
419: * exist in iby_ecapp_v, or that the procedure ecapp_pkg.update_status
420: * does not exist. Both these are ok. Swallow the exception and
421: * all procedure to exit gracefully. Fix for bug 3883880.
422: */
423: --iby_debug_pub.add('Exception Occurred: Either the ecapp name does not exist ||

Line 424: --|| in iby_ecapp_v, or that the procedure ecapp_pkg.update_status does not exist'|| sqlerrm ,

420: * does not exist. Both these are ok. Swallow the exception and
421: * all procedure to exit gracefully. Fix for bug 3883880.
422: */
423: --iby_debug_pub.add('Exception Occurred: Either the ecapp name does not exist ||
424: --|| in iby_ecapp_v, or that the procedure ecapp_pkg.update_status does not exist'|| sqlerrm ,
425: --iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
426: iby_debug_pub.add('Crash in inner exception block=' || sqlerrm,iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
427: l_updapp_success := FALSE;
428: END;

Line 460: procedure update_ecapp (in_ecappid in iby_ecapp.ecappid%type)

456: raise_application_error(-20000, 'IBY_204610#ECAPP=' || l_ecapp_rec.app_short_name , FALSE );
457: end update_ecapp;
458: -- End of Overloaded Procedure
459:
460: procedure update_ecapp (in_ecappid in iby_ecapp.ecappid%type)
461: is
462:
463:
464: TYPE txn_mid_TabTyp is TABLE OF iby_trans_core_v.trxnmid%TYPE

Line 491: CURSOR c_trans_core (cin_ecappid in iby_ecapp.ecappid%type) IS

487: i NUMBER := 0;
488:
489: -- Updated the where clause so that the transactions initiated from
490: -- OM will also be picked up this cursor (bug# 8239041)
491: CURSOR c_trans_core (cin_ecappid in iby_ecapp.ecappid%type) IS
492: SELECT iby_trans_core_v.TRANSACTIONID,
493: iby_trans_core_v.STATUS,
494: iby_trans_core_v.UPDATEDATE,
495: iby_trans_core_v.REQTYPE,

Line 504: CURSOR c_trans_fi (cin_ecappid in iby_ecapp.ecappid%type) IS

500: --AND iby_trans_core_v.ecappid = DECODE(cin_ecappid, '222', cin_ecappid, iby_trans_core_v.ecappid);
501: AND iby_trans_core_v.ecappid = DECODE(cin_ecappid, '222', iby_trans_core_v.ecappid,cin_ecappid);
502:
503:
504: CURSOR c_trans_fi (cin_ecappid in iby_ecapp.ecappid%type) IS
505: SELECT iby_trans_fi_v.TRANSACTIONID,
506: iby_trans_fi_v.STATUS,
507: iby_trans_fi_v.UPDATEDATE,
508: iby_trans_fi_v.REQTYPE,

Line 517: CURSOR c_trans_bankacct (cin_ecappid in iby_ecapp.ecappid%type) IS

513: AND iby_trans_fi_v.ecappid = cin_ecappid;
514:
515: -- r_trans_fi c_trans_fi%ROWTYPE;
516:
517: CURSOR c_trans_bankacct (cin_ecappid in iby_ecapp.ecappid%type) IS
518: SELECT iby_trans_bankacct_v.TRANSACTIONID,
519: iby_trans_bankacct_v.STATUS,
520: iby_trans_bankacct_v.UPDATEDATE,
521: iby_trans_bankacct_v.REQTYPE,

Line 530: CURSOR c_trans_pcard (cin_ecappid in iby_ecapp.ecappid%type) IS

526: AND iby_trans_bankacct_v.ecappid = cin_ecappid;
527:
528: -- r_trans_bankacct c_trans_bankacct%ROWTYPE;
529:
530: CURSOR c_trans_pcard (cin_ecappid in iby_ecapp.ecappid%type) IS
531: SELECT iby_trans_pcard_v.TRANSACTIONID,
532: iby_trans_pcard_v.STATUS,
533: iby_trans_pcard_v.UPDATEDATE,
534: iby_trans_pcard_v.REQTYPE,

Line 663: -- The view iby_ecapp_v has two records for each of the ecappid's. To avoid

659: BEGIN
660:
661: -- Now getting the application short name
662: iby_debug_pub.add('Enter update_ecapp:',iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
663: -- The view iby_ecapp_v has two records for each of the ecappid's. To avoid
664: -- the possible exception, using distinct function
665: SELECT distinct(application_short_name)
666: INTO ecapp_name
667: FROM iby_ecapp_v

Line 667: FROM iby_ecapp_v

663: -- The view iby_ecapp_v has two records for each of the ecappid's. To avoid
664: -- the possible exception, using distinct function
665: SELECT distinct(application_short_name)
666: INTO ecapp_name
667: FROM iby_ecapp_v
668: WHERE ecappid = in_ecappid;
669: iby_debug_pub.add('application_short_name:' || ecapp_name,iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
670: -- dbms_output.put_line('Total count for inner loop : ' || i);
671: --dbms_output.put_line('Sending in : ' || txn_id_Tab(1) ||'** ' ||Status_Tab(1) ||'** '|| updatedt_Tab(1) || '** '|| refcode_Tab(1) ||'** '|| txn_mid_Tab(1));

Line 719: * exist in iby_ecapp_v, or that the procedure ecapp_pkg.update_status

715: WHEN OTHERS THEN
716:
717: /*
718: * If we reached here it means that either the ecapp name does not
719: * exist in iby_ecapp_v, or that the procedure ecapp_pkg.update_status
720: * does not exist. Both these are ok. Swallow the exception and
721: * all procedure to exit gracefully. Fix for bug 3883880.
722: */
723: --iby_debug_pub.add('Exception Occurred: Either the ecapp name does not exist ||

Line 724: --|| in iby_ecapp_v, or that the procedure ecapp_pkg.update_status does not exist'|| sqlerrm ,

720: * does not exist. Both these are ok. Swallow the exception and
721: * all procedure to exit gracefully. Fix for bug 3883880.
722: */
723: --iby_debug_pub.add('Exception Occurred: Either the ecapp name does not exist ||
724: --|| in iby_ecapp_v, or that the procedure ecapp_pkg.update_status does not exist'|| sqlerrm ,
725: --iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
726: NULL;
727:
728: END;