APPS.IBY_SCHED dependencies on IBY_ECAPP_V

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 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 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;