APPS.HXC_APPROVAL_UTILITIES dependencies on WF_ITEM_ACTIVITY_STATUSES

Line 686: l_item_type wf_item_activity_statuses.item_type%TYPE := 'HXCEMP';

682: ,p_adv_search IN VARCHAR2
683: )
684: IS
685: -- l_approver_name per_all_people_f.full_name%TYPE;
686: l_item_type wf_item_activity_statuses.item_type%TYPE := 'HXCEMP';
687: l_item_key wf_item_activity_statuses.item_key%TYPE;
688: l_app_bb_id hxc_time_building_blocks.time_building_block_id%TYPE;
689: l_app_bb_ovn hxc_time_building_blocks.object_version_number%TYPE;
690: l_approval_record approval_notification;

Line 687: l_item_key wf_item_activity_statuses.item_key%TYPE;

683: )
684: IS
685: -- l_approver_name per_all_people_f.full_name%TYPE;
686: l_item_type wf_item_activity_statuses.item_type%TYPE := 'HXCEMP';
687: l_item_key wf_item_activity_statuses.item_key%TYPE;
688: l_app_bb_id hxc_time_building_blocks.time_building_block_id%TYPE;
689: l_app_bb_ovn hxc_time_building_blocks.object_version_number%TYPE;
690: l_approval_record approval_notification;
691: l_array_index NUMBER := 0;

Line 708: p_item_type IN wf_item_activity_statuses.item_type%TYPE

704: l_proc VARCHAR2(100);
705:
706:
707: CURSOR c_notification_item_keys(
708: p_item_type IN wf_item_activity_statuses.item_type%TYPE
709: ,p_approver_id IN NUMBER
710: )
711: IS
712: SELECT wias.item_key

Line 714: wf_item_activity_statuses wias,

710: )
711: IS
712: SELECT wias.item_key
713: FROM WF_NOTIFICATIONS wn,
714: wf_item_activity_statuses wias,
715: fnd_user fu
716: WHERE wn.recipient_role = fu.user_name
717: AND wn.status = 'OPEN'
718: AND wn.message_name IN ('TIMECARD_APPROVAL','TIMECARD_APPROVAL_INLINE')