APPS.PA_DISTRIBUTION_LIST_UTILS dependencies on PA_OBJECT_DIST_LISTS

Line 209: FROM pa_object_dist_lists

205: l_object_id NUMBER := p_context_object_id;
206:
207: CURSOR c_list_ids IS
208: SELECT list_id
209: FROM pa_object_dist_lists
210: WHERE object_type = p_object_type
211: AND object_id = p_object_id;
212:
213: /* Bug 2717635 in the following query, selected from table pa_project_parties

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

286: x_return_status := 'E';
287:
288: WHEN OTHERS THEN
289: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
290: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_OBJECT_DIST_LISTS_UTILS',
291: p_procedure_name => 'GET_ACCESS_LEVEL',
292: p_error_text => SUBSTRB(SQLERRM,1,240));
293: END get_access_level;
294:

Line 314: FROM pa_object_dist_lists

310: i NUMBER;
311:
312: CURSOR c_list_ids IS
313: SELECT list_id
314: FROM pa_object_dist_lists
315: WHERE object_type = p_object_type
316: AND object_id = p_object_id;
317:
318: --Bug# 4284420: Modified the cursor to avoid selecting end-dated fnd_users

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

452: x_return_status := 'E';
453: WHEN OTHERS THEN
454: --dbms_output.put_line('unhandled exception');
455: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
456: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_OBJECT_DIST_LISTS_UTILS',
457: p_procedure_name => 'GET_ACCESS_LEVEL',
458: p_error_text => SUBSTRB(SQLERRM,1,240));
459: END get_dist_list;
460:

Line 485: FROM pa_object_dist_lists

481: i NUMBER;
482:
483: CURSOR c_list_ids IS
484: SELECT list_id
485: FROM pa_object_dist_lists
486: WHERE object_type = p_object_type
487: AND object_id = p_object_id;
488:
489: /*

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

638: WHEN FND_API.G_EXC_ERROR THEN
639: x_return_status := 'E';
640: WHEN OTHERS THEN
641: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
642: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_OBJECT_DIST_LISTS_UTILS',
643: p_procedure_name => 'GET_DIST_LIST_EMAIL',
644: p_error_text => SUBSTRB(SQLERRM,1,240));
645: END get_dist_list_email;
646:

Line 690: FROM pa_object_dist_lists

686: WHERE page_type_code = 'PPR'
687: AND object_page_layout_id = p_object_id_to;
688:
689: CURSOR get_list_id_from IS SELECT list_id
690: FROM pa_object_dist_lists
691: WHERE object_type = p_object_type_from
692: AND object_id = p_object_id_from;
693:
694: CURSOR get_list_id_to IS SELECT list_id

Line 695: FROM pa_object_dist_lists

691: WHERE object_type = p_object_type_from
692: AND object_id = p_object_id_from;
693:
694: CURSOR get_list_id_to IS SELECT list_id
695: FROM pa_object_dist_lists
696: WHERE object_type = p_object_type_to
697: AND object_id = p_object_id_to;
698:
699: CURSOR get_project_party_to IS SELECT b.project_party_id

Line 750: -- create new entry into pa_object_dist_lists table

746: IF x_return_status<>'S' THEN
747: RETURN;
748: END IF;
749:
750: -- create new entry into pa_object_dist_lists table
751:
752: PA_OBJECT_DIST_LISTS_PVT.CREATE_OBJECT_DIST_LIST(P_VALIDATE_ONLY => 'F',
753: P_LIST_ID => l_list_id_to,
754: P_OBJECT_TYPE => p_object_type_to,

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

748: END IF;
749:
750: -- create new entry into pa_object_dist_lists table
751:
752: PA_OBJECT_DIST_LISTS_PVT.CREATE_OBJECT_DIST_LIST(P_VALIDATE_ONLY => 'F',
753: P_LIST_ID => l_list_id_to,
754: P_OBJECT_TYPE => p_object_type_to,
755: P_OBJECT_ID => p_object_id_to,
756: x_return_status => x_return_status,