91: ,p_pc_all_obj.pc_desc_fields.name
92: ,p_pc_all_obj.pc_desc_fields.description
93: ,l_language
94: ,USERENV('LANG')
95: ,fnd_global.user_id
96: ,sysdate()
97: ,fnd_global.user_id
98: ,sysdate()
99: ,0);
93: ,l_language
94: ,USERENV('LANG')
95: ,fnd_global.user_id
96: ,sysdate()
97: ,fnd_global.user_id
98: ,sysdate()
99: ,0);
100:
101: END LOOP;
1324: P_LIST_ID => l_list_id,
1325: P_NAME => l_obj_name,
1326: P_DESCRIPTION => p_distr_list.description,
1327: P_RECORD_VERSION_NUMBER => NULL,
1328: P_CREATED_BY => fnd_global.user_id,
1329: P_CREATION_DATE => sysdate,
1330: P_LAST_UPDATED_BY => fnd_global.user_id,
1331: P_LAST_UPDATE_DATE => sysdate,
1332: P_LAST_UPDATE_LOGIN => fnd_global.user_id
1326: P_DESCRIPTION => p_distr_list.description,
1327: P_RECORD_VERSION_NUMBER => NULL,
1328: P_CREATED_BY => fnd_global.user_id,
1329: P_CREATION_DATE => sysdate,
1330: P_LAST_UPDATED_BY => fnd_global.user_id,
1331: P_LAST_UPDATE_DATE => sysdate,
1332: P_LAST_UPDATE_LOGIN => fnd_global.user_id
1333: );
1334:
1328: P_CREATED_BY => fnd_global.user_id,
1329: P_CREATION_DATE => sysdate,
1330: P_LAST_UPDATED_BY => fnd_global.user_id,
1331: P_LAST_UPDATE_DATE => sysdate,
1332: P_LAST_UPDATE_LOGIN => fnd_global.user_id
1333: );
1334:
1335: p_list_id := l_list_id;
1336:
1340: P_LIST_ID => l_list_id,
1341: P_OBJECT_TYPE => p_distr_list.object_type,
1342: P_OBJECT_ID => p_distr_list.object_id,
1343: P_RECORD_VERSION_NUMBER => NULL,
1344: P_CREATED_BY => fnd_global.user_id,
1345: P_CREATION_DATE => sysdate,
1346: P_LAST_UPDATED_BY => fnd_global.user_id,
1347: P_LAST_UPDATE_DATE => sysdate,
1348: P_LAST_UPDATE_LOGIN => fnd_global.user_id
1342: P_OBJECT_ID => p_distr_list.object_id,
1343: P_RECORD_VERSION_NUMBER => NULL,
1344: P_CREATED_BY => fnd_global.user_id,
1345: P_CREATION_DATE => sysdate,
1346: P_LAST_UPDATED_BY => fnd_global.user_id,
1347: P_LAST_UPDATE_DATE => sysdate,
1348: P_LAST_UPDATE_LOGIN => fnd_global.user_id
1349: );
1350:
1344: P_CREATED_BY => fnd_global.user_id,
1345: P_CREATION_DATE => sysdate,
1346: P_LAST_UPDATED_BY => fnd_global.user_id,
1347: P_LAST_UPDATE_DATE => sysdate,
1348: P_LAST_UPDATE_LOGIN => fnd_global.user_id
1349: );
1350:
1351:
1352: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1440: P_ACCESS_LEVEL => NULL,
1441: P_MENU_ID => NULL,
1442: P_EMAIL => p_distr_list_items_tbl(i).email_exists,
1443: P_RECORD_VERSION_NUMBER => NULL,
1444: P_LAST_UPDATED_BY => fnd_global.user_id,
1445: P_LAST_UPDATE_DATE => sysdate,
1446: P_LAST_UPDATE_LOGIN => fnd_global.user_id
1447: );
1448:
1442: P_EMAIL => p_distr_list_items_tbl(i).email_exists,
1443: P_RECORD_VERSION_NUMBER => NULL,
1444: P_LAST_UPDATED_BY => fnd_global.user_id,
1445: P_LAST_UPDATE_DATE => sysdate,
1446: P_LAST_UPDATE_LOGIN => fnd_global.user_id
1447: );
1448:
1449: ELSE
1450:
1460: P_ACCESS_LEVEL => NULL,
1461: P_MENU_ID => NULL,
1462: P_EMAIL => p_distr_list_items_tbl(i).email_exists,
1463: P_RECORD_VERSION_NUMBER => NULL,
1464: P_CREATED_BY => fnd_global.user_id,
1465: P_CREATION_DATE => sysdate,
1466: P_LAST_UPDATED_BY => fnd_global.user_id,
1467: P_LAST_UPDATE_DATE => sysdate,
1468: P_LAST_UPDATE_LOGIN => fnd_global.user_id
1462: P_EMAIL => p_distr_list_items_tbl(i).email_exists,
1463: P_RECORD_VERSION_NUMBER => NULL,
1464: P_CREATED_BY => fnd_global.user_id,
1465: P_CREATION_DATE => sysdate,
1466: P_LAST_UPDATED_BY => fnd_global.user_id,
1467: P_LAST_UPDATE_DATE => sysdate,
1468: P_LAST_UPDATE_LOGIN => fnd_global.user_id
1469: );
1470:
1464: P_CREATED_BY => fnd_global.user_id,
1465: P_CREATION_DATE => sysdate,
1466: P_LAST_UPDATED_BY => fnd_global.user_id,
1467: P_LAST_UPDATE_DATE => sysdate,
1468: P_LAST_UPDATE_LOGIN => fnd_global.user_id
1469: );
1470:
1471:
1472: END IF;