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_COMPS

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 48: hxc_approval_comps hac,

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
52: AND has.approval_style_id = hac.approval_style_id

Line 88: hxc_approval_comps hac,

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
92: AND has.approval_style_id = hac.approval_style_id

Line 121: hxc_approval_comps hac,

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
125: AND has.approval_style_id = hac.approval_style_id

Line 155: hxc_approval_comps hac,

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
159: AND has.approval_style_id = hac.approval_style_id

Line 189: hxc_approval_comps hac,

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
193: AND has.approval_style_id = hac.approval_style_id

Line 223: hxc_approval_comps hac,

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
227: AND has.approval_style_id = hac.approval_style_id

Line 264: hxc_approval_comps hac,

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
268: AND has.approval_style_id = hac.approval_style_id

Line 307: hxc_approval_comps hac,

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
311: AND has.approval_style_id = hac.approval_style_id

Line 350: hxc_approval_comps hac,

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
354: AND has.approval_style_id = hac.approval_style_id

Line 393: hxc_approval_comps hac,

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
397: AND has.approval_style_id = hac.approval_style_id

Line 435: hxc_approval_comps hac,

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
439: AND has.approval_style_id = hac.approval_style_id

Line 659: l_approval_comp_id hxc_approval_comps.approval_comp_id%type;

655: l_object_version_number_table hxc_app_comp_notifications_api.ovn_type;
656: l_count number(9) :=0;
657: l_comp_notif_id_exist hxc_app_comp_notifications.comp_notification_id%type;
658: l_ovn_exist hxc_app_comp_notifications.object_version_number%type;
659: l_approval_comp_id hxc_approval_comps.approval_comp_id%type;
660: l_approval_comp_ovn hxc_approval_comps.object_version_number%type;
661: l_old_notif_rec hxc_notification_helper.g_rec_notif;
662: l_comp_notification_ovn number(9);
663:

Line 660: l_approval_comp_ovn hxc_approval_comps.object_version_number%type;

656: l_count number(9) :=0;
657: l_comp_notif_id_exist hxc_app_comp_notifications.comp_notification_id%type;
658: l_ovn_exist hxc_app_comp_notifications.object_version_number%type;
659: l_approval_comp_id hxc_approval_comps.approval_comp_id%type;
660: l_approval_comp_ovn hxc_approval_comps.object_version_number%type;
661: l_old_notif_rec hxc_notification_helper.g_rec_notif;
662: l_comp_notification_ovn number(9);
663:
664: --

Line 697: hxc_approval_comps hac,

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
701: has.approval_style_id = p_approval_style_id and

Line 742: hxc_approval_comps hac,

738: ,p_comp_notification_id in number
739: ,p_object_version_number in number)
740: is
741: select count(1) from
742: hxc_approval_comps hac,
743: hxc_app_comp_notifications hacn,
744: hxc_app_comp_notif_usages hacnu
745: where
746: hac.approval_comp_id not in (select hac.approval_comp_id

Line 747: from hxc_approval_comps hac

743: hxc_app_comp_notifications hacn,
744: hxc_app_comp_notif_usages hacnu
745: where
746: hac.approval_comp_id not in (select hac.approval_comp_id
747: from hxc_approval_comps hac
748: where
749: approval_style_id = p_approval_style_id) and
750: hac.approval_comp_id=hacnu.approval_comp_id and
751: hacn.comp_notification_id=hacnu.comp_notification_id and

Line 761: hxc_approval_comps hac

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
765: hac.object_version_number = (SELECT MAX (object_version_number)

Line 766: FROM hxc_approval_comps

762: where
763: has.name=p_approval_style and
764: has.approval_style_id = hac.approval_style_id and
765: hac.object_version_number = (SELECT MAX (object_version_number)
766: FROM hxc_approval_comps
767: WHERE approval_comp_id =hac.approval_comp_id);
768:
769: cursor csr_del_disabled_usages(p_approval_style_id in number)
770: is select hacnu.approval_comp_id,hacnu.approval_comp_ovn,

Line 774: hxc_approval_comps hac,

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
778: has.approval_style_id=hac.approval_style_id and

Line 1365: approval_comp_id in (select approval_comp_id from hxc_approval_comps

1361: fetch csr_notif_id into l_comp_notification_id,l_object_version_number;
1362: update hxc_app_comp_notif_usages
1363: set
1364: enabled_flag='N' where
1365: approval_comp_id in (select approval_comp_id from hxc_approval_comps
1366: where approval_style_id=p_approval_style_id) and
1367: comp_notification_id=l_comp_notification_id and
1368: comp_notification_ovn=l_object_version_number;
1369: close csr_notif_id;

Line 1396: approval_comp_id in (select approval_comp_id from hxc_approval_comps

1392: fetch csr_notif_id into l_comp_notification_id,l_object_version_number;
1393: update hxc_app_comp_notif_usages
1394: set
1395: enabled_flag='N' where
1396: approval_comp_id in (select approval_comp_id from hxc_approval_comps
1397: where approval_style_id=p_approval_style_id) and
1398: comp_notification_id=l_comp_notification_id and
1399: comp_notification_ovn=l_object_version_number;
1400: close csr_notif_id;

Line 1426: approval_comp_id in (select approval_comp_id from hxc_approval_comps

1422: fetch csr_notif_id into l_comp_notification_id,l_object_version_number;
1423: update hxc_app_comp_notif_usages
1424: set
1425: enabled_flag='N' where
1426: approval_comp_id in (select approval_comp_id from hxc_approval_comps
1427: where approval_style_id=p_approval_style_id) and
1428: comp_notification_id=l_comp_notification_id and
1429: comp_notification_ovn=l_object_version_number;
1430:

Line 1457: approval_comp_id in (select approval_comp_id from hxc_approval_comps

1453: fetch csr_notif_id into l_comp_notification_id,l_object_version_number;
1454: update hxc_app_comp_notif_usages
1455: set
1456: enabled_flag='N' where
1457: approval_comp_id in (select approval_comp_id from hxc_approval_comps
1458: where approval_style_id=p_approval_style_id) and
1459: comp_notification_id=l_comp_notification_id and
1460: comp_notification_ovn=l_object_version_number;
1461:

Line 1487: approval_comp_id in (select approval_comp_id from hxc_approval_comps

1483: fetch csr_notif_id into l_comp_notification_id,l_object_version_number;
1484: update hxc_app_comp_notif_usages
1485: set
1486: enabled_flag='N' where
1487: approval_comp_id in (select approval_comp_id from hxc_approval_comps
1488: where approval_style_id=p_approval_style_id) and
1489: comp_notification_id=l_comp_notification_id and
1490: comp_notification_ovn=l_object_version_number;
1491: close csr_notif_id;

Line 1517: approval_comp_id in (select approval_comp_id from hxc_approval_comps

1513: fetch csr_notif_id into l_comp_notification_id,l_object_version_number;
1514: update hxc_app_comp_notif_usages
1515: set
1516: enabled_flag='N' where
1517: approval_comp_id in (select approval_comp_id from hxc_approval_comps
1518: where approval_style_id=p_approval_style_id) and
1519: comp_notification_id=l_comp_notification_id and
1520: comp_notification_ovn=l_object_version_number;
1521: close csr_notif_id;

Line 1547: hxc_approval_comps hac,

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
1551: has.approval_style_id = p_approval_style_id and

Line 1564: hxc_approval_comps hac,

1560: ,p_comp_notification_id in number
1561: ,p_object_version_number in number)
1562: is
1563: select count(1) from
1564: hxc_approval_comps hac,
1565: hxc_app_comp_notifications hacn,
1566: hxc_app_comp_notif_usages hacnu
1567: where
1568: hac.approval_comp_id not in (select hac.approval_comp_id from hxc_approval_comps hac

Line 1568: hac.approval_comp_id not in (select hac.approval_comp_id from hxc_approval_comps hac

1564: hxc_approval_comps hac,
1565: hxc_app_comp_notifications hacn,
1566: hxc_app_comp_notif_usages hacnu
1567: where
1568: hac.approval_comp_id not in (select hac.approval_comp_id from hxc_approval_comps hac
1569: where approval_style_id = p_approval_style_id) and
1570: hac.approval_comp_id=hacnu.approval_comp_id and
1571: hacn.comp_notification_id=hacnu.comp_notification_id and
1572: hacn.object_version_number=hacnu.comp_notification_ovn and

Line 1613: from hxc_approval_comps where

1609: delete from hxc_app_comp_notif_usages
1610: where
1611: approval_comp_id in
1612: (select approval_comp_id
1613: from hxc_approval_comps where
1614: approval_style_id=p_approval_style_id) and
1615: comp_notification_id = l_comp_notification_id and
1616: comp_notification_ovn = l_object_version_number;
1617:

Line 1652: hxc_approval_comps hac,

1648: )
1649: is
1650: select count(1) from
1651: hxc_app_comp_notif_usages hacnu,
1652: hxc_approval_comps hac,
1653: hxc_approval_comps hac1
1654: where
1655: hac.approval_comp_id=p_approval_comp_id and
1656: hac.approval_comp_id<>hac1.approval_comp_id and

Line 1653: hxc_approval_comps hac1

1649: is
1650: select count(1) from
1651: hxc_app_comp_notif_usages hacnu,
1652: hxc_approval_comps hac,
1653: hxc_approval_comps hac1
1654: where
1655: hac.approval_comp_id=p_approval_comp_id and
1656: hac.approval_comp_id<>hac1.approval_comp_id and
1657: hac.approval_style_id=hac1.approval_style_id and

Line 1664: hxc_approval_comps hac

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
1668: hac.approval_comp_id in (select approval_comp_id from hxc_app_comp_notif_usages);

Line 1673: hxc_approval_comps hac,

1669:
1670: cursor csr_comp_notification (p_approval_comp_id in number) is
1671: select hacnu.comp_notification_id,hacnu.comp_notification_ovn,hacnu.enabled_flag
1672: from
1673: hxc_approval_comps hac,
1674: hxc_app_comp_notif_usages hacnu
1675: where
1676: hac.approval_comp_id=p_approval_comp_id and
1677: hacnu.approval_comp_id=hac.approval_comp_id;

Line 1724: hxc_approval_comps where

1720: delete from
1721: hxc_app_comp_notif_usages
1722: where
1723: approval_comp_id in (select approval_comp_id from
1724: hxc_approval_comps where
1725: PARENT_COMP_ID=p_approval_comp_id and
1726: PARENT_COMP_OVN=p_approval_comp_ovn);
1727:
1728: delete from