APPS.PA_PERF_NOTIFICATION_PKG dependencies on PA_DISTRIBUTION_LIST_UTILS

Line 247: l_user_names pa_distribution_list_utils.pa_vc_1000_150 := null;

243: language VARCHAR2(2000);
244: territory VARCHAR2(2000);
245: l_priority_name pa_lookups.meaning%TYPE;
246: l_object_page_layout_id NUMBER;
247: l_user_names pa_distribution_list_utils.pa_vc_1000_150 := null;
248: l_full_names pa_distribution_list_utils.pa_vc_1000_150 := null;
249: l_email_addresses pa_distribution_list_utils.pa_vc_1000_150 := null;
250:
251: -- This Cursor gets the Pageid and PageType associated with the Automatic Report Type for the Project

Line 248: l_full_names pa_distribution_list_utils.pa_vc_1000_150 := null;

244: territory VARCHAR2(2000);
245: l_priority_name pa_lookups.meaning%TYPE;
246: l_object_page_layout_id NUMBER;
247: l_user_names pa_distribution_list_utils.pa_vc_1000_150 := null;
248: l_full_names pa_distribution_list_utils.pa_vc_1000_150 := null;
249: l_email_addresses pa_distribution_list_utils.pa_vc_1000_150 := null;
250:
251: -- This Cursor gets the Pageid and PageType associated with the Automatic Report Type for the Project
252: CURSOR get_page( c_object_id NUMBER)

Line 249: l_email_addresses pa_distribution_list_utils.pa_vc_1000_150 := null;

245: l_priority_name pa_lookups.meaning%TYPE;
246: l_object_page_layout_id NUMBER;
247: l_user_names pa_distribution_list_utils.pa_vc_1000_150 := null;
248: l_full_names pa_distribution_list_utils.pa_vc_1000_150 := null;
249: l_email_addresses pa_distribution_list_utils.pa_vc_1000_150 := null;
250:
251: -- This Cursor gets the Pageid and PageType associated with the Automatic Report Type for the Project
252: CURSOR get_page( c_object_id NUMBER)
253: IS

Line 358: PA_DISTRIBUTION_LIST_UTILS.get_dist_list(

354: END LOOP;
355:
356:
357:
358: PA_DISTRIBUTION_LIST_UTILS.get_dist_list(
359: p_object_type => 'PA_OBJECT_PAGE_LAYOUT',
360: p_object_id => l_object_page_layout_id,
361: p_access_level => 1, -- view priv
362: x_user_names => l_user_names,