APPS.WIP_PROD_INDICATORS dependencies on FND_STATS

Line 885: fnd_stats.gather_table_stats (g_wip_schema, 'WIP_INDICATORS_TEMP',

881: commit ;
882:
883: -- gather stats on table to allow index access
884: If nvl(WIP_CALL_LOG,-1) =1 then
885: fnd_stats.gather_table_stats (g_wip_schema, 'WIP_INDICATORS_TEMP',
886: cascade => true);
887: End If;
888: -- all successful
889: p_errnum := 0 ;

Line 1317: fnd_stats.gather_table_stats (g_wip_schema, 'WIP_INDICATORS_TEMP',

1313: COMMIT ;
1314:
1315: -- gather stats on table to allow index access
1316: If nvl(WIP_CALL_LOG,-1) =1 then
1317: fnd_stats.gather_table_stats (g_wip_schema, 'WIP_INDICATORS_TEMP',
1318: cascade => true);
1319: End If;
1320: -- Phase IV: SFCB
1321: x_phase := 'IV';

Line 1596: fnd_stats.gather_table_stats (g_wip_schema, 'WIP_INDICATORS_TEMP',

1592: commit ;
1593:
1594: -- gather stats on table to allow index access
1595: If nvl(WIP_CALL_LOG,-1) =1 then
1596: fnd_stats.gather_table_stats (g_wip_schema, 'WIP_INDICATORS_TEMP',
1597: cascade => true);
1598: End If;
1599: p_errnum := 0;
1600: p_errmesg := 0;

Line 2012: fnd_stats.gather_table_stats (g_wip_schema, 'WIP_INDICATORS_TEMP',

2008: commit ;
2009:
2010: -- gather stats on table to allow index access
2011: If nvl(WIP_CALL_LOG,-1) =1 then
2012: fnd_stats.gather_table_stats (g_wip_schema, 'WIP_INDICATORS_TEMP',
2013: cascade => true);
2014: End If;
2015: -- Step2 : Delete all the original rows (i.e. the ones
2016: -- without the resource information that were

Line 2448: fnd_stats.gather_table_stats (g_wip_schema, 'WIP_INDICATORS_TEMP',

2444: commit;
2445:
2446: -- gather stats on table to allow index access
2447: If nvl(WIP_CALL_LOG,-1) =1 then
2448: fnd_stats.gather_table_stats (g_wip_schema, 'WIP_INDICATORS_TEMP',
2449: cascade => true);
2450: End If;
2451:
2452: EXCEPTION

Line 2866: fnd_stats.gather_table_stats (g_wip_schema, 'WIP_BIS_PROD_INDICATORS',

2862: commit ;
2863:
2864: -- gather stats on table to allow index access
2865: If nvl(WIP_CALL_LOG,-1) =1 then
2866: fnd_stats.gather_table_stats (g_wip_schema, 'WIP_BIS_PROD_INDICATORS',
2867: cascade => true);
2868: End If;
2869:
2870: -- Phase III:

Line 3028: fnd_stats.gather_table_stats (g_wip_schema, 'WIP_BIS_PROD_INDICATORS',

3024: commit ;
3025:
3026: -- gather stats on table to allow index access
3027: If nvl(WIP_CALL_LOG,-1) =1 then
3028: fnd_stats.gather_table_stats (g_wip_schema, 'WIP_BIS_PROD_INDICATORS',
3029: cascade => true);
3030: End If;
3031: -- Phase VI:
3032: -- Update Yield information into

Line 3136: fnd_stats.gather_table_stats (g_wip_schema, 'WIP_BIS_PROD_INDICATORS',

3132: commit ;
3133:
3134: -- gather stats on table to allow index access
3135: If nvl(WIP_CALL_LOG,-1) =1 then
3136: fnd_stats.gather_table_stats (g_wip_schema, 'WIP_BIS_PROD_INDICATORS',
3137: cascade => true);
3138: End if;
3139:
3140: -- Phase VIII:

Line 3428: fnd_stats.gather_table_stats (g_wip_schema, 'WIP_BIS_PROD_INDICATORS',

3424: commit ;
3425:
3426:
3427: -- gather stats on table to allow index access
3428: fnd_stats.gather_table_stats (g_wip_schema, 'WIP_BIS_PROD_INDICATORS',
3429: cascade => true);
3430:
3431: p_errnum := 0;
3432: p_errmesg := '';

Line 4324: fnd_stats.gather_table_stats (g_wip_schema, 'WIP_INDICATORS_TEMP',

4320:
4321:
4322: -- gather stats on table to allow index access
4323: If nvl(WIP_CALL_LOG,-1) =1 then
4324: fnd_stats.gather_table_stats (g_wip_schema, 'WIP_INDICATORS_TEMP',
4325: cascade => true);
4326: End If;
4327:
4328: x_phase := 'IV';

Line 4341: fnd_stats.gather_table_stats (g_wip_schema, 'WIP_INDICATORS_TEMP',

4337: where indicator_type = WIP_PRODUCTIVITY
4338: and process_phase = WIP_PROD_PHASE_THREE ;
4339: -- gather stats on table to allow index access
4340: If nvl(WIP_CALL_LOG,-1) =1 then
4341: fnd_stats.gather_table_stats (g_wip_schema, 'WIP_INDICATORS_TEMP',
4342: cascade => true);
4343: End If;
4344:
4345:

Line 4508: fnd_stats.gather_table_stats (g_wip_schema, 'WIP_INDICATORS_TEMP',

4504: g_applicationid ;
4505:
4506: -- gather stats on table to allow index access
4507: If nvl(WIP_CALL_LOG,-1) =1 then
4508: fnd_stats.gather_table_stats (g_wip_schema, 'WIP_INDICATORS_TEMP',
4509: cascade => true);
4510: End IF;
4511:
4512: EXCEPTION

Line 4991: fnd_stats.gather_table_stats (g_wip_schema, 'WIP_INDICATORS_TEMP',

4987: END LOOP ;
4988:
4989: -- gather stats on table to allow index access
4990: If nvl(WIP_CALL_LOG,-1) =1 then
4991: fnd_stats.gather_table_stats (g_wip_schema, 'WIP_INDICATORS_TEMP',
4992: cascade => true);
4993: End If;
4994:
4995:

Line 5169: fnd_stats.gather_table_stats (g_wip_schema, 'WIP_INDICATORS_TEMP',

5165: commit ;
5166:
5167: -- gather stats on table to allow index access
5168: If nvl(WIP_CALL_LOG,-1) =1 then
5169: fnd_stats.gather_table_stats (g_wip_schema, 'WIP_INDICATORS_TEMP',
5170: cascade => true);
5171: End If;
5172:
5173: p_errnum := 0;