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 90: l_appraisal_id per_appraisals.appraisal_id%TYPE;

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

Line 91: l_object_version_number per_appraisals.object_version_number%TYPE;

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

Line 582: l_object_version_number per_appraisals.object_version_number%TYPE;

578: -- Declare cursors and local variables
579: --
580:
581: l_proc varchar2(72) := g_package||'update_appraisal';
582: l_object_version_number per_appraisals.object_version_number%TYPE;
583: l_asn_object_version_number per_assessments.object_version_number%TYPE;
584: l_assessment_id per_assessments.assessment_id%TYPE;
585: l_old_mainap_id per_appraisals.main_appraiser_id%TYPE;
586: l_participant_id_1 per_participants.participant_id%TYPE;

Line 585: l_old_mainap_id per_appraisals.main_appraiser_id%TYPE;

581: l_proc varchar2(72) := g_package||'update_appraisal';
582: l_object_version_number per_appraisals.object_version_number%TYPE;
583: l_asn_object_version_number per_assessments.object_version_number%TYPE;
584: l_assessment_id per_assessments.assessment_id%TYPE;
585: l_old_mainap_id per_appraisals.main_appraiser_id%TYPE;
586: l_participant_id_1 per_participants.participant_id%TYPE;
587: l_participant_id_2 per_participants.participant_id%TYPE;
588: l_part_object_version_number_1 per_participants.object_version_number%TYPE;
589: l_part_object_version_number_2 per_participants.object_version_number%TYPE;

Line 692: and par.participation_in_table = 'PER_APPRAISALS'

688: CURSOR csr_get_participant IS
689: SELECT par.participant_id, par.object_version_number
690: FROM per_participants par
691: WHERE par.participation_in_id = p_appraisal_id
692: and par.participation_in_table = 'PER_APPRAISALS'
693: and par.participation_in_column = 'APPRAISAL_ID'
694: and par.person_id = p_person_id;
695: --
696: BEGIN

Line 719: FROM per_appraisals apr

715: -- check if Participant exists for the Appraisal and the PersonId
716: --
717: CURSOR csr_get_map_id IS
718: SELECT apr.main_appraiser_id
719: FROM per_appraisals apr
720: WHERE apr.appraisal_id = p_appraisal_id;
721: --
722: l_main_appraiser_id per_appraisals.main_appraiser_id%TYPE;
723: BEGIN

Line 722: l_main_appraiser_id per_appraisals.main_appraiser_id%TYPE;

718: SELECT apr.main_appraiser_id
719: FROM per_appraisals apr
720: WHERE apr.appraisal_id = p_appraisal_id;
721: --
722: l_main_appraiser_id per_appraisals.main_appraiser_id%TYPE;
723: BEGIN
724: --
725: OPEN csr_get_map_id;
726: FETCH csr_get_map_id INTO l_main_appraiser_id;

Line 1122: and participation_in_table = 'PER_APPRAISALS'

1118: --
1119: cursor cs_get_participants is
1120: select participant_id,object_version_number from per_participants
1121: where participation_in_id = p_appraisal_id
1122: and participation_in_table = 'PER_APPRAISALS'
1123: and participation_in_column = 'APPRAISAL_ID';
1124: --
1125:
1126: cursor cs_get_objectives is

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

1144:
1145: cursor cs_get_perf_review_rec is
1146: select performance_review_id, object_version_number
1147: from per_performance_reviews
1148: where event_id in (select event_id from per_appraisals where appraisal_id = p_appraisal_id);
1149:
1150: --
1151: cursor cs_get_per_events_rec is
1152: select event_id, object_version_number

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

1150: --
1151: cursor cs_get_per_events_rec is
1152: select event_id, object_version_number
1153: from per_events
1154: where event_id in (select event_id from per_appraisals where appraisal_id = p_appraisal_id);
1155:
1156: --
1157: /*
1158: --

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

1167: hr_quest_answer_values where questionnaire_answer_id in
1168: (select questionnaire_answer_id from hr_quest_answers
1169: where type = 'PARTICIPANT' and type_object_id in
1170: (select participant_id from per_participants where
1171: participation_in_table='PER_APPRAISALS' and participation_in_column='APPRAISAL_ID' and
1172: participation_in_id=p_appraisal_id
1173: )
1174: );
1175:

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

1257: j) delete_ota_training_plan_members
1258: - this is under review as to how to be deleted . so nothing for this now
1259: k) hr_perf_review_api.delete_perf_review
1260: (we create an entry in per_performance_reviews table and this has the column
1261: Event_Id which will be same as Event_Id in Per_Appraisals table)
1262: l) per_events_api.delete_event
1263: (we added an Event_id in Per_Appraisals, using that event_id we go here and delete it)
1264: m) delete_appraisal finally .
1265:

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

1259: k) hr_perf_review_api.delete_perf_review
1260: (we create an entry in per_performance_reviews table and this has the column
1261: Event_Id which will be same as Event_Id in Per_Appraisals table)
1262: l) per_events_api.delete_event
1263: (we added an Event_id in Per_Appraisals, using that event_id we go here and delete it)
1264: m) delete_appraisal finally .
1265:
1266: */
1267: