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: /* Bug 7042156. Collect statistics only if the no.of records is bigger than the profile
47: option threshold */
48: IF (l_num_rows_inserted > nvl(fnd_profile.value('EGO_GATHER_STATS'),100)) THEN --{
49: FND_STATS.GATHER_TABLE_STATS(l_schema, 'EGO_ITEM_CAT_DENORM_HIER');

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

45: --Comupte stats on EGO_ITEM_CAT_DENORM_HIER
46: /* Bug 7042156. Collect statistics only if the no.of records is bigger than the profile
47: option threshold */
48: IF (l_num_rows_inserted > nvl(fnd_profile.value('EGO_GATHER_STATS'),100)) THEN --{
49: FND_STATS.GATHER_TABLE_STATS(l_schema, 'EGO_ITEM_CAT_DENORM_HIER');
50: FND_STATS.GATHER_INDEX_STATS(l_schema, 'EGO_ITEM_CAT_DENORM_HIER_U1');
51: END IF; --}
52:
53: x_return_status := 'S';

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

46: /* Bug 7042156. Collect statistics only if the no.of records is bigger than the profile
47: option threshold */
48: IF (l_num_rows_inserted > nvl(fnd_profile.value('EGO_GATHER_STATS'),100)) THEN --{
49: FND_STATS.GATHER_TABLE_STATS(l_schema, 'EGO_ITEM_CAT_DENORM_HIER');
50: FND_STATS.GATHER_INDEX_STATS(l_schema, 'EGO_ITEM_CAT_DENORM_HIER_U1');
51: END IF; --}
52:
53: x_return_status := 'S';
54:

Line 98: DELETE FROM EGO_ITEM_CAT_DENORM_HIER

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

Line 103: INSERT INTO EGO_ITEM_CAT_DENORM_HIER(PARENT_CATALOG_GROUP_ID

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

Line 116: DELETE FROM EGO_ITEM_CAT_DENORM_HIER

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

Line 131: DELETE FROM EGO_ITEM_CAT_DENORM_HIER

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

Line 153: INSERT INTO EGO_ITEM_CAT_DENORM_HIER(PARENT_CATALOG_GROUP_ID

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

Line 166: --Comupte stats on EGO_ITEM_CAT_DENORM_HIER

162: END IF;
163: --}
164: END LOOP;
165:
166: --Comupte stats on EGO_ITEM_CAT_DENORM_HIER
167: /* Bug 7042156. Collect statistics only if the no.of records is bigger than the profile
168: option threshold */
169: IF (l_num_rows_updated > nvl(fnd_profile.value('EGO_GATHER_STATS'),100)) THEN --{
170: FND_STATS.GATHER_TABLE_STATS(l_schema, 'EGO_ITEM_CAT_DENORM_HIER');

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

166: --Comupte stats on EGO_ITEM_CAT_DENORM_HIER
167: /* Bug 7042156. Collect statistics only if the no.of records is bigger than the profile
168: option threshold */
169: IF (l_num_rows_updated > nvl(fnd_profile.value('EGO_GATHER_STATS'),100)) THEN --{
170: FND_STATS.GATHER_TABLE_STATS(l_schema, 'EGO_ITEM_CAT_DENORM_HIER');
171: FND_STATS.GATHER_INDEX_STATS(l_schema, 'EGO_ITEM_CAT_DENORM_HIER_U1');
172: END IF; --}
173:
174: x_return_status := 'S';

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

167: /* Bug 7042156. Collect statistics only if the no.of records is bigger than the profile
168: option threshold */
169: IF (l_num_rows_updated > nvl(fnd_profile.value('EGO_GATHER_STATS'),100)) THEN --{
170: FND_STATS.GATHER_TABLE_STATS(l_schema, 'EGO_ITEM_CAT_DENORM_HIER');
171: FND_STATS.GATHER_INDEX_STATS(l_schema, 'EGO_ITEM_CAT_DENORM_HIER_U1');
172: END IF; --}
173:
174: x_return_status := 'S';
175: