APPS.HR_APPRAISALS_API dependencies on PER_EVENTS

Line 1199: cursor cs_get_per_events_rec is

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
1201: from per_events
1202: where event_id in (select event_id from per_appraisals where appraisal_id = p_appraisal_id);
1203:

Line 1201: from per_events

1197:
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: /*

Line 1310: l) per_events_api.delete_event

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:
1314: */

Line 1383: FOR per_events_rec in cs_get_per_events_rec LOOP

1379: );
1380: END LOOP;
1381:
1382: --
1383: FOR per_events_rec in cs_get_per_events_rec LOOP
1384: per_events_api.delete_event
1385: (
1386: p_validate => p_validate
1387: ,p_event_id => per_events_rec.event_id

Line 1384: per_events_api.delete_event

1380: END LOOP;
1381:
1382: --
1383: FOR per_events_rec in cs_get_per_events_rec LOOP
1384: per_events_api.delete_event
1385: (
1386: p_validate => p_validate
1387: ,p_event_id => per_events_rec.event_id
1388: ,p_object_version_number => per_events_rec.object_version_number

Line 1387: ,p_event_id => per_events_rec.event_id

1383: FOR per_events_rec in cs_get_per_events_rec LOOP
1384: per_events_api.delete_event
1385: (
1386: p_validate => p_validate
1387: ,p_event_id => per_events_rec.event_id
1388: ,p_object_version_number => per_events_rec.object_version_number
1389: );
1390: END LOOP;
1391: --

Line 1388: ,p_object_version_number => per_events_rec.object_version_number

1384: per_events_api.delete_event
1385: (
1386: p_validate => p_validate
1387: ,p_event_id => per_events_rec.event_id
1388: ,p_object_version_number => per_events_rec.object_version_number
1389: );
1390: END LOOP;
1391: --
1392: