APPS.PQH_PTX_UPD dependencies on HR_ALL_POSITIONS_F

Line 311: l_name hr_all_positions_f.name%type;

307: l_effective_start_date date;
308: l_effective_end_date date;
309: l_position_definition_id number;
310: l_valid_grades_changed_warning boolean;
311: l_name hr_all_positions_f.name%type;
312: l_review_flag hr_all_positions_f.review_flag%type;
313: l_object_version_number number;
314: l_effective_date date :=sysdate;
315: l_datetrack_mode varchar2(20):='UPDATE';

Line 312: l_review_flag hr_all_positions_f.review_flag%type;

308: l_effective_end_date date;
309: l_position_definition_id number;
310: l_valid_grades_changed_warning boolean;
311: l_name hr_all_positions_f.name%type;
312: l_review_flag hr_all_positions_f.review_flag%type;
313: l_object_version_number number;
314: l_effective_date date :=sysdate;
315: l_datetrack_mode varchar2(20):='UPDATE';
316: --

Line 320: from hr_all_positions_f

316: --
317: --
318: cursor c_review_flag(p_position_id number) is
319: select review_flag
320: from hr_all_positions_f
321: where position_id = p_position_id;
322: --
323: cursor c1(p_position_id number, p_effective_date date) is
324: select review_flag, object_version_number

Line 325: from hr_all_positions_f

321: where position_id = p_position_id;
322: --
323: cursor c1(p_position_id number, p_effective_date date) is
324: select review_flag, object_version_number
325: from hr_all_positions_f
326: where position_id = p_position_id
327: and p_effective_date between effective_start_date and effective_end_date;
328: --
329: Begin

Line 346: update hr_all_positions_f

342: elsif ((nvl(p_rec.review_flag,'N') = 'Y' and nvl(l_review_flag,'N') = 'N')
343: or (nvl(p_rec.review_flag,'N') = 'N' and nvl(l_review_flag,'N') = 'Y'))then */
344: --
345: else
346: update hr_all_positions_f
347: set review_flag = p_rec.review_flag
348: where position_id = p_rec.position_id;
349: /*
350: hr_position_api.update_position(