APPS.PA_DISTRIBUTION_LIST_UTILS dependencies on PA_DISTRIBUTION_LISTS

Line 9: Select 'X' from pa_distribution_lists

5: p_list_id in Number )
6: return boolean
7: IS
8: Cursor C1 is
9: Select 'X' from pa_distribution_lists
10: where list_id = p_list_id;
11:
12: l_dummy varchar2(1);
13: l_return_status boolean := TRUE;

Line 39: from pa_distribution_lists

35: return boolean
36: IS
37: Cursor C1 is
38: Select list_id
39: from pa_distribution_lists
40: where name = p_list_name
41: and (p_list_id is null
42: OR p_list_id <> list_id) ;
43:

Line 70: from pa_distribution_lists

66: return number
67: IS
68: Cursor C1 is
69: Select list_id
70: from pa_distribution_lists
71: where name = p_list_name;
72:
73: l_list_id Number := 0;
74:

Line 702: select pa_distribution_lists_s.nextVal into l_list_id_to from dual;

698:
699: OPEN get_list_id_from;
700: FETCH get_list_id_from INTO l_list_id_from;
701: CLOSE get_list_id_from;
702: select pa_distribution_lists_s.nextVal into l_list_id_to from dual;
703:
704: -- create new entry into pa_distribution_lists
705:
706: PA_DISTRIBUTION_LISTS_PVT.CREATE_DIST_LIST(P_VALIDATE_ONLY => 'F',

Line 704: -- create new entry into pa_distribution_lists

700: FETCH get_list_id_from INTO l_list_id_from;
701: CLOSE get_list_id_from;
702: select pa_distribution_lists_s.nextVal into l_list_id_to from dual;
703:
704: -- create new entry into pa_distribution_lists
705:
706: PA_DISTRIBUTION_LISTS_PVT.CREATE_DIST_LIST(P_VALIDATE_ONLY => 'F',
707: P_LIST_ID => l_list_id_to,
708: P_NAME => l_list_id_to,

Line 706: PA_DISTRIBUTION_LISTS_PVT.CREATE_DIST_LIST(P_VALIDATE_ONLY => 'F',

702: select pa_distribution_lists_s.nextVal into l_list_id_to from dual;
703:
704: -- create new entry into pa_distribution_lists
705:
706: PA_DISTRIBUTION_LISTS_PVT.CREATE_DIST_LIST(P_VALIDATE_ONLY => 'F',
707: P_LIST_ID => l_list_id_to,
708: P_NAME => l_list_id_to,
709: P_DESCRIPTION => l_list_id_to,
710: x_return_status => x_return_status,

Line 751: PA_DISTRIBUTION_LISTS_PVT.CREATE_DIST_LIST_ITEM(P_VALIDATE_ONLY => 'F',

747:
748:
749: select pa_dist_list_items_s.nextVal into l_list_item_id from dual;
750:
751: PA_DISTRIBUTION_LISTS_PVT.CREATE_DIST_LIST_ITEM(P_VALIDATE_ONLY => 'F',
752: P_LIST_ITEM_ID => l_list_item_id,
753: P_LIST_ID => l_list_id_to,
754: P_RECIPIENT_TYPE => l_recipient_type,
755: P_RECIPIENT_ID => l_recipient_id,