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.ICX_CAT_CNTNT_SCRTY_UPG_PVT dependencies on ICX_TBL_NUMBER

Line 13: TYPE ICX_MAP_TBL_NUMBER IS TABLE OF ICX_TBL_NUMBER

9:
10: TYPE ICX_MAP_VARCHAR20 IS TABLE OF VARCHAR2(20)
11: INDEX BY BINARY_INTEGER;
12:
13: TYPE ICX_MAP_TBL_NUMBER IS TABLE OF ICX_TBL_NUMBER
14: INDEX BY BINARY_INTEGER;
15:
16:
17: -- TOP-LEVEL MIGRATE METHOD AND HELPERS

Line 97: p_catalog_ids IN ICX_TBL_NUMBER,

93: --------------------------------------------------
94:
95: PROCEDURE migrate_catalogs_no_realms
96: (
97: p_catalog_ids IN ICX_TBL_NUMBER,
98: p_old_store_ids IN ICX_TBL_NUMBER,
99: p_new_zone_ids IN ICX_TBL_NUMBER
100: );
101:

Line 98: p_old_store_ids IN ICX_TBL_NUMBER,

94:
95: PROCEDURE migrate_catalogs_no_realms
96: (
97: p_catalog_ids IN ICX_TBL_NUMBER,
98: p_old_store_ids IN ICX_TBL_NUMBER,
99: p_new_zone_ids IN ICX_TBL_NUMBER
100: );
101:
102: PROCEDURE migrate_catalog_with_realms

Line 99: p_new_zone_ids IN ICX_TBL_NUMBER

95: PROCEDURE migrate_catalogs_no_realms
96: (
97: p_catalog_ids IN ICX_TBL_NUMBER,
98: p_old_store_ids IN ICX_TBL_NUMBER,
99: p_new_zone_ids IN ICX_TBL_NUMBER
100: );
101:
102: PROCEDURE migrate_catalog_with_realms
103: (

Line 106: p_resp_with_realms_ids IN ICX_TBL_NUMBER

102: PROCEDURE migrate_catalog_with_realms
103: (
104: p_catalog_id IN NUMBER,
105: p_old_store_id IN NUMBER,
106: p_resp_with_realms_ids IN ICX_TBL_NUMBER
107: );
108:
109: PROCEDURE migrate_isrcs_no_realms
110: (

Line 111: p_item_source_ids IN ICX_TBL_NUMBER,

107: );
108:
109: PROCEDURE migrate_isrcs_no_realms
110: (
111: p_item_source_ids IN ICX_TBL_NUMBER,
112: p_old_store_ids IN ICX_TBL_NUMBER,
113: p_new_zone_ids IN ICX_TBL_NUMBER
114: );
115:

Line 112: p_old_store_ids IN ICX_TBL_NUMBER,

108:
109: PROCEDURE migrate_isrcs_no_realms
110: (
111: p_item_source_ids IN ICX_TBL_NUMBER,
112: p_old_store_ids IN ICX_TBL_NUMBER,
113: p_new_zone_ids IN ICX_TBL_NUMBER
114: );
115:
116: PROCEDURE migrate_isrc_with_realms

Line 113: p_new_zone_ids IN ICX_TBL_NUMBER

109: PROCEDURE migrate_isrcs_no_realms
110: (
111: p_item_source_ids IN ICX_TBL_NUMBER,
112: p_old_store_ids IN ICX_TBL_NUMBER,
113: p_new_zone_ids IN ICX_TBL_NUMBER
114: );
115:
116: PROCEDURE migrate_isrc_with_realms
117: (

Line 120: p_resp_with_realms_ids IN ICX_TBL_NUMBER,

116: PROCEDURE migrate_isrc_with_realms
117: (
118: p_item_source_id IN NUMBER,
119: p_old_store_id IN NUMBER,
120: p_resp_with_realms_ids IN ICX_TBL_NUMBER,
121: p_resp_without_realms_ids IN ICX_TBL_NUMBER
122: );
123:
124:

Line 121: p_resp_without_realms_ids IN ICX_TBL_NUMBER

117: (
118: p_item_source_id IN NUMBER,
119: p_old_store_id IN NUMBER,
120: p_resp_with_realms_ids IN ICX_TBL_NUMBER,
121: p_resp_without_realms_ids IN ICX_TBL_NUMBER
122: );
123:
124:
125: -- QUERYING OLD DATA HELPERS

Line 138: x_old_content_ids OUT NOCOPY ICX_TBL_NUMBER,

134: PROCEDURE get_contents_to_migrate
135: (
136: p_catalogs_migrated IN BOOLEAN,
137: p_item_sources_migrated IN BOOLEAN,
138: x_old_content_ids OUT NOCOPY ICX_TBL_NUMBER,
139: x_content_types OUT NOCOPY ICX_TBL_VARCHAR15,
140: x_old_store_ids OUT NOCOPY ICX_TBL_NUMBER
141: );
142:

Line 140: x_old_store_ids OUT NOCOPY ICX_TBL_NUMBER

136: p_catalogs_migrated IN BOOLEAN,
137: p_item_sources_migrated IN BOOLEAN,
138: x_old_content_ids OUT NOCOPY ICX_TBL_NUMBER,
139: x_content_types OUT NOCOPY ICX_TBL_VARCHAR15,
140: x_old_store_ids OUT NOCOPY ICX_TBL_NUMBER
141: );
142:
143: PROCEDURE populate_store_security_flags;
144:

Line 157: p_zone_ids IN ICX_TBL_NUMBER,

153: PROCEDURE create_R12_stores;
154:
155: PROCEDURE add_zones_to_store
156: (
157: p_zone_ids IN ICX_TBL_NUMBER,
158: p_r12_store_id IN NUMBER,
159: p_old_source_id IN NUMBER,
160: p_old_store_id IN NUMBER
161: );

Line 165: p_zone_ids IN ICX_TBL_NUMBER,

161: );
162:
163: PROCEDURE add_zones_to_stores
164: (
165: p_zone_ids IN ICX_TBL_NUMBER,
166: p_r12_store_ids IN ICX_TBL_NUMBER,
167: p_old_source_ids IN ICX_TBL_NUMBER,
168: p_old_store_ids IN ICX_TBL_NUMBER
169: );

Line 166: p_r12_store_ids IN ICX_TBL_NUMBER,

162:
163: PROCEDURE add_zones_to_stores
164: (
165: p_zone_ids IN ICX_TBL_NUMBER,
166: p_r12_store_ids IN ICX_TBL_NUMBER,
167: p_old_source_ids IN ICX_TBL_NUMBER,
168: p_old_store_ids IN ICX_TBL_NUMBER
169: );
170:

Line 167: p_old_source_ids IN ICX_TBL_NUMBER,

163: PROCEDURE add_zones_to_stores
164: (
165: p_zone_ids IN ICX_TBL_NUMBER,
166: p_r12_store_ids IN ICX_TBL_NUMBER,
167: p_old_source_ids IN ICX_TBL_NUMBER,
168: p_old_store_ids IN ICX_TBL_NUMBER
169: );
170:
171: PROCEDURE add_smart_forms_to_stores

Line 168: p_old_store_ids IN ICX_TBL_NUMBER

164: (
165: p_zone_ids IN ICX_TBL_NUMBER,
166: p_r12_store_ids IN ICX_TBL_NUMBER,
167: p_old_source_ids IN ICX_TBL_NUMBER,
168: p_old_store_ids IN ICX_TBL_NUMBER
169: );
170:
171: PROCEDURE add_smart_forms_to_stores
172: (

Line 173: p_smart_form_ids IN ICX_TBL_NUMBER,

169: );
170:
171: PROCEDURE add_smart_forms_to_stores
172: (
173: p_smart_form_ids IN ICX_TBL_NUMBER,
174: p_r12_store_ids IN ICX_TBL_NUMBER,
175: p_old_store_ids IN ICX_TBL_NUMBER
176: );
177:

Line 174: p_r12_store_ids IN ICX_TBL_NUMBER,

170:
171: PROCEDURE add_smart_forms_to_stores
172: (
173: p_smart_form_ids IN ICX_TBL_NUMBER,
174: p_r12_store_ids IN ICX_TBL_NUMBER,
175: p_old_store_ids IN ICX_TBL_NUMBER
176: );
177:
178:

Line 175: p_old_store_ids IN ICX_TBL_NUMBER

171: PROCEDURE add_smart_forms_to_stores
172: (
173: p_smart_form_ids IN ICX_TBL_NUMBER,
174: p_r12_store_ids IN ICX_TBL_NUMBER,
175: p_old_store_ids IN ICX_TBL_NUMBER
176: );
177:
178:
179: -- CONTENT ZONE HELPERS

Line 186: RETURN ICX_TBL_NUMBER;

182: FUNCTION get_new_zone_ids
183: (
184: p_num_zones IN NUMBER
185: )
186: RETURN ICX_TBL_NUMBER;
187:
188: PROCEDURE create_local_zones
189: (
190: p_new_zone_ids IN ICX_TBL_NUMBER,

Line 190: p_new_zone_ids IN ICX_TBL_NUMBER,

186: RETURN ICX_TBL_NUMBER;
187:
188: PROCEDURE create_local_zones
189: (
190: p_new_zone_ids IN ICX_TBL_NUMBER,
191: p_catalog_id IN NUMBER,
192: p_security_flag IN VARCHAR2,
193: p_supplier_flag IN VARCHAR2,
194: p_category_flag IN VARCHAR2

Line 199: p_new_zone_ids IN ICX_TBL_NUMBER,

195: );
196:
197: PROCEDURE create_local_zones
198: (
199: p_new_zone_ids IN ICX_TBL_NUMBER,
200: p_catalog_ids IN ICX_TBL_NUMBER,
201: p_security_flags IN ICX_TBL_VARCHAR20,
202: p_supplier_flags IN ICX_TBL_VARCHAR20,
203: p_category_flag IN VARCHAR2

Line 200: p_catalog_ids IN ICX_TBL_NUMBER,

196:
197: PROCEDURE create_local_zones
198: (
199: p_new_zone_ids IN ICX_TBL_NUMBER,
200: p_catalog_ids IN ICX_TBL_NUMBER,
201: p_security_flags IN ICX_TBL_VARCHAR20,
202: p_supplier_flags IN ICX_TBL_VARCHAR20,
203: p_category_flag IN VARCHAR2
204: );

Line 208: p_new_zone_ids IN ICX_TBL_NUMBER,

204: );
205:
206: PROCEDURE create_local_all_content_zones
207: (
208: p_new_zone_ids IN ICX_TBL_NUMBER,
209: p_category_flag IN VARCHAR2
210: );
211:
212: PROCEDURE add_resp_categories_to_zone

Line 214: p_new_zone_ids IN ICX_TBL_NUMBER,

210: );
211:
212: PROCEDURE add_resp_categories_to_zone
213: (
214: p_new_zone_ids IN ICX_TBL_NUMBER,
215: p_resp_ids IN ICX_TBL_NUMBER
216: );
217:
218: PROCEDURE create_item_source_zones

Line 215: p_resp_ids IN ICX_TBL_NUMBER

211:
212: PROCEDURE add_resp_categories_to_zone
213: (
214: p_new_zone_ids IN ICX_TBL_NUMBER,
215: p_resp_ids IN ICX_TBL_NUMBER
216: );
217:
218: PROCEDURE create_item_source_zones
219: (

Line 220: p_new_zone_ids IN ICX_TBL_NUMBER,

216: );
217:
218: PROCEDURE create_item_source_zones
219: (
220: p_new_zone_ids IN ICX_TBL_NUMBER,
221: p_item_source_id IN NUMBER,
222: p_security_flag IN VARCHAR2
223: );
224:

Line 227: p_new_zone_ids IN ICX_TBL_NUMBER,

223: );
224:
225: PROCEDURE create_item_source_zones
226: (
227: p_new_zone_ids IN ICX_TBL_NUMBER,
228: p_item_source_ids IN ICX_TBL_NUMBER,
229: p_security_flags IN ICX_TBL_VARCHAR20
230: );
231:

Line 228: p_item_source_ids IN ICX_TBL_NUMBER,

224:
225: PROCEDURE create_item_source_zones
226: (
227: p_new_zone_ids IN ICX_TBL_NUMBER,
228: p_item_source_ids IN ICX_TBL_NUMBER,
229: p_security_flags IN ICX_TBL_VARCHAR20
230: );
231:
232: PROCEDURE update_exchange_punchouts;

Line 240: p_new_zone_ids IN ICX_TBL_NUMBER,

236: --------------------------------
237:
238: PROCEDURE secure_zones_by_store_orgs
239: (
240: p_new_zone_ids IN ICX_TBL_NUMBER,
241: p_old_store_ids IN ICX_TBL_NUMBER,
242: p_security_flags IN ICX_TBL_VARCHAR20
243: );
244:

Line 241: p_old_store_ids IN ICX_TBL_NUMBER,

237:
238: PROCEDURE secure_zones_by_store_orgs
239: (
240: p_new_zone_ids IN ICX_TBL_NUMBER,
241: p_old_store_ids IN ICX_TBL_NUMBER,
242: p_security_flags IN ICX_TBL_VARCHAR20
243: );
244:
245: PROCEDURE secure_zones_by_resps

Line 247: p_new_zone_ids IN ICX_TBL_NUMBER,

243: );
244:
245: PROCEDURE secure_zones_by_resps
246: (
247: p_new_zone_ids IN ICX_TBL_NUMBER,
248: p_resp_ids IN ICX_TBL_NUMBER
249: );
250:
251: PROCEDURE secure_zone_by_resps

Line 248: p_resp_ids IN ICX_TBL_NUMBER

244:
245: PROCEDURE secure_zones_by_resps
246: (
247: p_new_zone_ids IN ICX_TBL_NUMBER,
248: p_resp_ids IN ICX_TBL_NUMBER
249: );
250:
251: PROCEDURE secure_zone_by_resps
252: (

Line 254: p_resp_ids IN ICX_TBL_NUMBER

250:
251: PROCEDURE secure_zone_by_resps
252: (
253: p_new_zone_id IN NUMBER,
254: p_resp_ids IN ICX_TBL_NUMBER
255: );
256:
257:
258: -- RESPONSIBILITY AND REALMS HELPER METHODS

Line 267: RETURN ICX_TBL_NUMBER;

263: FUNCTION get_catr_realm_values_cached
264: (
265: p_resp_id IN NUMBER
266: )
267: RETURN ICX_TBL_NUMBER;
268:
269: FUNCTION filter_out_no_category_resps
270: (
271: p_resp_with_realms_ids IN ICX_TBL_NUMBER

Line 271: p_resp_with_realms_ids IN ICX_TBL_NUMBER

267: RETURN ICX_TBL_NUMBER;
268:
269: FUNCTION filter_out_no_category_resps
270: (
271: p_resp_with_realms_ids IN ICX_TBL_NUMBER
272: )
273: RETURN ICX_TBL_NUMBER;
274:
275: FUNCTION get_realm_values_for_resp

Line 273: RETURN ICX_TBL_NUMBER;

269: FUNCTION filter_out_no_category_resps
270: (
271: p_resp_with_realms_ids IN ICX_TBL_NUMBER
272: )
273: RETURN ICX_TBL_NUMBER;
274:
275: FUNCTION get_realm_values_for_resp
276: (
277: p_resp_id IN NUMBER,

Line 280: RETURN ICX_TBL_NUMBER;

276: (
277: p_resp_id IN NUMBER,
278: p_realm_type IN VARCHAR2
279: )
280: RETURN ICX_TBL_NUMBER;
281:
282:
283: -- LARGE RESPONSIBILITY WITH REALMS QUERIES
284: -------------------------------------------

Line 290: RETURN ICX_TBL_NUMBER;

286: FUNCTION get_all_resps_with_realms
287: (
288: p_realm_type IN VARCHAR2
289: )
290: RETURN ICX_TBL_NUMBER;
291:
292: FUNCTION get_all_resps_without_realms
293: (
294: p_realm_type IN VARCHAR2

Line 296: RETURN ICX_TBL_NUMBER;

292: FUNCTION get_all_resps_without_realms
293: (
294: p_realm_type IN VARCHAR2
295: )
296: RETURN ICX_TBL_NUMBER;
297:
298: FUNCTION get_resps_with_realms_store
299: (
300: p_realm_type IN VARCHAR2,

Line 303: RETURN ICX_TBL_NUMBER;

299: (
300: p_realm_type IN VARCHAR2,
301: p_old_store_id IN NUMBER
302: )
303: RETURN ICX_TBL_NUMBER;
304:
305: FUNCTION get_resps_without_realms_store
306: (
307: p_realm_type IN VARCHAR2,

Line 310: RETURN ICX_TBL_NUMBER;

306: (
307: p_realm_type IN VARCHAR2,
308: p_old_store_id IN NUMBER
309: )
310: RETURN ICX_TBL_NUMBER;
311:
312: END ICX_CAT_CNTNT_SCRTY_UPG_PVT;
313: