APPS.FND_STATS dependencies on DUAL

Line 219: FROM dual;

215: request_from :='P'; -- P for PROG , cal by program
216: -- generate it from sequence
217: SELECT fnd_stats_hist_s.nextval
218: INTO request_id_l
219: FROM dual;
220:
221: ELSE -- call not from within apps context, maybe sqlplus
222: request_from:='U'; -- U for USER, called from sqlplus etc
223: -- generate it from sequence

Line 226: FROM dual;

222: request_from:='U'; -- U for USER, called from sqlplus etc
223: -- generate it from sequence
224: SELECT fnd_stats_hist_s.nextval
225: INTO request_id_l
226: FROM dual;
227:
228: END IF;
229: -- dbms_output.put_line('Request_id is '||request_id);
230: -- dbms_output.put_line('Effective Request_id is '||request_id_l);

Line 1156: /* end of individual tables */

1152: Errors(err_cnt+1) := NULL;
1153: err_cnt := err_cnt+1;
1154: END;
1155: END LOOP;
1156: /* end of individual tables */
1157: elsif ( (upper(OPTIONS)='GATHER AUTO') OR
1158: (
1159: upper(OPTIONS)='LIST AUTO'
1160: )

Line 1261: /* end of individual tables */

1257: Errors(err_cnt+1) := NULL;
1258: err_cnt := err_cnt+1;
1259: END;
1260: END LOOP;
1261: /* end of individual tables */
1262: -- GATHER AUTO includes GATHER EMPTY, so gather stats
1263: -- on any unalalyzed tables and/or indexes.
1264: FOR c_rec IN empty_cur(upper(schemaname))
1265: LOOP

Line 1437: /* end of individual tables */

1433: Errors(err_cnt+1) := NULL;
1434: err_cnt := err_cnt+1;
1435: END;
1436: END LOOP;
1437: /* end of individual tables */
1438: FOR rec_cur IN lock_stats_tab(upper(schemaname)) -- added by saleem to display warning for tables with locked stats
1439: LOOP
1440: dbms_output.put_line('stats on table '
1441: || rec_cur.table_name

Line 1568: /* end of individual tables */

1564: Errors(err_cnt+1) := NULL;
1565: err_cnt := err_cnt+1;
1566: END;
1567: END LOOP;
1568: /* end of individual tables */
1569: FOR rec_cur IN lock_stats_tab(upper(schemaname)) -- added by saleem to display warning for tables with locked stats
1570: LOOP
1571: dbms_output.put_line('stats on table '
1572: || rec_cur.table_name

Line 2066: /* end of individual tables */

2062: g_Errors(err_cnt+1) := NULL;
2063: err_cnt := err_cnt+1;
2064: END;
2065: END LOOP;
2066: /* end of individual tables */
2067: elsif ( (upper(OPTIONS)='GATHER AUTO') OR
2068: (
2069: upper(OPTIONS)='LIST AUTO'
2070: )

Line 2169: /* end of individual tables */

2165: g_Errors(err_cnt+1) := NULL;
2166: err_cnt := err_cnt+1;
2167: END;
2168: END LOOP;
2169: /* end of individual tables */
2170: -- GATHER AUTO includes GATHER EMPTY, so gather stats
2171: -- on any unalalyzed tables and/or indexes.
2172: FOR c_rec IN empty_cur(upper(schemaname))
2173: LOOP

Line 2320: /* end of individual tables */

2316: g_Errors(err_cnt+1) := NULL;
2317: err_cnt := err_cnt+1;
2318: END;
2319: END LOOP;
2320: /* end of individual tables */
2321: FOR rec_cur IN lock_stats_tab(upper(schemaname)) -- added by saleem to display warning for tables with locked stats
2322: LOOP
2323: dbms_output.put_line('stats on table '
2324: || rec_cur.table_name

Line 2449: /* end of individual tables */

2445: g_Errors(err_cnt+1) := NULL;
2446: err_cnt := err_cnt+1;
2447: END;
2448: END LOOP;
2449: /* end of individual tables */
2450: FOR rec_cur IN lock_stats_tab(upper(schemaname)) -- added by saleem to display warning for tables with locked stats
2451: LOOP
2452: dbms_output.put_line('stats on table '
2453: || rec_cur.table_name