APPS.PER_CHECKLIST_EVENTS dependencies on PER_BEN_IDENTIFIED_EVENTS

Line 232: FROM per_ben_identified_events

228: l_proc varchar2(72) ;
229: --cursor event_exists(p_person_id number,p_assignment_id number,p_ler_id number, p_effective_date date) is
230: cursor event_exists is
231: SELECT 'X'
232: FROM per_ben_identified_events
233: WHERE person_id = p_person_id
234: AND nvl(assignment_id,-1) = nvl(p_assignment_id,-1)
235: AND event_reason_id = p_ler_id
236: AND effective_date = p_effective_date;

Line 255: insert into per_ben_identified_events(

251: if event_exists%notfound then
252: if g_debug then
253: hr_utility.set_location('Entering '||l_proc,20);
254: end if;
255: insert into per_ben_identified_events(
256: ben_identified_event_id,
257: event_reason_id,
258: person_id,
259: assignment_id,

Line 264: per_ben_identified_events_s.nextval,

260: status,
261: effective_date,
262: object_version_number)
263: values(
264: per_ben_identified_events_s.nextval,
265: p_ler_id,
266: p_person_id,
267: p_assignment_id,
268: 'Pending',

Line 667: FROM per_ben_identified_events

663: SELECT person_id ,
664: assignment_id ,
665: effective_date,
666: event_reason_id
667: FROM per_ben_identified_events
668: WHERE status = 'Pending'
669: FOR UPDATE OF status;
670: --
671: l_proc varchar2(72) ;

Line 717: UPDATE per_ben_identified_events

713: end if;
714: --
715: -- Update the status from PENDING to Processed
716: --
717: UPDATE per_ben_identified_events
718: SET status = 'Processed'
719: WHERE CURRENT OF pending_events;
720: end loop;
721: --

Line 725: delete from per_ben_identified_events

721: --
722: -- Purge records that are processed. Purges all records
723: --
724: if nvl(p_purge,'N') = 'Y' then
725: delete from per_ben_identified_events
726: where status = 'Processed';
727: end if;
728: --
729: commit;

Line 758: FROM per_ben_identified_events

754: SELECT person_id ,
755: assignment_id ,
756: effective_date,
757: event_reason_id
758: FROM per_ben_identified_events
759: WHERE status = 'Pending'
760: AND person_id = p_person_id
761: FOR UPDATE OF status;
762:

Line 799: UPDATE per_ben_identified_events

795: hr_utility.set_location('after process call',4);
796: --
797: -- Update the status from PENDING to Processed
798: --
799: UPDATE per_ben_identified_events
800: SET status = 'Processed'
801: WHERE CURRENT OF pending_events;
802: end loop;
803:

Line 1403: l_effective_date per_ben_identified_events.effective_date%type;

1399: FUNCTION get_supervisor_id (p_transaction_id IN VARCHAR2) RETURN NUMBER
1400: IS
1401: l_person_id per_people_f.person_id%type;
1402: l_supervisor_id per_assignments_f.supervisor_id%type;
1403: l_effective_date per_ben_identified_events.effective_date%type;
1404: BEGIN
1405: select substr(p_transaction_id,instr(p_transaction_id,'-')+1,length(p_transaction_id))
1406: INTO l_person_id FROM dual;
1407: -- first get the effective_date from per_ben_identified_events table. we expect that there would be only one event with status 'PENDING'

Line 1407: -- first get the effective_date from per_ben_identified_events table. we expect that there would be only one event with status 'PENDING'

1403: l_effective_date per_ben_identified_events.effective_date%type;
1404: BEGIN
1405: select substr(p_transaction_id,instr(p_transaction_id,'-')+1,length(p_transaction_id))
1406: INTO l_person_id FROM dual;
1407: -- first get the effective_date from per_ben_identified_events table. we expect that there would be only one event with status 'PENDING'
1408: SELECT effective_date
1409: INTO l_effective_date
1410: FROM per_ben_identified_events
1411: WHERE status = 'Pending'

Line 1410: FROM per_ben_identified_events

1406: INTO l_person_id FROM dual;
1407: -- first get the effective_date from per_ben_identified_events table. we expect that there would be only one event with status 'PENDING'
1408: SELECT effective_date
1409: INTO l_effective_date
1410: FROM per_ben_identified_events
1411: WHERE status = 'Pending'
1412: AND person_id = l_person_id;
1413:
1414: -- get supervisor_id from assignment table as of the effective_date