APPS.HR_APPROVAL_SS dependencies on WF_ITEM_ACTIVITY_STATUSES

Line 131: ln_activity_id WF_ITEM_ACTIVITY_STATUSES.process_activity%type;

127: p_item_key in wf_items.item_key%type) return number
128: is
129: -- local variables
130: c_proc constant varchar2(30) := 'storeApproverDetails';
131: ln_activity_id WF_ITEM_ACTIVITY_STATUSES.process_activity%type;
132: begin
133: g_debug := hr_utility.debug_enabled;
134: if g_debug then
135: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);

Line 143: FROM WF_ITEM_ACTIVITY_STATUSES IAS

139: SELECT process_activity
140: into ln_activity_id
141: from
142: (select process_activity
143: FROM WF_ITEM_ACTIVITY_STATUSES IAS
144: WHERE ias.item_type = p_item_type
145: and ias.item_key = p_item_key
146: and ias.activity_status = 'NOTIFIED'
147: and ias.process_activity in (

Line 197: lv_result_code WF_ITEM_ACTIVITY_STATUSES.activity_result_code%type;

193: c_transaction_type varchar2(25);
194: c_next_approvers ame_util.approverstable2;
195: c_approvalprocesscompleteynout ame_util.charType;
196: l_current_forward_to_username wf_users.name%type;
197: lv_result_code WF_ITEM_ACTIVITY_STATUSES.activity_result_code%type;
198: lv_result_display varchar2(250);
199: lv_test_result_code varchar2(250);
200: lv_comments wf_item_attribute_values.text_value%type;
201: lv_recipient varchar2(250);

Line 2216: lv_result_code WF_ITEM_ACTIVITY_STATUSES.activity_result_code%type;

2212: c_transaction_type varchar2(25);
2213: c_next_approvers ame_util.approverstable2;
2214: c_approvalprocesscompleteynout ame_util.charType;
2215: l_current_forward_to_username wf_users.name%type;
2216: lv_result_code WF_ITEM_ACTIVITY_STATUSES.activity_result_code%type;
2217: lv_result_display varchar2(250);
2218:
2219: begin
2220: g_debug := hr_utility.debug_enabled;

Line 2265: lv_result_code WF_ITEM_ACTIVITY_STATUSES.activity_result_code%type;

2261: c_transaction_type varchar2(25);
2262: c_next_approvers ame_util.approverstable2;
2263: c_approvalprocesscompleteynout ame_util.charType;
2264: l_current_forward_to_username wf_users.name%type;
2265: lv_result_code WF_ITEM_ACTIVITY_STATUSES.activity_result_code%type;
2266: lv_result_display varchar2(250);
2267:
2268: begin
2269: g_debug := hr_utility.debug_enabled;

Line 2493: lv_result_code WF_ITEM_ACTIVITY_STATUSES.activity_result_code%type;

2489: c_transaction_type varchar2(25);
2490: c_next_approvers ame_util.approverstable2;
2491: c_approvalprocesscompleteynout ame_util.charType;
2492: l_current_forward_to_username wf_users.name%type;
2493: lv_result_code WF_ITEM_ACTIVITY_STATUSES.activity_result_code%type;
2494: lv_result_display varchar2(250);
2495: lv_test_result_code varchar2(250);
2496: lv_comments wf_item_attribute_values.text_value%type;
2497: lv_new_transaction varchar2(240);

Line 3339: FROM WF_ITEM_ACTIVITY_STATUSES IAS

3335: -- Fetch the id for RFC notification.
3336: begin
3337: SELECT ias.notification_id
3338: into ln_rfc_notification_id
3339: FROM WF_ITEM_ACTIVITY_STATUSES IAS
3340: WHERE ias.item_type = p_item_Type
3341: and ias.item_key = p_item_Key
3342: and IAS.ACTIVITY_STATUS = 'NOTIFIED'
3343: and notification_id is not null

Line 4019: lv_errorActid wf_item_activity_statuses.process_activity%type;

4015: lv_item_key wf_items.item_key%type;
4016: lr_transaction_rec hr_api_transactions%rowtype;
4017: lv_status varchar2(8);
4018: lv_result varchar2(30);
4019: lv_errorActid wf_item_activity_statuses.process_activity%type;
4020: lv_errname VARCHAR2(4000);
4021: l_index binary_integer;
4022: l_temp_item_attribute varchar2(2000);
4023: l_role_name wf_roles.name%type;

Line 4358: FROM WF_ITEM_ACTIVITY_STATUSES IAS

4354: where transaction_id=p_transaction_id;
4355:
4356: select notification_id
4357: into ln_notification_id
4358: FROM WF_ITEM_ACTIVITY_STATUSES IAS
4359: WHERE ias.item_type = lr_hr_api_transaction_rec.item_type
4360: and ias.item_key = lr_hr_api_transaction_rec.item_key
4361: and ias.activity_status = 'NOTIFIED'
4362: and ias.notification_id is not null

Line 4380: ln_activity_id wf_item_activity_statuses.process_activity%type;

4376: is
4377: -- local variables
4378: c_proc constant varchar2(30) := 'processPageNavWFSubmit';
4379: lr_hr_api_transaction_rec hr_api_transactions%rowtype;
4380: ln_activity_id wf_item_activity_statuses.process_activity%type;
4381: begin
4382: if g_debug then
4383: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
4384: end if;

Line 4492: ln_activity_id wf_item_activity_statuses.process_activity%type;

4488: is
4489: -- local variables
4490: c_proc constant varchar2(30) := 'processNonPageNavWFSubmit';
4491: lr_hr_api_transaction_rec hr_api_transactions%rowtype;
4492: ln_activity_id wf_item_activity_statuses.process_activity%type;
4493: ln_notification_id wf_notifications.notification_id%type;
4494: lv_loginPersonDispName per_all_people_f.full_name%type;
4495: lv_loginPersonUserName fnd_user.user_name%type;
4496: ln_loginPersonId fnd_user.employee_id%type;

Line 4625: ln_activity_id wf_item_activity_statuses.process_activity%type;

4621: is
4622: -- local variables
4623: c_proc constant varchar2(30) := 'processApprovalSubmit';
4624: lr_hr_api_transaction_rec hr_api_transactions%rowtype;
4625: ln_activity_id wf_item_activity_statuses.process_activity%type;
4626: lv_loginPersonDispName per_all_people_f.full_name%type;
4627: lv_loginPersonUserName fnd_user.user_name%type;
4628: ln_loginPersonId fnd_user.employee_id%type;
4629: lv_item_type wf_items.item_type%type;

Line 4717: ln_oaf_page_act_id WF_ITEM_ACTIVITY_STATUSES.process_activity%type;

4713: procedure resetWfPageFlowState(p_transaction_id in number)
4714: is
4715: lr_hr_api_transaction_rec hr_api_transactions%rowtype;
4716: ln_activity_id wf_item_attribute_values.number_value%type;
4717: ln_oaf_page_act_id WF_ITEM_ACTIVITY_STATUSES.process_activity%type;
4718: lv_oaf_nav_attr wf_item_attribute_values.text_value%type;
4719: begin
4720:
4721: if(p_transaction_id is not null) then