APPS.FND_OAM_EM dependencies on FND_OAM_EM

Line 1: PACKAGE BODY fnd_oam_em AS

1: PACKAGE BODY fnd_oam_em AS
2: /* $Header: AFOAMEMB.pls 120.1.12000000.4 2007/04/25 22:04:43 ssuprasa ship $ */
3:
4:
5: /* DONE FOR LEVEL 1 */

Line 354: SELECT fnd_oam_em.get_apps_level apps_level,

350:
351:
352: -- open the cursor to return
353: OPEN ret FOR
354: SELECT fnd_oam_em.get_apps_level apps_level,
355: oam_root_url,
356: apps_name,
357: apps_version,
358: multi_org,

Line 705: fnd_oam_em.get_pend_rqsts('I',application_id,concurrent_queue_id) n_c,

701: where cp.session_id = audsid)
702: )
703: )
704: ) a_p,
705: fnd_oam_em.get_pend_rqsts('I',application_id,concurrent_queue_id) n_c,
706: fnd_oam_em.get_pend_rqsts('Q',application_id,concurrent_queue_id) s_c
707:
708: FROM fnd_concurrent_queues_vl CQ,
709: WHERE manager_type = 1

Line 706: fnd_oam_em.get_pend_rqsts('Q',application_id,concurrent_queue_id) s_c

702: )
703: )
704: ) a_p,
705: fnd_oam_em.get_pend_rqsts('I',application_id,concurrent_queue_id) n_c,
706: fnd_oam_em.get_pend_rqsts('Q',application_id,concurrent_queue_id) s_c
707:
708: FROM fnd_concurrent_queues_vl CQ,
709: WHERE manager_type = 1
710: ORDER BY decode(CQ.control_code, 'X',2,'E',2,1), user_concurrent_queue_name

Line 945: END fnd_oam_em;

941: END get_icm_statusV;
942: */
943:
944:
945: END fnd_oam_em;