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.PA_DISTRIBUTION_LIST_UTILS dependencies on PA_DIST_LIST_ITEMS

Line 73: from pa_dist_list_items

69: return boolean
70: IS
71: Cursor C1 is
72: Select list_item_id
73: from pa_dist_list_items
74: where list_id = p_list_id
75: and recipient_type = p_recipient_type
76: and recipient_id = p_recipient_id;
77:

Line 223: FROM pa_dist_list_items i,

219:
220: CURSOR c_access_level(cp_list_id NUMBER) IS -- Bug 2717635
221: SELECT MAX(access_level) access_level FROM (
222: SELECT access_level
223: FROM pa_dist_list_items i,
224: pa_project_parties p -- Bug 2717635
225: WHERE i.list_id = cp_list_id
226: AND i.recipient_type = 'PROJECT_PARTY'
227: AND p.project_party_id = i.recipient_id

Line 233: FROM pa_dist_list_items i,

229: AND p.object_type = l_object_type
230: AND p.object_id = l_object_id
231: UNION ALL
232: SELECT access_level
233: FROM pa_dist_list_items i,
234: pa_project_parties p -- Bug 2717635
235: /* fnd_user u */ -- Bug 2717635
236: WHERE i.list_id = cp_list_id
237: AND i.recipient_type = 'PROJECT_ROLE'

Line 244: FROM pa_dist_list_items

240: AND p.object_type = l_object_type
241: AND p.object_id = l_object_id
242: UNION ALL
243: SELECT access_level
244: FROM pa_dist_list_items
245: WHERE list_id = cp_list_id
246: AND recipient_type = 'ALL_PROJECT_PARTIES'
247: AND EXISTS (SELECT 'Y' FROM pa_project_parties -- Bug 2717635
248: WHERE resource_id = l_resource_id -- Bug 2717635

Line 253: FROM pa_dist_list_items

249: AND object_type = l_object_type
250: AND object_id = l_object_id)
251: UNION ALL
252: SELECT access_level
253: FROM pa_dist_list_items
254: WHERE list_id = cp_list_id
255: AND recipient_type = 'HZ_PARTY'
256: AND recipient_id = l_party_id);
257:

Line 324: FROM pa_dist_list_items i,

320: SELECT DISTINCT user_name, full_name, email_address FROM (
321: SELECT p.user_name user_name,
322: p.resource_source_name full_name,
323: p.email_address email_address
324: FROM pa_dist_list_items i,
325: pa_project_parties_v p,
326: fnd_user u
327: WHERE i.list_id = cp_list_id
328: AND i.access_level >= p_access_level

Line 340: FROM pa_dist_list_items i,

336: UNION ALL
337: SELECT p.user_name user_name,
338: p.resource_source_name full_name,
339: p.email_address email_address
340: FROM pa_dist_list_items i,
341: pa_project_parties_v p,
342: fnd_user u
343: WHERE i.list_id = cp_list_id
344: AND i.access_level >= p_access_level

Line 358: WHERE EXISTS (SELECT 1 FROM pa_dist_list_items i

354: p.resource_source_name full_name,
355: p.email_address email_address
356: FROM pa_project_parties_v p,
357: fnd_user u
358: WHERE EXISTS (SELECT 1 FROM pa_dist_list_items i
359: WHERE i.list_id = cp_list_id
360: AND i.access_level >= p_access_level
361: AND i.recipient_type = 'ALL_PROJECT_PARTIES')
362: AND p.object_type = l_object_type

Line 371: FROM pa_dist_list_items i,

367: UNION ALL
368: SELECT u.user_name user_name,
369: hzp.party_name full_name,
370: hzp.email_address email_address
371: FROM pa_dist_list_items i,
372: hz_parties hzp,
373: fnd_user u
374: WHERE i.list_id = cp_list_id
375: AND i.access_level >= p_access_level

Line 386: FROM pa_dist_list_items i,

382: UNION ALL
383: SELECT u.user_name user_name,
384: per.full_name full_name,
385: per.email_address email_address
386: FROM pa_dist_list_items i,
387: per_all_people_f per,
388: fnd_user u
389: WHERE i.list_id = cp_list_id
390: AND i.access_level >= p_access_level

Line 402: FROM pa_dist_list_items i

398: UNION ALL
399: SELECT NULL user_name,
400: NULL full_name,
401: recipient_id email_address
402: FROM pa_dist_list_items i
403: WHERE i.list_id = cp_list_id
404: AND i.access_level >= p_access_level
405: AND i.recipient_type = 'EMAIL_ADDRESS');
406:

Line 491: * in pa_dist_list_items.

487: AND object_id = p_object_id;
488:
489: /*
490: * 1. Modified this cursor to filter out records based on the value of the email column
491: * in pa_dist_list_items.
492: * 2. Retrieve all team members if 'Send Status Report by email to all project team members'
493: * is selected.
494: * 3. Removed the condition SELECT for ALL_PROJECT_PARTIES as this has nothing to do with
495: * email notifications.

Line 503: FROM pa_dist_list_items i,

499: SELECT DISTINCT user_name, full_name, email_address FROM (
500: SELECT p.user_name user_name,
501: p.resource_source_name full_name,
502: p.email_address email_address
503: FROM pa_dist_list_items i,
504: pa_project_parties_v p,
505: fnd_user u
506: WHERE i.list_id = cp_list_id
507: AND i.access_level >= p_access_level

Line 520: FROM pa_dist_list_items i,

516: UNION ALL
517: SELECT p.user_name user_name,
518: p.resource_source_name full_name,
519: p.email_address email_address
520: FROM pa_dist_list_items i,
521: pa_project_parties_v p,
522: fnd_user u
523: WHERE i.list_id = cp_list_id
524: AND i.access_level >= p_access_level

Line 537: FROM pa_dist_list_items i,

533: UNION ALL
534: SELECT u.user_name user_name,
535: hzp.party_name full_name,
536: hzp.email_address email_address
537: FROM pa_dist_list_items i,
538: hz_parties hzp,
539: fnd_user u
540: WHERE i.list_id = cp_list_id
541: AND i.access_level >= p_access_level

Line 553: FROM pa_dist_list_items i,

549: UNION ALL
550: SELECT u.user_name user_name,
551: per.full_name full_name,
552: per.email_address email_address
553: FROM pa_dist_list_items i,
554: per_all_people_f per,
555: fnd_user u
556: WHERE i.list_id = cp_list_id
557: AND i.access_level >= p_access_level

Line 570: FROM pa_dist_list_items i

566: UNION ALL
567: SELECT NULL user_name,
568: NULL full_name,
569: recipient_id email_address
570: FROM pa_dist_list_items i
571: WHERE i.list_id = cp_list_id
572: AND i.access_level >= p_access_level
573: AND i.recipient_type = 'EMAIL_ADDRESS'
574: AND nvl(i.email, 'Y') <> 'N'

Line 583: FROM pa_dist_list_items i

579: p.email_address email_address
580: FROM pa_project_parties_v p,
581: fnd_user u
582: WHERE EXISTS ( SELECT 1
583: FROM pa_dist_list_items i
584: WHERE i.list_id = cp_list_id
585: AND i.access_level >= p_access_level
586: AND i.recipient_type = 'EMAIL_ALL'
587: )

Line 709: FROM pa_dist_list_items

705: AND b.resource_source_id = a.resource_source_id
706: AND b.project_role_id = a.project_role_id;
707:
708: CURSOR get_list_items IS SELECT recipient_type, recipient_id, access_level, email, menu_id
709: FROM pa_dist_list_items
710: WHERE list_id = l_list_id_from;
711:
712:
713: BEGIN

Line 810: select pa_dist_list_items_s.nextVal into l_list_item_id from dual;

806: -- copy project we can avoid creating dist list items for such receipients and
807: -- proceed.
808: IF l_recipient_id IS NOT NULL THEN
809:
810: select pa_dist_list_items_s.nextVal into l_list_item_id from dual;
811:
812: PA_DISTRIBUTION_LISTS_PVT.CREATE_DIST_LIST_ITEM(P_VALIDATE_ONLY => 'F',
813: P_LIST_ITEM_ID => l_list_item_id,
814: P_LIST_ID => l_list_id_to,

Line 839: Select 'X' from pa_dist_list_items

835: p_list_item_id in Number )
836: return VARCHAR2
837: IS
838: Cursor C1 is
839: Select 'X' from pa_dist_list_items
840: where list_item_id = p_list_item_id;
841:
842: l_dummy varchar2(1);
843: l_return_status varchar2(1) := 'T';