[Home] [Help]
213: request_from :='P'; -- P for PROG , cal by program
214: -- generate it from sequence
215: SELECT fnd_stats_hist_s.nextval
216: INTO request_id_l
217: FROM dual;
218:
219: ELSE -- call not from within apps context, maybe sqlplus
220: request_from:='U'; -- U for USER, called from sqlplus etc
221: -- generate it from sequence
220: request_from:='U'; -- U for USER, called from sqlplus etc
221: -- generate it from sequence
222: SELECT fnd_stats_hist_s.nextval
223: INTO request_id_l
224: FROM dual;
225:
226: END IF;
227: -- dbms_output.put_line('Request_id is '||request_id);
228: -- dbms_output.put_line('Effective Request_id is '||request_id_l);
1029: Errors(err_cnt+1) := NULL;
1030: err_cnt := err_cnt+1;
1031: END;
1032: END LOOP;
1033: /* end of individual tables */
1034: FOR rec_cur IN lock_stats_tab(upper(schemaname)) -- added by saleem to display warning for tables with locked stats
1035: LOOP
1036: dbms_output.put_line('stats on table '
1037: || rec_cur.table_name
1140: Errors(err_cnt+1) := NULL;
1141: err_cnt := err_cnt+1;
1142: END;
1143: END LOOP;
1144: /* end of individual tables */
1145: FOR rec_cur IN lock_stats_tab(upper(schemaname)) -- added by saleem to display warning for tables with locked stats
1146: LOOP
1147: dbms_output.put_line('stats on table '
1148: || rec_cur.table_name
1517: g_Errors(err_cnt+1) := NULL;
1518: err_cnt := err_cnt+1;
1519: END;
1520: END LOOP;
1521: /* end of individual tables */
1522: FOR rec_cur IN lock_stats_tab(upper(schemaname)) -- added by saleem to display warning for tables with locked stats
1523: LOOP
1524: dbms_output.put_line('stats on table '
1525: || rec_cur.table_name
1628: g_Errors(err_cnt+1) := NULL;
1629: err_cnt := err_cnt+1;
1630: END;
1631: END LOOP;
1632: /* end of individual tables */
1633: FOR rec_cur IN lock_stats_tab(upper(schemaname)) -- added by saleem to display warning for tables with locked stats
1634: LOOP
1635: dbms_output.put_line('stats on table '
1636: || rec_cur.table_name