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