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 3009: lv_result_code WF_ITEM_ACTIVITY_STATUSES.activity_result_code%type;

3005: c_transaction_type varchar2(25);
3006: c_next_approvers ame_util.approverstable2;
3007: c_approvalprocesscompleteynout ame_util.charType;
3008: l_current_forward_to_username wf_users.name%type;
3009: lv_result_code WF_ITEM_ACTIVITY_STATUSES.activity_result_code%type;
3010: lv_result_display varchar2(250);
3011:
3012: begin
3013: g_debug := hr_utility.debug_enabled;

Line 3058: lv_result_code WF_ITEM_ACTIVITY_STATUSES.activity_result_code%type;

3054: c_transaction_type varchar2(25);
3055: c_next_approvers ame_util.approverstable2;
3056: c_approvalprocesscompleteynout ame_util.charType;
3057: l_current_forward_to_username wf_users.name%type;
3058: lv_result_code WF_ITEM_ACTIVITY_STATUSES.activity_result_code%type;
3059: lv_result_display varchar2(250);
3060:
3061: CURSOR csr_txn (p_txn_id IN NUMBER)IS
3062: SELECT transaction_ref_table, transaction_ref_id

Line 3329: lv_result_code WF_ITEM_ACTIVITY_STATUSES.activity_result_code%type;

3325: c_transaction_type varchar2(25);
3326: c_next_approvers ame_util.approverstable2;
3327: c_approvalprocesscompleteynout ame_util.charType;
3328: l_current_forward_to_username wf_users.name%type;
3329: lv_result_code WF_ITEM_ACTIVITY_STATUSES.activity_result_code%type;
3330: lv_result_display varchar2(250);
3331: lv_test_result_code varchar2(250);
3332: lv_comments wf_item_attribute_values.text_value%type;
3333: lv_new_transaction varchar2(240);

Line 4350: FROM WF_ITEM_ACTIVITY_STATUSES IAS

4346: -- Fetch the id for RFC notification.
4347: begin
4348: SELECT ias.notification_id
4349: into ln_rfc_notification_id
4350: FROM WF_ITEM_ACTIVITY_STATUSES IAS
4351: WHERE ias.item_type = p_item_Type
4352: and ias.item_key = p_item_Key
4353: and IAS.ACTIVITY_STATUS = 'NOTIFIED'
4354: and notification_id is not null

Line 5060: lv_errorActid wf_item_activity_statuses.process_activity%type;

5056: lv_item_key wf_items.item_key%type;
5057: lr_transaction_rec hr_api_transactions%rowtype;
5058: lv_status varchar2(8);
5059: lv_result varchar2(30);
5060: lv_errorActid wf_item_activity_statuses.process_activity%type;
5061: lv_errname VARCHAR2(4000);
5062: l_index binary_integer;
5063: l_temp_item_attribute varchar2(2000);
5064: l_role_name wf_roles.name%type;

Line 5399: FROM WF_ITEM_ACTIVITY_STATUSES IAS

5395: where transaction_id=p_transaction_id;
5396:
5397: select notification_id
5398: into ln_notification_id
5399: FROM WF_ITEM_ACTIVITY_STATUSES IAS
5400: WHERE ias.item_type = lr_hr_api_transaction_rec.item_type
5401: and ias.item_key = lr_hr_api_transaction_rec.item_key
5402: and ias.activity_status = 'NOTIFIED'
5403: and ias.notification_id is not null

Line 5421: ln_activity_id wf_item_activity_statuses.process_activity%type;

5417: is
5418: -- local variables
5419: c_proc constant varchar2(30) := 'processPageNavWFSubmit';
5420: lr_hr_api_transaction_rec hr_api_transactions%rowtype;
5421: ln_activity_id wf_item_activity_statuses.process_activity%type;
5422: begin
5423: if g_debug then
5424: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
5425: end if;

Line 5533: ln_activity_id wf_item_activity_statuses.process_activity%type;

5529: is
5530: -- local variables
5531: c_proc constant varchar2(30) := 'processNonPageNavWFSubmit';
5532: lr_hr_api_transaction_rec hr_api_transactions%rowtype;
5533: ln_activity_id wf_item_activity_statuses.process_activity%type;
5534: ln_notification_id wf_notifications.notification_id%type;
5535: lv_loginPersonDispName per_all_people_f.full_name%type;
5536: lv_loginPersonUserName fnd_user.user_name%type;
5537: ln_loginPersonId fnd_user.employee_id%type;

Line 5673: ln_activity_id wf_item_activity_statuses.process_activity%type;

5669: is
5670: -- local variables
5671: c_proc constant varchar2(30) := 'processApprovalSubmit';
5672: lr_hr_api_transaction_rec hr_api_transactions%rowtype;
5673: ln_activity_id wf_item_activity_statuses.process_activity%type;
5674: lv_loginPersonDispName per_all_people_f.full_name%type;
5675: lv_loginPersonUserName fnd_user.user_name%type;
5676: ln_loginPersonId fnd_user.employee_id%type;
5677: lv_item_type wf_items.item_type%type;

Line 5765: ln_oaf_page_act_id WF_ITEM_ACTIVITY_STATUSES.process_activity%type;

5761: procedure resetWfPageFlowState(p_transaction_id in number)
5762: is
5763: lr_hr_api_transaction_rec hr_api_transactions%rowtype;
5764: ln_activity_id wf_item_attribute_values.number_value%type;
5765: ln_oaf_page_act_id WF_ITEM_ACTIVITY_STATUSES.process_activity%type;
5766: lv_oaf_nav_attr wf_item_attribute_values.text_value%type;
5767: begin
5768:
5769: if(p_transaction_id is not null) then