APPS.PER_EVENTS_PKG dependencies on PER_LETTER_REQUESTS

Line 332: --* Inserts a row in per_letter_requests for an interview, as long as there *

328: --------------------------------------------------------------------------------
329: procedure REQUEST_LETTER (
330: --
331: --******************************************************************************
332: --* Inserts a row in per_letter_requests for an interview, as long as there *
333: --* are no pending entries for the letter type and an automatic letter is *
334: --* required. *
335: --******************************************************************************
336: --

Line 363: FROM PER_LETTER_REQUESTS PLR,

359: --
360: --fix for bug 7019343 starts here.
361: CURSOR csr_check_manual_or_auto IS
362: SELECT 1
363: FROM PER_LETTER_REQUESTS PLR,
364: PER_LETTER_GEN_STATUSES PLGS
365: WHERE PLGS.business_group_id + 0 = p_business_group_id
366: AND PLR.business_group_id +0 = p_business_group_id
367: AND PLGS.assignment_status_type_id = p_assignment_status_type_id

Line 401: insert into per_letter_requests

397:
398: if (nvl(fnd_profile.value('HR_LETTER_BY_VACANCY'),'N')='Y') then
399:
400: hr_utility.set_location('HR_LETTER_BY_VACANCY = Y',10);
401: insert into per_letter_requests
402: ( letter_request_id
403: , business_group_id
404: , letter_type_id
405: , request_status

Line 414: select per_letter_requests_s.nextval

410: , last_update_login
411: , created_by
412: , creation_date
413: , vacancy_id)
414: select per_letter_requests_s.nextval
415: , p_business_group_id
416: , s.letter_type_id
417: , 'PENDING'
418: , 'AUTO'

Line 432: from per_letter_requests r

428: and s.assignment_status_type_id = p_assignment_status_type_id
429: and s.enabled_flag = 'Y'
430: and not exists
431: (select null
432: from per_letter_requests r
433: where r.letter_type_id = s.letter_type_id
434: and r.business_group_id + 0 = p_business_group_id
435: and r.business_group_id + 0 = s.business_group_id
436: and r.request_status = 'PENDING'

Line 471: from per_letter_requests r

467: , p_user
468: , p_login_id
469: , p_user
470: , sysdate
471: from per_letter_requests r
472: where exists
473: (select null
474: from per_letter_gen_statuses s
475: where s.letter_type_id = r.letter_type_id

Line 494: insert into per_letter_requests

490: and r.vacancy_id = l_vacancy_id;
491: else
492:
493: -- Profile HR: Letter by Vacancy has not been set to Yes
494: insert into per_letter_requests
495: ( letter_request_id
496: , business_group_id
497: , letter_type_id
498: , request_status

Line 507: select per_letter_requests_s.nextval

503: , last_update_login
504: , created_by
505: , creation_date
506: , vacancy_id)
507: select per_letter_requests_s.nextval
508: , p_business_group_id
509: , s.letter_type_id
510: , 'PENDING'
511: , 'AUTO'

Line 525: from per_letter_requests r

521: and s.assignment_status_type_id = p_assignment_status_type_id
522: and s.enabled_flag = 'Y'
523: and not exists
524: (select null
525: from per_letter_requests r
526: where r.letter_type_id = s.letter_type_id
527: and r.business_group_id + 0 = p_business_group_id
528: and r.business_group_id + 0 = s.business_group_id
529: and r.request_status = 'PENDING'

Line 564: from per_letter_requests r

560: , p_user
561: , p_login_id
562: , p_user
563: , sysdate
564: from per_letter_requests r
565: where exists
566: (select null
567: from per_letter_gen_statuses s
568: where s.letter_type_id = r.letter_type_id