DBA Data[Home] [Help]

APPS.MSC_SNAPSHOT_PK dependencies on FND_INSTALLATION

Line 839: lv_retval := FND_INSTALLATION.GET_APP_INFO ( 'MSC', lv_dummy1, lv_dummy2, lv_msc_schema);

835: /* DBMS_MVIEW.REFRESH ('MSC_ITEM_SO_SR_LEVELS_MV','c');
836: DBMS_MVIEW.REFRESH ('MSC_ITEM_FCST_SR_LEVELS_MV','c');*/
837:
838: IF p_plan_id is NULL THEN
839: lv_retval := FND_INSTALLATION.GET_APP_INFO ( 'MSC', lv_dummy1, lv_dummy2, lv_msc_schema);
840:
841: lv_sql_stmt:= 'TRUNCATE TABLE '||lv_msc_schema||'.MSC_ITEM_SO_SR_LEVELS';
842: EXECUTE IMMEDIATE lv_sql_stmt;
843:

Line 2013: lv_retval := FND_INSTALLATION.GET_APP_INFO ( 'MSC', lv_dummy1, lv_dummy2, lv_msc_schema);

2009:
2010: --Fetch the profile values
2011: lv_share_partition := fnd_profile.value('MSC_SHARE_PARTITIONS');
2012: lv_parallel_run := fnd_profile.value('MSC_PARALLEL_PLAN_RUN');
2013: lv_retval := FND_INSTALLATION.GET_APP_INFO ( 'MSC', lv_dummy1, lv_dummy2, lv_msc_schema);
2014:
2015: -- If share partitions or parallel run, use the delete coomand
2016: -- Else use the truncate partition
2017: IF (lv_share_partition = 'Y' or lv_parallel_run = 'Y') THEN