APPS.GHR_HISTORY_FETCH dependencies on PER_ASSIGNMENT_EXTRA_INFO

Line 1160: p_asgei_data out nocopy per_assignment_extra_info%rowtype,

1156: p_noa_id_corrected in number default null,
1157: p_rowid in rowid default null,
1158: p_pa_history_id in number default null,
1159: p_get_ovn_flag in varchar2 default 'N' ,
1160: p_asgei_data out nocopy per_assignment_extra_info%rowtype,
1161: p_result_code out nocopy varchar2 ) is
1162:
1163: cursor per_asgei_rowid_cursor is
1164: select *

Line 1165: from per_assignment_extra_info

1161: p_result_code out nocopy varchar2 ) is
1162:
1163: cursor per_asgei_rowid_cursor is
1164: select *
1165: from per_assignment_extra_info
1166: where rowid = p_rowid;
1167:
1168: cursor c_get_ovn is
1169: select object_version_number

Line 1170: from per_assignment_extra_info

1166: where rowid = p_rowid;
1167:
1168: cursor c_get_ovn is
1169: select object_version_number
1170: from per_assignment_extra_info
1171: where assignment_extra_info_id = p_assignment_extra_info_id;
1172:
1173: l_result_code varchar2(30);
1174: l_asgei_data per_assignment_extra_info%rowtype;

Line 1174: l_asgei_data per_assignment_extra_info%rowtype;

1170: from per_assignment_extra_info
1171: where assignment_extra_info_id = p_assignment_extra_info_id;
1172:
1173: l_result_code varchar2(30);
1174: l_asgei_data per_assignment_extra_info%rowtype;
1175: l_hist_data ghr_pa_history%rowtype;
1176: l_proc varchar2(30):='fetch_asgei';
1177:
1178: Begin

Line 1557: p_asg_ei_data out nocopy per_assignment_extra_info%rowtype

1553:
1554: Procedure fetch_asgei ( p_assignment_id in number,
1555: p_information_type in varchar2,
1556: p_date_effective in date,
1557: p_asg_ei_data out nocopy per_assignment_extra_info%rowtype
1558: )
1559: is
1560: l_proc varchar2(72) := 'Fetch_Asgei (2)';
1561: l_asg_ei_data ghr_assignment_extra_info_h_v%rowtype;

Line 1565: l_extra_info_id per_assignment_extra_info.assignment_extra_info_id%type;

1561: l_asg_ei_data ghr_assignment_extra_info_h_v%rowtype;
1562: l_pa_history_id ghr_pa_history.pa_history_id%type;
1563: l_max_effective_date date;
1564: l_session ghr_history_api.g_session_var_type;
1565: l_extra_info_id per_assignment_extra_info.assignment_extra_info_id%type;
1566: l_result varchar2(20);
1567: cursor c_extra_info_id is
1568: select aei.assignment_extra_info_id
1569: from per_assignment_extra_info aei

Line 1569: from per_assignment_extra_info aei

1565: l_extra_info_id per_assignment_extra_info.assignment_extra_info_id%type;
1566: l_result varchar2(20);
1567: cursor c_extra_info_id is
1568: select aei.assignment_extra_info_id
1569: from per_assignment_extra_info aei
1570: where aei.assignment_id = p_assignment_id
1571: and aei.information_type = p_information_type;
1572: Begin
1573: hr_utility.set_location('Entering ' || l_proc,5);

Line 2817: r_aei per_assignment_extra_info%rowtype;

2813: ,p_creation_date out nocopy date
2814: ,p_result_code out nocopy varchar2
2815: )
2816: Is
2817: r_aei per_assignment_extra_info%rowtype;
2818: l_proc varchar2(30):='fetch_asgei (1)';
2819: l_result_code varchar2(30);
2820: Begin
2821: hr_utility.set_location(' Entering : ' || l_proc, 10);

Line 3082: p_asgei_data out nocopy per_assignment_extra_info%rowtype) as

3078: p_altered_pa_request_id in number ,
3079: p_noa_id_corrected in number ,
3080: p_date_effective in date default null,
3081: p_get_ovn_flag in varchar2 default 'N' ,
3082: p_asgei_data out nocopy per_assignment_extra_info%rowtype) as
3083:
3084:
3085: cursor get_root_hist_id(
3086: cp_pa_req_id in number,

Line 3099: from per_assignment_extra_info aei

3095: and nature_of_action_id = cp_noa_id;
3096:
3097: cursor c_extra_info_id is
3098: select aei.assignment_extra_info_id
3099: from per_assignment_extra_info aei
3100: where aei.assignment_id = p_assignment_id
3101: and aei.information_type = p_information_type;
3102:
3103: l_pa_history_id number;