DBA Data[Home] [Help]

APPS.MSC_UTIL dependencies on FND_APPLICATION

Line 480: FROM fnd_application

476: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'Creating Snapshot Log for ' ||p_table||' ...');
477:
478: SELECT application_short_name
479: into lappshortname
480: FROM fnd_application
481: WHERE application_id = p_appl_id;
482:
483: v_sql_stmt:=
484: ' CREATE SNAPSHOT LOG ON '||p_schema ||'.'||p_table||' WITH ROWID ' ;

Line 633: FROM fnd_application

629:
630:
631: SELECT application_short_name
632: INTO lv_appl_short_nm
633: FROM fnd_application
634: WHERE application_id=724;
635:
636: IF p_schema = MSC_UTIL.G_APPS_SCHEMA THEN
637:

Line 715: FROM fnd_application

711: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'Creating Snapshot for '||p_table||' ...');
712:
713: SELECT application_short_name
714: INTO lv_appl_short_nm
715: FROM fnd_application
716: WHERE application_id=724;
717:
718: IF p_schema = MSC_UTIL.G_APPS_SCHEMA THEN
719: return CREATE_SNAP2_AS( p_table,

Line 854: FROM fnd_application

850:
851:
852: SELECT application_short_name
853: INTO lv_appl_short_nm
854: FROM fnd_application
855: WHERE application_id=724;
856:
857: IF p_schema = MSC_UTIL.G_APPS_SCHEMA THEN
858:

Line 903: FROM fnd_application

899:
900:
901: SELECT application_short_name
902: INTO lv_appl_short_nm
903: FROM fnd_application
904: WHERE application_id=724;
905:
906: IF p_schema = MSC_UTIL.G_APPS_SCHEMA THEN
907: