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.PER_APPLICATIONS_PKG dependencies on PER_LETTER_REQUEST_LINES

Line 386: FROM per_letter_request_lines l

382: AND PLG.ENABLED_FLAG = 'Y';
383:
384: CURSOR c_chk_lines IS
385: SELECT distinct(1)
386: FROM per_letter_request_lines l
387: WHERE L.person_id = p_person_id
388: AND l.business_group_id + 0 = p_business_group_id
389: AND l.assignment_status_type_id = P_dummy_asg_stat_id
390: AND EXISTS

Line 405: FROM per_letter_request_lines L

401: SELECT 1
402: FROM per_letter_requests r
403: WHERE NOT EXISTS
404: (SELECT NULL
405: FROM per_letter_request_lines L
406: WHERE r.letter_request_id = l.letter_request_id);
407:
408:
409: ----

Line 426: DELETE FROM PER_LETTER_REQUEST_LINES l

422: OPEN c_chk_lines;
423: FETCH c_chk_lines INTO v_lines_exist;
424: IF c_chk_lines%FOUND THEN
425: CLOSE c_chk_lines;
426: DELETE FROM PER_LETTER_REQUEST_LINES l
427: WHERE l.person_id = p_person_id
428: AND l.assignment_status_type_id = P_dummy_asg_stat_id
429: AND l.business_group_id + 0 = p_business_group_id;
430: --

Line 442: FROM Per_letter_request_lines l

438: AND r.request_status = 'PENDING'
439: AND r.auto_or_manual = 'AUTO'
440: AND NOT EXISTS
441: (SELECT null
442: FROM Per_letter_request_lines l
443: WHERE l.letter_request_id = r.letter_request_id
444: AND l.business_group_id + 0 = p_business_group_id);
445: --
446: ELSE CLOSE c_chk_empty_requests;

Line 578: INSERT INTO PER_LETTER_REQUEST_LINES

574: OPEN csr_let_req;
575: LOOP
576: FETCH csr_let_req into v_letter_request_id,v_letter_type;
577: EXIT when csr_let_req%NOTFOUND;
578: INSERT INTO PER_LETTER_REQUEST_LINES
579: (
580: LETTER_REQUEST_LINE_ID
581: , BUSINESS_GROUP_ID
582: , LETTER_REQUEST_ID

Line 593: PER_LETTER_REQUEST_LINES_S.nextval

589: , LAST_UPDATE_LOGIN
590: , CREATED_BY
591: , CREATION_DATE)
592: select
593: PER_LETTER_REQUEST_LINES_S.nextval
594: , p_business_group_id
595: , v_letter_request_id
596: , p_person_id
597: , a.ASSIGNMENT_ID

Line 621: from PER_LETTER_REQUEST_LINES l

617: AND a.PERSON_ID = p_person_id
618: AND a.APPLICATION_ID = p_application_id
619: and not exists
620: (select null
621: from PER_LETTER_REQUEST_LINES l
622: where l.PERSON_ID = p_person_id
623: AND A.PERSON_ID = p_person_id
624: and l.ASSIGNMENT_ID = a.ASSIGNMENT_ID
625: and l.ASSIGNMENT_STATUS_TYPE_ID =

Line 675: INSERT INTO PER_LETTER_REQUEST_LINES

671: OPEN csr_assign;
672: LOOP
673: FETCH csr_assign INTO v_assignment_id;
674: EXIT WHEN csr_assign%NOTFOUND;
675: INSERT INTO PER_LETTER_REQUEST_LINES
676: (
677: LETTER_REQUEST_LINE_ID
678: , BUSINESS_GROUP_ID
679: , LETTER_REQUEST_ID

Line 690: PER_LETTER_REQUEST_LINES_S.nextval

686: , LAST_UPDATE_LOGIN
687: , CREATED_BY
688: , CREATION_DATE)
689: select
690: PER_LETTER_REQUEST_LINES_S.nextval
691: , P_Business_group_id
692: , r.LETTER_REQUEST_ID
693: , P_person_id
694: , v_assignment_id

Line 714: FROM per_letter_request_lines L

710: AND r.DATE_FROM = p_session_date
711: AND s.ENABLED_FLAG = 'Y'
712: AND NOT EXISTS
713: (SELECT NULL
714: FROM per_letter_request_lines L
715: WHERE L.person_id = P_person_id
716: AND L.assignment_id = v_assignment_id
717: AND L.assignment_status_type_id =
718: p_assignment_status_type_id

Line 761: FROM per_letter_request_lines L

757: AND s.enabled_flag = 'Y';
758:
759: CURSOR c_chk_lines IS
760: SELECT distinct(1)
761: FROM per_letter_request_lines L
762: , per_assignments_f a
763: WHERE l.person_id = P_person_id
764: AND l.business_group_id + 0 = p_business_group_id
765: AND l.assignment_id = a.assignment_id

Line 800: from PER_LETTER_REQUEST_LINES l

796: and R.REQUEST_STATUS = 'PENDING'
797: and R.AUTO_OR_MANUAL = 'AUTO'
798: and not exists
799: (select null
800: from PER_LETTER_REQUEST_LINES l
801: where l.LETTER_REQUEST_ID = R.LETTER_REQUEST_ID
802: and l.business_group_id + 0 = r.business_group_id + 0
803: and l.business_group_id + 0 = p_business_group_id);
804:

Line 827: DELETE FROM per_letter_request_lines lrL

823: IF csr_let_req_id%FOUND THEN
824: CLOSE csr_let_req_id;
825: FOR csr_let_req_id_rec IN csr_let_req_id LOOP
826: --
827: DELETE FROM per_letter_request_lines lrL
828: WHERE lrl.business_group_id + 0 = p_business_group_id
829: AND lrl.letter_request_id =
830: csr_let_req_id_REC.letter_request_id
831: AND lrl.person_id = P_person_id