APPS.HR_ABSUTIL_SS dependencies on HR_API_TRANSACTIONS

Line 342: from hr_api_transactions

338: 'ROS','Y',
339: 'YS','Y',
340: status))
341: into lv_approvalStatus
342: from hr_api_transactions
343: where transaction_id=p_transaction_id;
344: exception
345: when others then
346: lv_approvalStatus:=null;

Line 386: from hr_api_transactions

382: 'ROS','Y',
383: 'YS','Y',
384: status)
385: into lv_approvalStatusCode
386: from hr_api_transactions
387: where transaction_id=p_transaction_id;
388:
389: exception
390: when others then

Line 619: lv_status hr_api_transactions.status%type;

615: IS
616: c_proc constant varchar2(30) := 'getAbsenceNotificationDetails';
617: lv_item_type wf_item_activity_statuses.item_type%type;
618: lv_item_key wf_item_activity_statuses.item_key%type;
619: lv_status hr_api_transactions.status%type;
620: ln_notification_id wf_notifications.notification_id%type;
621: begin
622: g_debug := hr_utility.debug_enabled;
623: if g_debug then

Line 630: from hr_api_transactions

626:
627: begin
628: select status,item_type,item_key
629: into lv_status,lv_item_type,lv_item_key
630: from hr_api_transactions
631: where transaction_id=p_transaction_id;
632: exception
633: when others then
634: null;

Line 833: lr_hr_api_transaction_rec hr_api_transactions%rowtype;

829: is
830:
831:
832: lv_result varchar2(100);
833: lr_hr_api_transaction_rec hr_api_transactions%rowtype;
834: lr_wf_items_rec wf_items%rowtype := null;
835: l_user_key varchar2(50) := null;
836:
837: begin

Line 842: from hr_api_transactions

838:
839: if(p_transaction_id is not null) then
840: begin
841: select * into lr_hr_api_transaction_rec
842: from hr_api_transactions
843: where transaction_id=p_transaction_id;
844: exception
845: when others then
846: raise;

Line 886: select transaction_id from hr_api_transactions hat

882: is
883:
884: cursor c_trans_rec(p_absence_attendance_id number) is
885:
886: select transaction_id from hr_api_transactions hat
887: where hat.transaction_ref_id = p_absence_attendance_id
888: and hat.transaction_ref_table = 'PER_ABSENCE_ATTENDANCES'
889: and hat.status not in ('AC','Y');
890: