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 103: from pa_distribution_lists

99: return number
100: IS
101: Cursor C1 is
102: Select list_id
103: from pa_distribution_lists
104: where name = p_list_name;
105:
106: l_list_id Number := 0;
107:

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

731:
732: OPEN get_list_id_from;
733: FETCH get_list_id_from INTO l_list_id_from;
734: CLOSE get_list_id_from;
735: select pa_distribution_lists_s.nextVal into l_list_id_to from dual;
736:
737: -- create new entry into pa_distribution_lists
738:
739: PA_DISTRIBUTION_LISTS_PVT.CREATE_DIST_LIST(P_VALIDATE_ONLY => 'F',

Line 737: -- create new entry into pa_distribution_lists

733: FETCH get_list_id_from INTO l_list_id_from;
734: CLOSE get_list_id_from;
735: select pa_distribution_lists_s.nextVal into l_list_id_to from dual;
736:
737: -- create new entry into pa_distribution_lists
738:
739: PA_DISTRIBUTION_LISTS_PVT.CREATE_DIST_LIST(P_VALIDATE_ONLY => 'F',
740: P_LIST_ID => l_list_id_to,
741: P_NAME => l_list_id_to,

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

735: select pa_distribution_lists_s.nextVal into l_list_id_to from dual;
736:
737: -- create new entry into pa_distribution_lists
738:
739: PA_DISTRIBUTION_LISTS_PVT.CREATE_DIST_LIST(P_VALIDATE_ONLY => 'F',
740: P_LIST_ID => l_list_id_to,
741: P_NAME => l_list_id_to,
742: P_DESCRIPTION => l_list_id_to,
743: x_return_status => x_return_status,

Line 788: PA_DISTRIBUTION_LISTS_PVT.UPDATE_DIST_LIST_ITEM(P_VALIDATE_ONLY => 'F',

784: p_list_id => l_list_id_to,
785: p_recipient_type => l_recipient_type,
786: p_recipient_id => l_recipient_id)) THEN
787:
788: PA_DISTRIBUTION_LISTS_PVT.UPDATE_DIST_LIST_ITEM(P_VALIDATE_ONLY => 'F',
789: P_LIST_ITEM_ID => l_list_item_id,
790: P_LIST_ID => l_list_id_to,
791: P_RECIPIENT_TYPE => l_recipient_type,
792: P_RECIPIENT_ID => l_recipient_id,

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

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,
815: P_RECIPIENT_TYPE => l_recipient_type,
816: P_RECIPIENT_ID => l_recipient_id,