APPS.HR_ABSUTIL_SS dependencies on HR_API_TRANSACTIONS

Line 293: from hr_api_transactions

289: 'ROS','Y',
290: 'YS','Y',
291: status))
292: into lv_approvalStatus
293: from hr_api_transactions
294: where transaction_id=p_transaction_id;
295: exception
296: when others then
297: lv_approvalStatus:=null;

Line 337: from hr_api_transactions

333: 'ROS','Y',
334: 'YS','Y',
335: status)
336: into lv_approvalStatusCode
337: from hr_api_transactions
338: where transaction_id=p_transaction_id;
339:
340: exception
341: when others then

Line 570: lv_status hr_api_transactions.status%type;

566: IS
567: c_proc constant varchar2(30) := 'getAbsenceNotificationDetails';
568: lv_item_type wf_item_activity_statuses.item_type%type;
569: lv_item_key wf_item_activity_statuses.item_key%type;
570: lv_status hr_api_transactions.status%type;
571: ln_notification_id wf_notifications.notification_id%type;
572: begin
573: g_debug := hr_utility.debug_enabled;
574: if g_debug then

Line 581: from hr_api_transactions

577:
578: begin
579: select status,item_type,item_key
580: into lv_status,lv_item_type,lv_item_key
581: from hr_api_transactions
582: where transaction_id=p_transaction_id;
583: exception
584: when others then
585: null;