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 HR_API_TRANSACTIONS

Line 3035: lv_creator_person_id hr_api_transactions.creator_person_id%type;

3031: lv_roleName wf_users.name%type;
3032: lv_businessGroupId per_all_people_f.business_group_id%type;
3033: lv_orig_systemId wf_roles.orig_system_id%type;
3034: lv_orig_system wf_roles.orig_system%type;
3035: lv_creator_person_id hr_api_transactions.creator_person_id%type;
3036: begin
3037: g_debug := hr_utility.debug_enabled;
3038: if g_debug then
3039: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);

Line 3058: from hr_api_transactions

3054: -- check the case for creator person id
3055: begin
3056: select creator_person_id
3057: into lv_creator_person_id
3058: from hr_api_transactions
3059: where transaction_id=p_transaction_id;
3060:
3061: if(lv_creator_person_id=lv_orig_systemId) then
3062: return 'Y';

Line 3162: p_transaction_id in hr_api_transactions.transaction_id%type,

3158: end getUserOrigSystemId;
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,

Line 3733: p_transaction_id in hr_api_transactions.transaction_id%type,

3729: end appraisalRolesReInit;
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;

Line 3763: from hr_api_transactions

3759: elsif(p_transaction_id is not null) then
3760: begin
3761: select item_type,item_key
3762: into lv_item_type,lv_item_key
3763: from hr_api_transactions
3764: where transaction_id=p_transaction_id;
3765: exception
3766: when others then
3767: null;

Line 4006: ,p_relaunch_function hr_api_transactions.relaunch_function%type

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
4009: ,p_error_message out nocopy varchar2
4010: ,p_errstack out nocopy varchar2

Line 4016: lr_transaction_rec hr_api_transactions%rowtype;

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;
4020: lv_errname VARCHAR2(4000);

Line 4039: from hr_api_transactions

4035: -- block to get the transaction record details
4036: begin
4037: select *
4038: into lr_transaction_rec
4039: from hr_api_transactions
4040: where transaction_id=p_transaction_id;
4041: exception
4042: when no_data_found then
4043: raise;

Line 4294: lr_hr_api_transaction_rec hr_api_transactions%rowtype;

4290: function getinitApprovalBlockId(p_transaction_id in number) return number
4291: is
4292:
4293: c_proc constant varchar2(30) := 'getinitApprovalBlockId';
4294: lr_hr_api_transaction_rec hr_api_transactions%rowtype;
4295: ln_activity_id number;
4296: lv_loginPersonDispName per_all_people_f.full_name%type;
4297: lv_loginPersonUserName fnd_user.user_name%type;
4298: ln_loginPersonId fnd_user.employee_id%type;

Line 4302: from hr_api_transactions

4298: ln_loginPersonId fnd_user.employee_id%type;
4299: begin
4300: if(p_transaction_id is not null) then
4301: select * into lr_hr_api_transaction_rec
4302: from hr_api_transactions
4303: where transaction_id=p_transaction_id;
4304: if(lr_hr_api_transaction_rec.transaction_ref_table='PER_APPRAISALS') then
4305: -- appraisal specfic
4306:

Line 4348: lr_hr_api_transaction_rec hr_api_transactions%rowtype;

4344:
4345: function getApproverNtfId(p_transaction_id in number) return number
4346: is
4347: c_proc constant varchar2(30) := 'getApproverNtfId';
4348: lr_hr_api_transaction_rec hr_api_transactions%rowtype;
4349: ln_notification_id wf_notifications.notification_id%type;
4350: begin
4351: if(p_transaction_id is not null) then
4352: select * into lr_hr_api_transaction_rec

Line 4353: from hr_api_transactions

4349: ln_notification_id wf_notifications.notification_id%type;
4350: begin
4351: if(p_transaction_id is not null) then
4352: select * into lr_hr_api_transaction_rec
4353: from hr_api_transactions
4354: where transaction_id=p_transaction_id;
4355:
4356: select notification_id
4357: into ln_notification_id

Line 4379: lr_hr_api_transaction_rec hr_api_transactions%rowtype;

4375: p_approval_comments in varchar2)
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);

Line 4389: from hr_api_transactions

4385:
4386: if(p_transaction_id is not null) then
4387:
4388: select * into lr_hr_api_transaction_rec
4389: from hr_api_transactions
4390: where transaction_id=p_transaction_id;
4391:
4392: hr_transaction_api.update_transaction(
4393: p_transaction_id => p_transaction_id,

Line 4491: lr_hr_api_transaction_rec hr_api_transactions%rowtype;

4487: p_approval_comments in varchar2)
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;

Line 4506: from hr_api_transactions

4502:
4503: if(p_transaction_id is not null) then
4504:
4505: select * into lr_hr_api_transaction_rec
4506: from hr_api_transactions
4507: where transaction_id=p_transaction_id;
4508:
4509: hr_transaction_api.update_transaction(
4510: p_transaction_id => p_transaction_id,

Line 4624: lr_hr_api_transaction_rec hr_api_transactions%rowtype;

4620: p_approval_comments in varchar2)
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;

Line 4644: from hr_api_transactions

4640:
4641: begin
4642: select item_type,item_key
4643: into lv_item_type,lv_item_key
4644: from hr_api_transactions
4645: where transaction_id=p_transaction_id;
4646: exception
4647: when no_data_found then
4648: -- get the fnd message and populate to the fnd message pub

Line 4715: lr_hr_api_transaction_rec hr_api_transactions%rowtype;

4711: end processApprovalSubmit;
4712:
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

Line 4724: from hr_api_transactions

4720:
4721: if(p_transaction_id is not null) then
4722: begin
4723: select * into lr_hr_api_transaction_rec
4724: from hr_api_transactions
4725: where transaction_id=p_transaction_id;
4726: exception
4727: when others then
4728: null;

Line 4787: lv_status hr_api_transactions.status%type;

4783:
4784: is
4785: -- local variables
4786: c_proc constant varchar2(40) := 'checktransactionState';
4787: lv_status hr_api_transactions.status%type;
4788: lv_state hr_api_transactions.transaction_state%type;
4789: begin
4790: if g_debug then
4791: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);

Line 4788: lv_state hr_api_transactions.transaction_state%type;

4784: is
4785: -- local variables
4786: c_proc constant varchar2(40) := 'checktransactionState';
4787: lv_status hr_api_transactions.status%type;
4788: lv_state hr_api_transactions.transaction_state%type;
4789: begin
4790: if g_debug then
4791: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
4792: end if;

Line 4798: from hr_api_transactions

4794:
4795: begin
4796: select status,transaction_state
4797: into lv_status,lv_state
4798: from hr_api_transactions
4799: where transaction_id=p_transaction_id;
4800:
4801: -- check the transaction status
4802: if(lv_status in ('YS','RIS','ROS')) then