APPS.HR_SFLUTIL_SS dependencies on WF_ITEM_ACTIVITY_STATUSES

Line 126: from wf_item_activity_statuses ias,

122: lv_sendNtf varchar2(4);
123:
124: cursor sflNotificationsCursor is
125: select ias.notification_id notification_id
126: from wf_item_activity_statuses ias,
127: wf_notifications ntf
128: where ias.item_type = itemtype
129: and ias.item_key =itemkey
130: and ias.notification_id is not null

Line 135: from wf_item_activity_statuses_h ias,

131: and ntf.notification_id = ias.notification_id
132: and ntf.status='OPEN'
133: union
134: select ias.notification_id notification_id
135: from wf_item_activity_statuses_h ias,
136: wf_notifications ntf
137: where ias.notification_id is not null
138: and ias.item_type = itemtype
139: and ias.item_key =itemkey

Line 315: lv_parent_item_type wf_item_activity_statuses.item_type%type;

311: document_type IN OUT NOCOPY Varchar2)
312: is
313: c_proc constant varchar2(30) := 'getSFLMsgSubject';
314: ln_transaction_id hr_api_transactions.transaction_id%type;
315: lv_parent_item_type wf_item_activity_statuses.item_type%type;
316: lv_parent_item_key wf_item_activity_statuses.item_key%type;
317: l_creator_person_id per_people_f.person_id%type;
318: l_creator_disp_name wf_users.display_name%type;
319: l_creator_username wf_users.name%type;

Line 316: lv_parent_item_key wf_item_activity_statuses.item_key%type;

312: is
313: c_proc constant varchar2(30) := 'getSFLMsgSubject';
314: ln_transaction_id hr_api_transactions.transaction_id%type;
315: lv_parent_item_type wf_item_activity_statuses.item_type%type;
316: lv_parent_item_key wf_item_activity_statuses.item_key%type;
317: l_creator_person_id per_people_f.person_id%type;
318: l_creator_disp_name wf_users.display_name%type;
319: l_creator_username wf_users.name%type;
320: l_current_person_id per_people_f.person_id%type;

Line 626: lv_item_type wf_item_activity_statuses.item_type%type;

622: ,p_itemKey OUT NOCOPY VARCHAR2 )
623:
624: IS
625: c_proc constant varchar2(30) := 'getSFLTransactionDetails';
626: lv_item_type wf_item_activity_statuses.item_type%type;
627: lv_item_key wf_item_activity_statuses.item_key%type;
628: begin
629: g_debug := hr_utility.debug_enabled;
630: if g_debug then

Line 627: lv_item_key wf_item_activity_statuses.item_key%type;

623:
624: IS
625: c_proc constant varchar2(30) := 'getSFLTransactionDetails';
626: lv_item_type wf_item_activity_statuses.item_type%type;
627: lv_item_key wf_item_activity_statuses.item_key%type;
628: begin
629: g_debug := hr_utility.debug_enabled;
630: if g_debug then
631: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);

Line 925: ln_activity_id wf_item_activity_statuses.process_activity%type;

921: is
922: -- local variables
923: c_proc constant varchar2(30) := 'processApprovalSubmit';
924: lr_hr_api_transaction_rec hr_api_transactions%rowtype;
925: ln_activity_id wf_item_activity_statuses.process_activity%type;
926: lv_loginPersonDispName per_all_people_f.full_name%type;
927: lv_loginPersonUserName fnd_user.user_name%type;
928: ln_loginPersonId fnd_user.employee_id%type;
929:

Line 980: FROM WF_ITEM_ACTIVITY_STATUSES IAS

976: SELECT process_activity
977: into ln_activity_id
978: from
979: (select process_activity
980: FROM WF_ITEM_ACTIVITY_STATUSES IAS
981: WHERE ias.item_type = lr_hr_api_transaction_rec.item_type
982: and ias.item_key = lr_hr_api_transaction_rec.item_type
983: and ias.activity_status = 'NOTIFIED'
984: and ias.process_activity in (