APPS.PQH_PTX_INS dependencies on HR_ALL_POSITIONS_F

Line 462: l_name hr_all_positions_f.name%type;

458: l_effective_start_date date;
459: l_effective_end_date date;
460: l_position_definition_id number;
461: l_valid_grades_changed_warning boolean;
462: l_name hr_all_positions_f.name%type;
463: l_review_flag hr_all_positions_f.review_flag%type;
464: l_object_version_number number;
465: l_effective_date date :=sysdate;
466: l_datetrack_mode varchar2(20):='UPDATE';

Line 463: l_review_flag hr_all_positions_f.review_flag%type;

459: l_effective_end_date date;
460: l_position_definition_id number;
461: l_valid_grades_changed_warning boolean;
462: l_name hr_all_positions_f.name%type;
463: l_review_flag hr_all_positions_f.review_flag%type;
464: l_object_version_number number;
465: l_effective_date date :=sysdate;
466: l_datetrack_mode varchar2(20):='UPDATE';
467: --

Line 470: from hr_all_positions_f

466: l_datetrack_mode varchar2(20):='UPDATE';
467: --
468: cursor c_review_flag(p_position_id number) is
469: select review_flag
470: from hr_all_positions_f
471: where position_id = p_position_id;
472: --
473: cursor c1(p_position_id number, p_effective_date date) is
474: select review_flag, object_version_number

Line 475: from hr_all_positions_f

471: where position_id = p_position_id;
472: --
473: cursor c1(p_position_id number, p_effective_date date) is
474: select review_flag, object_version_number
475: from hr_all_positions_f
476: where position_id = p_position_id
477: and p_effective_date between effective_start_date and effective_end_date;
478: --
479: Begin

Line 497: update hr_all_positions_f

493: /* Bug 6524175 Changes
494: elsif ((nvl(p_rec.review_flag,'N') = 'Y' and nvl(l_review_flag,'N') = 'N'))then */
495: --
496: else
497: update hr_all_positions_f
498: set review_flag = p_rec.review_flag
499: where position_id = p_rec.position_id;
500: /*
501: hr_position_api.update_position(