APPS.AD_DD dependencies on FND_TABLES

Line 34: from fnd_tables

30: p_table_id number;
31: begin
32:
33: select table_id into p_table_id
34: from fnd_tables
35: where application_id = p_apps_id
36: and table_name = p_tab_name;
37:
38: return p_table_id;

Line 292: insert into fnd_tables (

288: -- calculate the next_extent size
289: --
290: new_next_extent := round(p_next_extent, 0);
291:
292: insert into fnd_tables (
293: APPLICATION_ID ,
294: TABLE_ID ,
295: TABLE_NAME ,
296: USER_TABLE_NAME ,

Line 314: fnd_tables_s.nextval,

310: MAX_TRANS ,
311: PCT_FREE ,
312: PCT_USED )
313: select p_appl_id,
314: fnd_tables_s.nextval,
315: up_tab_name,
316: up_tab_name,
317: to_date('01-01-1990', 'DD-MM-YYYY') ,
318: 1,

Line 335: from fnd_tables

331: p_pct_free,
332: p_pct_used
333: from sys.dual
334: where not exists ( select 'x'
335: from fnd_tables
336: where application_id = p_appl_id
337: and table_name = up_tab_name);
338:
339: end;

Line 376: ' does not exist in FND_TABLES for application_short_name "'||

372:
373: if p_table_id is null then
374:
375: raise_application_error(-20000, 'Table '||up_tab_name||
376: ' does not exist in FND_TABLES for application_short_name "'||
377: p_appl_short_name||'" application_id "'||p_appl_id||'".');
378:
379: end if;
380: --

Line 505: delete from fnd_tables

501: --
502: delete from fnd_columns
503: where application_id = p_appl_id and table_id = p_table_id;
504:
505: delete from fnd_tables
506: where application_id = p_appl_id and table_id = p_table_id;
507:
508: end delete_table;
509: