APPS.PA_DISTRIBUTION_LIST_UTILS dependencies on PA_OBJECT_DIST_LISTS

Line 176: FROM pa_object_dist_lists

172: l_object_id NUMBER := p_context_object_id;
173:
174: CURSOR c_list_ids IS
175: SELECT list_id
176: FROM pa_object_dist_lists
177: WHERE object_type = p_object_type
178: AND object_id = p_object_id;
179:
180: /* Bug 2717635 in the following query, selected from table pa_project_parties

Line 257: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_OBJECT_DIST_LISTS_UTILS',

253: x_return_status := 'E';
254:
255: WHEN OTHERS THEN
256: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
257: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_OBJECT_DIST_LISTS_UTILS',
258: p_procedure_name => 'GET_ACCESS_LEVEL',
259: p_error_text => SUBSTRB(SQLERRM,1,240));
260: END get_access_level;
261:

Line 281: FROM pa_object_dist_lists

277: i NUMBER;
278:
279: CURSOR c_list_ids IS
280: SELECT list_id
281: FROM pa_object_dist_lists
282: WHERE object_type = p_object_type
283: AND object_id = p_object_id;
284:
285: --Bug# 4284420: Modified the cursor to avoid selecting end-dated fnd_users

Line 423: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_OBJECT_DIST_LISTS_UTILS',

419: x_return_status := 'E';
420: WHEN OTHERS THEN
421: --dbms_output.put_line('unhandled exception');
422: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
423: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_OBJECT_DIST_LISTS_UTILS',
424: p_procedure_name => 'GET_ACCESS_LEVEL',
425: p_error_text => SUBSTRB(SQLERRM,1,240));
426: END get_dist_list;
427:

Line 452: FROM pa_object_dist_lists

448: i NUMBER;
449:
450: CURSOR c_list_ids IS
451: SELECT list_id
452: FROM pa_object_dist_lists
453: WHERE object_type = p_object_type
454: AND object_id = p_object_id;
455:
456: /*

Line 609: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_OBJECT_DIST_LISTS_UTILS',

605: WHEN FND_API.G_EXC_ERROR THEN
606: x_return_status := 'E';
607: WHEN OTHERS THEN
608: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
609: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_OBJECT_DIST_LISTS_UTILS',
610: p_procedure_name => 'GET_DIST_LIST_EMAIL',
611: p_error_text => SUBSTRB(SQLERRM,1,240));
612: END get_dist_list_email;
613:

Line 657: FROM pa_object_dist_lists

653: WHERE page_type_code = 'PPR'
654: AND object_page_layout_id = p_object_id_to;
655:
656: CURSOR get_list_id_from IS SELECT list_id
657: FROM pa_object_dist_lists
658: WHERE object_type = p_object_type_from
659: AND object_id = p_object_id_from;
660:
661: CURSOR get_list_id_to IS SELECT list_id

Line 662: FROM pa_object_dist_lists

658: WHERE object_type = p_object_type_from
659: AND object_id = p_object_id_from;
660:
661: CURSOR get_list_id_to IS SELECT list_id
662: FROM pa_object_dist_lists
663: WHERE object_type = p_object_type_to
664: AND object_id = p_object_id_to;
665:
666: CURSOR get_project_party_to IS SELECT b.project_party_id

Line 717: -- create new entry into pa_object_dist_lists table

713: IF x_return_status<>'S' THEN
714: RETURN;
715: END IF;
716:
717: -- create new entry into pa_object_dist_lists table
718:
719: PA_OBJECT_DIST_LISTS_PVT.CREATE_OBJECT_DIST_LIST(P_VALIDATE_ONLY => 'F',
720: P_LIST_ID => l_list_id_to,
721: P_OBJECT_TYPE => p_object_type_to,

Line 719: PA_OBJECT_DIST_LISTS_PVT.CREATE_OBJECT_DIST_LIST(P_VALIDATE_ONLY => 'F',

715: END IF;
716:
717: -- create new entry into pa_object_dist_lists table
718:
719: PA_OBJECT_DIST_LISTS_PVT.CREATE_OBJECT_DIST_LIST(P_VALIDATE_ONLY => 'F',
720: P_LIST_ID => l_list_id_to,
721: P_OBJECT_TYPE => p_object_type_to,
722: P_OBJECT_ID => p_object_id_to,
723: x_return_status => x_return_status,