381: P_LAST_UPDATE_LOGIN => Fnd_Global.user_id
382: );
383:
384:
385: Pa_Object_Dist_Lists_Pkg.INSERT_ROW
386: (
387: P_LIST_ID => l_dist_list_id,
388: P_OBJECT_TYPE => 'PA_RP_LIST',
389: P_OBJECT_ID => l_rp_id,
512: l_email_list VARCHAR(4000);
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