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_HISTORY_FETCH dependencies on PER_ASSIGNMENT_EXTRA_INFO

Line 1228: p_asgei_data out nocopy per_assignment_extra_info%rowtype,

1224: p_noa_id_corrected in number default null,
1225: p_rowid in rowid default null,
1226: p_pa_history_id in number default null,
1227: p_get_ovn_flag in varchar2 default 'N' ,
1228: p_asgei_data out nocopy per_assignment_extra_info%rowtype,
1229: p_result_code out nocopy varchar2 ) is
1230:
1231: cursor per_asgei_rowid_cursor is
1232: select *

Line 1233: from per_assignment_extra_info

1229: p_result_code out nocopy varchar2 ) is
1230:
1231: cursor per_asgei_rowid_cursor is
1232: select *
1233: from per_assignment_extra_info
1234: where rowid = p_rowid;
1235:
1236: cursor c_get_ovn is
1237: select object_version_number

Line 1238: from per_assignment_extra_info

1234: where rowid = p_rowid;
1235:
1236: cursor c_get_ovn is
1237: select object_version_number
1238: from per_assignment_extra_info
1239: where assignment_extra_info_id = p_assignment_extra_info_id;
1240:
1241: l_result_code varchar2(30);
1242: l_asgei_data per_assignment_extra_info%rowtype;

Line 1242: l_asgei_data per_assignment_extra_info%rowtype;

1238: from per_assignment_extra_info
1239: where assignment_extra_info_id = p_assignment_extra_info_id;
1240:
1241: l_result_code varchar2(30);
1242: l_asgei_data per_assignment_extra_info%rowtype;
1243: l_hist_data ghr_pa_history%rowtype;
1244: l_proc varchar2(30):='fetch_asgei';
1245:
1246: Begin

Line 1627: p_asg_ei_data out nocopy per_assignment_extra_info%rowtype

1623:
1624: Procedure fetch_asgei ( p_assignment_id in number,
1625: p_information_type in varchar2,
1626: p_date_effective in date,
1627: p_asg_ei_data out nocopy per_assignment_extra_info%rowtype
1628: )
1629: is
1630: l_proc varchar2(72) := 'Fetch_Asgei (2)';
1631: l_asg_ei_data ghr_assignment_extra_info_h_v%rowtype;

Line 1635: l_extra_info_id per_assignment_extra_info.assignment_extra_info_id%type;

1631: l_asg_ei_data ghr_assignment_extra_info_h_v%rowtype;
1632: l_pa_history_id ghr_pa_history.pa_history_id%type;
1633: l_max_effective_date date;
1634: l_session ghr_history_api.g_session_var_type;
1635: l_extra_info_id per_assignment_extra_info.assignment_extra_info_id%type;
1636: l_result varchar2(20);
1637: cursor c_extra_info_id is
1638: select aei.assignment_extra_info_id
1639: from per_assignment_extra_info aei

Line 1639: from per_assignment_extra_info aei

1635: l_extra_info_id per_assignment_extra_info.assignment_extra_info_id%type;
1636: l_result varchar2(20);
1637: cursor c_extra_info_id is
1638: select aei.assignment_extra_info_id
1639: from per_assignment_extra_info aei
1640: where aei.assignment_id = p_assignment_id
1641: and aei.information_type = p_information_type;
1642: --Begin Bug 11680558, 11776559,11781442 added aei_information1 and aei_information2
1643: cursor c_det_extra_info_id is

Line 1645: from per_assignment_extra_info aei

1641: and aei.information_type = p_information_type;
1642: --Begin Bug 11680558, 11776559,11781442 added aei_information1 and aei_information2
1643: cursor c_det_extra_info_id is
1644: select aei.assignment_extra_info_id
1645: from per_assignment_extra_info aei
1646: where aei.assignment_id = p_assignment_id
1647: and aei.information_type = p_information_type
1648: AND fnd_date.canonical_to_date(aei.aei_information1) = (
1649: select max(fnd_date.canonical_to_date(aei_in.aei_information1)) from per_assignment_extra_info aei_in

Line 1649: select max(fnd_date.canonical_to_date(aei_in.aei_information1)) from per_assignment_extra_info aei_in

1645: from per_assignment_extra_info aei
1646: where aei.assignment_id = p_assignment_id
1647: and aei.information_type = p_information_type
1648: AND fnd_date.canonical_to_date(aei.aei_information1) = (
1649: select max(fnd_date.canonical_to_date(aei_in.aei_information1)) from per_assignment_extra_info aei_in
1650: where fnd_date.canonical_to_date(aei_in.aei_information1)<= p_date_effective
1651: AND aei_in.information_type=aei.information_type
1652: and aei_in.assignment_id = aei.assignment_id
1653: AND aei_in.assignment_extra_info_id IN(

Line 2917: r_aei per_assignment_extra_info%rowtype;

2913: ,p_creation_date out nocopy date
2914: ,p_result_code out nocopy varchar2
2915: )
2916: Is
2917: r_aei per_assignment_extra_info%rowtype;
2918: l_proc varchar2(30):='fetch_asgei (1)';
2919: l_result_code varchar2(30);
2920: Begin
2921: hr_utility.set_location(' Entering : ' || l_proc, 10);

Line 3182: p_asgei_data out nocopy per_assignment_extra_info%rowtype) as

3178: p_altered_pa_request_id in number ,
3179: p_noa_id_corrected in number ,
3180: p_date_effective in date default null,
3181: p_get_ovn_flag in varchar2 default 'N' ,
3182: p_asgei_data out nocopy per_assignment_extra_info%rowtype) as
3183:
3184:
3185: cursor get_root_hist_id(
3186: cp_pa_req_id in number,

Line 3199: from per_assignment_extra_info aei

3195: and nature_of_action_id = cp_noa_id;
3196:
3197: cursor c_extra_info_id is
3198: select aei.assignment_extra_info_id
3199: from per_assignment_extra_info aei
3200: where aei.assignment_id = p_assignment_id
3201: and aei.information_type = p_information_type;
3202:
3203: l_pa_history_id number;