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.HR_APPRAISALS_API dependencies on PER_APPRAISALS

Line 92: l_appraisal_id per_appraisals.appraisal_id%TYPE;

88: -- Declare cursors and local variables
89: --
90: --
91: l_proc varchar2(72) := g_package||'create_appraisal';
92: l_appraisal_id per_appraisals.appraisal_id%TYPE;
93: l_object_version_number per_appraisals.object_version_number%TYPE;
94:
95: begin
96: hr_utility.set_location('Entering:'|| l_proc, 5);

Line 93: l_object_version_number per_appraisals.object_version_number%TYPE;

89: --
90: --
91: l_proc varchar2(72) := g_package||'create_appraisal';
92: l_appraisal_id per_appraisals.appraisal_id%TYPE;
93: l_object_version_number per_appraisals.object_version_number%TYPE;
94:
95: begin
96: hr_utility.set_location('Entering:'|| l_proc, 5);
97: --

Line 592: l_object_version_number per_appraisals.object_version_number%TYPE;

588: -- Declare cursors and local variables
589: --
590:
591: l_proc varchar2(72) := g_package||'update_appraisal';
592: l_object_version_number per_appraisals.object_version_number%TYPE;
593: l_asn_object_version_number per_assessments.object_version_number%TYPE;
594: l_assessment_id per_assessments.assessment_id%TYPE;
595: l_old_mainap_id per_appraisals.main_appraiser_id%TYPE;
596: l_participant_id_1 per_participants.participant_id%TYPE;

Line 595: l_old_mainap_id per_appraisals.main_appraiser_id%TYPE;

591: l_proc varchar2(72) := g_package||'update_appraisal';
592: l_object_version_number per_appraisals.object_version_number%TYPE;
593: l_asn_object_version_number per_assessments.object_version_number%TYPE;
594: l_assessment_id per_assessments.assessment_id%TYPE;
595: l_old_mainap_id per_appraisals.main_appraiser_id%TYPE;
596: l_participant_id_1 per_participants.participant_id%TYPE;
597: l_participant_id_2 per_participants.participant_id%TYPE;
598: l_part_object_version_number_1 per_participants.object_version_number%TYPE;
599: l_part_object_version_number_2 per_participants.object_version_number%TYPE;

Line 600: l_appraisee_person_id per_appraisals.appraisee_person_id%TYPE;

596: l_participant_id_1 per_participants.participant_id%TYPE;
597: l_participant_id_2 per_participants.participant_id%TYPE;
598: l_part_object_version_number_1 per_participants.object_version_number%TYPE;
599: l_part_object_version_number_2 per_participants.object_version_number%TYPE;
600: l_appraisee_person_id per_appraisals.appraisee_person_id%TYPE;
601: l_appraiser_person_id per_appraisals.appraiser_person_id%TYPE;
602: l_appraisal_sys_status per_appraisals.appraisal_system_status%TYPE;
603: --
604: lv_object_version_number number := p_object_version_number ;

Line 601: l_appraiser_person_id per_appraisals.appraiser_person_id%TYPE;

597: l_participant_id_2 per_participants.participant_id%TYPE;
598: l_part_object_version_number_1 per_participants.object_version_number%TYPE;
599: l_part_object_version_number_2 per_participants.object_version_number%TYPE;
600: l_appraisee_person_id per_appraisals.appraisee_person_id%TYPE;
601: l_appraiser_person_id per_appraisals.appraiser_person_id%TYPE;
602: l_appraisal_sys_status per_appraisals.appraisal_system_status%TYPE;
603: --
604: lv_object_version_number number := p_object_version_number ;
605: --

Line 602: l_appraisal_sys_status per_appraisals.appraisal_system_status%TYPE;

598: l_part_object_version_number_1 per_participants.object_version_number%TYPE;
599: l_part_object_version_number_2 per_participants.object_version_number%TYPE;
600: l_appraisee_person_id per_appraisals.appraisee_person_id%TYPE;
601: l_appraiser_person_id per_appraisals.appraiser_person_id%TYPE;
602: l_appraisal_sys_status per_appraisals.appraisal_system_status%TYPE;
603: --
604: lv_object_version_number number := p_object_version_number ;
605: --
606: l_person_id NUMBER(9,0);

Line 610: FROM per_appraisals

606: l_person_id NUMBER(9,0);
607: l_ota_installed varchar2(10);
608: CURSOR get_appraisee_person_id (p_appraisal_id IN number) IS
609: SELECT appraisee_person_id
610: FROM per_appraisals
611: WHERE appraisal_id = p_appraisal_id;
612: -- ----------------------------------------------------------------------
613: -- Declare Local Procedure and Functions
614: -- ----------------------------------------------------------------------

Line 709: and par.participation_in_table = 'PER_APPRAISALS'

705: CURSOR csr_get_participant IS
706: SELECT par.participant_id, par.object_version_number
707: FROM per_participants par
708: WHERE par.participation_in_id = p_appraisal_id
709: and par.participation_in_table = 'PER_APPRAISALS'
710: and par.participation_in_column = 'APPRAISAL_ID'
711: and par.person_id = p_person_id;
712: --
713: BEGIN

Line 736: FROM per_appraisals apr

732: -- check if Participant exists for the Appraisal and the PersonId
733: --
734: CURSOR csr_get_map_id IS
735: SELECT apr.main_appraiser_id
736: FROM per_appraisals apr
737: WHERE apr.appraisal_id = p_appraisal_id;
738: --
739: l_main_appraiser_id per_appraisals.main_appraiser_id%TYPE;
740: BEGIN

Line 739: l_main_appraiser_id per_appraisals.main_appraiser_id%TYPE;

735: SELECT apr.main_appraiser_id
736: FROM per_appraisals apr
737: WHERE apr.appraisal_id = p_appraisal_id;
738: --
739: l_main_appraiser_id per_appraisals.main_appraiser_id%TYPE;
740: BEGIN
741: --
742: OPEN csr_get_map_id;
743: FETCH csr_get_map_id INTO l_main_appraiser_id;

Line 1170: and participation_in_table = 'PER_APPRAISALS'

1166: --
1167: cursor cs_get_participants is
1168: select participant_id,object_version_number from per_participants
1169: where participation_in_id = p_appraisal_id
1170: and participation_in_table = 'PER_APPRAISALS'
1171: and participation_in_column = 'APPRAISAL_ID';
1172: --
1173:
1174: cursor cs_get_objectives is

Line 1196: where event_id in (select event_id from per_appraisals where appraisal_id = p_appraisal_id);

1192:
1193: cursor cs_get_perf_review_rec is
1194: select performance_review_id, object_version_number
1195: from per_performance_reviews
1196: where event_id in (select event_id from per_appraisals where appraisal_id = p_appraisal_id);
1197:
1198: --
1199: cursor cs_get_per_events_rec is
1200: select event_id, object_version_number

Line 1202: where event_id in (select event_id from per_appraisals where appraisal_id = p_appraisal_id);

1198: --
1199: cursor cs_get_per_events_rec is
1200: select event_id, object_version_number
1201: from per_events
1202: where event_id in (select event_id from per_appraisals where appraisal_id = p_appraisal_id);
1203:
1204: --
1205: /*
1206: --

Line 1219: participation_in_table='PER_APPRAISALS' and participation_in_column='APPRAISAL_ID' and

1215: hr_quest_answer_values where questionnaire_answer_id in
1216: (select questionnaire_answer_id from hr_quest_answers
1217: where type = 'PARTICIPANT' and type_object_id in
1218: (select participant_id from per_participants where
1219: participation_in_table='PER_APPRAISALS' and participation_in_column='APPRAISAL_ID' and
1220: participation_in_id=p_appraisal_id
1221: )
1222: );
1223:

Line 1309: Event_Id which will be same as Event_Id in Per_Appraisals table)

1305: j) delete_ota_training_plan_members
1306: - this is under review as to how to be deleted . so nothing for this now
1307: k) hr_perf_review_api.delete_perf_review
1308: (we create an entry in per_performance_reviews table and this has the column
1309: Event_Id which will be same as Event_Id in Per_Appraisals table)
1310: l) per_events_api.delete_event
1311: (we added an Event_id in Per_Appraisals, using that event_id we go here and delete it)
1312: m) delete_appraisal finally .
1313:

Line 1311: (we added an Event_id in Per_Appraisals, using that event_id we go here and delete it)

1307: k) hr_perf_review_api.delete_perf_review
1308: (we create an entry in per_performance_reviews table and this has the column
1309: Event_Id which will be same as Event_Id in Per_Appraisals table)
1310: l) per_events_api.delete_event
1311: (we added an Event_id in Per_Appraisals, using that event_id we go here and delete it)
1312: m) delete_appraisal finally .
1313:
1314: */
1315: