APPS.HR_ABSUTIL_SS dependencies on WF_ITEM_ACTIVITY_STATUSES

Line 449: lv_item_type wf_item_activity_statuses.item_type%type;

445: p_absence_attendance_id in number) return varchar2
446:
447: IS
448: c_proc constant varchar2(30) := 'isConfirmAllowed';
449: lv_item_type wf_item_activity_statuses.item_type%type;
450: lv_item_key wf_item_activity_statuses.item_key%type;
451: begin
452: g_debug := hr_utility.debug_enabled;
453: if g_debug then

Line 450: lv_item_key wf_item_activity_statuses.item_key%type;

446:
447: IS
448: c_proc constant varchar2(30) := 'isConfirmAllowed';
449: lv_item_type wf_item_activity_statuses.item_type%type;
450: lv_item_key wf_item_activity_statuses.item_key%type;
451: begin
452: g_debug := hr_utility.debug_enabled;
453: if g_debug then
454: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);

Line 514: lv_item_type wf_item_activity_statuses.item_type%type;

510: p_absence_attendance_id in number) return varchar2
511:
512: IS
513: c_proc constant varchar2(30) := 'hasSupportingDocuments';
514: lv_item_type wf_item_activity_statuses.item_type%type;
515: lv_item_key wf_item_activity_statuses.item_key%type;
516: lv_entity_name constant varchar2(50) := 'PER_ABSENCE_ATTENDANCES';
517: lv_pkey1 fnd_attached_documents.pk1_value%type;
518: l_exists VARCHAR2(1);

Line 515: lv_item_key wf_item_activity_statuses.item_key%type;

511:
512: IS
513: c_proc constant varchar2(30) := 'hasSupportingDocuments';
514: lv_item_type wf_item_activity_statuses.item_type%type;
515: lv_item_key wf_item_activity_statuses.item_key%type;
516: lv_entity_name constant varchar2(50) := 'PER_ABSENCE_ATTENDANCES';
517: lv_pkey1 fnd_attached_documents.pk1_value%type;
518: l_exists VARCHAR2(1);
519:

Line 568: lv_item_type wf_item_activity_statuses.item_type%type;

564:
565:
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

Line 569: lv_item_key wf_item_activity_statuses.item_key%type;

565:
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;

Line 608: FROM WF_ITEM_ACTIVITY_STATUSES IAS

604: -- get the ntf id
605: begin
606: select notification_id
607: into ln_notification_id
608: FROM WF_ITEM_ACTIVITY_STATUSES IAS
609: WHERE ias.item_type = lv_item_type
610: and ias.item_key = lv_item_key
611: and ias.activity_status = 'NOTIFIED'
612: and ias.notification_id is not null