APPS.HXC_NOTIFICATION_PROCESS_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 20

		select fuser.employee_id,wf.message_type,wf.item_key
		  from wf_notifications wf,
           fnd_user fuser
		 where wf.notification_id = l_notification_id
			 and fuser.user_name = wf.RECIPIENT_ROLE;

Line: 70

select approval_mechanism
from hxc_approval_comps hac, hxc_app_period_summary haps
where haps.application_period_id = p_app_bb_id
and haps.application_period_ovn = p_app_bb_ovn
and haps.approval_comp_id = hac.approval_comp_id;

Line: 208

select hacn.notification_number_retries
from hxc_app_period_summary haps
     ,hxc_approval_comps hac
     ,hxc_app_comp_notif_usages hacnu
     ,hxc_app_comp_notifications hacn
where haps.application_period_id = p_app_bb_id
 and  haps.approval_comp_id = hac.approval_comp_id
 and  hacnu.approval_comp_id = hac.approval_comp_id
 and  hacnu.approval_comp_ovn = hac.object_version_number
 and  hacnu.comp_notification_id = hacn.comp_notification_id
 and  hacnu.comp_notification_ovn=hacn.object_version_number
 and  hacnu.enabled_flag = 'Y'
 and  hacn.notification_action_code = 'REQUEST-APPROVAL-RESEND';

Line: 224

select hac.approval_comp_id
from hxc_approval_comps hac,
     hxc_approval_styles has,
    hxc_time_building_blocks htb
where htb.time_building_block_id =p_bb_id
and htb.object_version_number = p_bb_ovn
and htb.approval_style_id = has.approval_style_id
and has.approval_style_id = hac.APPROVAL_STYLE_ID
and hac.approval_mechanism = 'PROJECT_MANAGER'
and hac.parent_comp_id is null
and hac.parent_comp_ovn is null;

Line: 238

select hacn.notification_number_retries
from  hxc_approval_comps hac
     ,hxc_app_comp_notif_usages hacnu
     ,hxc_app_comp_notifications hacn
where hac.approval_comp_id = p_app_comp_id
 and  hacnu.approval_comp_id = hac.approval_comp_id
 and  hacnu.approval_comp_ovn = hac.object_version_number
 and  hacnu.comp_notification_id = hacn.comp_notification_id
 and  hacnu.comp_notification_ovn=hacn.object_version_number
 and  hacnu.enabled_flag = 'Y'
 and  hacn.notification_action_code = 'REQUEST-APPROVAL-RESEND';

Line: 635

   select tc.resource_id, tc.start_time, tc.stop_time,tc.last_updated_by
     from hxc_time_building_blocks tc
    where tc.time_building_block_id = p_bld_blk_id
      and tc.object_version_number = p_ovn;

Line: 645

   select aps.start_time,                 -- period_start_date
          aps.stop_time,                  -- period_end_date
          aps.time_recipient_id,
          aps.recipient_sequence,
          aps.time_category_id,
          aps.category_sequence
     from hxc_app_period_summary aps
    where  aps.application_period_id = p_app_bb_id
    and aps.application_period_ovn = p_app_bb_ovn;

Line: 657

select parent_item_key
from wf_items
where item_type = p_itemtype
and item_key = p_item_key
and root_activity = 'OTL_ERROR_PROCESS';

Line: 665

  select ta.attribute3,
         ta.attribute4,
         ta.attribute5,
         ta.attribute6
     from hxc_time_attributes ta,
          hxc_time_attribute_usages tau,
          hxc_time_building_blocks tbb
    where tbb.time_building_block_id = p_timecard_bb_id
      and tbb.object_version_number  = p_timecard_ovn
      and tbb.time_building_block_id = tau.time_building_block_id
      and tbb.object_version_number  = tau.time_building_block_ovn
      and ta.time_attribute_id  = tau.time_attribute_id
      and ta.attribute_category = 'SECURITY';

Line: 687

l_last_updated_by		number;

Line: 762

  		           l_last_updated_by;

Line: 774

		SELECT hxc_approval_item_key_s.nextval
                INTO l_item_key
                FROM dual;

Line: 779

		update hxc_app_period_summary
		set notification_status = 'NOTIFIED',
                      approval_item_type = p_itemtype,
                      approval_process_name = l_process_name,
                      approval_item_key = l_item_key
                where application_period_id = l_app_bb_id
                  and application_period_ovn = l_app_bb_ovn;

Line: 797

                                                                       p_user_id => l_last_updated_by)
                                    );

Line: 957

               update hxc_app_period_summary
                  set notification_status = 'NOTIFIED'
                where application_period_id = l_app_bb_id
                  and application_period_ovn = l_app_bb_ovn;

Line: 989

select wn.original_recipient
  from wf_item_activity_statuses wias,
          wf_process_activities wpa,
          wf_notifications wn
 where wias.item_type = p_itemtype
   and wias.item_key = p_itemkey
   and wias.process_activity = wpa.instance_id
   and wpa.activity_name IN('TC_APR_NOTIFICATION', 'TC_APR_NOTIFICATION_ABS')
   and wias.notification_id = wn.notification_id;