[Home] [Help]
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,
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,