APPS.PA_RP_UTIL dependencies on PA_DIST_LIST_ITEMS

Line 407: Pa_Dist_List_Items_Pkg.Update_Row

403:
404: IF l_dist_list_items(i).list_item_id IS NOT NULL THEN
405:
406:
407: Pa_Dist_List_Items_Pkg.Update_Row
408: (
409: P_LIST_ITEM_ID => l_dist_list_items(i).list_item_id,
410: P_LIST_ID => l_dist_list_id,
411: P_RECIPIENT_TYPE => l_dist_list_items(i).recipient_type,

Line 425: --DBMS_OUTPUT.put_line('... before insert in Pa_Dist_List_Items_Update_Row...insert row..');

421:
422: ELSE
423:
424: -- call insert , set listItemId
425: --DBMS_OUTPUT.put_line('... before insert in Pa_Dist_List_Items_Update_Row...insert row..');
426:
427: Pa_Dist_List_Items_Pkg.INSERT_ROW
428: (
429: P_LIST_ITEM_ID => l_dist_list_item_id,

Line 427: Pa_Dist_List_Items_Pkg.INSERT_ROW

423:
424: -- call insert , set listItemId
425: --DBMS_OUTPUT.put_line('... before insert in Pa_Dist_List_Items_Update_Row...insert row..');
426:
427: Pa_Dist_List_Items_Pkg.INSERT_ROW
428: (
429: P_LIST_ITEM_ID => l_dist_list_item_id,
430: P_LIST_ID => l_dist_list_id,
431: P_RECIPIENT_TYPE => l_dist_list_items(i).recipient_type,

Line 517: pa_dist_list_items i,

513:
514: CURSOR c_project_role_emails IS
515: SELECT DISTINCT(p.email_address)
516: FROM pa_object_dist_lists o,
517: pa_dist_list_items i,
518: pa_project_parties_v p,
519: fnd_user u
520: WHERE o.object_id = p_rp_id
521: AND o.list_id = i.list_id