APPS.HXC_APP_COMP_NOTIFICATIONS_API dependencies on HXC_APPROVAL_COMPS

Line 29: l_approval_comp_id hxc_approval_comps.approval_comp_id%TYPE;

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;
33: l_object_version_number_exist hxc_app_comp_notifications.object_version_number%TYPE;

Line 30: l_approval_comp_ovn hxc_approval_comps.object_version_number%TYPE;

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;
33: l_object_version_number_exist hxc_app_comp_notifications.object_version_number%TYPE;
34: l_count number(1) :=0;

Line 42: FROM hxc_approval_styles has, hxc_approval_comps hac

38: cursor csr_approval_comp_id
39: (p_approval_style_name in varchar2)
40: is
41: SELECT hac.approval_comp_id, hac.object_version_number
42: FROM hxc_approval_styles has, hxc_approval_comps hac
43: WHERE has.NAME = p_approval_style_name
44: AND has.approval_style_id = hac.approval_style_id
45: AND hac.object_version_number = (SELECT MAX (object_version_number)
46: FROM hxc_approval_comps

Line 46: FROM hxc_approval_comps

42: FROM hxc_approval_styles has, hxc_approval_comps hac
43: WHERE has.NAME = p_approval_style_name
44: AND has.approval_style_id = hac.approval_style_id
45: AND hac.object_version_number = (SELECT MAX (object_version_number)
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

Line 70: FROM hxc_approval_styles has, hxc_approval_comps hac, hxc_time_recipients htr

66: cursor csr_comp_from_recipient
67: ( p_approval_style_name in varchar2
68: ,p_time_recipient_name in varchar2) is
69: SELECT hac.approval_comp_id, hac.object_version_number
70: FROM hxc_approval_styles has, hxc_approval_comps hac, hxc_time_recipients htr
71: WHERE has.NAME = p_approval_style_name
72: AND htr.NAME = p_time_recipient_name
73: AND has.approval_style_id = hac.approval_style_id
74: AND htr.time_recipient_id = hac.time_recipient_id

Line 76: FROM hxc_approval_comps

72: AND htr.NAME = p_time_recipient_name
73: AND has.approval_style_id = hac.approval_style_id
74: AND htr.time_recipient_id = hac.time_recipient_id
75: AND hac.object_version_number = (SELECT MAX (object_version_number)
76: FROM hxc_approval_comps
77: WHERE approval_comp_id =
78: hac.approval_comp_id);
79:
80: cursor csr_chk_diabled

Line 258: from hxc_approval_comps where

254: if(p_approval_component_id is not null)
255: then
256: select approval_comp_id,object_version_number
257: into l_approval_comp_id,l_approval_comp_ovn
258: from hxc_approval_comps where
259: approval_comp_id=p_approval_component_id;
260: else
261: open csr_comp_from_recipient(p_approval_style_name,p_time_recipient_name);
262: fetch csr_comp_from_recipient into l_approval_comp_id,l_approval_comp_ovn;

Line 758: hxc_approval_comps hac,

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
761: AND has.approval_style_id = hac.approval_style_id
762: AND hac.approval_comp_id = hacnu.approval_comp_id