APPS.ICX_CONTENTS_POSTUPG_PVT dependencies on ICX_TBL_NUMBER

Line 41: l_original_zone_ids ICX_TBL_NUMBER := ICX_TBL_NUMBER();

37: --
38: PROCEDURE auto_split
39: IS
40:
41: l_original_zone_ids ICX_TBL_NUMBER := ICX_TBL_NUMBER();
42: l_new_zone_ids ICX_TBL_NUMBER := ICX_TBL_NUMBER();
43: l_zone_categories ICX_MAP_TBL_NUMBER;
44:
45: l_api_name CONSTANT VARCHAR2(30) := 'auto_split';

Line 42: l_new_zone_ids ICX_TBL_NUMBER := ICX_TBL_NUMBER();

38: PROCEDURE auto_split
39: IS
40:
41: l_original_zone_ids ICX_TBL_NUMBER := ICX_TBL_NUMBER();
42: l_new_zone_ids ICX_TBL_NUMBER := ICX_TBL_NUMBER();
43: l_zone_categories ICX_MAP_TBL_NUMBER;
44:
45: l_api_name CONSTANT VARCHAR2(30) := 'auto_split';
46: l_err_loc PLS_INTEGER;

Line 137: p_new_zone_ids OUT NOCOPY ICX_TBL_NUMBER,

133:
134:
135:
136: PROCEDURE get_new_zones_and_categorylist(p_original_zone_id IN NUMBER,
137: p_new_zone_ids OUT NOCOPY ICX_TBL_NUMBER,
138: p_zone_categories OUT NOCOPY ICX_MAP_TBL_NUMBER) IS
139:
140: l_category_list ICX_TBL_NUMBER := ICX_TBL_NUMBER();
141: l_zone_categories ICX_TBL_NUMBER := ICX_TBL_NUMBER();

Line 140: l_category_list ICX_TBL_NUMBER := ICX_TBL_NUMBER();

136: PROCEDURE get_new_zones_and_categorylist(p_original_zone_id IN NUMBER,
137: p_new_zone_ids OUT NOCOPY ICX_TBL_NUMBER,
138: p_zone_categories OUT NOCOPY ICX_MAP_TBL_NUMBER) IS
139:
140: l_category_list ICX_TBL_NUMBER := ICX_TBL_NUMBER();
141: l_zone_categories ICX_TBL_NUMBER := ICX_TBL_NUMBER();
142: l_no_of_zones_reqd PLS_INTEGER;
143: l_api_name CONSTANT VARCHAR2(30) := 'get_new_zones_and_categorylist';
144: l_err_loc PLS_INTEGER;

Line 141: l_zone_categories ICX_TBL_NUMBER := ICX_TBL_NUMBER();

137: p_new_zone_ids OUT NOCOPY ICX_TBL_NUMBER,
138: p_zone_categories OUT NOCOPY ICX_MAP_TBL_NUMBER) IS
139:
140: l_category_list ICX_TBL_NUMBER := ICX_TBL_NUMBER();
141: l_zone_categories ICX_TBL_NUMBER := ICX_TBL_NUMBER();
142: l_no_of_zones_reqd PLS_INTEGER;
143: l_api_name CONSTANT VARCHAR2(30) := 'get_new_zones_and_categorylist';
144: l_err_loc PLS_INTEGER;
145: l_zone_counter PLS_INTEGER := 0;

Line 201: p_new_zone_ids IN ICX_TBL_NUMBER) IS

197: END get_new_zones_and_categorylist;
198:
199:
200: PROCEDURE create_content_zones(p_old_zone_id IN NUMBER,
201: p_new_zone_ids IN ICX_TBL_NUMBER) IS
202:
203: l_api_name CONSTANT VARCHAR2(30) := 'create_content_zones_b';
204: l_err_loc PLS_INTEGER;
205: l_index_tab ICX_IDX_TBL_NUMBER;

Line 283: p_new_zone_ids IN ICX_TBL_NUMBER ,

279: END create_content_zones;
280:
281:
282: PROCEDURE create_category_restrictions(p_old_zone_id IN NUMBER,
283: p_new_zone_ids IN ICX_TBL_NUMBER ,
284: p_zone_categories IN ICX_MAP_TBL_NUMBER ) IS
285:
286: l_api_name CONSTANT VARCHAR2(30) := 'create_category_restrictions';
287: l_err_loc PLS_INTEGER;

Line 329: p_new_zone_ids IN ICX_TBL_NUMBER) IS

325: END create_category_restrictions;
326:
327:
328: PROCEDURE create_secure_contents(p_old_zone_id IN NUMBER,
329: p_new_zone_ids IN ICX_TBL_NUMBER) IS
330:
331: l_api_name CONSTANT VARCHAR2(30) := 'create_secure_contents';
332: l_err_loc PLS_INTEGER;
333:

Line 369: p_new_zone_ids IN ICX_TBL_NUMBER) IS

365:
366: END create_secure_contents;
367:
368: PROCEDURE add_new_zones_to_stores(p_old_zone_id IN NUMBER,
369: p_new_zone_ids IN ICX_TBL_NUMBER) IS
370:
371: l_api_name CONSTANT VARCHAR2(30) := 'add_new_zones_to_stores';
372: l_err_loc PLS_INTEGER;
373: