eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FND_TS_SIZE dependencies on FND_TS_SIZING

Line 30: PROCEDURE ins_fnd_ts_sizing (cur_rec IN rec_type,

26: CLOSE tsp_csr;
27: RETURN l_tablespace_name;
28: END get_tsp_name;
29:
30: PROCEDURE ins_fnd_ts_sizing (cur_rec IN rec_type,
31: p_uni_extent IN NUMBER,
32: p_allocation_type IN VARCHAR2,
33: p_creation_date IN DATE,
34: p_partition_name IN VARCHAR2 DEFAULT NULL)

Line 151: INSERT INTO fnd_ts_sizing (

147: l_total_bytes_required:= (ceil(used_byts/p_uni_extent))*(p_uni_extent);
148: end if;
149: end if;
150:
151: INSERT INTO fnd_ts_sizing (
152: owner,
153: old_tablespace,
154: new_tablespace,
155: object_type,

Line 195: END ins_fnd_ts_sizing;

191: cur_rec.classified,
192: cur_rec.partitioned,
193: p_creation_date);
194:
195: END ins_fnd_ts_sizing;
196:
197: PROCEDURE gen_tab_sizing (p_app IN VARCHAR2,
198: p_uni_extent IN NUMBER,
199: p_allocation_type IN VARCHAR2,

Line 618: DELETE FROM fnd_ts_sizing

614: and lob_name = p_lob_name;
615:
616: BEGIN
617:
618: DELETE FROM fnd_ts_sizing
619: WHERE owner = p_app;
620: COMMIT;
621:
622: OPEN tab_csr;

Line 636: ins_fnd_ts_sizing (

632: cur_rec.partitioned := trim(cur_rec.partitioned);
633:
634: if (cur_rec.partitioned = 'NO') then
635: -- non-partitioned tables and LOBS will be sized here.
636: ins_fnd_ts_sizing (
637: cur_rec,
638: p_uni_extent,
639: p_allocation_type,
640: p_creation_date);

Line 646: ins_fnd_ts_sizing (

642: cur_rec.object_type := 'TABLE PARTITION';
643: FOR tab_part_rec IN get_tab_partition(cur_rec.table_name)
644: LOOP
645: cur_rec.tablespace_name := tab_part_rec.tablespace_name;
646: ins_fnd_ts_sizing (
647: cur_rec,
648: P_uni_extent,
649: p_allocation_type,
650: p_creation_date,

Line 658: ins_fnd_ts_sizing (

654: cur_rec.object_type := 'LOB PARTITION';
655: FOR lob_part_rec IN get_lob_partition(cur_rec.parent, cur_rec.table_name)
656: LOOP
657: cur_rec.tablespace_name := lob_part_rec.tablespace_name;
658: ins_fnd_ts_sizing (
659: cur_rec,
660: p_uni_extent,
661: p_allocation_type,
662: p_creation_date,

Line 667: ins_fnd_ts_sizing (

663: lob_part_rec.lob_partition_name);
664: /*
665: cur_rec.object_type := 'INDEX PARTITION';
666: cur_rec.table_name := REPLACE(cur_rec.table_name, 'LOB', 'IL');
667: ins_fnd_ts_sizing (
668: cur_rec,
669: p_uni_extent,
670: p_allocation_type,
671: p_creation_date,

Line 1105: DELETE FROM fnd_ts_sizing

1101: where index_name = p_index_name
1102: and index_owner=p_app;
1103: BEGIN
1104: /*
1105: DELETE FROM fnd_ts_sizing
1106: WHERE owner = p_app
1107: AND object_type IN ('INDEX', 'INDEX PARTITION', 'LOBINDEX');
1108: COMMIT;
1109: */

Line 1125: ins_fnd_ts_sizing (

1121: cur_rec.partitioned := trim(cur_rec.partitioned);
1122:
1123: if (cur_rec.partitioned = 'NO') then
1124: -- non-partitioned indexes will be sized here.
1125: ins_fnd_ts_sizing (
1126: cur_rec,
1127: p_uni_extent,
1128: p_allocation_type,
1129: p_creation_date);

Line 1135: ins_fnd_ts_sizing (

1131: cur_rec.object_type := 'INDEX PARTITION';
1132: FOR ind_part_rec IN get_ind_partition(cur_rec.table_name)
1133: LOOP
1134: cur_rec.tablespace_name := ind_part_rec.tablespace_name;
1135: ins_fnd_ts_sizing (
1136: cur_rec,
1137: p_uni_extent,
1138: p_allocation_type,
1139: p_creation_date,

Line 1592: DELETE FROM fnd_ts_sizing;

1588: and lob_name = p_lob_name;
1589:
1590: BEGIN
1591:
1592: DELETE FROM fnd_ts_sizing;
1593: COMMIT;
1594:
1595: OPEN tab_csr;
1596: LOOP

Line 1609: ins_fnd_ts_sizing (

1605: cur_rec.partitioned := trim(cur_rec.partitioned);
1606:
1607: if (cur_rec.partitioned = 'NO') then
1608: -- non-partitioned tables and LOBS will be sized here.
1609: ins_fnd_ts_sizing (
1610: cur_rec,
1611: p_uni_extent,
1612: p_allocation_type,
1613: p_creation_date);

Line 1619: ins_fnd_ts_sizing (

1615: cur_rec.object_type := 'TABLE PARTITION';
1616: FOR tab_part_rec IN get_tab_partition (cur_rec.owner, cur_rec.table_name)
1617: LOOP
1618: cur_rec.tablespace_name := tab_part_rec.tablespace_name;
1619: ins_fnd_ts_sizing (
1620: cur_rec,
1621: p_uni_extent,
1622: p_allocation_type,
1623: p_creation_date,

Line 1631: ins_fnd_ts_sizing (

1627: cur_rec.object_type := 'LOB PARTITION';
1628: FOR lob_part_rec IN get_lob_partition(cur_rec.owner, cur_rec.parent, cur_rec.table_name)
1629: LOOP
1630: cur_rec.tablespace_name := lob_part_rec.tablespace_name;
1631: ins_fnd_ts_sizing (
1632: cur_rec,
1633: P_uni_extent,
1634: p_allocation_type,
1635: p_creation_date,

Line 1640: ins_fnd_ts_sizing (

1636: lob_part_rec.lob_partition_name);
1637: /*
1638: cur_rec.object_type := 'INDEX PARTITION';
1639: cur_rec.table_name := REPLACE(cur_rec.table_name, 'LOB', 'IL');
1640: ins_fnd_ts_sizing (
1641: cur_rec,
1642: p_uni_extent,
1643: p_allocation_type,
1644: p_creation_date,

Line 2110: DELETE FROM fnd_ts_sizing

2106: where index_owner = p_owner
2107: and index_name = p_index_name;
2108: BEGIN
2109: /*
2110: DELETE FROM fnd_ts_sizing
2111: WHERE object_type IN ('INDEX', 'INDEX PARTITION', 'LOBINDEX');
2112: COMMIT;
2113: */
2114:

Line 2129: ins_fnd_ts_sizing (

2125: cur_rec.partitioned := trim(cur_rec.partitioned);
2126:
2127: if (cur_rec.partitioned = 'NO') then
2128: -- non-partitioned indexes will be sized here.
2129: ins_fnd_ts_sizing (
2130: cur_rec,
2131: p_uni_extent,
2132: p_allocation_type,
2133: p_creation_date);

Line 2139: ins_fnd_ts_sizing (

2135: cur_rec.object_type := 'INDEX PARTITION';
2136: FOR ind_part_rec IN get_ind_partition(cur_rec.owner, cur_rec.table_name)
2137: LOOP
2138: cur_rec.tablespace_name := ind_part_rec.tablespace_name;
2139: ins_fnd_ts_sizing (
2140: cur_rec,
2141: p_uni_extent,
2142: p_allocation_type,
2143: p_creation_date,