APPS.HXC_NOTIFICATION_PROCESS_PKG dependencies on HXC_APP_PERIOD_SUMMARY

Line 20: from hxc_approval_comps hac, hxc_app_period_summary haps

16:
17: CURSOR c_get_app_mechanism(p_app_bb_id IN NUMBER,p_app_bb_ovn IN NUMBER)
18: IS
19: select approval_mechanism
20: from hxc_approval_comps hac, hxc_app_period_summary haps
21: where haps.application_period_id = p_app_bb_id
22: and haps.application_period_ovn = p_app_bb_ovn
23: and haps.approval_comp_id = hac.approval_comp_id;
24:

Line 25: l_app_bb_id hxc_app_period_summary.application_period_id%type;

21: where haps.application_period_id = p_app_bb_id
22: and haps.application_period_ovn = p_app_bb_ovn
23: and haps.approval_comp_id = hac.approval_comp_id;
24:
25: l_app_bb_id hxc_app_period_summary.application_period_id%type;
26: l_app_bb_ovn hxc_app_period_summary.application_period_ovn%type;
27: l_app_mechanism varchar2(30);
28: l_label varchar2(50);
29: l_approval_style_id number;

Line 26: l_app_bb_ovn hxc_app_period_summary.application_period_ovn%type;

22: and haps.application_period_ovn = p_app_bb_ovn
23: and haps.approval_comp_id = hac.approval_comp_id;
24:
25: l_app_bb_id hxc_app_period_summary.application_period_id%type;
26: l_app_bb_ovn hxc_app_period_summary.application_period_ovn%type;
27: l_app_mechanism varchar2(30);
28: l_label varchar2(50);
29: l_approval_style_id number;
30: l_preparer_timeout number;

Line 158: from hxc_app_period_summary haps

154:
155: CURSOR c_timeout_enabled(p_app_bb_id in number)
156: IS
157: select hacn.notification_number_retries
158: from hxc_app_period_summary haps
159: ,hxc_approval_comps hac
160: ,hxc_app_comp_notif_usages hacnu
161: ,hxc_app_comp_notifications hacn
162: where haps.application_period_id = p_app_bb_id

Line 600: from hxc_app_period_summary aps

596: aps.time_recipient_id,
597: aps.recipient_sequence,
598: aps.time_category_id,
599: aps.category_sequence
600: from hxc_app_period_summary aps
601: where aps.application_period_id = p_app_bb_id
602: and aps.application_period_ovn = p_app_bb_ovn;
603:
604: CURSOR c_is_error_process(p_itemtype in varchar2, p_item_key in varchar2)

Line 728: update hxc_app_period_summary

724: INTO l_item_key
725: FROM dual;
726:
727:
728: update hxc_app_period_summary
729: set notification_status = 'NOTIFIED',
730: approval_item_type = p_itemtype,
731: approval_process_name = l_process_name,
732: approval_item_key = l_item_key

Line 906: update hxc_app_period_summary

902:
903: -- Update attribute4 with NOTIFIED and attribute2 with the Item Key.
904:
905:
906: update hxc_app_period_summary
907: set notification_status = 'NOTIFIED'
908: where application_period_id = l_app_bb_id
909: and application_period_ovn = l_app_bb_ovn;
910: