APPS.OKI_REFRESH_PVT dependencies on FND_STATS

Line 1172: fnd_stats.gather_table_stats(ownname=>'OKI' ,tabname=>'OKI_JOB_RUN_DTL',percent=> 10);

1168: COMMIT ;
1169:
1170:
1171: -- analyze table
1172: fnd_stats.gather_table_stats(ownname=>'OKI' ,tabname=>'OKI_JOB_RUN_DTL',percent=> 10);
1173:
1174: EXCEPTION
1175: WHEN OTHERS THEN
1176: l_sqlcode := sqlcode ;

Line 1469: fnd_stats.gather_table_stats(ownname => 'OKI'

1465: END IF ;
1466:
1467:
1468: -- analyze table
1469: fnd_stats.gather_table_stats(ownname => 'OKI'
1470: ,tabname => 'OKI_K_CONV_RATE',percent=> 10);
1471:
1472: EXCEPTION
1473: when l_no_update_refresh then

Line 2303: fnd_stats.gather_table_stats(ownname=>'OKI' ,tabname=>'OKI_DAILY_RATES',percent=> 10);

2299: RAISE l_no_update_refresh;
2300: END IF ;
2301:
2302: -- analyze table
2303: fnd_stats.gather_table_stats(ownname=>'OKI' ,tabname=>'OKI_DAILY_RATES',percent=> 10);
2304:
2305: --DBMS_OUTPUT.PUT_LINE('End of the program...');
2306: fnd_message.set_name('OKI','OKI_TABLE_LOAD_SUCCESS');
2307: fnd_message.set_token('TABLE_NAME','OKI_DAILY_RATES');

Line 2758: fnd_stats.gather_table_stats(ownname => 'OKI'

2754:
2755: /* Fetches distinct qualifiers before issuing update with subquery. */
2756: l_errpos := 6.25;
2757: -- analyze table
2758: fnd_stats.gather_table_stats(ownname => 'OKI'
2759: ,tabname => 'OKI_SALES_K_HDRS',percent=> 10);
2760:
2761: l_errpos := 7;
2762:

Line 3238: fnd_stats.gather_table_stats( ownname => 'OKI'

3234: RAISE l_no_update_refresh;
3235: END IF;
3236: l_loc := 'Analyzing ' || l_table_name ;
3237: -- analyze table
3238: fnd_stats.gather_table_stats( ownname => 'OKI'
3239: , tabname => l_table_name
3240: , percent => 10 ) ;
3241:
3242: fnd_message.set_name( application => 'OKI'

Line 3566: fnd_stats.gather_table_stats(ownname => 'OKI'

3562: END IF ;
3563: l_errpos := 8;
3564:
3565: -- analyze table
3566: fnd_stats.gather_table_stats(ownname => 'OKI'
3567: ,tabname => 'OKI_SOLD_ITM_LINES',percent=> 10);
3568: l_errpos := 9;
3569:
3570: fnd_message.set_name(application => 'OKI'

Line 3844: fnd_stats.gather_table_stats( ownname => 'OKI'

3840: END IF;
3841:
3842: l_loc := 'Analyzing ' || l_table_name ;
3843: -- analyze table
3844: fnd_stats.gather_table_stats( ownname => 'OKI'
3845: , tabname => l_table_name
3846: , percent => 10 ) ;
3847:
3848: fnd_message.set_name( application => 'OKI'

Line 4204: fnd_stats.gather_table_stats(ownname => 'OKI'

4200: END IF;
4201: l_errpos := 8;
4202:
4203: -- analyze table
4204: fnd_stats.gather_table_stats(ownname => 'OKI'
4205: ,tabname => 'OKI_COV_PRD_LINES',percent=> 10);
4206: l_errpos := 9;
4207:
4208: fnd_message.set_name(application => 'OKI'

Line 4579: fnd_stats.gather_table_stats( ownname => 'OKI'

4575: END IF;
4576:
4577: l_loc := 'Analyzing ' || l_table_name ;
4578: -- analyze table
4579: fnd_stats.gather_table_stats( ownname => 'OKI'
4580: , tabname => l_table_name
4581: , percent => 10 ) ;
4582:
4583: fnd_message.set_name( application => 'OKI'

Line 4829: fnd_stats.gather_table_stats(ownname => 'OKI'

4825:
4826: l_errpos := 9;
4827:
4828: -- analyze table
4829: fnd_stats.gather_table_stats(ownname => 'OKI'
4830: ,tabname => 'OKI_K_SALESREPS',percent=> 10);
4831:
4832: fnd_message.set_name(application => 'OKI'
4833: ,name => 'OKI_TABLE_LOAD_SUCCESS');

Line 5043: fnd_stats.gather_table_stats( ownname => 'OKI'

5039: end if;
5040:
5041: l_loc := 'Analyze ' || l_table_name ;
5042: -- analyze table
5043: fnd_stats.gather_table_stats( ownname => 'OKI'
5044: , tabname => l_table_name
5045: , percent => 10 ) ;
5046:
5047: fnd_message.set_name( application => 'OKI'