DBA Data[Home] [Help]

APPS.IMC_RECENT_OBJECT_ACCESS_PUB dependencies on FND_PROFILE

Line 312: -- l_max_records := NVL(FND_PROFILE.value(g_store_max_profile), g_default_max_store);

308: -- dbms_output.put_line('l_new_access_id = ' || l_new_access_id);
309: -- dbms_output.put_line('l_object_version_number = ' || l_object_version_number);
310: -- dbms_output.put_line('l_last_update_login = ' || l_last_update_login);
311:
312: -- l_max_records := NVL(FND_PROFILE.value(g_store_max_profile), g_default_max_store);
313: l_max_records := NVL(FND_PROFILE.value(g_display_max_profile), g_default_max_display);
314: -- dbms_output.put_line('l_max_records = ' || l_max_records);
315:
316: -- l_maintain := NVL(FND_PROFILE.value(g_maintenance_profile), g_default_maintenance);

Line 313: l_max_records := NVL(FND_PROFILE.value(g_display_max_profile), g_default_max_display);

309: -- dbms_output.put_line('l_object_version_number = ' || l_object_version_number);
310: -- dbms_output.put_line('l_last_update_login = ' || l_last_update_login);
311:
312: -- l_max_records := NVL(FND_PROFILE.value(g_store_max_profile), g_default_max_store);
313: l_max_records := NVL(FND_PROFILE.value(g_display_max_profile), g_default_max_display);
314: -- dbms_output.put_line('l_max_records = ' || l_max_records);
315:
316: -- l_maintain := NVL(FND_PROFILE.value(g_maintenance_profile), g_default_maintenance);
317: -- Table will now be maintained, by default.

Line 316: -- l_maintain := NVL(FND_PROFILE.value(g_maintenance_profile), g_default_maintenance);

312: -- l_max_records := NVL(FND_PROFILE.value(g_store_max_profile), g_default_max_store);
313: l_max_records := NVL(FND_PROFILE.value(g_display_max_profile), g_default_max_display);
314: -- dbms_output.put_line('l_max_records = ' || l_max_records);
315:
316: -- l_maintain := NVL(FND_PROFILE.value(g_maintenance_profile), g_default_maintenance);
317: -- Table will now be maintained, by default.
318: l_maintain := 'Y';
319: -- dbms_output.put_line('l_maintain = ' || l_maintain);
320:

Line 496: l_max_records := NVL(FND_PROFILE.value(g_display_max_profile), g_default_max_display);

492: 'AND object_version_number = ' || p_object_version_number || ' ';
493: END IF;
494:
495: /* Only return the number of records specified in the profile */
496: l_max_records := NVL(FND_PROFILE.value(g_display_max_profile), g_default_max_display);
497:
498: l_where_clause := l_where_clause ||
499: 'AND ROWNUM <= ' || l_max_records || ' ';
500:

Line 574: -- l_max_records := NVL(FND_PROFILE.value(g_store_max_profile), g_default_max_store);

570: FND_MESSAGE.SET_NAME('IMC', g_invalid_user_id);
571: FND_MSG_PUB.ADD;
572: RAISE FND_API.G_EXC_ERROR;
573: ELSE
574: -- l_max_records := NVL(FND_PROFILE.value(g_store_max_profile), g_default_max_store);
575: l_max_records := NVL(FND_PROFILE.value(g_display_max_profile), g_default_max_display);
576: x_flush_count := 0;
577:
578: OPEN records_for_this_user;

Line 575: l_max_records := NVL(FND_PROFILE.value(g_display_max_profile), g_default_max_display);

571: FND_MSG_PUB.ADD;
572: RAISE FND_API.G_EXC_ERROR;
573: ELSE
574: -- l_max_records := NVL(FND_PROFILE.value(g_store_max_profile), g_default_max_store);
575: l_max_records := NVL(FND_PROFILE.value(g_display_max_profile), g_default_max_display);
576: x_flush_count := 0;
577:
578: OPEN records_for_this_user;
579: