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_NOTIFICATIONS

Line 1: Package Body hxc_app_comp_notifications_api as

1: Package Body hxc_app_comp_notifications_api as
2: /* $Header: hxchanapi.pkb 120.0 2006/06/19 06:58:02 gsirigin noship $ */
3: --
4: -- Package Variables
5: --

Line 6: g_package varchar2(33) := 'hxc_app_comp_notifications_api.';

2: /* $Header: hxchanapi.pkb 120.0 2006/06/19 06:58:02 gsirigin noship $ */
3: --
4: -- Package Variables
5: --
6: g_package varchar2(33) := 'hxc_app_comp_notifications_api.';
7: g_debug boolean :=hr_utility.debug_enabled;
8: --
9: -- ----------------------------------------------------------------------------
10: -- |--------------------------< >--------------|

Line 27: l_comp_notification_id hxc_app_comp_notifications.comp_notification_id%TYPE;

23: p_object_version_number in out nocopy ovn_type
24: ) is
25:
26: l_proc varchar2(72) := g_package||'create_app_comp_notifications';
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';

Line 28: l_object_version_number hxc_app_comp_notifications.object_version_number%TYPE;

24: ) is
25:
26: l_proc varchar2(72) := g_package||'create_app_comp_notifications';
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;

Line 32: l_comp_notification_id_exist 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:
36:

Line 33: l_object_version_number_exist 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:
36:
37:

Line 50: ( p_notification_number_retries in hxc_app_comp_notifications.notification_number_retries%type

46: FROM hxc_approval_comps
47: WHERE approval_comp_id =hac.approval_comp_id);
48:
49: cursor csr_chk_app_comp_notifications
50: ( p_notification_number_retries in hxc_app_comp_notifications.notification_number_retries%type
51: ,p_notification_timeout_value in hxc_app_comp_notifications.notification_timeout_value%type
52: ,p_notification_action_code in hxc_app_comp_notifications.notification_action_code%type
53: ,p_notification_recipient_code in hxc_app_comp_notifications.notification_recipient_code%type
54: ) is

Line 51: ,p_notification_timeout_value in hxc_app_comp_notifications.notification_timeout_value%type

47: WHERE approval_comp_id =hac.approval_comp_id);
48:
49: cursor csr_chk_app_comp_notifications
50: ( p_notification_number_retries in hxc_app_comp_notifications.notification_number_retries%type
51: ,p_notification_timeout_value in hxc_app_comp_notifications.notification_timeout_value%type
52: ,p_notification_action_code in hxc_app_comp_notifications.notification_action_code%type
53: ,p_notification_recipient_code in hxc_app_comp_notifications.notification_recipient_code%type
54: ) is
55: SELECT hacn.comp_notification_id, hacn.object_version_number

Line 52: ,p_notification_action_code in hxc_app_comp_notifications.notification_action_code%type

48:
49: cursor csr_chk_app_comp_notifications
50: ( p_notification_number_retries in hxc_app_comp_notifications.notification_number_retries%type
51: ,p_notification_timeout_value in hxc_app_comp_notifications.notification_timeout_value%type
52: ,p_notification_action_code in hxc_app_comp_notifications.notification_action_code%type
53: ,p_notification_recipient_code in hxc_app_comp_notifications.notification_recipient_code%type
54: ) is
55: SELECT hacn.comp_notification_id, hacn.object_version_number
56: FROM hxc_app_comp_notifications hacn

Line 53: ,p_notification_recipient_code in hxc_app_comp_notifications.notification_recipient_code%type

49: cursor csr_chk_app_comp_notifications
50: ( p_notification_number_retries in hxc_app_comp_notifications.notification_number_retries%type
51: ,p_notification_timeout_value in hxc_app_comp_notifications.notification_timeout_value%type
52: ,p_notification_action_code in hxc_app_comp_notifications.notification_action_code%type
53: ,p_notification_recipient_code in hxc_app_comp_notifications.notification_recipient_code%type
54: ) is
55: SELECT hacn.comp_notification_id, hacn.object_version_number
56: FROM hxc_app_comp_notifications hacn
57: WHERE notification_number_retries = p_notification_number_retries

Line 56: FROM hxc_app_comp_notifications hacn

52: ,p_notification_action_code in hxc_app_comp_notifications.notification_action_code%type
53: ,p_notification_recipient_code in hxc_app_comp_notifications.notification_recipient_code%type
54: ) is
55: SELECT hacn.comp_notification_id, hacn.object_version_number
56: FROM hxc_app_comp_notifications hacn
57: WHERE notification_number_retries = p_notification_number_retries
58: AND notification_timeout_value = p_notification_timeout_value
59: AND notification_action_code = p_notification_action_code
60: AND notification_recipient_code = p_notification_recipient_code

Line 62: FROM hxc_app_comp_notifications

58: AND notification_timeout_value = p_notification_timeout_value
59: AND notification_action_code = p_notification_action_code
60: AND notification_recipient_code = p_notification_recipient_code
61: AND object_version_number = (SELECT MAX (object_version_number)
62: FROM hxc_app_comp_notifications
63: WHERE comp_notification_id =
64: hacn.comp_notification_id);
65:
66: cursor csr_comp_from_recipient

Line 126: hxc_app_comp_notifications_bk1.create_app_comp_notification_b

122:
123:
124:
125:
126: hxc_app_comp_notifications_bk1.create_app_comp_notification_b
127: (
128: p_notification_number_retries => p_notification_number_retries
129: ,p_notification_timeout_value => p_notification_timeout_value
130: ,p_notification_action_code => p_notification_action_code

Line 332: hxc_app_comp_notifications_bk1.create_app_comp_notification_a

328: -- Call After Process User Hook
329: --
330:
331: begin
332: hxc_app_comp_notifications_bk1.create_app_comp_notification_a
333: (p_comp_notification_id => l_comp_notification_id
334: ,p_object_version_number => l_object_version_number
335: ,p_notification_number_retries => p_notification_number_retries
336: ,p_notification_timeout_value => p_notification_timeout_value

Line 418: l_object_version_number hxc_app_comp_notifications.object_version_number%type :=p_object_version_number;

414: ) is
415: --
416: -- Declare cursors and local variables
417: --
418: l_object_version_number hxc_app_comp_notifications.object_version_number%type :=p_object_version_number;
419: l_effective_date date;
420: l_proc varchar2(72) := g_package||'update_app_comp_notification';
421: begin
422: if g_debug then

Line 435: hxc_app_comp_notifications_bk2.update_app_comp_notification_b

431: --
432: -- Call Before Process User Hook
433: --
434: begin
435: hxc_app_comp_notifications_bk2.update_app_comp_notification_b
436: (p_comp_notification_id => p_comp_notification_id
437: ,p_object_version_number => p_object_version_number
438: ,p_notification_number_retries => p_notification_number_retries
439: ,p_notification_timeout_value => p_notification_timeout_value

Line 482: hxc_app_comp_notifications_bk2.update_app_comp_notification_a

478: --
479: -- Call After Process User Hook
480: --
481: begin
482: hxc_app_comp_notifications_bk2.update_app_comp_notification_a
483: (p_comp_notification_id => p_comp_notification_id
484: ,p_object_version_number => p_object_version_number
485: ,p_notification_number_retries => p_notification_number_retries
486: ,p_notification_timeout_value => p_notification_timeout_value

Line 573: hxc_app_comp_notifications_bk3.delete_app_comp_notification_b

569: --
570: -- Call Before Process User Hook
571: --
572: begin
573: hxc_app_comp_notifications_bk3.delete_app_comp_notification_b
574: (p_comp_notification_id => p_comp_notification_id
575: ,p_object_version_number => p_object_version_number
576: );
577: exception

Line 598: hxc_app_comp_notifications_bk3.delete_app_comp_notification_a

594: --
595: -- Call After Process User Hook
596: --
597: begin
598: hxc_app_comp_notifications_bk3.delete_app_comp_notification_a
599: (p_comp_notification_id => p_comp_notification_id
600: ,p_object_version_number => p_object_version_number
601: ); exception
602: when hr_api.cannot_find_prog_unit then

Line 685: -- Delete from hxc_app_comp_notifications

681: comp_notification_ovn= p_object_version_number and
682: enabled_flag = 'N';
683:
684: --
685: -- Delete from hxc_app_comp_notifications
686: --
687:
688: hxc_han_del.del
689: (p_comp_notification_id => p_comp_notification_id

Line 756: FROM hxc_app_comp_notifications hacn,

752:
753: CURSOR csr_resend_notifications
754: IS
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

Line 798: -- Delete from hxc_app_comp_notifications

794: end loop;
795: close csr_resend_notifications;
796:
797: --
798: -- Delete from hxc_app_comp_notifications
799: --
800:
801: /* hxc_han_del.del
802: (p_comp_notification_id => l_comp_notification_id

Line 849: end hxc_app_comp_notifications_api;

845: hr_utility.set_location(' Leaving:'||l_proc, 90);
846: end if;
847: raise;
848: end disable_timeout_notifications;
849: end hxc_app_comp_notifications_api;