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_APP_COMP_NOTIFICATIONS_API dependencies on HXC_APP_COMP_NOTIF_USAGES

Line 31: l_enabled_flag hxc_app_comp_notif_usages.enabled_flag%TYPE DEFAULT 'Y';

27: l_comp_notification_id hxc_app_comp_notifications.comp_notification_id%TYPE;
28: l_object_version_number hxc_app_comp_notifications.object_version_number%TYPE;
29: l_approval_comp_id hxc_approval_comps.approval_comp_id%TYPE;
30: l_approval_comp_ovn hxc_approval_comps.object_version_number%TYPE;
31: l_enabled_flag hxc_app_comp_notif_usages.enabled_flag%TYPE DEFAULT 'Y';
32: l_comp_notification_id_exist hxc_app_comp_notifications.comp_notification_id%TYPE;
33: l_object_version_number_exist hxc_app_comp_notifications.object_version_number%TYPE;
34: l_count number(1) :=0;
35:

Line 87: FROM hxc_app_comp_notif_usages

83: ,l_comp_notification_id in number
84: ,l_comp_notification_ovn in number)
85: is
86: SELECT COUNT (1)
87: FROM hxc_app_comp_notif_usages
88: WHERE approval_comp_id = l_approval_comp_id
89: AND approval_comp_ovn = l_approval_comp_ovn
90: AND comp_notification_id = l_comp_notification_id
91: AND comp_notification_ovn = l_comp_notification_ovn

Line 187: -- Insert into hxc_app_comp_notif_usages

183: open csr_approval_comp_id(p_approval_style_name);
184: LOOP
185: fetch csr_approval_comp_id into l_approval_comp_id, l_approval_comp_ovn;
186: exit when csr_approval_comp_id%notfound;
187: -- Insert into hxc_app_comp_notif_usages
188:
189: insert into hxc_app_comp_notif_usages
190: (approval_comp_id
191: ,approval_comp_ovn

Line 189: insert into hxc_app_comp_notif_usages

185: fetch csr_approval_comp_id into l_approval_comp_id, l_approval_comp_ovn;
186: exit when csr_approval_comp_id%notfound;
187: -- Insert into hxc_app_comp_notif_usages
188:
189: insert into hxc_app_comp_notif_usages
190: (approval_comp_id
191: ,approval_comp_ovn
192: ,comp_notification_id
193: ,comp_notification_ovn

Line 210: -- Insert into hxc_app_comp_notif_usages

206: open csr_approval_comp_id(p_approval_style_name);
207: LOOP
208: fetch csr_approval_comp_id into l_approval_comp_id, l_approval_comp_ovn;
209: exit when csr_approval_comp_id%notfound;
210: -- Insert into hxc_app_comp_notif_usages
211:
212: open csr_chk_diabled( l_approval_comp_id
213: ,l_approval_comp_ovn
214: ,l_comp_notification_id_exist

Line 221: update hxc_app_comp_notif_usages

217: fetch csr_chk_diabled into l_count;
218: close csr_chk_diabled;
219: if (l_count>0)
220: then
221: update hxc_app_comp_notif_usages
222: set
223: enabled_flag='Y'
224: where
225: approval_comp_id=l_approval_comp_id and

Line 231: insert into hxc_app_comp_notif_usages

227: comp_notification_id=l_comp_notification_id_exist and
228: comp_notification_ovn=l_object_version_number_exist;
229:
230: else
231: insert into hxc_app_comp_notif_usages
232: (approval_comp_id
233: ,approval_comp_ovn
234: ,comp_notification_id
235: ,comp_notification_ovn

Line 281: -- Insert into hxc_app_comp_notif_usages. We need not loop as we are dealing with only one

277: ,p_comp_notification_id => l_comp_notification_id
278: ,p_object_version_number => l_object_version_number
279: );
280:
281: -- Insert into hxc_app_comp_notif_usages. We need not loop as we are dealing with only one
282: -- approval component.
283:
284: insert into hxc_app_comp_notif_usages
285: (approval_comp_id

Line 284: insert into hxc_app_comp_notif_usages

280:
281: -- Insert into hxc_app_comp_notif_usages. We need not loop as we are dealing with only one
282: -- approval component.
283:
284: insert into hxc_app_comp_notif_usages
285: (approval_comp_id
286: ,approval_comp_ovn
287: ,comp_notification_id
288: ,comp_notification_ovn

Line 299: -- Insert into hxc_app_comp_notif_usages

295: ,l_enabled_flag
296: );
297:
298: else
299: -- Insert into hxc_app_comp_notif_usages
300:
301: insert into hxc_app_comp_notif_usages
302: (approval_comp_id
303: ,approval_comp_ovn

Line 301: insert into hxc_app_comp_notif_usages

297:
298: else
299: -- Insert into hxc_app_comp_notif_usages
300:
301: insert into hxc_app_comp_notif_usages
302: (approval_comp_id
303: ,approval_comp_ovn
304: ,comp_notification_id
305: ,comp_notification_ovn

Line 471: --Update the hxc_app_comp_notif_usages table

467: ,p_notification_timeout_value => p_notification_timeout_value
468: );
469:
470:
471: --Update the hxc_app_comp_notif_usages table
472:
473: update hxc_app_comp_notif_usages
474: set
475: comp_notification_ovn = l_object_version_number

Line 473: update hxc_app_comp_notif_usages

469:
470:
471: --Update the hxc_app_comp_notif_usages table
472:
473: update hxc_app_comp_notif_usages
474: set
475: comp_notification_ovn = l_object_version_number
476: where comp_notification_id = p_comp_notification_id;
477:

Line 585: -- update hxc_app_comp_notif_usages table

581: ,p_hook_type => 'BP'
582: );
583: end;
584: --
585: -- update hxc_app_comp_notif_usages table
586: --
587: update hxc_app_comp_notif_usages
588: set
589: enabled_flag = 'N' where

Line 587: update hxc_app_comp_notif_usages

583: end;
584: --
585: -- update hxc_app_comp_notif_usages table
586: --
587: update hxc_app_comp_notif_usages
588: set
589: enabled_flag = 'N' where
590: comp_notification_id = p_comp_notification_id and
591: comp_notification_ovn = p_object_version_number;

Line 677: -- Deleting records from hxc_app_comp_notif_usages

673:
674:
675:
676: --
677: -- Deleting records from hxc_app_comp_notif_usages
678: --
679: delete from hxc_app_comp_notif_usages where
680: comp_notification_id = p_comp_notification_id and
681: comp_notification_ovn= p_object_version_number and

Line 679: delete from hxc_app_comp_notif_usages where

675:
676: --
677: -- Deleting records from hxc_app_comp_notif_usages
678: --
679: delete from hxc_app_comp_notif_usages where
680: comp_notification_id = p_comp_notification_id and
681: comp_notification_ovn= p_object_version_number and
682: enabled_flag = 'N';
683:

Line 759: hxc_app_comp_notif_usages hacnu

755: SELECT hacnu.approval_comp_id, hacnu.comp_notification_id
756: FROM hxc_app_comp_notifications hacn,
757: hxc_approval_styles has,
758: hxc_approval_comps hac,
759: hxc_app_comp_notif_usages hacnu
760: WHERE has.NAME = p_approval_style_name
761: AND has.approval_style_id = hac.approval_style_id
762: AND hac.approval_comp_id = hacnu.approval_comp_id
763: AND hac.object_version_number = hacnu.approval_comp_ovn

Line 783: -- Deleting records from hxc_app_comp_notif_usages

779: -- Call Before Process User Hook
780: --
781:
782: --
783: -- Deleting records from hxc_app_comp_notif_usages
784: --
785: open csr_resend_notifications;
786: LOOP
787: fetch csr_resend_notifications into l_approval_comp_id,l_comp_notification_id;

Line 789: update hxc_app_comp_notif_usages

785: open csr_resend_notifications;
786: LOOP
787: fetch csr_resend_notifications into l_approval_comp_id,l_comp_notification_id;
788: exit when csr_resend_notifications%notfound;
789: update hxc_app_comp_notif_usages
790: set
791: enabled_flag = 'N'
792: where approval_comp_id = l_approval_comp_id and
793: comp_notification_id = l_comp_notification_id;