[Home] [Help]
192: c_transaction_id varchar2(25);
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;
403: is
404: -- local variables
405: c_proc constant varchar2(30) := 'storeApproverDetails';
406: l_current_forward_to_id per_people_f.person_id%type;
407: l_current_forward_to_origSys wf_users.orig_system%type;
408: l_current_forward_to_username wf_users.name%type;
409: l_current_forward_to_disp_name wf_users.display_name%type;
410:
411: begin
404: -- local variables
405: c_proc constant varchar2(30) := 'storeApproverDetails';
406: l_current_forward_to_id per_people_f.person_id%type;
407: l_current_forward_to_origSys wf_users.orig_system%type;
408: l_current_forward_to_username wf_users.name%type;
409: l_current_forward_to_disp_name wf_users.display_name%type;
410:
411: begin
412: g_debug := hr_utility.debug_enabled;
405: c_proc constant varchar2(30) := 'storeApproverDetails';
406: l_current_forward_to_id per_people_f.person_id%type;
407: l_current_forward_to_origSys wf_users.orig_system%type;
408: l_current_forward_to_username wf_users.name%type;
409: l_current_forward_to_disp_name wf_users.display_name%type;
410:
411: begin
412: g_debug := hr_utility.debug_enabled;
413: if g_debug then
623: p_item_key in varchar2)
624: is
625: -- local variables
626: c_proc constant varchar2(30) := 'storePrllApprDetails';
627: l_current_forward_to_username wf_users.name%type;
628: l_current_forward_to_disp_name wf_users.display_name%type;
629: l_role_name varchar2(1000) := null;
630:
631: begin
624: is
625: -- local variables
626: c_proc constant varchar2(30) := 'storePrllApprDetails';
627: l_current_forward_to_username wf_users.name%type;
628: l_current_forward_to_disp_name wf_users.display_name%type;
629: l_role_name varchar2(1000) := null;
630:
631: begin
632: g_debug := hr_utility.debug_enabled;
1485: is
1486: -- local variables
1487: c_proc constant varchar2(30) := 'getNextApproverRole';
1488: lv_current_approver_category varchar2(4000);
1489: l_current_forward_to_username wf_users.name%type;
1490: l_current_forward_to_disp_name wf_users.display_name%type;
1491: l_is_parallel varchar2(10) := null;
1492:
1493: begin
1486: -- local variables
1487: c_proc constant varchar2(30) := 'getNextApproverRole';
1488: lv_current_approver_category varchar2(4000);
1489: l_current_forward_to_username wf_users.name%type;
1490: l_current_forward_to_disp_name wf_users.display_name%type;
1491: l_is_parallel varchar2(10) := null;
1492:
1493: begin
1494: g_debug := hr_utility.debug_enabled;
2111: c_transaction_id varchar2(25);
2112: c_transaction_type varchar2(25);
2113: c_next_approvers ame_util.approverstable2;
2114: c_approvalprocesscompleteynout ame_util.charType;
2115: l_current_forward_to_username wf_users.name%type;
2116:
2117: begin
2118: g_debug := hr_utility.debug_enabled;
2119:
2200: c_transaction_id varchar2(25);
2201: c_transaction_type varchar2(25);
2202: c_next_approvers ame_util.approverstable2;
2203: c_approvalprocesscompleteynout ame_util.charType;
2204: l_current_forward_to_username wf_users.name%type;
2205: notification_rec ame_util2.notificationRecord;
2206: l_is_parallel varchar2(10) := null;
2207: original_forward_to_user wf_users.name%type;
2208: l_role_name wf_users.name%type;
2203: c_approvalprocesscompleteynout ame_util.charType;
2204: l_current_forward_to_username wf_users.name%type;
2205: notification_rec ame_util2.notificationRecord;
2206: l_is_parallel varchar2(10) := null;
2207: original_forward_to_user wf_users.name%type;
2208: l_role_name wf_users.name%type;
2209:
2210: ntfidstartpos number := null;
2211: startpos number := null;
2204: l_current_forward_to_username wf_users.name%type;
2205: notification_rec ame_util2.notificationRecord;
2206: l_is_parallel varchar2(10) := null;
2207: original_forward_to_user wf_users.name%type;
2208: l_role_name wf_users.name%type;
2209:
2210: ntfidstartpos number := null;
2211: startpos number := null;
2212: endpos number := null;
2471: -- Variables required for AME API
2472: c_application_id integer;
2473: c_transaction_id varchar2(25);
2474: c_transaction_type varchar2(25);
2475: l_current_forward_to_username wf_users.name%type;
2476: l_curr_fwd_to_orig_system_id number;
2477: l_is_parallel varchar2(10) := null;
2478: c_next_approvers ame_util.approverstable2;
2479: c_approvalprocesscompleteynout varchar2(1) ;
2630: c_transaction_id varchar2(25);
2631: c_transaction_type varchar2(25);
2632: c_next_approvers ame_util.approverstable2;
2633: c_approvalprocesscompleteynout ame_util.charType;
2634: l_current_forward_to_username wf_users.name%type;
2635: l_is_parallel varchar2(10) := null;
2636:
2637: CURSOR c_get_users_from_role (p_role_name VARCHAR2) IS
2638: select *
2885: c_transaction_id varchar2(25);
2886: c_transaction_type varchar2(25);
2887: c_next_approvers ame_util.approverstable2;
2888: c_approvalprocesscompleteynout ame_util.charType;
2889: l_current_forward_to_username wf_users.name%type;
2890: lv_transaction_status varchar2(100);
2891: lv_approval_required varchar2(100);
2892: lv_result varchar2(100);
2893: lv_comments wf_item_attribute_values.text_value%type;
3004: c_transaction_id varchar2(25);
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
3053: c_transaction_id varchar2(25);
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
3149: c_transaction_id varchar2(25);
3150: c_transaction_type varchar2(25);
3151: c_next_approvers ame_util.approverstable2;
3152: c_approvalprocesscompleteynout ame_util.charType;
3153: l_current_forward_to_username wf_users.name%type;
3154: rec_forwardee ame_util.approverRecord2;
3155:
3156: l_new_fwd_person_id per_people_f.person_id%type;
3157: l_new_orig_system varchar2(30);
3324: c_transaction_id varchar2(25);
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;
3446: c_transaction_type varchar2(25);
3447: c_all_approvers ame_util.approverstable2;--ame_util.approversTable;
3448: c_approvalprocesscompleteynout ame_util.charType;
3449:
3450: c_creator_user wf_users.name%Type;
3451: c_return_user wf_users.name%Type;
3452: c_match_found varchar2(1);
3453: c_rfc_initiator varchar2(1);
3454: notification_rec ame_util2.notificationRecord;
3447: c_all_approvers ame_util.approverstable2;--ame_util.approversTable;
3448: c_approvalprocesscompleteynout ame_util.charType;
3449:
3450: c_creator_user wf_users.name%Type;
3451: c_return_user wf_users.name%Type;
3452: c_match_found varchar2(1);
3453: c_rfc_initiator varchar2(1);
3454: notification_rec ame_util2.notificationRecord;
3455: c_rfc_user wf_users.name%Type;
3451: c_return_user wf_users.name%Type;
3452: c_match_found varchar2(1);
3453: c_rfc_initiator varchar2(1);
3454: notification_rec ame_util2.notificationRecord;
3455: c_rfc_user wf_users.name%Type;
3456: l_is_parallel varchar2(10) := null;
3457:
3458: l_proc constant varchar2(100) := g_package || ' reset_ame_to_rfc_state';
3459: begin
3614: p_item_key in varchar2) is
3615:
3616: -- local variables
3617: c_proc constant varchar2(60) := 'reset_approval_rfc_data';
3618: c_return_user wf_users.name%Type;
3619: c_creator_user wf_users.name%Type;
3620: l_approvalProcessVersion varchar2(10);
3621: l_curr_approver_role wf_roles.name%type;
3622: c_return_user_role_info_tbl wf_directory.wf_local_roles_tbl_type;
3615:
3616: -- local variables
3617: c_proc constant varchar2(60) := 'reset_approval_rfc_data';
3618: c_return_user wf_users.name%Type;
3619: c_creator_user wf_users.name%Type;
3620: l_approvalProcessVersion varchar2(10);
3621: l_curr_approver_role wf_roles.name%type;
3622: c_return_user_role_info_tbl wf_directory.wf_local_roles_tbl_type;
3623: l_curr_approver_role_info_tbl wf_directory.wf_local_roles_tbl_type;
3841: c_transaction_id varchar2(25);
3842: c_transaction_type varchar2(25);
3843: c_next_approvers ame_util.approverstable2;
3844: c_approvalprocesscompleteynout ame_util.charType;
3845: l_current_forward_to_username wf_users.name%type;
3846: lv_creatorUserName wf_roles.name%type;
3847: lv_rfcUserName wf_roles.name%type;
3848: lv_customRFC varchar2(5);
3849:
4004: p_orig_system_id in number)
4005: return varchar2 is
4006: -- local variables
4007: c_proc constant varchar2(30) := 'processRFC';
4008: lv_role_displayName wf_users.display_name%type;
4009: lv_roleName wf_users.name%type;
4010: begin
4011: g_debug := hr_utility.debug_enabled;
4012: if g_debug then
4005: return varchar2 is
4006: -- local variables
4007: c_proc constant varchar2(30) := 'processRFC';
4008: lv_role_displayName wf_users.display_name%type;
4009: lv_roleName wf_users.name%type;
4010: begin
4011: g_debug := hr_utility.debug_enabled;
4012: if g_debug then
4013: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
4037: p_orig_system_id in number)
4038: return varchar2 is
4039: -- local variables
4040: c_proc constant varchar2(30) := 'isApproverEditAllowed';
4041: lv_role_displayName wf_users.display_name%type;
4042: lv_roleName wf_users.name%type;
4043: lv_businessGroupId per_all_people_f.business_group_id%type;
4044: lv_orig_systemId wf_roles.orig_system_id%type;
4045: lv_orig_system wf_roles.orig_system%type;
4038: return varchar2 is
4039: -- local variables
4040: c_proc constant varchar2(30) := 'isApproverEditAllowed';
4041: lv_role_displayName wf_users.display_name%type;
4042: lv_roleName wf_users.name%type;
4043: lv_businessGroupId per_all_people_f.business_group_id%type;
4044: lv_orig_systemId wf_roles.orig_system_id%type;
4045: lv_orig_system wf_roles.orig_system%type;
4046: lv_creator_person_id hr_api_transactions.creator_person_id%type;
4923: --
4924: l_item_type_attribute_name varchar2(30);
4925: type l_suffix_tab is table of varchar2(30) index by binary_integer;
4926: l_suffix l_suffix_tab;
4927: l_username wf_users.name%type;
4928: l_display_name wf_users.display_name%type;
4929: --
4930: begin
4931: if p_service_orig_sys_id is not null then
4924: l_item_type_attribute_name varchar2(30);
4925: type l_suffix_tab is table of varchar2(30) index by binary_integer;
4926: l_suffix l_suffix_tab;
4927: l_username wf_users.name%type;
4928: l_display_name wf_users.display_name%type;
4929: --
4930: begin
4931: if p_service_orig_sys_id is not null then
4932: l_suffix(1) := 'ID';
5883: p_item_key in wf_items.item_key%type,
5884: error_message_text in varchar2)
5885: is
5886:
5887: l_creator_disp_name wf_users.display_name%type;
5888: l_aprv_routing_username varchar2(60);
5889: lv_process_display_name wf_runnable_processes_v.display_name%type;
5890: c_application_id integer;
5891: c_transaction_id varchar2(25);
5889: lv_process_display_name wf_runnable_processes_v.display_name%type;
5890: c_application_id integer;
5891: c_transaction_id varchar2(25);
5892: c_transaction_type varchar2(25);
5893: l_forward_from_display_name wf_users.display_name%type;
5894: l_forward_to_display_name wf_users.display_name%type;
5895: c_approver_to_notify_rec ame_util.approverRecord2;
5896: lv_ntf_sub_msg wf_item_attribute_values.text_value%type;
5897:
5890: c_application_id integer;
5891: c_transaction_id varchar2(25);
5892: c_transaction_type varchar2(25);
5893: l_forward_from_display_name wf_users.display_name%type;
5894: l_forward_to_display_name wf_users.display_name%type;
5895: c_approver_to_notify_rec ame_util.approverRecord2;
5896: lv_ntf_sub_msg wf_item_attribute_values.text_value%type;
5897:
5898:
5982: c_transaction_id varchar2(25);
5983: c_transaction_type varchar2(50);
5984: c_next_approvers ame_util.approverstable2;
5985: c_approvalprocesscompleteynout ame_util.charType;
5986: l_current_forward_to_username wf_users.name%type;
5987: itemClass varchar2(100);
5988: itemId varchar2(100);
5989: actionTypeId number;
5990: groupOrChainId number;
5990: groupOrChainId number;
5991: occurrence number;
5992: notification_rec ame_util2.notificationRecord;
5993: l_trans_ref_table hr_api_transactions.transaction_ref_Table%type;
5994: l_current_forward_to_username1 wf_users.name%type;
5995:
5996: l_is_parallel varchar2(10) := null;
5997: original_forward_to_user wf_users.name%type;
5998: l_role_name wf_users.name%type;
5993: l_trans_ref_table hr_api_transactions.transaction_ref_Table%type;
5994: l_current_forward_to_username1 wf_users.name%type;
5995:
5996: l_is_parallel varchar2(10) := null;
5997: original_forward_to_user wf_users.name%type;
5998: l_role_name wf_users.name%type;
5999:
6000: ntfidstartpos number := null;
6001: startpos number := null;
5994: l_current_forward_to_username1 wf_users.name%type;
5995:
5996: l_is_parallel varchar2(10) := null;
5997: original_forward_to_user wf_users.name%type;
5998: l_role_name wf_users.name%type;
5999:
6000: ntfidstartpos number := null;
6001: startpos number := null;
6002: endpos number := null;