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 237: SELECT user_name from ghr_pa_routing_history

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

Line 243: SELECT user_name from ghr_pa_routing_history

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

Line 248: l_approver_name ghr_pa_routing_history.user_name%TYPE;

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

Line 249: l_upd_hr_user_name ghr_pa_routing_history.user_name%TYPE;

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

Line 360: l_approver_name ghr_pa_routing_history.user_name%TYPE;

356: funcmode in varchar2,
357: result in out nocopy varchar2) is
358: --
359: --
360: l_approver_name ghr_pa_routing_history.user_name%TYPE;
361: l_upd_hr_user_name ghr_pa_routing_history.user_name%TYPE;
362: --
363: l_result varchar2(4000);
364: begin

Line 361: l_upd_hr_user_name ghr_pa_routing_history.user_name%TYPE;

357: result in out nocopy varchar2) is
358: --
359: --
360: l_approver_name ghr_pa_routing_history.user_name%TYPE;
361: l_upd_hr_user_name ghr_pa_routing_history.user_name%TYPE;
362: --
363: l_result varchar2(4000);
364: begin
365: l_result := result;

Line 432: l_user_name ghr_pa_routing_history.user_name%TYPE;

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

Line 433: l_action_taken ghr_pa_routing_history.action_taken%TYPE;

429: result in out nocopy varchar2 ) is
430: --
431: --
432: l_user_name ghr_pa_routing_history.user_name%TYPE;
433: l_action_taken ghr_pa_routing_history.action_taken%TYPE;
434: l_groupbox_name ghr_groupboxes.name%TYPE;
435: l_subject varchar2(500);
436: l_line1 varchar2(500);
437: l_line2 varchar2(500);

Line 607: l_pa_routing_history_id ghr_pa_routing_history.pa_routing_history_id%TYPE;

603: p_groupbox_name OUT nocopy varchar2
604: ) IS
605:
606: -- Local variables
607: l_pa_routing_history_id ghr_pa_routing_history.pa_routing_history_id%TYPE;
608: l_user_name ghr_pa_routing_history.user_name%TYPE;
609: l_groupbox_id ghr_pa_routing_history.groupbox_id%TYPE;
610: l_action_taken ghr_pa_routing_history.action_taken%TYPE;
611: l_groupbox_name ghr_groupboxes.name%TYPE;

Line 608: l_user_name ghr_pa_routing_history.user_name%TYPE;

604: ) IS
605:
606: -- Local variables
607: l_pa_routing_history_id ghr_pa_routing_history.pa_routing_history_id%TYPE;
608: l_user_name ghr_pa_routing_history.user_name%TYPE;
609: l_groupbox_id ghr_pa_routing_history.groupbox_id%TYPE;
610: l_action_taken ghr_pa_routing_history.action_taken%TYPE;
611: l_groupbox_name ghr_groupboxes.name%TYPE;
612: --

Line 609: l_groupbox_id ghr_pa_routing_history.groupbox_id%TYPE;

605:
606: -- Local variables
607: l_pa_routing_history_id ghr_pa_routing_history.pa_routing_history_id%TYPE;
608: l_user_name ghr_pa_routing_history.user_name%TYPE;
609: l_groupbox_id ghr_pa_routing_history.groupbox_id%TYPE;
610: l_action_taken ghr_pa_routing_history.action_taken%TYPE;
611: l_groupbox_name ghr_groupboxes.name%TYPE;
612: --
613: --

Line 610: l_action_taken ghr_pa_routing_history.action_taken%TYPE;

606: -- Local variables
607: l_pa_routing_history_id ghr_pa_routing_history.pa_routing_history_id%TYPE;
608: l_user_name ghr_pa_routing_history.user_name%TYPE;
609: l_groupbox_id ghr_pa_routing_history.groupbox_id%TYPE;
610: l_action_taken ghr_pa_routing_history.action_taken%TYPE;
611: l_groupbox_name ghr_groupboxes.name%TYPE;
612: --
613: --
614: cursor csr_pa_routing_history is

Line 616: FROM ghr_pa_routing_history

612: --
613: --
614: cursor csr_pa_routing_history is
615: SELECT max(pa_routing_history_id)
616: FROM ghr_pa_routing_history
617: WHERE pa_request_id = p_pa_request_id;
618: --
619: cursor csr_pah_details is
620: SELECT action_taken, user_name, groupbox_id

Line 621: FROM ghr_pa_routing_history

617: WHERE pa_request_id = p_pa_request_id;
618: --
619: cursor csr_pah_details is
620: SELECT action_taken, user_name, groupbox_id
621: FROM ghr_pa_routing_history
622: WHERE pa_routing_history_id = l_pa_routing_history_id;
623: --
624: cursor csr_gbx_details is
625: SELECT name

Line 740: l_action_taken1 ghr_pa_routing_history.action_taken%TYPE;

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

Line 741: l_creation_date ghr_pa_routing_history.creation_date%TYPE;

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

Line 742: l_date_notification_sent ghr_pa_routing_history.date_notification_sent%TYPE;

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

Line 776: SELECT action_taken from ghr_pa_routing_history

772: FROM hr_organization_units
773: WHERE organization_id = l_to_organization_id ;
774: --
775: cursor csr_get_routing_details is
776: SELECT action_taken from ghr_pa_routing_history
777: where pa_request_id = p_pa_request_id
778: order by pa_routing_history_id desc;
779: --
780: cursor csr_get_initiated_date is

Line 781: SELECT date_notification_sent, creation_date FROM ghr_pa_routing_history

777: where pa_request_id = p_pa_request_id
778: order by pa_routing_history_id desc;
779: --
780: cursor csr_get_initiated_date is
781: SELECT date_notification_sent, creation_date FROM ghr_pa_routing_history
782: WHERE pa_request_id = p_pa_request_id
783: order by 1 asc;
784: --
785: cursor csr_from_org_details is

Line 1116: l_action_taken ghr_pa_routing_history.action_taken%TYPE;

1112: actid in number,
1113: funcmode in varchar2,
1114: result in out nocopy varchar2) is
1115: --
1116: l_action_taken ghr_pa_routing_history.action_taken%TYPE;
1117: l_load_form varchar2(200);--Bug# 7312949
1118: --
1119: cursor csr_parh is
1120: SELECT action_taken

Line 1121: FROM ghr_pa_routing_history

1117: l_load_form varchar2(200);--Bug# 7312949
1118: --
1119: cursor csr_parh is
1120: SELECT action_taken
1121: FROM ghr_pa_routing_history
1122: WHERE pa_request_id = itemkey
1123: order by pa_routing_history_id desc;
1124: --
1125:

Line 1314: l_prh_rec ghr_pa_routing_history%rowtype := NULL;

1310: --
1311: --
1312: l_forward_to_name varchar2(30);
1313: l_user_name varchar2(30);
1314: l_prh_rec ghr_pa_routing_history%rowtype := NULL;
1315: l_routing_group_id ghr_routing_groups.routing_group_id%type;
1316: l_effective_date ghr_pa_requests.effective_date%type;
1317: l_first_noa_id ghr_pa_requests.first_noa_id%type;
1318: l_second_noa_id ghr_pa_requests.second_noa_id%type;

Line 1391: from ghr_pa_routing_history prh

1387:
1388: Cursor C_routing_history_id is
1389: select prh.pa_routing_history_id,
1390: prh.object_version_number
1391: from ghr_pa_routing_history prh
1392: where prh.pa_request_id = itemkey
1393: order by prh.pa_routing_history_id desc;
1394:
1395: Cursor get_par

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

1400: where pa_request_id = itemkey;
1401:
1402: l_valid_user varchar2(1) := 'N';
1403: l_gbx_user_id ghr_groupbox_users.groupbox_user_id%type;
1404: l_initiator_flag ghr_pa_routing_history.initiator_flag%TYPE := NULL;
1405: l_requester_flag ghr_pa_routing_history.requester_flag%TYPE;
1406: l_reviewer_flag ghr_pa_routing_history.reviewer_flag%TYPE;
1407: l_authorizer_flag ghr_pa_routing_history.authorizer_flag%TYPE;
1408: l_approver_flag ghr_pa_routing_history.approver_flag%TYPE;

Line 1405: l_requester_flag ghr_pa_routing_history.requester_flag%TYPE;

1401:
1402: l_valid_user varchar2(1) := 'N';
1403: l_gbx_user_id ghr_groupbox_users.groupbox_user_id%type;
1404: l_initiator_flag ghr_pa_routing_history.initiator_flag%TYPE := NULL;
1405: l_requester_flag ghr_pa_routing_history.requester_flag%TYPE;
1406: l_reviewer_flag ghr_pa_routing_history.reviewer_flag%TYPE;
1407: l_authorizer_flag ghr_pa_routing_history.authorizer_flag%TYPE;
1408: l_approver_flag ghr_pa_routing_history.approver_flag%TYPE;
1409: l_approved_flag ghr_pa_routing_history.approved_flag%TYPE;

Line 1406: l_reviewer_flag ghr_pa_routing_history.reviewer_flag%TYPE;

1402: l_valid_user varchar2(1) := 'N';
1403: l_gbx_user_id ghr_groupbox_users.groupbox_user_id%type;
1404: l_initiator_flag ghr_pa_routing_history.initiator_flag%TYPE := NULL;
1405: l_requester_flag ghr_pa_routing_history.requester_flag%TYPE;
1406: l_reviewer_flag ghr_pa_routing_history.reviewer_flag%TYPE;
1407: l_authorizer_flag ghr_pa_routing_history.authorizer_flag%TYPE;
1408: l_approver_flag ghr_pa_routing_history.approver_flag%TYPE;
1409: l_approved_flag ghr_pa_routing_history.approved_flag%TYPE;
1410: l_personnelist_flag ghr_pa_routing_history.personnelist_flag%TYPE;

Line 1407: l_authorizer_flag ghr_pa_routing_history.authorizer_flag%TYPE;

1403: l_gbx_user_id ghr_groupbox_users.groupbox_user_id%type;
1404: l_initiator_flag ghr_pa_routing_history.initiator_flag%TYPE := NULL;
1405: l_requester_flag ghr_pa_routing_history.requester_flag%TYPE;
1406: l_reviewer_flag ghr_pa_routing_history.reviewer_flag%TYPE;
1407: l_authorizer_flag ghr_pa_routing_history.authorizer_flag%TYPE;
1408: l_approver_flag ghr_pa_routing_history.approver_flag%TYPE;
1409: l_approved_flag ghr_pa_routing_history.approved_flag%TYPE;
1410: l_personnelist_flag ghr_pa_routing_history.personnelist_flag%TYPE;
1411: l_user_name_employee_id per_people_f.person_id%TYPE;

Line 1408: l_approver_flag ghr_pa_routing_history.approver_flag%TYPE;

1404: l_initiator_flag ghr_pa_routing_history.initiator_flag%TYPE := NULL;
1405: l_requester_flag ghr_pa_routing_history.requester_flag%TYPE;
1406: l_reviewer_flag ghr_pa_routing_history.reviewer_flag%TYPE;
1407: l_authorizer_flag ghr_pa_routing_history.authorizer_flag%TYPE;
1408: l_approver_flag ghr_pa_routing_history.approver_flag%TYPE;
1409: l_approved_flag ghr_pa_routing_history.approved_flag%TYPE;
1410: l_personnelist_flag ghr_pa_routing_history.personnelist_flag%TYPE;
1411: l_user_name_employee_id per_people_f.person_id%TYPE;
1412: l_user_name_emp_first_name per_people_f.first_name%TYPE;

Line 1409: l_approved_flag ghr_pa_routing_history.approved_flag%TYPE;

1405: l_requester_flag ghr_pa_routing_history.requester_flag%TYPE;
1406: l_reviewer_flag ghr_pa_routing_history.reviewer_flag%TYPE;
1407: l_authorizer_flag ghr_pa_routing_history.authorizer_flag%TYPE;
1408: l_approver_flag ghr_pa_routing_history.approver_flag%TYPE;
1409: l_approved_flag ghr_pa_routing_history.approved_flag%TYPE;
1410: l_personnelist_flag ghr_pa_routing_history.personnelist_flag%TYPE;
1411: l_user_name_employee_id per_people_f.person_id%TYPE;
1412: l_user_name_emp_first_name per_people_f.first_name%TYPE;
1413: l_user_name_emp_last_name per_people_f.last_name%TYPE;

Line 1410: l_personnelist_flag ghr_pa_routing_history.personnelist_flag%TYPE;

1406: l_reviewer_flag ghr_pa_routing_history.reviewer_flag%TYPE;
1407: l_authorizer_flag ghr_pa_routing_history.authorizer_flag%TYPE;
1408: l_approver_flag ghr_pa_routing_history.approver_flag%TYPE;
1409: l_approved_flag ghr_pa_routing_history.approved_flag%TYPE;
1410: l_personnelist_flag ghr_pa_routing_history.personnelist_flag%TYPE;
1411: l_user_name_employee_id per_people_f.person_id%TYPE;
1412: l_user_name_emp_first_name per_people_f.first_name%TYPE;
1413: l_user_name_emp_last_name per_people_f.last_name%TYPE;
1414: l_user_name_emp_middle_names per_people_f.middle_names%TYPE;

Line 1416: l_u_pa_routing_history_id ghr_pa_routing_history.pa_routing_history_id%TYPE;

1412: l_user_name_emp_first_name per_people_f.first_name%TYPE;
1413: l_user_name_emp_last_name per_people_f.last_name%TYPE;
1414: l_user_name_emp_middle_names per_people_f.middle_names%TYPE;
1415: l_current_user_name fnd_user.user_name%type;
1416: l_u_pa_routing_history_id ghr_pa_routing_history.pa_routing_history_id%TYPE;
1417: l_u_prh_object_version_number ghr_pa_routing_history.object_version_number%TYPE;
1418:
1419: l_result varchar2(4000);
1420: l_exp number;

Line 1417: l_u_prh_object_version_number ghr_pa_routing_history.object_version_number%TYPE;

1413: l_user_name_emp_last_name per_people_f.last_name%TYPE;
1414: l_user_name_emp_middle_names per_people_f.middle_names%TYPE;
1415: l_current_user_name fnd_user.user_name%type;
1416: l_u_pa_routing_history_id ghr_pa_routing_history.pa_routing_history_id%TYPE;
1417: l_u_prh_object_version_number ghr_pa_routing_history.object_version_number%TYPE;
1418:
1419: l_result varchar2(4000);
1420: l_exp number;
1421: BEGIN