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_APP_COMP_NOTIF_USAGES

Line 50: hxc_app_comp_notif_usages hacnu

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
53: AND hac.approval_comp_id = hacnu.approval_comp_id
54: AND hac.object_version_number = hacnu.approval_comp_ovn

Line 90: hxc_app_comp_notif_usages hacnu

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
93: AND hac.approval_comp_id = hacnu.approval_comp_id
94: AND hac.object_version_number = hacnu.approval_comp_ovn

Line 123: hxc_app_comp_notif_usages hacnu

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
126: AND hac.approval_comp_id = hacnu.approval_comp_id
127: AND hac.object_version_number = hacnu.approval_comp_ovn

Line 157: hxc_app_comp_notif_usages hacnu

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
160: AND hac.approval_comp_id = hacnu.approval_comp_id
161: AND hac.object_version_number = hacnu.approval_comp_ovn

Line 191: hxc_app_comp_notif_usages hacnu

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
194: AND hac.approval_comp_id = hacnu.approval_comp_id
195: AND hac.object_version_number = hacnu.approval_comp_ovn

Line 225: hxc_app_comp_notif_usages hacnu

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
228: AND hac.approval_comp_id = hacnu.approval_comp_id
229: AND hac.object_version_number = hacnu.approval_comp_ovn

Line 266: hxc_app_comp_notif_usages hacnu

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
269: AND hac.approval_comp_id = hacnu.approval_comp_id
270: AND hac.object_version_number = hacnu.approval_comp_ovn

Line 309: hxc_app_comp_notif_usages hacnu

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
312: AND hac.approval_comp_id = hacnu.approval_comp_id
313: AND hac.object_version_number = hacnu.approval_comp_ovn

Line 352: hxc_app_comp_notif_usages hacnu

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
355: AND hac.approval_comp_id = hacnu.approval_comp_id
356: AND hac.object_version_number = hacnu.approval_comp_ovn

Line 395: hxc_app_comp_notif_usages hacnu

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
398: AND hac.approval_comp_id = hacnu.approval_comp_id
399: AND hac.object_version_number = hacnu.approval_comp_ovn

Line 437: hxc_app_comp_notif_usages hacnu

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
440: AND hac.approval_comp_id = hacnu.approval_comp_id
441: AND hac.object_version_number = hacnu.approval_comp_ovn

Line 699: hxc_app_comp_notif_usages hacnu

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
702: has.approval_style_id = hac.approval_style_id and
703: hac.approval_comp_id=hacnu.approval_comp_id and

Line 744: hxc_app_comp_notif_usages hacnu

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
747: from hxc_approval_comps hac
748: where

Line 772: hxc_app_comp_notif_usages hacnu,

768:
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

Line 809: from hxc_app_comp_notif_usages where

805: l_approval_comp_id,l_approval_comp_ovn,
806: l_comp_notification_id,l_comp_notification_ovn;
807: exit when csr_del_disabled_usages%notfound;
808: delete
809: from hxc_app_comp_notif_usages where
810: approval_comp_id=l_approval_comp_id and
811: approval_comp_ovn=l_approval_comp_ovn and
812: comp_notification_id=l_comp_notification_id and
813: comp_notification_ovn=l_comp_notification_ovn;

Line 884: update hxc_app_comp_notif_usages

880: loop
881: fetch csr_approval_comp_id into l_approval_comp_id,l_approval_comp_ovn;
882: exit when csr_approval_comp_id%notfound;
883:
884: update hxc_app_comp_notif_usages
885: set
886: comp_notification_id = l_comp_notif_id_exist,
887: comp_notification_ovn = l_ovn_exist
888: where

Line 924: delete from hxc_app_comp_notif_usages

920: open csr_approval_comp_id(p_approval_style_name);
921: loop
922: fetch csr_approval_comp_id into l_approval_comp_id,l_approval_comp_ovn;
923: exit when csr_approval_comp_id%notfound;
924: delete from hxc_app_comp_notif_usages
925: where
926: approval_comp_id =l_approval_comp_id and
927: approval_comp_ovn =l_approval_comp_ovn and
928: comp_notification_id=l_comp_notification_id and

Line 959: update hxc_app_comp_notif_usages

955: loop
956: fetch csr_approval_comp_id into l_approval_comp_id,l_approval_comp_ovn;
957: exit when csr_approval_comp_id%notfound;
958:
959: update hxc_app_comp_notif_usages
960: set
961: comp_notification_id = l_comp_notif_id_exist,
962: comp_notification_ovn = l_ovn_exist
963: where

Line 1003: delete from hxc_app_comp_notif_usages

999: open csr_approval_comp_id(p_approval_style_name);
1000: loop
1001: fetch csr_approval_comp_id into l_approval_comp_id,l_approval_comp_ovn;
1002: exit when csr_approval_comp_id%notfound;
1003: delete from hxc_app_comp_notif_usages
1004: where
1005: approval_comp_id =l_approval_comp_id and
1006: approval_comp_ovn =l_approval_comp_ovn and
1007: comp_notification_id=l_comp_notification_id and

Line 1038: update hxc_app_comp_notif_usages

1034: loop
1035: fetch csr_approval_comp_id into l_approval_comp_id,l_approval_comp_ovn;
1036: exit when csr_approval_comp_id%notfound;
1037:
1038: update hxc_app_comp_notif_usages
1039: set
1040: comp_notification_id = l_comp_notif_id_exist,
1041: comp_notification_ovn = l_ovn_exist
1042: where

Line 1082: delete from hxc_app_comp_notif_usages

1078: open csr_approval_comp_id(p_approval_style_name);
1079: loop
1080: fetch csr_approval_comp_id into l_approval_comp_id,l_approval_comp_ovn;
1081: exit when csr_approval_comp_id%notfound;
1082: delete from hxc_app_comp_notif_usages
1083: where
1084: approval_comp_id =l_approval_comp_id and
1085: approval_comp_ovn =l_approval_comp_ovn and
1086: comp_notification_id=l_comp_notification_id and

Line 1119: update hxc_app_comp_notif_usages

1115: loop
1116: fetch csr_approval_comp_id into l_approval_comp_id,l_approval_comp_ovn;
1117: exit when csr_approval_comp_id%notfound;
1118:
1119: update hxc_app_comp_notif_usages
1120: set
1121: comp_notification_id = l_comp_notif_id_exist,
1122: comp_notification_ovn = l_ovn_exist
1123: where

Line 1162: delete from hxc_app_comp_notif_usages

1158: open csr_approval_comp_id(p_approval_style_name);
1159: loop
1160: fetch csr_approval_comp_id into l_approval_comp_id,l_approval_comp_ovn;
1161: exit when csr_approval_comp_id%notfound;
1162: delete from hxc_app_comp_notif_usages
1163: where
1164: approval_comp_id =l_approval_comp_id and
1165: approval_comp_ovn =l_approval_comp_ovn and
1166: comp_notification_id=l_comp_notification_id and

Line 1199: update hxc_app_comp_notif_usages

1195: loop
1196: fetch csr_approval_comp_id into l_approval_comp_id,l_approval_comp_ovn;
1197: exit when csr_approval_comp_id%notfound;
1198:
1199: update hxc_app_comp_notif_usages
1200: set
1201: comp_notification_id = l_comp_notif_id_exist,
1202: comp_notification_ovn = l_ovn_exist
1203: where

Line 1242: delete from hxc_app_comp_notif_usages

1238: open csr_approval_comp_id(p_approval_style_name);
1239: loop
1240: fetch csr_approval_comp_id into l_approval_comp_id,l_approval_comp_ovn;
1241: exit when csr_approval_comp_id%notfound;
1242: delete from hxc_app_comp_notif_usages
1243: where
1244: approval_comp_id =l_approval_comp_id and
1245: approval_comp_ovn =l_approval_comp_ovn and
1246: comp_notification_id=l_comp_notification_id and

Line 1280: update hxc_app_comp_notif_usages

1276: loop
1277: fetch csr_approval_comp_id into l_approval_comp_id,l_approval_comp_ovn;
1278: exit when csr_approval_comp_id%notfound;
1279:
1280: update hxc_app_comp_notif_usages
1281: set
1282: comp_notification_id = l_comp_notif_id_exist,
1283: comp_notification_ovn = l_ovn_exist
1284: where

Line 1322: delete from hxc_app_comp_notif_usages

1318: open csr_approval_comp_id(p_approval_style_name);
1319: loop
1320: fetch csr_approval_comp_id into l_approval_comp_id,l_approval_comp_ovn;
1321: exit when csr_approval_comp_id%notfound;
1322: delete from hxc_app_comp_notif_usages
1323: where
1324: approval_comp_id =l_approval_comp_id and
1325: approval_comp_ovn =l_approval_comp_ovn and
1326: comp_notification_id=l_comp_notification_id and

Line 1362: update hxc_app_comp_notif_usages

1358:
1359: open csr_notif_id(p_approval_style_id,'REQUEST-APPROVAL','SUPERVISOR');
1360:
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

Line 1393: update hxc_app_comp_notif_usages

1389: elsif(p_notify_worker_on_submit = 'N' and l_old_notif_rec.notify_worker_on_submit = 'Y')
1390: then
1391: open csr_notif_id(p_approval_style_id,'SUBMISSION','WORKER');
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

Line 1423: update hxc_app_comp_notif_usages

1419: then
1420: open csr_notif_id(p_approval_style_id,'AUTO-APPROVE','WORKER');
1421:
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

Line 1454: update hxc_app_comp_notif_usages

1450: then
1451: open csr_notif_id(p_approval_style_id,'APPROVED','PREPARER');
1452:
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

Line 1484: update hxc_app_comp_notif_usages

1480: elsif(p_notify_preparer_rejected = 'N' and l_old_notif_rec.notify_preparer_rejected = 'Y')
1481: then
1482: open csr_notif_id(p_approval_style_id,'REJECTED','PREPARER');
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

Line 1514: update hxc_app_comp_notif_usages

1510: elsif(p_notify_preparer_transfer = 'N' and l_old_notif_rec.notify_preparer_transfer = 'Y')
1511: then
1512: open csr_notif_id(p_approval_style_id,'TRANSFER','PREPARER');
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

Line 1549: hxc_app_comp_notif_usages hacnu

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
1552: has.approval_style_id = hac.approval_style_id and
1553: hac.approval_comp_id=hacnu.approval_comp_id and

Line 1566: hxc_app_comp_notif_usages hacnu

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
1569: where approval_style_id = p_approval_style_id) and
1570: hac.approval_comp_id=hacnu.approval_comp_id and

Line 1609: delete from hxc_app_comp_notif_usages

1605: ,p_object_version_number => l_object_version_number
1606: );
1607: else
1608:
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

Line 1651: hxc_app_comp_notif_usages hacnu,

1647: p_approval_comp_id in number
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

Line 1668: hac.approval_comp_id in (select approval_comp_id from hxc_app_comp_notif_usages);

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

Line 1674: hxc_app_comp_notif_usages hacnu

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

Line 1696: hxc_app_comp_notif_usages

1692: loop
1693: fetch csr_comp_notification into l_comp_notification_id,l_comp_notification_ovn,l_enabled_flag;
1694: exit when csr_comp_notification%notfound;
1695: insert into
1696: hxc_app_comp_notif_usages
1697: (
1698: approval_comp_id
1699: ,approval_comp_ovn
1700: ,comp_notification_id

Line 1721: hxc_app_comp_notif_usages

1717: then
1718:
1719: --For deleting rows corresponding to ELA
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

Line 1729: hxc_app_comp_notif_usages

1725: PARENT_COMP_ID=p_approval_comp_id and
1726: PARENT_COMP_OVN=p_approval_comp_ovn);
1727:
1728: delete from
1729: hxc_app_comp_notif_usages
1730: where
1731: approval_comp_id = p_approval_comp_id and
1732: approval_comp_ovn = p_approval_comp_ovn;
1733: end if;