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.HXC_NOTIFICATION_HELPER dependencies on HXC_APPROVAL_STYLES

Line 12: l_run_recipient_extensions hxc_approval_styles.run_recipient_extensions%TYPE;

8: FUNCTION run_extensions (p_approval_comp_id IN NUMBER)
9: RETURN BOOLEAN
10: IS
11: l_extension BOOLEAN;
12: l_run_recipient_extensions hxc_approval_styles.run_recipient_extensions%TYPE;
13:
14: CURSOR csr_run_extension
15: IS
16: SELECT has.run_recipient_extensions

Line 17: FROM hxc_approval_styles has, hxc_approval_comps hac

13:
14: CURSOR csr_run_extension
15: IS
16: SELECT has.run_recipient_extensions
17: FROM hxc_approval_styles has, hxc_approval_comps hac
18: WHERE hac.approval_comp_id = p_approval_comp_id
19: AND has.approval_style_id = hac.approval_style_id;
20: BEGIN
21: OPEN csr_run_extension;

Line 47: IS select count(1) FROM hxc_approval_styles has,

43: l_timeout_notifs number (9) := 0;
44: l_notifs VARCHAR2 (9);
45:
46: CURSOR csr_timeout_notifs
47: IS select count(1) FROM hxc_approval_styles has,
48: hxc_approval_comps hac,
49: hxc_app_comp_notifications hacn,
50: hxc_app_comp_notif_usages hacnu
51: WHERE has.approval_style_id = p_approval_style_id

Line 87: FROM hxc_approval_styles has,

83:
84: CURSOR csr_timeout_retries
85: IS
86: SELECT notification_number_retries
87: FROM hxc_approval_styles has,
88: hxc_approval_comps hac,
89: hxc_app_comp_notifications hacn,
90: hxc_app_comp_notif_usages hacnu
91: WHERE has.approval_style_id = p_approval_style_id

Line 120: FROM hxc_approval_styles has,

116:
117: CURSOR csr_timeout_value
118: IS
119: SELECT notification_timeout_value
120: FROM hxc_approval_styles has,
121: hxc_approval_comps hac,
122: hxc_app_comp_notifications hacn,
123: hxc_app_comp_notif_usages hacnu
124: WHERE has.approval_style_id = p_approval_style_id

Line 154: FROM hxc_approval_styles has,

150:
151: CURSOR csr_timeout_value
152: IS
153: SELECT hacn.notification_timeout_value
154: FROM hxc_approval_styles has,
155: hxc_approval_comps hac,
156: hxc_app_comp_notifications hacn,
157: hxc_app_comp_notif_usages hacnu
158: WHERE has.approval_style_id = p_approval_style_id

Line 188: FROM hxc_approval_styles has,

184:
185: CURSOR csr_timeout_value
186: IS
187: SELECT hacn.notification_timeout_value
188: FROM hxc_approval_styles has,
189: hxc_approval_comps hac,
190: hxc_app_comp_notifications hacn,
191: hxc_app_comp_notif_usages hacnu
192: WHERE has.approval_style_id = p_approval_style_id

Line 222: FROM hxc_approval_styles has,

218:
219: CURSOR csr_sup_for_approval
220: IS
221: SELECT COUNT (1)
222: FROM hxc_approval_styles has,
223: hxc_approval_comps hac,
224: hxc_app_comp_notifications hacn,
225: hxc_app_comp_notif_usages hacnu
226: WHERE has.approval_style_id = p_approval_style_id

Line 263: FROM hxc_approval_styles has,

259:
260: CURSOR csr_worker_sumission
261: IS
262: SELECT COUNT (1)
263: FROM hxc_approval_styles has,
264: hxc_approval_comps hac,
265: hxc_app_comp_notifications hacn,
266: hxc_app_comp_notif_usages hacnu
267: WHERE has.approval_style_id = p_approval_style_id

Line 306: FROM hxc_approval_styles has,

302:
303: CURSOR csr_worker_auto_approve
304: IS
305: SELECT COUNT (1)
306: FROM hxc_approval_styles has,
307: hxc_approval_comps hac,
308: hxc_app_comp_notifications hacn,
309: hxc_app_comp_notif_usages hacnu
310: WHERE has.approval_style_id = p_approval_style_id

Line 349: FROM hxc_approval_styles has,

345:
346: CURSOR csr_preparer_approve
347: IS
348: SELECT COUNT (1)
349: FROM hxc_approval_styles has,
350: hxc_approval_comps hac,
351: hxc_app_comp_notifications hacn,
352: hxc_app_comp_notif_usages hacnu
353: WHERE has.approval_style_id = p_approval_style_id

Line 392: FROM hxc_approval_styles has,

388:
389: CURSOR csr_preparer_reject
390: IS
391: SELECT COUNT (1)
392: FROM hxc_approval_styles has,
393: hxc_approval_comps hac,
394: hxc_app_comp_notifications hacn,
395: hxc_app_comp_notif_usages hacnu
396: WHERE has.approval_style_id = p_approval_style_id

Line 434: FROM hxc_approval_styles has,

430:
431: CURSOR csr_preparer_transfer
432: IS
433: SELECT COUNT (1)
434: FROM hxc_approval_styles has,
435: hxc_approval_comps hac,
436: hxc_app_comp_notifications hacn,
437: hxc_app_comp_notif_usages hacnu
438: WHERE has.approval_style_id = p_approval_style_id

Line 682: from hxc_approval_styles_v

678: notify_worker_on_aa,
679: notify_preparer_approved,
680: notify_preparer_rejected,
681: notify_preparer_transfer
682: from hxc_approval_styles_v
683: where
684: approval_style_id=p_approval_style_id;
685:
686:

Line 696: hxc_approval_styles has,

692: ,p_notification_action_code in varchar2
693: ,p_notification_recipient_code in varchar2) is
694: select hacn.comp_notification_id,hacn.object_version_number
695: from
696: hxc_approval_styles has,
697: hxc_approval_comps hac,
698: hxc_app_comp_notifications hacn,
699: hxc_app_comp_notif_usages hacnu
700: where

Line 760: hxc_approval_styles has,

756:
757: cursor csr_approval_comp_id(p_approval_style in varchar2)
758: is select hac.approval_comp_id,hac.object_version_number
759: from
760: hxc_approval_styles has,
761: hxc_approval_comps hac
762: where
763: has.name=p_approval_style and
764: has.approval_style_id = hac.approval_style_id and

Line 773: hxc_approval_styles has,

769: cursor csr_del_disabled_usages(p_approval_style_id in number)
770: is select hacnu.approval_comp_id,hacnu.approval_comp_ovn,
771: hacnu.comp_notification_id,hacnu.comp_notification_ovn from
772: hxc_app_comp_notif_usages hacnu,
773: hxc_approval_styles has,
774: hxc_approval_comps hac,
775: hxc_app_comp_notifications hacn
776: where
777: has.approval_style_id=p_approval_style_id and

Line 1535: p_approval_style_id in hxc_approval_styles.approval_style_id%type

1531: -- ----------------------------------------------------------------------------
1532:
1533: Procedure delete_notification_records
1534: (
1535: p_approval_style_id in hxc_approval_styles.approval_style_id%type
1536: ) is
1537:
1538:
1539: --

Line 1546: hxc_approval_styles has,

1542: cursor csr_notif_id
1543: (p_approval_style_id in number) is
1544: select distinct hacn.comp_notification_id,hacn.object_version_number
1545: from
1546: hxc_approval_styles has,
1547: hxc_approval_comps hac,
1548: hxc_app_comp_notifications hacn,
1549: hxc_app_comp_notif_usages hacnu
1550: where

Line 1663: hxc_approval_styles has,

1659:
1660: cursor csr_approval_comp (p_approval_style_id in number)
1661: is
1662: select hac.approval_comp_id from
1663: hxc_approval_styles has,
1664: hxc_approval_comps hac
1665: where
1666: has.approval_style_id=p_approval_style_id and
1667: has.approval_style_id=hac.approval_style_id and