APPS.HR_APPRAISALS_API dependencies on PER_EVENTS

Line 1151: cursor cs_get_per_events_rec is

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
1153: from per_events
1154: where event_id in (select event_id from per_appraisals where appraisal_id = p_appraisal_id);
1155:

Line 1153: from per_events

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

Line 1262: l) per_events_api.delete_event

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

Line 1335: FOR per_events_rec in cs_get_per_events_rec LOOP

1331: );
1332: END LOOP;
1333:
1334: --
1335: FOR per_events_rec in cs_get_per_events_rec LOOP
1336: per_events_api.delete_event
1337: (
1338: p_validate => p_validate
1339: ,p_event_id => per_events_rec.event_id

Line 1336: per_events_api.delete_event

1332: END LOOP;
1333:
1334: --
1335: FOR per_events_rec in cs_get_per_events_rec LOOP
1336: per_events_api.delete_event
1337: (
1338: p_validate => p_validate
1339: ,p_event_id => per_events_rec.event_id
1340: ,p_object_version_number => per_events_rec.object_version_number

Line 1339: ,p_event_id => per_events_rec.event_id

1335: FOR per_events_rec in cs_get_per_events_rec LOOP
1336: per_events_api.delete_event
1337: (
1338: p_validate => p_validate
1339: ,p_event_id => per_events_rec.event_id
1340: ,p_object_version_number => per_events_rec.object_version_number
1341: );
1342: END LOOP;
1343: --

Line 1340: ,p_object_version_number => per_events_rec.object_version_number

1336: per_events_api.delete_event
1337: (
1338: p_validate => p_validate
1339: ,p_event_id => per_events_rec.event_id
1340: ,p_object_version_number => per_events_rec.object_version_number
1341: );
1342: END LOOP;
1343: --
1344: