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.GHR_WF_PKG dependencies on GHR_PA_ROUTING_HISTORY

Line 240: SELECT user_name from ghr_pa_routing_history

236: --
237: --
238: --
239: cursor csr_get_approver_name is
240: SELECT user_name from ghr_pa_routing_history
241: where pa_request_id = itemkey
242: and approval_status = 'APPROVE'
243: order by pa_routing_history_id desc;
244: --

Line 246: SELECT user_name from ghr_pa_routing_history

242: and approval_status = 'APPROVE'
243: order by pa_routing_history_id desc;
244: --
245: cursor csr_get_upd_hr_user_name is
246: SELECT user_name from ghr_pa_routing_history
247: where pa_request_id = itemkey
248: and action_taken in ('UPDATE_HR_COMPLETE','ENDED')
249: order by pa_routing_history_id desc;
250: --

Line 251: l_approver_name ghr_pa_routing_history.user_name%TYPE;

247: where pa_request_id = itemkey
248: and action_taken in ('UPDATE_HR_COMPLETE','ENDED')
249: order by pa_routing_history_id desc;
250: --
251: l_approver_name ghr_pa_routing_history.user_name%TYPE;
252: l_upd_hr_user_name ghr_pa_routing_history.user_name%TYPE;
253: l_line3 varchar2(500);
254: l_load_form varchar2(200); --Bug# 7312949
255: l_result varchar2(4000);

Line 252: l_upd_hr_user_name ghr_pa_routing_history.user_name%TYPE;

248: and action_taken in ('UPDATE_HR_COMPLETE','ENDED')
249: order by pa_routing_history_id desc;
250: --
251: l_approver_name ghr_pa_routing_history.user_name%TYPE;
252: l_upd_hr_user_name ghr_pa_routing_history.user_name%TYPE;
253: l_line3 varchar2(500);
254: l_load_form varchar2(200); --Bug# 7312949
255: l_result varchar2(4000);
256: --

Line 364: l_approver_name ghr_pa_routing_history.user_name%TYPE;

360: funcmode in varchar2,
361: result in out nocopy varchar2) is
362: --
363: --
364: l_approver_name ghr_pa_routing_history.user_name%TYPE;
365: l_upd_hr_user_name ghr_pa_routing_history.user_name%TYPE;
366: --
367: l_result varchar2(4000);
368: begin

Line 365: l_upd_hr_user_name ghr_pa_routing_history.user_name%TYPE;

361: result in out nocopy varchar2) is
362: --
363: --
364: l_approver_name ghr_pa_routing_history.user_name%TYPE;
365: l_upd_hr_user_name ghr_pa_routing_history.user_name%TYPE;
366: --
367: l_result varchar2(4000);
368: begin
369: l_result := result;

Line 436: l_user_name ghr_pa_routing_history.user_name%TYPE;

432: funcmode in varchar2,
433: result in out nocopy varchar2 ) is
434: --
435: --
436: l_user_name ghr_pa_routing_history.user_name%TYPE;
437: l_action_taken ghr_pa_routing_history.action_taken%TYPE;
438: l_groupbox_name ghr_groupboxes.name%TYPE;
439: l_subject varchar2(500);
440: l_line1 varchar2(500);

Line 437: l_action_taken ghr_pa_routing_history.action_taken%TYPE;

433: result in out nocopy varchar2 ) is
434: --
435: --
436: l_user_name ghr_pa_routing_history.user_name%TYPE;
437: l_action_taken ghr_pa_routing_history.action_taken%TYPE;
438: l_groupbox_name ghr_groupboxes.name%TYPE;
439: l_subject varchar2(500);
440: l_line1 varchar2(500);
441: l_line2 varchar2(500);

Line 611: l_pa_routing_history_id ghr_pa_routing_history.pa_routing_history_id%TYPE;

607: p_groupbox_name OUT nocopy varchar2
608: ) IS
609:
610: -- Local variables
611: l_pa_routing_history_id ghr_pa_routing_history.pa_routing_history_id%TYPE;
612: l_user_name ghr_pa_routing_history.user_name%TYPE;
613: l_groupbox_id ghr_pa_routing_history.groupbox_id%TYPE;
614: l_action_taken ghr_pa_routing_history.action_taken%TYPE;
615: l_groupbox_name ghr_groupboxes.name%TYPE;

Line 612: l_user_name ghr_pa_routing_history.user_name%TYPE;

608: ) IS
609:
610: -- Local variables
611: l_pa_routing_history_id ghr_pa_routing_history.pa_routing_history_id%TYPE;
612: l_user_name ghr_pa_routing_history.user_name%TYPE;
613: l_groupbox_id ghr_pa_routing_history.groupbox_id%TYPE;
614: l_action_taken ghr_pa_routing_history.action_taken%TYPE;
615: l_groupbox_name ghr_groupboxes.name%TYPE;
616: --

Line 613: l_groupbox_id ghr_pa_routing_history.groupbox_id%TYPE;

609:
610: -- Local variables
611: l_pa_routing_history_id ghr_pa_routing_history.pa_routing_history_id%TYPE;
612: l_user_name ghr_pa_routing_history.user_name%TYPE;
613: l_groupbox_id ghr_pa_routing_history.groupbox_id%TYPE;
614: l_action_taken ghr_pa_routing_history.action_taken%TYPE;
615: l_groupbox_name ghr_groupboxes.name%TYPE;
616: --
617: --

Line 614: l_action_taken ghr_pa_routing_history.action_taken%TYPE;

610: -- Local variables
611: l_pa_routing_history_id ghr_pa_routing_history.pa_routing_history_id%TYPE;
612: l_user_name ghr_pa_routing_history.user_name%TYPE;
613: l_groupbox_id ghr_pa_routing_history.groupbox_id%TYPE;
614: l_action_taken ghr_pa_routing_history.action_taken%TYPE;
615: l_groupbox_name ghr_groupboxes.name%TYPE;
616: --
617: --
618: cursor csr_pa_routing_history is

Line 620: FROM ghr_pa_routing_history

616: --
617: --
618: cursor csr_pa_routing_history is
619: SELECT max(pa_routing_history_id)
620: FROM ghr_pa_routing_history
621: WHERE pa_request_id = p_pa_request_id;
622: --
623: cursor csr_pah_details is
624: SELECT action_taken, user_name, groupbox_id

Line 625: FROM ghr_pa_routing_history

621: WHERE pa_request_id = p_pa_request_id;
622: --
623: cursor csr_pah_details is
624: SELECT action_taken, user_name, groupbox_id
625: FROM ghr_pa_routing_history
626: WHERE pa_routing_history_id = l_pa_routing_history_id;
627: --
628: cursor csr_gbx_details is
629: SELECT name

Line 744: l_action_taken1 ghr_pa_routing_history.action_taken%TYPE;

740: l_to_organization_name hr_organization_units.name%TYPE;
741: l_from_organization_name hr_organization_units.name%TYPE;
742: l_noa_fam_desc ghr_families.name%TYPE;
743: l_error_msg varchar2(1200);
744: l_action_taken1 ghr_pa_routing_history.action_taken%TYPE;
745: l_creation_date ghr_pa_routing_history.creation_date%TYPE;
746: l_date_notification_sent ghr_pa_routing_history.date_notification_sent%TYPE;
747: l_from_position_id ghr_pa_requests.from_position_id%TYPE;
748: l_to_position_id ghr_pa_requests.to_position_id%TYPE;

Line 745: l_creation_date ghr_pa_routing_history.creation_date%TYPE;

741: l_from_organization_name hr_organization_units.name%TYPE;
742: l_noa_fam_desc ghr_families.name%TYPE;
743: l_error_msg varchar2(1200);
744: l_action_taken1 ghr_pa_routing_history.action_taken%TYPE;
745: l_creation_date ghr_pa_routing_history.creation_date%TYPE;
746: l_date_notification_sent ghr_pa_routing_history.date_notification_sent%TYPE;
747: l_from_position_id ghr_pa_requests.from_position_id%TYPE;
748: l_to_position_id ghr_pa_requests.to_position_id%TYPE;
749: --

Line 746: l_date_notification_sent ghr_pa_routing_history.date_notification_sent%TYPE;

742: l_noa_fam_desc ghr_families.name%TYPE;
743: l_error_msg varchar2(1200);
744: l_action_taken1 ghr_pa_routing_history.action_taken%TYPE;
745: l_creation_date ghr_pa_routing_history.creation_date%TYPE;
746: l_date_notification_sent ghr_pa_routing_history.date_notification_sent%TYPE;
747: l_from_position_id ghr_pa_requests.from_position_id%TYPE;
748: l_to_position_id ghr_pa_requests.to_position_id%TYPE;
749: --
750: l_personnel_office_id ghr_pa_requests.personnel_office_id%TYPE;

Line 780: SELECT action_taken from ghr_pa_routing_history

776: FROM hr_organization_units
777: WHERE organization_id = l_to_organization_id ;
778: --
779: cursor csr_get_routing_details is
780: SELECT action_taken from ghr_pa_routing_history
781: where pa_request_id = p_pa_request_id
782: order by pa_routing_history_id desc;
783: --
784: cursor csr_get_initiated_date is

Line 785: SELECT date_notification_sent, creation_date FROM ghr_pa_routing_history

781: where pa_request_id = p_pa_request_id
782: order by pa_routing_history_id desc;
783: --
784: cursor csr_get_initiated_date is
785: SELECT date_notification_sent, creation_date FROM ghr_pa_routing_history
786: WHERE pa_request_id = p_pa_request_id
787: order by 1 asc;
788: --
789: cursor csr_from_org_details is

Line 1136: l_action_taken ghr_pa_routing_history.action_taken%TYPE;

1132: actid in number,
1133: funcmode in varchar2,
1134: result in out nocopy varchar2) is
1135: --
1136: l_action_taken ghr_pa_routing_history.action_taken%TYPE;
1137: l_load_form varchar2(200);--Bug# 7312949
1138: --
1139: cursor csr_parh is
1140: SELECT action_taken

Line 1141: FROM ghr_pa_routing_history

1137: l_load_form varchar2(200);--Bug# 7312949
1138: --
1139: cursor csr_parh is
1140: SELECT action_taken
1141: FROM ghr_pa_routing_history
1142: WHERE pa_request_id = itemkey
1143: order by pa_routing_history_id desc;
1144: --
1145:

Line 1334: l_forward_to_name ghr_pa_routing_history.user_name%TYPE;

1330: result in out nocopy varchar2) is
1331: --
1332: --
1333: --BUG #13655849 increased the size of user_name
1334: l_forward_to_name ghr_pa_routing_history.user_name%TYPE;
1335: l_user_name ghr_pa_routing_history.user_name%TYPE;
1336: l_prh_rec ghr_pa_routing_history%rowtype := NULL;
1337: l_routing_group_id ghr_routing_groups.routing_group_id%type;
1338: l_effective_date ghr_pa_requests.effective_date%type;

Line 1335: l_user_name ghr_pa_routing_history.user_name%TYPE;

1331: --
1332: --
1333: --BUG #13655849 increased the size of user_name
1334: l_forward_to_name ghr_pa_routing_history.user_name%TYPE;
1335: l_user_name ghr_pa_routing_history.user_name%TYPE;
1336: l_prh_rec ghr_pa_routing_history%rowtype := NULL;
1337: l_routing_group_id ghr_routing_groups.routing_group_id%type;
1338: l_effective_date ghr_pa_requests.effective_date%type;
1339: l_first_noa_id ghr_pa_requests.first_noa_id%type;

Line 1336: l_prh_rec ghr_pa_routing_history%rowtype := NULL;

1332: --
1333: --BUG #13655849 increased the size of user_name
1334: l_forward_to_name ghr_pa_routing_history.user_name%TYPE;
1335: l_user_name ghr_pa_routing_history.user_name%TYPE;
1336: l_prh_rec ghr_pa_routing_history%rowtype := NULL;
1337: l_routing_group_id ghr_routing_groups.routing_group_id%type;
1338: l_effective_date ghr_pa_requests.effective_date%type;
1339: l_first_noa_id ghr_pa_requests.first_noa_id%type;
1340: l_second_noa_id ghr_pa_requests.second_noa_id%type;

Line 1413: from ghr_pa_routing_history prh

1409:
1410: Cursor C_routing_history_id is
1411: select prh.pa_routing_history_id,
1412: prh.object_version_number
1413: from ghr_pa_routing_history prh
1414: where prh.pa_request_id = itemkey
1415: order by prh.pa_routing_history_id desc;
1416:
1417: Cursor get_par

Line 1426: l_initiator_flag ghr_pa_routing_history.initiator_flag%TYPE := NULL;

1422: where pa_request_id = itemkey;
1423:
1424: l_valid_user varchar2(1) := 'N';
1425: l_gbx_user_id ghr_groupbox_users.groupbox_user_id%type;
1426: l_initiator_flag ghr_pa_routing_history.initiator_flag%TYPE := NULL;
1427: l_requester_flag ghr_pa_routing_history.requester_flag%TYPE;
1428: l_reviewer_flag ghr_pa_routing_history.reviewer_flag%TYPE;
1429: l_authorizer_flag ghr_pa_routing_history.authorizer_flag%TYPE;
1430: l_approver_flag ghr_pa_routing_history.approver_flag%TYPE;

Line 1427: l_requester_flag ghr_pa_routing_history.requester_flag%TYPE;

1423:
1424: l_valid_user varchar2(1) := 'N';
1425: l_gbx_user_id ghr_groupbox_users.groupbox_user_id%type;
1426: l_initiator_flag ghr_pa_routing_history.initiator_flag%TYPE := NULL;
1427: l_requester_flag ghr_pa_routing_history.requester_flag%TYPE;
1428: l_reviewer_flag ghr_pa_routing_history.reviewer_flag%TYPE;
1429: l_authorizer_flag ghr_pa_routing_history.authorizer_flag%TYPE;
1430: l_approver_flag ghr_pa_routing_history.approver_flag%TYPE;
1431: l_approved_flag ghr_pa_routing_history.approved_flag%TYPE;

Line 1428: l_reviewer_flag ghr_pa_routing_history.reviewer_flag%TYPE;

1424: l_valid_user varchar2(1) := 'N';
1425: l_gbx_user_id ghr_groupbox_users.groupbox_user_id%type;
1426: l_initiator_flag ghr_pa_routing_history.initiator_flag%TYPE := NULL;
1427: l_requester_flag ghr_pa_routing_history.requester_flag%TYPE;
1428: l_reviewer_flag ghr_pa_routing_history.reviewer_flag%TYPE;
1429: l_authorizer_flag ghr_pa_routing_history.authorizer_flag%TYPE;
1430: l_approver_flag ghr_pa_routing_history.approver_flag%TYPE;
1431: l_approved_flag ghr_pa_routing_history.approved_flag%TYPE;
1432: l_personnelist_flag ghr_pa_routing_history.personnelist_flag%TYPE;

Line 1429: l_authorizer_flag ghr_pa_routing_history.authorizer_flag%TYPE;

1425: l_gbx_user_id ghr_groupbox_users.groupbox_user_id%type;
1426: l_initiator_flag ghr_pa_routing_history.initiator_flag%TYPE := NULL;
1427: l_requester_flag ghr_pa_routing_history.requester_flag%TYPE;
1428: l_reviewer_flag ghr_pa_routing_history.reviewer_flag%TYPE;
1429: l_authorizer_flag ghr_pa_routing_history.authorizer_flag%TYPE;
1430: l_approver_flag ghr_pa_routing_history.approver_flag%TYPE;
1431: l_approved_flag ghr_pa_routing_history.approved_flag%TYPE;
1432: l_personnelist_flag ghr_pa_routing_history.personnelist_flag%TYPE;
1433: l_user_name_employee_id per_people_f.person_id%TYPE;

Line 1430: l_approver_flag ghr_pa_routing_history.approver_flag%TYPE;

1426: l_initiator_flag ghr_pa_routing_history.initiator_flag%TYPE := NULL;
1427: l_requester_flag ghr_pa_routing_history.requester_flag%TYPE;
1428: l_reviewer_flag ghr_pa_routing_history.reviewer_flag%TYPE;
1429: l_authorizer_flag ghr_pa_routing_history.authorizer_flag%TYPE;
1430: l_approver_flag ghr_pa_routing_history.approver_flag%TYPE;
1431: l_approved_flag ghr_pa_routing_history.approved_flag%TYPE;
1432: l_personnelist_flag ghr_pa_routing_history.personnelist_flag%TYPE;
1433: l_user_name_employee_id per_people_f.person_id%TYPE;
1434: l_user_name_emp_first_name per_people_f.first_name%TYPE;

Line 1431: l_approved_flag ghr_pa_routing_history.approved_flag%TYPE;

1427: l_requester_flag ghr_pa_routing_history.requester_flag%TYPE;
1428: l_reviewer_flag ghr_pa_routing_history.reviewer_flag%TYPE;
1429: l_authorizer_flag ghr_pa_routing_history.authorizer_flag%TYPE;
1430: l_approver_flag ghr_pa_routing_history.approver_flag%TYPE;
1431: l_approved_flag ghr_pa_routing_history.approved_flag%TYPE;
1432: l_personnelist_flag ghr_pa_routing_history.personnelist_flag%TYPE;
1433: l_user_name_employee_id per_people_f.person_id%TYPE;
1434: l_user_name_emp_first_name per_people_f.first_name%TYPE;
1435: l_user_name_emp_last_name per_people_f.last_name%TYPE;

Line 1432: l_personnelist_flag ghr_pa_routing_history.personnelist_flag%TYPE;

1428: l_reviewer_flag ghr_pa_routing_history.reviewer_flag%TYPE;
1429: l_authorizer_flag ghr_pa_routing_history.authorizer_flag%TYPE;
1430: l_approver_flag ghr_pa_routing_history.approver_flag%TYPE;
1431: l_approved_flag ghr_pa_routing_history.approved_flag%TYPE;
1432: l_personnelist_flag ghr_pa_routing_history.personnelist_flag%TYPE;
1433: l_user_name_employee_id per_people_f.person_id%TYPE;
1434: l_user_name_emp_first_name per_people_f.first_name%TYPE;
1435: l_user_name_emp_last_name per_people_f.last_name%TYPE;
1436: l_user_name_emp_middle_names per_people_f.middle_names%TYPE;

Line 1438: l_u_pa_routing_history_id ghr_pa_routing_history.pa_routing_history_id%TYPE;

1434: l_user_name_emp_first_name per_people_f.first_name%TYPE;
1435: l_user_name_emp_last_name per_people_f.last_name%TYPE;
1436: l_user_name_emp_middle_names per_people_f.middle_names%TYPE;
1437: l_current_user_name fnd_user.user_name%type;
1438: l_u_pa_routing_history_id ghr_pa_routing_history.pa_routing_history_id%TYPE;
1439: l_u_prh_object_version_number ghr_pa_routing_history.object_version_number%TYPE;
1440:
1441: l_result varchar2(4000);
1442: l_exp number;

Line 1439: l_u_prh_object_version_number ghr_pa_routing_history.object_version_number%TYPE;

1435: l_user_name_emp_last_name per_people_f.last_name%TYPE;
1436: l_user_name_emp_middle_names per_people_f.middle_names%TYPE;
1437: l_current_user_name fnd_user.user_name%type;
1438: l_u_pa_routing_history_id ghr_pa_routing_history.pa_routing_history_id%TYPE;
1439: l_u_prh_object_version_number ghr_pa_routing_history.object_version_number%TYPE;
1440:
1441: l_result varchar2(4000);
1442: l_exp number;
1443: BEGIN