373: P_LIST_ID => l_dist_list_id,
374: P_NAME => 'Reportin pack distribution list',
375: P_DESCRIPTION => l_rp_id,
376: P_RECORD_VERSION_NUMBER => NULL,
377: P_CREATED_BY => Fnd_Global.user_id,
378: P_CREATION_DATE => SYSDATE,
379: P_LAST_UPDATED_BY => Fnd_Global.user_id,
380: P_LAST_UPDATE_DATE => SYSDATE,
381: P_LAST_UPDATE_LOGIN => Fnd_Global.user_id
375: P_DESCRIPTION => l_rp_id,
376: P_RECORD_VERSION_NUMBER => NULL,
377: P_CREATED_BY => Fnd_Global.user_id,
378: P_CREATION_DATE => SYSDATE,
379: P_LAST_UPDATED_BY => Fnd_Global.user_id,
380: P_LAST_UPDATE_DATE => SYSDATE,
381: P_LAST_UPDATE_LOGIN => Fnd_Global.user_id
382: );
383:
377: P_CREATED_BY => Fnd_Global.user_id,
378: P_CREATION_DATE => SYSDATE,
379: P_LAST_UPDATED_BY => Fnd_Global.user_id,
380: P_LAST_UPDATE_DATE => SYSDATE,
381: P_LAST_UPDATE_LOGIN => Fnd_Global.user_id
382: );
383:
384:
385: Pa_Object_Dist_Lists_Pkg.INSERT_ROW
387: P_LIST_ID => l_dist_list_id,
388: P_OBJECT_TYPE => 'PA_RP_LIST',
389: P_OBJECT_ID => l_rp_id,
390: P_RECORD_VERSION_NUMBER => NULL,
391: P_CREATED_BY => Fnd_Global.user_id,
392: P_CREATION_DATE => SYSDATE,
393: P_LAST_UPDATED_BY => Fnd_Global.user_id,
394: P_LAST_UPDATE_DATE => SYSDATE,
395: P_LAST_UPDATE_LOGIN => Fnd_Global.user_id
389: P_OBJECT_ID => l_rp_id,
390: P_RECORD_VERSION_NUMBER => NULL,
391: P_CREATED_BY => Fnd_Global.user_id,
392: P_CREATION_DATE => SYSDATE,
393: P_LAST_UPDATED_BY => Fnd_Global.user_id,
394: P_LAST_UPDATE_DATE => SYSDATE,
395: P_LAST_UPDATE_LOGIN => Fnd_Global.user_id
396: );
397: END IF;
391: P_CREATED_BY => Fnd_Global.user_id,
392: P_CREATION_DATE => SYSDATE,
393: P_LAST_UPDATED_BY => Fnd_Global.user_id,
394: P_LAST_UPDATE_DATE => SYSDATE,
395: P_LAST_UPDATE_LOGIN => Fnd_Global.user_id
396: );
397: END IF;
398:
399: IF l_dist_list_items IS NOT NULL THEN
413: P_ACCESS_LEVEL => NULL,
414: P_MENU_ID => NULL,
415: P_EMAIL => l_dist_list_items(i).email_exists,
416: P_RECORD_VERSION_NUMBER => NULL,
417: P_LAST_UPDATED_BY => Fnd_Global.user_id,
418: P_LAST_UPDATE_DATE => SYSDATE,
419: P_LAST_UPDATE_LOGIN => Fnd_Global.user_id
420: );
421:
415: P_EMAIL => l_dist_list_items(i).email_exists,
416: P_RECORD_VERSION_NUMBER => NULL,
417: P_LAST_UPDATED_BY => Fnd_Global.user_id,
418: P_LAST_UPDATE_DATE => SYSDATE,
419: P_LAST_UPDATE_LOGIN => Fnd_Global.user_id
420: );
421:
422: ELSE
423:
433: P_ACCESS_LEVEL => NULL,
434: P_MENU_ID => NULL,
435: P_EMAIL => l_dist_list_items(i).email_exists,
436: P_RECORD_VERSION_NUMBER => NULL,
437: P_LAST_UPDATED_BY => Fnd_Global.user_id,
438: P_LAST_UPDATE_DATE => SYSDATE,
439: P_LAST_UPDATE_LOGIN => Fnd_Global.user_id,
440: P_CREATED_BY => Fnd_Global.user_id,
441: P_CREATION_DATE => SYSDATE
435: P_EMAIL => l_dist_list_items(i).email_exists,
436: P_RECORD_VERSION_NUMBER => NULL,
437: P_LAST_UPDATED_BY => Fnd_Global.user_id,
438: P_LAST_UPDATE_DATE => SYSDATE,
439: P_LAST_UPDATE_LOGIN => Fnd_Global.user_id,
440: P_CREATED_BY => Fnd_Global.user_id,
441: P_CREATION_DATE => SYSDATE
442: );
443:
436: P_RECORD_VERSION_NUMBER => NULL,
437: P_LAST_UPDATED_BY => Fnd_Global.user_id,
438: P_LAST_UPDATE_DATE => SYSDATE,
439: P_LAST_UPDATE_LOGIN => Fnd_Global.user_id,
440: P_CREATED_BY => Fnd_Global.user_id,
441: P_CREATION_DATE => SYSDATE
442: );
443:
444:
483: , p_rp_id
484: , p_param_names(l_i)
485: , p_param_values(l_i)
486: , SYSDATE()
487: , Fnd_Global.user_id
488: , SYSDATE()
489: , Fnd_Global.user_id
490: , Fnd_Global.login_id);
491:
485: , p_param_values(l_i)
486: , SYSDATE()
487: , Fnd_Global.user_id
488: , SYSDATE()
489: , Fnd_Global.user_id
490: , Fnd_Global.login_id);
491:
492:
493:
486: , SYSDATE()
487: , Fnd_Global.user_id
488: , SYSDATE()
489: , Fnd_Global.user_id
490: , Fnd_Global.login_id);
491:
492:
493:
494: IF g_debug_mode = 'Y' THEN