eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_APPROVAL_SS dependencies on WF_ITEMS

Line 126: function getOAFPageActId(p_item_type in wf_items.item_type%type,

122: hr_approval_custom.g_itemkey := p_itemkey;
123: hr_utility.set_location('Leaving: '|| l_proc,10);
124: END set_custom_wf_globals;
125:
126: function getOAFPageActId(p_item_type in wf_items.item_type%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';

Line 127: p_item_key in wf_items.item_key%type) return number

123: hr_utility.set_location('Leaving: '|| l_proc,10);
124: END set_custom_wf_globals;
125:
126: function getOAFPageActId(p_item_type in wf_items.item_type%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;

Line 152: WF_ITEMS WI

148: select wpa.instance_id
149: FROM WF_PROCESS_ACTIVITIES WPA,
150: WF_ACTIVITY_ATTRIBUTES WAA,
151: WF_ACTIVITIES WA,
152: WF_ITEMS WI
153: WHERE wpa.process_item_type = ias.item_type
154: and wa.item_type = wpa.process_item_type
155: and wa.name = wpa.activity_name
156: and wi.item_type = ias.item_type

Line 1617: procedure forwardToRoleReInit(p_item_type in wf_items.item_type%type,

1613: when others then
1614: raise;
1615: end updateApprovalHistory;
1616:
1617: procedure forwardToRoleReInit(p_item_type in wf_items.item_type%type,
1618: p_item_key in wf_items.item_key%type) is
1619: lv_role_name wf_roles.name%type;
1620: lv_role_disp_name wf_roles.name%type;
1621: lv_role_orig_system wf_roles.orig_system%type;

Line 1618: p_item_key in wf_items.item_key%type) is

1614: raise;
1615: end updateApprovalHistory;
1616:
1617: procedure forwardToRoleReInit(p_item_type in wf_items.item_type%type,
1618: p_item_key in wf_items.item_key%type) is
1619: lv_role_name wf_roles.name%type;
1620: lv_role_disp_name wf_roles.name%type;
1621: lv_role_orig_system wf_roles.orig_system%type;
1622: lv_role_orig_sys_id wf_roles.orig_system_id%type;

Line 3163: p_item_type in wf_items.item_type%type,

3159:
3160:
3161: procedure handleRFCAction(p_approval_notification_id in wf_notifications.notification_id%type,
3162: p_transaction_id in hr_api_transactions.transaction_id%type,
3163: p_item_type in wf_items.item_type%type,
3164: p_item_key in wf_items.item_key%type,
3165: p_rfcRoleName in wf_roles.name%type,
3166: p_rfcUserOrigSystem in wf_roles.orig_system%type,
3167: p_rfcUserOrigSystemId in wf_roles.orig_system_id%type,

Line 3164: p_item_key in wf_items.item_key%type,

3160:
3161: procedure handleRFCAction(p_approval_notification_id in wf_notifications.notification_id%type,
3162: p_transaction_id in hr_api_transactions.transaction_id%type,
3163: p_item_type in wf_items.item_type%type,
3164: p_item_key in wf_items.item_key%type,
3165: p_rfcRoleName in wf_roles.name%type,
3166: p_rfcUserOrigSystem in wf_roles.orig_system%type,
3167: p_rfcUserOrigSystemId in wf_roles.orig_system_id%type,
3168: p_rfc_comments in varchar2,

Line 3442: lv_item_type wf_items.item_type%type;

3438: end handleRFCAction;
3439:
3440: procedure handleRFCAction(p_approval_notification_id in wf_notifications.notification_id%type
3441: ) is
3442: lv_item_type wf_items.item_type%type;
3443: lv_item_key wf_items.item_key%type;
3444: lv_creator_role wf_roles.name%type;
3445: lv_creator_orig_system wf_roles.orig_system%type;
3446: lv_creator_orig_sys_id wf_roles.orig_system_id%type;

Line 3443: lv_item_key wf_items.item_key%type;

3439:
3440: procedure handleRFCAction(p_approval_notification_id in wf_notifications.notification_id%type
3441: ) is
3442: lv_item_type wf_items.item_type%type;
3443: lv_item_key wf_items.item_key%type;
3444: lv_creator_role wf_roles.name%type;
3445: lv_creator_orig_system wf_roles.orig_system%type;
3446: lv_creator_orig_sys_id wf_roles.orig_system_id%type;
3447: begin

Line 3487: procedure creatorRoleReInit(p_item_type in wf_items.item_type%type,

3483: );
3484:
3485: end handleRFCAction;
3486:
3487: procedure creatorRoleReInit(p_item_type in wf_items.item_type%type,
3488: p_item_key in wf_items.item_key%type) is
3489: lv_role_name wf_roles.name%type;
3490: lv_role_disp_name wf_roles.name%type;
3491: lv_role_orig_system wf_roles.orig_system%type;

Line 3488: p_item_key in wf_items.item_key%type) is

3484:
3485: end handleRFCAction;
3486:
3487: procedure creatorRoleReInit(p_item_type in wf_items.item_type%type,
3488: p_item_key in wf_items.item_key%type) is
3489: lv_role_name wf_roles.name%type;
3490: lv_role_disp_name wf_roles.name%type;
3491: lv_role_orig_system wf_roles.orig_system%type;
3492: lv_role_orig_sys_id wf_roles.orig_system_id%type;

Line 3531: procedure selPersonRoleReInit(p_item_type in wf_items.item_type%type,

3527:
3528: end creatorRoleReInit;
3529:
3530:
3531: procedure selPersonRoleReInit(p_item_type in wf_items.item_type%type,
3532: p_item_key in wf_items.item_key%type) is
3533: lv_role_name wf_roles.name%type;
3534: lv_role_disp_name wf_roles.name%type;
3535: lv_role_orig_system wf_roles.orig_system%type;

Line 3532: p_item_key in wf_items.item_key%type) is

3528: end creatorRoleReInit;
3529:
3530:
3531: procedure selPersonRoleReInit(p_item_type in wf_items.item_type%type,
3532: p_item_key in wf_items.item_key%type) is
3533: lv_role_name wf_roles.name%type;
3534: lv_role_disp_name wf_roles.name%type;
3535: lv_role_orig_system wf_roles.orig_system%type;
3536: lv_role_orig_sys_id wf_roles.orig_system_id%type;

Line 3563: procedure forwardFromRoleReInit(p_item_type in wf_items.item_type%type,

3559: end if;
3560:
3561: end selPersonRoleReInit;
3562:
3563: procedure forwardFromRoleReInit(p_item_type in wf_items.item_type%type,
3564: p_item_key in wf_items.item_key%type) is
3565: lv_role_name wf_roles.name%type;
3566: lv_role_disp_name wf_roles.name%type;
3567: lv_role_orig_system wf_roles.orig_system%type;

Line 3564: p_item_key in wf_items.item_key%type) is

3560:
3561: end selPersonRoleReInit;
3562:
3563: procedure forwardFromRoleReInit(p_item_type in wf_items.item_type%type,
3564: p_item_key in wf_items.item_key%type) is
3565: lv_role_name wf_roles.name%type;
3566: lv_role_disp_name wf_roles.name%type;
3567: lv_role_orig_system wf_roles.orig_system%type;
3568: lv_role_orig_sys_id wf_roles.orig_system_id%type;

Line 3601: procedure rfcUserRoleReInit(p_item_type in wf_items.item_type%type,

3597:
3598: end forwardFromRoleReInit;
3599:
3600:
3601: procedure rfcUserRoleReInit(p_item_type in wf_items.item_type%type,
3602: p_item_key in wf_items.item_key%type) is
3603: lv_role_name wf_roles.name%type;
3604: lv_role_disp_name wf_roles.name%type;
3605: lv_role_orig_system wf_roles.orig_system%type;

Line 3602: p_item_key in wf_items.item_key%type) is

3598: end forwardFromRoleReInit;
3599:
3600:
3601: procedure rfcUserRoleReInit(p_item_type in wf_items.item_type%type,
3602: p_item_key in wf_items.item_key%type) is
3603: lv_role_name wf_roles.name%type;
3604: lv_role_disp_name wf_roles.name%type;
3605: lv_role_orig_system wf_roles.orig_system%type;
3606: lv_role_orig_sys_id wf_roles.orig_system_id%type;

Line 3639: procedure appraisalRolesReInit(p_item_type in wf_items.item_type%type,

3635:
3636: end rfcUserRoleReInit;
3637:
3638:
3639: procedure appraisalRolesReInit(p_item_type in wf_items.item_type%type,
3640: p_item_key in wf_items.item_key%type) is
3641: lv_role_name wf_roles.name%type;
3642: lv_role_disp_name wf_roles.name%type;
3643: lv_role_orig_system wf_roles.orig_system%type;

Line 3640: p_item_key in wf_items.item_key%type) is

3636: end rfcUserRoleReInit;
3637:
3638:
3639: procedure appraisalRolesReInit(p_item_type in wf_items.item_type%type,
3640: p_item_key in wf_items.item_key%type) is
3641: lv_role_name wf_roles.name%type;
3642: lv_role_disp_name wf_roles.name%type;
3643: lv_role_orig_system wf_roles.orig_system%type;
3644: lv_role_orig_sys_id wf_roles.orig_system_id%type;

Line 3734: p_item_type in wf_items.item_type%type,

3730:
3731:
3732: procedure reInitPerformerRoles(p_notification_id in wf_notifications.notification_id%type,
3733: p_transaction_id in hr_api_transactions.transaction_id%type,
3734: p_item_type in wf_items.item_type%type,
3735: p_item_key in wf_items.item_key%type) is
3736: c_proc constant varchar2(30) := 'reInitPerformerRoles';
3737: lv_item_type wf_items.item_type%type;
3738: lv_item_key wf_items.item_key%type;

Line 3735: p_item_key in wf_items.item_key%type) is

3731:
3732: procedure reInitPerformerRoles(p_notification_id in wf_notifications.notification_id%type,
3733: p_transaction_id in hr_api_transactions.transaction_id%type,
3734: p_item_type in wf_items.item_type%type,
3735: p_item_key in wf_items.item_key%type) is
3736: c_proc constant varchar2(30) := 'reInitPerformerRoles';
3737: lv_item_type wf_items.item_type%type;
3738: lv_item_key wf_items.item_key%type;
3739:

Line 3737: lv_item_type wf_items.item_type%type;

3733: p_transaction_id in hr_api_transactions.transaction_id%type,
3734: p_item_type in wf_items.item_type%type,
3735: p_item_key in wf_items.item_key%type) is
3736: c_proc constant varchar2(30) := 'reInitPerformerRoles';
3737: lv_item_type wf_items.item_type%type;
3738: lv_item_key wf_items.item_key%type;
3739:
3740: begin
3741: g_debug := hr_utility.debug_enabled;

Line 3738: lv_item_key wf_items.item_key%type;

3734: p_item_type in wf_items.item_type%type,
3735: p_item_key in wf_items.item_key%type) is
3736: c_proc constant varchar2(30) := 'reInitPerformerRoles';
3737: lv_item_type wf_items.item_type%type;
3738: lv_item_key wf_items.item_key%type;
3739:
3740: begin
3741: g_debug := hr_utility.debug_enabled;
3742: if g_debug then

Line 3846: (p_item_type in wf_items.item_type%type

3842: -- ----------------------------------------------------------------------------
3843: -- |--------------------< wf_get_runnable_process_name >----------------------|
3844: -- ----------------------------------------------------------------------------
3845: function wf_get_runnable_process_name
3846: (p_item_type in wf_items.item_type%type
3847: ,p_process_name in wf_process_activities.process_name%type)
3848: return wf_runnable_processes_v.display_name%type is
3849: -- cursor determines is the specified process is runnable
3850: cursor csr_wrpv is

Line 3873: (p_item_type in wf_items.item_type%type

3869: -- ----------------------------------------------------------------------------
3870: -- |-------------------------< wf_process_runnable >--------------------------|
3871: -- ----------------------------------------------------------------------------
3872: function wf_process_runnable
3873: (p_item_type in wf_items.item_type%type
3874: ,p_process_name in wf_process_activities.process_name%type)
3875: return boolean is
3876: --
3877: begin

Line 3891: (p_item_type in wf_items.item_type%type

3887: -- ----------------------------------------------------------------------------
3888: -- |------------------------< create_hr_directory_services >------------------|
3889: -- ----------------------------------------------------------------------------
3890: procedure create_hr_directory_services
3891: (p_item_type in wf_items.item_type%type
3892: ,p_item_key in wf_items.item_key%type
3893: ,p_service_name in varchar2
3894: ,p_service_orig_sys_id in number
3895: ,p_service_orig_sys in varchar2) is

Line 3892: ,p_item_key in wf_items.item_key%type

3888: -- |------------------------< create_hr_directory_services >------------------|
3889: -- ----------------------------------------------------------------------------
3890: procedure create_hr_directory_services
3891: (p_item_type in wf_items.item_type%type
3892: ,p_item_key in wf_items.item_key%type
3893: ,p_service_name in varchar2
3894: ,p_service_orig_sys_id in number
3895: ,p_service_orig_sys in varchar2) is
3896: --

Line 4004: ,p_item_key in out nocopy wf_items.item_key%type

4000: --
4001: END getPersonNameFromID;
4002:
4003: procedure startGenericApprovalProcess(p_transaction_id in number
4004: ,p_item_key in out nocopy wf_items.item_key%type
4005: ,p_wf_ntf_sub_fnd_msg in fnd_new_messages.message_name%type
4006: ,p_relaunch_function hr_api_transactions.relaunch_function%type
4007: ,p_additional_wf_attributes in HR_WF_ATTR_TABLE
4008: ,p_status out nocopy varchar2

Line 4014: lv_item_type wf_items.item_type%type;

4010: ,p_errstack out nocopy varchar2
4011: )
4012: is
4013: c_proc constant varchar2(30) := 'reInitPerformerRoles';
4014: lv_item_type wf_items.item_type%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);

Line 4015: lv_item_key wf_items.item_key%type;

4011: )
4012: is
4013: c_proc constant varchar2(30) := 'reInitPerformerRoles';
4014: lv_item_type wf_items.item_type%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;

Line 4629: lv_item_type wf_items.item_type%type;

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;
4630: lv_item_key wf_items.item_key%type;
4631: lv_oaf_nav_attr wf_item_attribute_values.text_value%type;
4632: begin
4633: if g_debug then

Line 4630: lv_item_key wf_items.item_key%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;
4630: lv_item_key wf_items.item_key%type;
4631: lv_oaf_nav_attr wf_item_attribute_values.text_value%type;
4632: begin
4633: if g_debug then
4634: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);

Line 4834: procedure handleApprovalErrors(p_item_type in wf_items.item_type%type,

4830: when others then
4831: raise;
4832: end checktransactionState;
4833:
4834: procedure handleApprovalErrors(p_item_type in wf_items.item_type%type,
4835: p_item_key in wf_items.item_key%type,
4836: error_message_text in varchar2)
4837: is
4838:

Line 4835: p_item_key in wf_items.item_key%type,

4831: raise;
4832: end checktransactionState;
4833:
4834: procedure handleApprovalErrors(p_item_type in wf_items.item_type%type,
4835: p_item_key in wf_items.item_key%type,
4836: error_message_text in varchar2)
4837: is
4838:
4839: l_creator_disp_name wf_users.display_name%type;