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.EGO_BROWSE_PVT dependencies on EGO_ITEM_CAT_DENORM_HIER

Line 29: DELETE EGO_ITEM_CAT_DENORM_HIER;

25: END IF; --}
26:
27:
28: --First delete all records in the denorm table.
29: DELETE EGO_ITEM_CAT_DENORM_HIER;
30:
31: --Now for each record in the MTL_ITEM_CATALOG_GROUPS_B table
32: --insert the complete child heirarchy into the denorm table.
33: FOR cat_rec IN item_catalog_group_cursor

Line 35: INSERT INTO EGO_ITEM_CAT_DENORM_HIER(PARENT_CATALOG_GROUP_ID, CHILD_CATALOG_GROUP_ID)

31: --Now for each record in the MTL_ITEM_CATALOG_GROUPS_B table
32: --insert the complete child heirarchy into the denorm table.
33: FOR cat_rec IN item_catalog_group_cursor
34: LOOP --{
35: INSERT INTO EGO_ITEM_CAT_DENORM_HIER(PARENT_CATALOG_GROUP_ID, CHILD_CATALOG_GROUP_ID)
36: SELECT cat_rec.ITEM_CATALOG_GROUP_ID PARENT_CATALOG_GROUP_ID
37: , IC.ITEM_CATALOG_GROUP_ID CHILD_CATALOG_GROUP_ID
38: FROM MTL_ITEM_CATALOG_GROUPS_B IC
39: CONNECT BY PRIOR ITEM_CATALOG_GROUP_ID = PARENT_CATALOG_GROUP_ID

Line 45: --Comupte stats on EGO_ITEM_CAT_DENORM_HIER

41:
42: l_num_rows_inserted := l_num_rows_inserted + SQL%ROWCOUNT;
43: END LOOP; --}
44:
45: --Comupte stats on EGO_ITEM_CAT_DENORM_HIER
46: IF (l_num_rows_inserted > 50) THEN --{
47: FND_STATS.GATHER_TABLE_STATS(l_schema, 'EGO_ITEM_CAT_DENORM_HIER');
48: FND_STATS.GATHER_INDEX_STATS(l_schema, 'EGO_ITEM_CAT_DENORM_HIER_U1');
49: END IF; --}

Line 47: FND_STATS.GATHER_TABLE_STATS(l_schema, 'EGO_ITEM_CAT_DENORM_HIER');

43: END LOOP; --}
44:
45: --Comupte stats on EGO_ITEM_CAT_DENORM_HIER
46: IF (l_num_rows_inserted > 50) THEN --{
47: FND_STATS.GATHER_TABLE_STATS(l_schema, 'EGO_ITEM_CAT_DENORM_HIER');
48: FND_STATS.GATHER_INDEX_STATS(l_schema, 'EGO_ITEM_CAT_DENORM_HIER_U1');
49: END IF; --}
50:
51: x_return_status := 'S';

Line 48: FND_STATS.GATHER_INDEX_STATS(l_schema, 'EGO_ITEM_CAT_DENORM_HIER_U1');

44:
45: --Comupte stats on EGO_ITEM_CAT_DENORM_HIER
46: IF (l_num_rows_inserted > 50) THEN --{
47: FND_STATS.GATHER_TABLE_STATS(l_schema, 'EGO_ITEM_CAT_DENORM_HIER');
48: FND_STATS.GATHER_INDEX_STATS(l_schema, 'EGO_ITEM_CAT_DENORM_HIER_U1');
49: END IF; --}
50:
51: x_return_status := 'S';
52:

Line 96: DELETE FROM EGO_ITEM_CAT_DENORM_HIER

92: Raise_Application_Error (-20001, 'EGO Schema could not be located.');
93: END IF; --}
94:
95: --First delete the child hierarchy entries for the item catalog being create/updated
96: DELETE FROM EGO_ITEM_CAT_DENORM_HIER
97: WHERE PARENT_CATALOG_GROUP_ID = p_catalog_group_id;
98: l_num_rows_updated := l_num_rows_updated + SQL%ROWCOUNT;
99:
100: --Now insert the child hierarchy for the item catalog being create/updated

Line 101: INSERT INTO EGO_ITEM_CAT_DENORM_HIER(PARENT_CATALOG_GROUP_ID

97: WHERE PARENT_CATALOG_GROUP_ID = p_catalog_group_id;
98: l_num_rows_updated := l_num_rows_updated + SQL%ROWCOUNT;
99:
100: --Now insert the child hierarchy for the item catalog being create/updated
101: INSERT INTO EGO_ITEM_CAT_DENORM_HIER(PARENT_CATALOG_GROUP_ID
102: , CHILD_CATALOG_GROUP_ID)
103: ( SELECT p_catalog_group_id PARENT_CATALOG_GROUP_ID,
104: IC.ITEM_CATALOG_GROUP_ID CHILD_CATALOG_GROUP_ID
105: FROM MTL_ITEM_CATALOG_GROUPS_B IC

Line 114: DELETE FROM EGO_ITEM_CAT_DENORM_HIER

110: IF(p_old_parent_id IS NOT NULL AND p_old_parent_id <> -1) THEN
111: --{
112:
113: --Delete the records for the current child hierarchy from the old parent hierarchy
114: DELETE FROM EGO_ITEM_CAT_DENORM_HIER
115: WHERE PARENT_CATALOG_GROUP_ID = p_old_parent_id
116: AND CHILD_CATALOG_GROUP_ID IN
117: ( SELECT IC.ITEM_CATALOG_GROUP_ID
118: FROM MTL_ITEM_CATALOG_GROUPS_B IC

Line 129: DELETE FROM EGO_ITEM_CAT_DENORM_HIER

125: LOOP
126: --{
127: IF (old_parent_rec.PARENT_CATALOG_GROUP_ID IS NOT NULL) THEN
128: --{
129: DELETE FROM EGO_ITEM_CAT_DENORM_HIER
130: WHERE PARENT_CATALOG_GROUP_ID = old_parent_rec.PARENT_CATALOG_GROUP_ID
131: AND CHILD_CATALOG_GROUP_ID IN
132: ( SELECT IC.ITEM_CATALOG_GROUP_ID
133: FROM MTL_ITEM_CATALOG_GROUPS_B IC

Line 151: INSERT INTO EGO_ITEM_CAT_DENORM_HIER(PARENT_CATALOG_GROUP_ID

147: LOOP
148: --{
149: IF (new_parent_rec.PARENT_CATALOG_GROUP_ID IS NOT NULL) THEN
150: --{
151: INSERT INTO EGO_ITEM_CAT_DENORM_HIER(PARENT_CATALOG_GROUP_ID
152: , CHILD_CATALOG_GROUP_ID)
153: ( SELECT new_parent_rec.PARENT_CATALOG_GROUP_ID PARENT_CATALOG_GROUP_ID,
154: IC.ITEM_CATALOG_GROUP_ID CHILD_CATALOG_GROUP_ID
155: FROM MTL_ITEM_CATALOG_GROUPS_B IC

Line 164: --Comupte stats on EGO_ITEM_CAT_DENORM_HIER

160: END IF;
161: --}
162: END LOOP;
163:
164: --Comupte stats on EGO_ITEM_CAT_DENORM_HIER
165: IF (l_num_rows_updated > 50) THEN --{
166: FND_STATS.GATHER_TABLE_STATS(l_schema, 'EGO_ITEM_CAT_DENORM_HIER');
167: FND_STATS.GATHER_INDEX_STATS(l_schema, 'EGO_ITEM_CAT_DENORM_HIER_U1');
168: END IF; --}

Line 166: FND_STATS.GATHER_TABLE_STATS(l_schema, 'EGO_ITEM_CAT_DENORM_HIER');

162: END LOOP;
163:
164: --Comupte stats on EGO_ITEM_CAT_DENORM_HIER
165: IF (l_num_rows_updated > 50) THEN --{
166: FND_STATS.GATHER_TABLE_STATS(l_schema, 'EGO_ITEM_CAT_DENORM_HIER');
167: FND_STATS.GATHER_INDEX_STATS(l_schema, 'EGO_ITEM_CAT_DENORM_HIER_U1');
168: END IF; --}
169:
170: x_return_status := 'S';

Line 167: FND_STATS.GATHER_INDEX_STATS(l_schema, 'EGO_ITEM_CAT_DENORM_HIER_U1');

163:
164: --Comupte stats on EGO_ITEM_CAT_DENORM_HIER
165: IF (l_num_rows_updated > 50) THEN --{
166: FND_STATS.GATHER_TABLE_STATS(l_schema, 'EGO_ITEM_CAT_DENORM_HIER');
167: FND_STATS.GATHER_INDEX_STATS(l_schema, 'EGO_ITEM_CAT_DENORM_HIER_U1');
168: END IF; --}
169:
170: x_return_status := 'S';
171: