69: -- Version Initial version number = 1.0
70: -- History Current version number = 1.0
71: --=======================================================
72: procedure UPLOAD_REGION (
73: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
74: p_api_version_number IN NUMBER,
75: p_return_status OUT NOCOPY VARCHAR2,
76: p_index IN OUT NOCOPY NUMBER,
77: p_loader_timestamp IN DATE,
74: p_api_version_number IN NUMBER,
75: p_return_status OUT NOCOPY VARCHAR2,
76: p_index IN OUT NOCOPY NUMBER,
77: p_loader_timestamp IN DATE,
78: p_line_num IN NUMBER := FND_API.G_MISS_NUM,
79: p_buffer IN AK_ON_OBJECTS_PUB.Buffer_Type,
80: p_line_num_out OUT NOCOPY NUMBER,
81: p_buffer_out OUT NOCOPY AK_ON_OBJECTS_PUB.Buffer_Type,
82: p_upl_loader_cur IN OUT NOCOPY AK_ON_OBJECTS_PUB.LoaderCurTyp,
110: -- Version Initial version number = 1.0
111: -- History Current version number = 1.0
112: --=======================================================
113: procedure UPLOAD_REGION_SECOND (
114: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
115: p_return_status OUT NOCOPY VARCHAR2,
116: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
117: p_pass IN NUMBER := 2
118: );
112: --=======================================================
113: procedure UPLOAD_REGION_SECOND (
114: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
115: p_return_status OUT NOCOPY VARCHAR2,
116: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
117: p_pass IN NUMBER := 2
118: );
119:
120: --=======================================================
257: --
258: -- Version Initial version number = 1.1
259: --=======================================================
260: FUNCTION VALIDATE_GRAPH_COLUMN (
261: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
262: p_api_version_number IN NUMBER,
263: p_return_status OUT NOCOPY VARCHAR2,
264: p_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
265: p_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
260: FUNCTION VALIDATE_GRAPH_COLUMN (
261: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
262: p_api_version_number IN NUMBER,
263: p_return_status OUT NOCOPY VARCHAR2,
264: p_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
265: p_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
266: p_attribute_application_id IN NUMBER := FND_API.G_MISS_NUM,
267: p_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
268: p_graph_number IN NUMBER := FND_API.G_MISS_NUM,
261: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
262: p_api_version_number IN NUMBER,
263: p_return_status OUT NOCOPY VARCHAR2,
264: p_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
265: p_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
266: p_attribute_application_id IN NUMBER := FND_API.G_MISS_NUM,
267: p_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
268: p_graph_number IN NUMBER := FND_API.G_MISS_NUM,
269: p_pass IN NUMBER := 2,
262: p_api_version_number IN NUMBER,
263: p_return_status OUT NOCOPY VARCHAR2,
264: p_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
265: p_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
266: p_attribute_application_id IN NUMBER := FND_API.G_MISS_NUM,
267: p_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
268: p_graph_number IN NUMBER := FND_API.G_MISS_NUM,
269: p_pass IN NUMBER := 2,
270: p_caller IN VARCHAR2
263: p_return_status OUT NOCOPY VARCHAR2,
264: p_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
265: p_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
266: p_attribute_application_id IN NUMBER := FND_API.G_MISS_NUM,
267: p_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
268: p_graph_number IN NUMBER := FND_API.G_MISS_NUM,
269: p_pass IN NUMBER := 2,
270: p_caller IN VARCHAR2
271: ) return boolean;
264: p_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
265: p_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
266: p_attribute_application_id IN NUMBER := FND_API.G_MISS_NUM,
267: p_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
268: p_graph_number IN NUMBER := FND_API.G_MISS_NUM,
269: p_pass IN NUMBER := 2,
270: p_caller IN VARCHAR2
271: ) return boolean;
272: */
301: --
302: -- Version Initial version number = 1.1
303: --=======================================================
304: FUNCTION VALIDATE_LOV_RELATION (
305: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
306: p_api_version_number IN NUMBER,
307: p_return_status OUT NOCOPY VARCHAR2,
308: p_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
309: p_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
304: FUNCTION VALIDATE_LOV_RELATION (
305: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
306: p_api_version_number IN NUMBER,
307: p_return_status OUT NOCOPY VARCHAR2,
308: p_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
309: p_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
310: p_attribute_application_id IN NUMBER := FND_API.G_MISS_NUM,
311: p_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
312: p_lov_region_appl_id IN NUMBER := FND_API.G_MISS_NUM,
305: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
306: p_api_version_number IN NUMBER,
307: p_return_status OUT NOCOPY VARCHAR2,
308: p_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
309: p_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
310: p_attribute_application_id IN NUMBER := FND_API.G_MISS_NUM,
311: p_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
312: p_lov_region_appl_id IN NUMBER := FND_API.G_MISS_NUM,
313: p_lov_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
306: p_api_version_number IN NUMBER,
307: p_return_status OUT NOCOPY VARCHAR2,
308: p_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
309: p_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
310: p_attribute_application_id IN NUMBER := FND_API.G_MISS_NUM,
311: p_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
312: p_lov_region_appl_id IN NUMBER := FND_API.G_MISS_NUM,
313: p_lov_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
314: p_lov_attribute_appl_id IN NUMBER := FND_API.G_MISS_NUM,
307: p_return_status OUT NOCOPY VARCHAR2,
308: p_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
309: p_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
310: p_attribute_application_id IN NUMBER := FND_API.G_MISS_NUM,
311: p_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
312: p_lov_region_appl_id IN NUMBER := FND_API.G_MISS_NUM,
313: p_lov_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
314: p_lov_attribute_appl_id IN NUMBER := FND_API.G_MISS_NUM,
315: p_lov_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
308: p_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
309: p_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
310: p_attribute_application_id IN NUMBER := FND_API.G_MISS_NUM,
311: p_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
312: p_lov_region_appl_id IN NUMBER := FND_API.G_MISS_NUM,
313: p_lov_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
314: p_lov_attribute_appl_id IN NUMBER := FND_API.G_MISS_NUM,
315: p_lov_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
316: p_base_attribute_appl_id IN NUMBER := FND_API.G_MISS_NUM,
309: p_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
310: p_attribute_application_id IN NUMBER := FND_API.G_MISS_NUM,
311: p_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
312: p_lov_region_appl_id IN NUMBER := FND_API.G_MISS_NUM,
313: p_lov_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
314: p_lov_attribute_appl_id IN NUMBER := FND_API.G_MISS_NUM,
315: p_lov_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
316: p_base_attribute_appl_id IN NUMBER := FND_API.G_MISS_NUM,
317: p_base_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
310: p_attribute_application_id IN NUMBER := FND_API.G_MISS_NUM,
311: p_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
312: p_lov_region_appl_id IN NUMBER := FND_API.G_MISS_NUM,
313: p_lov_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
314: p_lov_attribute_appl_id IN NUMBER := FND_API.G_MISS_NUM,
315: p_lov_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
316: p_base_attribute_appl_id IN NUMBER := FND_API.G_MISS_NUM,
317: p_base_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
318: p_direction_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
311: p_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
312: p_lov_region_appl_id IN NUMBER := FND_API.G_MISS_NUM,
313: p_lov_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
314: p_lov_attribute_appl_id IN NUMBER := FND_API.G_MISS_NUM,
315: p_lov_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
316: p_base_attribute_appl_id IN NUMBER := FND_API.G_MISS_NUM,
317: p_base_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
318: p_direction_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
319: p_base_region_appl_id IN NUMBER := FND_API.G_MISS_NUM,
312: p_lov_region_appl_id IN NUMBER := FND_API.G_MISS_NUM,
313: p_lov_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
314: p_lov_attribute_appl_id IN NUMBER := FND_API.G_MISS_NUM,
315: p_lov_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
316: p_base_attribute_appl_id IN NUMBER := FND_API.G_MISS_NUM,
317: p_base_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
318: p_direction_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
319: p_base_region_appl_id IN NUMBER := FND_API.G_MISS_NUM,
320: p_base_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
313: p_lov_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
314: p_lov_attribute_appl_id IN NUMBER := FND_API.G_MISS_NUM,
315: p_lov_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
316: p_base_attribute_appl_id IN NUMBER := FND_API.G_MISS_NUM,
317: p_base_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
318: p_direction_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
319: p_base_region_appl_id IN NUMBER := FND_API.G_MISS_NUM,
320: p_base_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
321: p_caller IN VARCHAR2,
314: p_lov_attribute_appl_id IN NUMBER := FND_API.G_MISS_NUM,
315: p_lov_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
316: p_base_attribute_appl_id IN NUMBER := FND_API.G_MISS_NUM,
317: p_base_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
318: p_direction_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
319: p_base_region_appl_id IN NUMBER := FND_API.G_MISS_NUM,
320: p_base_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
321: p_caller IN VARCHAR2,
322: p_pass IN NUMBER := 2
315: p_lov_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
316: p_base_attribute_appl_id IN NUMBER := FND_API.G_MISS_NUM,
317: p_base_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
318: p_direction_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
319: p_base_region_appl_id IN NUMBER := FND_API.G_MISS_NUM,
320: p_base_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
321: p_caller IN VARCHAR2,
322: p_pass IN NUMBER := 2
323: ) return boolean;
316: p_base_attribute_appl_id IN NUMBER := FND_API.G_MISS_NUM,
317: p_base_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
318: p_direction_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
319: p_base_region_appl_id IN NUMBER := FND_API.G_MISS_NUM,
320: p_base_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
321: p_caller IN VARCHAR2,
322: p_pass IN NUMBER := 2
323: ) return boolean;
324:
347: --
348: -- Version Initial version number = 1.1
349: --=======================================================
350: PROCEDURE CREATE_GRAPH_COLUMN (
351: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
352: p_api_version_number IN NUMBER,
353: p_init_msg_tbl IN BOOLEAN := FALSE,
354: p_msg_count OUT NOCOPY NUMBER,
355: p_msg_data OUT NOCOPY VARCHAR2,
353: p_init_msg_tbl IN BOOLEAN := FALSE,
354: p_msg_count OUT NOCOPY NUMBER,
355: p_msg_data OUT NOCOPY VARCHAR2,
356: p_return_status OUT NOCOPY VARCHAR2,
357: p_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
358: p_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
359: p_attribute_application_id IN NUMBER := FND_API.G_MISS_NUM,
360: p_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
361: p_graph_number IN NUMBER := FND_API.G_MISS_NUM,
354: p_msg_count OUT NOCOPY NUMBER,
355: p_msg_data OUT NOCOPY VARCHAR2,
356: p_return_status OUT NOCOPY VARCHAR2,
357: p_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
358: p_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
359: p_attribute_application_id IN NUMBER := FND_API.G_MISS_NUM,
360: p_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
361: p_graph_number IN NUMBER := FND_API.G_MISS_NUM,
362: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
355: p_msg_data OUT NOCOPY VARCHAR2,
356: p_return_status OUT NOCOPY VARCHAR2,
357: p_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
358: p_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
359: p_attribute_application_id IN NUMBER := FND_API.G_MISS_NUM,
360: p_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
361: p_graph_number IN NUMBER := FND_API.G_MISS_NUM,
362: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
363: p_creation_date IN DATE := FND_API.G_MISS_DATE,
356: p_return_status OUT NOCOPY VARCHAR2,
357: p_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
358: p_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
359: p_attribute_application_id IN NUMBER := FND_API.G_MISS_NUM,
360: p_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
361: p_graph_number IN NUMBER := FND_API.G_MISS_NUM,
362: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
363: p_creation_date IN DATE := FND_API.G_MISS_DATE,
364: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
357: p_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
358: p_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
359: p_attribute_application_id IN NUMBER := FND_API.G_MISS_NUM,
360: p_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
361: p_graph_number IN NUMBER := FND_API.G_MISS_NUM,
362: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
363: p_creation_date IN DATE := FND_API.G_MISS_DATE,
364: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
365: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
358: p_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
359: p_attribute_application_id IN NUMBER := FND_API.G_MISS_NUM,
360: p_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
361: p_graph_number IN NUMBER := FND_API.G_MISS_NUM,
362: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
363: p_creation_date IN DATE := FND_API.G_MISS_DATE,
364: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
365: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
366: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
359: p_attribute_application_id IN NUMBER := FND_API.G_MISS_NUM,
360: p_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
361: p_graph_number IN NUMBER := FND_API.G_MISS_NUM,
362: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
363: p_creation_date IN DATE := FND_API.G_MISS_DATE,
364: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
365: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
366: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
367: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
360: p_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
361: p_graph_number IN NUMBER := FND_API.G_MISS_NUM,
362: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
363: p_creation_date IN DATE := FND_API.G_MISS_DATE,
364: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
365: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
366: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
367: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
368: p_pass IN NUMBER,
361: p_graph_number IN NUMBER := FND_API.G_MISS_NUM,
362: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
363: p_creation_date IN DATE := FND_API.G_MISS_DATE,
364: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
365: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
366: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
367: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
368: p_pass IN NUMBER,
369: p_copy_redo_flag IN OUT NOCOPY BOOLEAN
362: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
363: p_creation_date IN DATE := FND_API.G_MISS_DATE,
364: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
365: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
366: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
367: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
368: p_pass IN NUMBER,
369: p_copy_redo_flag IN OUT NOCOPY BOOLEAN
370: );
363: p_creation_date IN DATE := FND_API.G_MISS_DATE,
364: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
365: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
366: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
367: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
368: p_pass IN NUMBER,
369: p_copy_redo_flag IN OUT NOCOPY BOOLEAN
370: );
371: */
394: --
395: -- Version Initial version number = 1.1
396: --=======================================================
397: PROCEDURE CREATE_LOV_RELATION (
398: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
399: p_api_version_number IN NUMBER,
400: p_init_msg_tbl IN BOOLEAN := FALSE,
401: p_msg_count OUT NOCOPY NUMBER,
402: p_msg_data OUT NOCOPY VARCHAR2,
400: p_init_msg_tbl IN BOOLEAN := FALSE,
401: p_msg_count OUT NOCOPY NUMBER,
402: p_msg_data OUT NOCOPY VARCHAR2,
403: p_return_status OUT NOCOPY VARCHAR2,
404: p_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
405: p_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
406: p_attribute_application_id IN NUMBER := FND_API.G_MISS_NUM,
407: p_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
408: p_lov_region_appl_id IN NUMBER := FND_API.G_MISS_NUM,
401: p_msg_count OUT NOCOPY NUMBER,
402: p_msg_data OUT NOCOPY VARCHAR2,
403: p_return_status OUT NOCOPY VARCHAR2,
404: p_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
405: p_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
406: p_attribute_application_id IN NUMBER := FND_API.G_MISS_NUM,
407: p_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
408: p_lov_region_appl_id IN NUMBER := FND_API.G_MISS_NUM,
409: p_lov_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
402: p_msg_data OUT NOCOPY VARCHAR2,
403: p_return_status OUT NOCOPY VARCHAR2,
404: p_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
405: p_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
406: p_attribute_application_id IN NUMBER := FND_API.G_MISS_NUM,
407: p_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
408: p_lov_region_appl_id IN NUMBER := FND_API.G_MISS_NUM,
409: p_lov_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
410: p_lov_attribute_appl_id IN NUMBER := FND_API.G_MISS_NUM,
403: p_return_status OUT NOCOPY VARCHAR2,
404: p_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
405: p_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
406: p_attribute_application_id IN NUMBER := FND_API.G_MISS_NUM,
407: p_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
408: p_lov_region_appl_id IN NUMBER := FND_API.G_MISS_NUM,
409: p_lov_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
410: p_lov_attribute_appl_id IN NUMBER := FND_API.G_MISS_NUM,
411: p_lov_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
404: p_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
405: p_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
406: p_attribute_application_id IN NUMBER := FND_API.G_MISS_NUM,
407: p_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
408: p_lov_region_appl_id IN NUMBER := FND_API.G_MISS_NUM,
409: p_lov_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
410: p_lov_attribute_appl_id IN NUMBER := FND_API.G_MISS_NUM,
411: p_lov_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
412: p_base_attribute_appl_id IN NUMBER := FND_API.G_MISS_NUM,
405: p_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
406: p_attribute_application_id IN NUMBER := FND_API.G_MISS_NUM,
407: p_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
408: p_lov_region_appl_id IN NUMBER := FND_API.G_MISS_NUM,
409: p_lov_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
410: p_lov_attribute_appl_id IN NUMBER := FND_API.G_MISS_NUM,
411: p_lov_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
412: p_base_attribute_appl_id IN NUMBER := FND_API.G_MISS_NUM,
413: p_base_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
406: p_attribute_application_id IN NUMBER := FND_API.G_MISS_NUM,
407: p_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
408: p_lov_region_appl_id IN NUMBER := FND_API.G_MISS_NUM,
409: p_lov_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
410: p_lov_attribute_appl_id IN NUMBER := FND_API.G_MISS_NUM,
411: p_lov_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
412: p_base_attribute_appl_id IN NUMBER := FND_API.G_MISS_NUM,
413: p_base_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
414: p_direction_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
407: p_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
408: p_lov_region_appl_id IN NUMBER := FND_API.G_MISS_NUM,
409: p_lov_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
410: p_lov_attribute_appl_id IN NUMBER := FND_API.G_MISS_NUM,
411: p_lov_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
412: p_base_attribute_appl_id IN NUMBER := FND_API.G_MISS_NUM,
413: p_base_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
414: p_direction_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
415: p_base_region_appl_id IN NUMBER := FND_API.G_MISS_NUM,
408: p_lov_region_appl_id IN NUMBER := FND_API.G_MISS_NUM,
409: p_lov_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
410: p_lov_attribute_appl_id IN NUMBER := FND_API.G_MISS_NUM,
411: p_lov_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
412: p_base_attribute_appl_id IN NUMBER := FND_API.G_MISS_NUM,
413: p_base_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
414: p_direction_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
415: p_base_region_appl_id IN NUMBER := FND_API.G_MISS_NUM,
416: p_base_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
409: p_lov_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
410: p_lov_attribute_appl_id IN NUMBER := FND_API.G_MISS_NUM,
411: p_lov_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
412: p_base_attribute_appl_id IN NUMBER := FND_API.G_MISS_NUM,
413: p_base_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
414: p_direction_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
415: p_base_region_appl_id IN NUMBER := FND_API.G_MISS_NUM,
416: p_base_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
417: p_required_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
410: p_lov_attribute_appl_id IN NUMBER := FND_API.G_MISS_NUM,
411: p_lov_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
412: p_base_attribute_appl_id IN NUMBER := FND_API.G_MISS_NUM,
413: p_base_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
414: p_direction_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
415: p_base_region_appl_id IN NUMBER := FND_API.G_MISS_NUM,
416: p_base_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
417: p_required_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
418: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
411: p_lov_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
412: p_base_attribute_appl_id IN NUMBER := FND_API.G_MISS_NUM,
413: p_base_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
414: p_direction_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
415: p_base_region_appl_id IN NUMBER := FND_API.G_MISS_NUM,
416: p_base_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
417: p_required_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
418: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
419: p_creation_date IN DATE := FND_API.G_MISS_DATE,
412: p_base_attribute_appl_id IN NUMBER := FND_API.G_MISS_NUM,
413: p_base_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
414: p_direction_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
415: p_base_region_appl_id IN NUMBER := FND_API.G_MISS_NUM,
416: p_base_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
417: p_required_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
418: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
419: p_creation_date IN DATE := FND_API.G_MISS_DATE,
420: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
413: p_base_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
414: p_direction_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
415: p_base_region_appl_id IN NUMBER := FND_API.G_MISS_NUM,
416: p_base_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
417: p_required_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
418: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
419: p_creation_date IN DATE := FND_API.G_MISS_DATE,
420: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
421: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
414: p_direction_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
415: p_base_region_appl_id IN NUMBER := FND_API.G_MISS_NUM,
416: p_base_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
417: p_required_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
418: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
419: p_creation_date IN DATE := FND_API.G_MISS_DATE,
420: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
421: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
422: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
415: p_base_region_appl_id IN NUMBER := FND_API.G_MISS_NUM,
416: p_base_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
417: p_required_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
418: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
419: p_creation_date IN DATE := FND_API.G_MISS_DATE,
420: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
421: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
422: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
423: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
416: p_base_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
417: p_required_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
418: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
419: p_creation_date IN DATE := FND_API.G_MISS_DATE,
420: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
421: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
422: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
423: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
424: p_pass IN NUMBER,
417: p_required_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
418: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
419: p_creation_date IN DATE := FND_API.G_MISS_DATE,
420: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
421: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
422: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
423: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
424: p_pass IN NUMBER,
425: p_copy_redo_flag IN OUT NOCOPY BOOLEAN
418: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
419: p_creation_date IN DATE := FND_API.G_MISS_DATE,
420: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
421: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
422: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
423: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
424: p_pass IN NUMBER,
425: p_copy_redo_flag IN OUT NOCOPY BOOLEAN
426: );
419: p_creation_date IN DATE := FND_API.G_MISS_DATE,
420: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
421: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
422: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
423: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
424: p_pass IN NUMBER,
425: p_copy_redo_flag IN OUT NOCOPY BOOLEAN
426: );
427:
449: -- Version Initial version number = 1.0
450: -- History Current version number = 1.0
451: --=======================================================
452: PROCEDURE UPDATE_GRAPH_COLUMN (
453: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
454: p_api_version_number IN NUMBER,
455: p_init_msg_tbl IN BOOLEAN := FALSE,
456: p_msg_count OUT NOCOPY NUMBER,
457: p_msg_data OUT NOCOPY VARCHAR2,
455: p_init_msg_tbl IN BOOLEAN := FALSE,
456: p_msg_count OUT NOCOPY NUMBER,
457: p_msg_data OUT NOCOPY VARCHAR2,
458: p_return_status OUT NOCOPY VARCHAR2,
459: p_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
460: p_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
461: p_attribute_application_id IN NUMBER := FND_API.G_MISS_NUM,
462: p_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
463: p_graph_number IN NUMBER := FND_API.G_MISS_NUM,
456: p_msg_count OUT NOCOPY NUMBER,
457: p_msg_data OUT NOCOPY VARCHAR2,
458: p_return_status OUT NOCOPY VARCHAR2,
459: p_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
460: p_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
461: p_attribute_application_id IN NUMBER := FND_API.G_MISS_NUM,
462: p_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
463: p_graph_number IN NUMBER := FND_API.G_MISS_NUM,
464: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
457: p_msg_data OUT NOCOPY VARCHAR2,
458: p_return_status OUT NOCOPY VARCHAR2,
459: p_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
460: p_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
461: p_attribute_application_id IN NUMBER := FND_API.G_MISS_NUM,
462: p_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
463: p_graph_number IN NUMBER := FND_API.G_MISS_NUM,
464: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
465: p_creation_date IN DATE := FND_API.G_MISS_DATE,
458: p_return_status OUT NOCOPY VARCHAR2,
459: p_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
460: p_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
461: p_attribute_application_id IN NUMBER := FND_API.G_MISS_NUM,
462: p_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
463: p_graph_number IN NUMBER := FND_API.G_MISS_NUM,
464: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
465: p_creation_date IN DATE := FND_API.G_MISS_DATE,
466: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
459: p_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
460: p_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
461: p_attribute_application_id IN NUMBER := FND_API.G_MISS_NUM,
462: p_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
463: p_graph_number IN NUMBER := FND_API.G_MISS_NUM,
464: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
465: p_creation_date IN DATE := FND_API.G_MISS_DATE,
466: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
467: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
460: p_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
461: p_attribute_application_id IN NUMBER := FND_API.G_MISS_NUM,
462: p_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
463: p_graph_number IN NUMBER := FND_API.G_MISS_NUM,
464: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
465: p_creation_date IN DATE := FND_API.G_MISS_DATE,
466: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
467: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
468: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
461: p_attribute_application_id IN NUMBER := FND_API.G_MISS_NUM,
462: p_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
463: p_graph_number IN NUMBER := FND_API.G_MISS_NUM,
464: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
465: p_creation_date IN DATE := FND_API.G_MISS_DATE,
466: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
467: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
468: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
469: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
462: p_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
463: p_graph_number IN NUMBER := FND_API.G_MISS_NUM,
464: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
465: p_creation_date IN DATE := FND_API.G_MISS_DATE,
466: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
467: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
468: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
469: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
470: p_pass IN NUMBER,
463: p_graph_number IN NUMBER := FND_API.G_MISS_NUM,
464: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
465: p_creation_date IN DATE := FND_API.G_MISS_DATE,
466: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
467: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
468: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
469: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
470: p_pass IN NUMBER,
471: p_copy_redo_flag IN OUT NOCOPY BOOLEAN
464: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
465: p_creation_date IN DATE := FND_API.G_MISS_DATE,
466: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
467: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
468: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
469: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
470: p_pass IN NUMBER,
471: p_copy_redo_flag IN OUT NOCOPY BOOLEAN
472: );
465: p_creation_date IN DATE := FND_API.G_MISS_DATE,
466: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
467: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
468: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
469: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
470: p_pass IN NUMBER,
471: p_copy_redo_flag IN OUT NOCOPY BOOLEAN
472: );
473: */
495: -- Version Initial version number = 1.0
496: -- History Current version number = 1.0
497: --=======================================================
498: PROCEDURE UPDATE_LOV_RELATION (
499: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
500: p_api_version_number IN NUMBER,
501: p_init_msg_tbl IN BOOLEAN := FALSE,
502: p_msg_count OUT NOCOPY NUMBER,
503: p_msg_data OUT NOCOPY VARCHAR2,
501: p_init_msg_tbl IN BOOLEAN := FALSE,
502: p_msg_count OUT NOCOPY NUMBER,
503: p_msg_data OUT NOCOPY VARCHAR2,
504: p_return_status OUT NOCOPY VARCHAR2,
505: p_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
506: p_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
507: p_attribute_application_id IN NUMBER := FND_API.G_MISS_NUM,
508: p_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
509: p_lov_region_appl_id IN NUMBER := FND_API.G_MISS_NUM,
502: p_msg_count OUT NOCOPY NUMBER,
503: p_msg_data OUT NOCOPY VARCHAR2,
504: p_return_status OUT NOCOPY VARCHAR2,
505: p_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
506: p_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
507: p_attribute_application_id IN NUMBER := FND_API.G_MISS_NUM,
508: p_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
509: p_lov_region_appl_id IN NUMBER := FND_API.G_MISS_NUM,
510: p_lov_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
503: p_msg_data OUT NOCOPY VARCHAR2,
504: p_return_status OUT NOCOPY VARCHAR2,
505: p_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
506: p_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
507: p_attribute_application_id IN NUMBER := FND_API.G_MISS_NUM,
508: p_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
509: p_lov_region_appl_id IN NUMBER := FND_API.G_MISS_NUM,
510: p_lov_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
511: p_lov_attribute_appl_id IN NUMBER := FND_API.G_MISS_NUM,
504: p_return_status OUT NOCOPY VARCHAR2,
505: p_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
506: p_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
507: p_attribute_application_id IN NUMBER := FND_API.G_MISS_NUM,
508: p_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
509: p_lov_region_appl_id IN NUMBER := FND_API.G_MISS_NUM,
510: p_lov_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
511: p_lov_attribute_appl_id IN NUMBER := FND_API.G_MISS_NUM,
512: p_lov_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
505: p_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
506: p_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
507: p_attribute_application_id IN NUMBER := FND_API.G_MISS_NUM,
508: p_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
509: p_lov_region_appl_id IN NUMBER := FND_API.G_MISS_NUM,
510: p_lov_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
511: p_lov_attribute_appl_id IN NUMBER := FND_API.G_MISS_NUM,
512: p_lov_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
513: p_base_attribute_appl_id IN NUMBER := FND_API.G_MISS_NUM,
506: p_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
507: p_attribute_application_id IN NUMBER := FND_API.G_MISS_NUM,
508: p_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
509: p_lov_region_appl_id IN NUMBER := FND_API.G_MISS_NUM,
510: p_lov_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
511: p_lov_attribute_appl_id IN NUMBER := FND_API.G_MISS_NUM,
512: p_lov_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
513: p_base_attribute_appl_id IN NUMBER := FND_API.G_MISS_NUM,
514: p_base_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
507: p_attribute_application_id IN NUMBER := FND_API.G_MISS_NUM,
508: p_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
509: p_lov_region_appl_id IN NUMBER := FND_API.G_MISS_NUM,
510: p_lov_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
511: p_lov_attribute_appl_id IN NUMBER := FND_API.G_MISS_NUM,
512: p_lov_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
513: p_base_attribute_appl_id IN NUMBER := FND_API.G_MISS_NUM,
514: p_base_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
515: p_direction_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
508: p_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
509: p_lov_region_appl_id IN NUMBER := FND_API.G_MISS_NUM,
510: p_lov_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
511: p_lov_attribute_appl_id IN NUMBER := FND_API.G_MISS_NUM,
512: p_lov_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
513: p_base_attribute_appl_id IN NUMBER := FND_API.G_MISS_NUM,
514: p_base_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
515: p_direction_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
516: p_base_region_appl_id IN NUMBER := FND_API.G_MISS_NUM,
509: p_lov_region_appl_id IN NUMBER := FND_API.G_MISS_NUM,
510: p_lov_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
511: p_lov_attribute_appl_id IN NUMBER := FND_API.G_MISS_NUM,
512: p_lov_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
513: p_base_attribute_appl_id IN NUMBER := FND_API.G_MISS_NUM,
514: p_base_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
515: p_direction_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
516: p_base_region_appl_id IN NUMBER := FND_API.G_MISS_NUM,
517: p_base_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
510: p_lov_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
511: p_lov_attribute_appl_id IN NUMBER := FND_API.G_MISS_NUM,
512: p_lov_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
513: p_base_attribute_appl_id IN NUMBER := FND_API.G_MISS_NUM,
514: p_base_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
515: p_direction_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
516: p_base_region_appl_id IN NUMBER := FND_API.G_MISS_NUM,
517: p_base_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
518: p_required_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
511: p_lov_attribute_appl_id IN NUMBER := FND_API.G_MISS_NUM,
512: p_lov_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
513: p_base_attribute_appl_id IN NUMBER := FND_API.G_MISS_NUM,
514: p_base_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
515: p_direction_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
516: p_base_region_appl_id IN NUMBER := FND_API.G_MISS_NUM,
517: p_base_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
518: p_required_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
519: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
512: p_lov_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
513: p_base_attribute_appl_id IN NUMBER := FND_API.G_MISS_NUM,
514: p_base_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
515: p_direction_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
516: p_base_region_appl_id IN NUMBER := FND_API.G_MISS_NUM,
517: p_base_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
518: p_required_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
519: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
520: p_creation_date IN DATE := FND_API.G_MISS_DATE,
513: p_base_attribute_appl_id IN NUMBER := FND_API.G_MISS_NUM,
514: p_base_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
515: p_direction_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
516: p_base_region_appl_id IN NUMBER := FND_API.G_MISS_NUM,
517: p_base_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
518: p_required_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
519: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
520: p_creation_date IN DATE := FND_API.G_MISS_DATE,
521: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
514: p_base_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
515: p_direction_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
516: p_base_region_appl_id IN NUMBER := FND_API.G_MISS_NUM,
517: p_base_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
518: p_required_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
519: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
520: p_creation_date IN DATE := FND_API.G_MISS_DATE,
521: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
522: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
515: p_direction_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
516: p_base_region_appl_id IN NUMBER := FND_API.G_MISS_NUM,
517: p_base_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
518: p_required_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
519: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
520: p_creation_date IN DATE := FND_API.G_MISS_DATE,
521: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
522: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
523: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
516: p_base_region_appl_id IN NUMBER := FND_API.G_MISS_NUM,
517: p_base_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
518: p_required_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
519: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
520: p_creation_date IN DATE := FND_API.G_MISS_DATE,
521: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
522: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
523: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
524: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
517: p_base_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
518: p_required_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
519: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
520: p_creation_date IN DATE := FND_API.G_MISS_DATE,
521: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
522: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
523: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
524: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
525: p_pass IN NUMBER,
518: p_required_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
519: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
520: p_creation_date IN DATE := FND_API.G_MISS_DATE,
521: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
522: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
523: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
524: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
525: p_pass IN NUMBER,
526: p_copy_redo_flag IN OUT NOCOPY BOOLEAN
519: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
520: p_creation_date IN DATE := FND_API.G_MISS_DATE,
521: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
522: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
523: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
524: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
525: p_pass IN NUMBER,
526: p_copy_redo_flag IN OUT NOCOPY BOOLEAN
527: );
520: p_creation_date IN DATE := FND_API.G_MISS_DATE,
521: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
522: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
523: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
524: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
525: p_pass IN NUMBER,
526: p_copy_redo_flag IN OUT NOCOPY BOOLEAN
527: );
528:
556: --
557: -- Version Initial version number = 1.1
558: --=======================================================
559: FUNCTION VALIDATE_CATEGORY_USAGE (
560: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
561: p_api_version_number IN NUMBER,
562: p_return_status OUT NOCOPY VARCHAR2,
563: p_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
564: p_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
559: FUNCTION VALIDATE_CATEGORY_USAGE (
560: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
561: p_api_version_number IN NUMBER,
562: p_return_status OUT NOCOPY VARCHAR2,
563: p_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
564: p_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
565: p_attribute_application_id IN NUMBER := FND_API.G_MISS_NUM,
566: p_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
567: p_category_name IN VARCHAR2:= FND_API.G_MISS_CHAR,
560: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
561: p_api_version_number IN NUMBER,
562: p_return_status OUT NOCOPY VARCHAR2,
563: p_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
564: p_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
565: p_attribute_application_id IN NUMBER := FND_API.G_MISS_NUM,
566: p_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
567: p_category_name IN VARCHAR2:= FND_API.G_MISS_CHAR,
568: p_category_id IN NUMBER := FND_API.G_MISS_NUM,
561: p_api_version_number IN NUMBER,
562: p_return_status OUT NOCOPY VARCHAR2,
563: p_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
564: p_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
565: p_attribute_application_id IN NUMBER := FND_API.G_MISS_NUM,
566: p_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
567: p_category_name IN VARCHAR2:= FND_API.G_MISS_CHAR,
568: p_category_id IN NUMBER := FND_API.G_MISS_NUM,
569: p_application_id IN NUMBER := FND_API.G_MISS_NUM,
562: p_return_status OUT NOCOPY VARCHAR2,
563: p_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
564: p_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
565: p_attribute_application_id IN NUMBER := FND_API.G_MISS_NUM,
566: p_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
567: p_category_name IN VARCHAR2:= FND_API.G_MISS_CHAR,
568: p_category_id IN NUMBER := FND_API.G_MISS_NUM,
569: p_application_id IN NUMBER := FND_API.G_MISS_NUM,
570: p_show_all IN VARCHAR2 := FND_API.G_MISS_CHAR,
563: p_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
564: p_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
565: p_attribute_application_id IN NUMBER := FND_API.G_MISS_NUM,
566: p_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
567: p_category_name IN VARCHAR2:= FND_API.G_MISS_CHAR,
568: p_category_id IN NUMBER := FND_API.G_MISS_NUM,
569: p_application_id IN NUMBER := FND_API.G_MISS_NUM,
570: p_show_all IN VARCHAR2 := FND_API.G_MISS_CHAR,
571: p_caller IN VARCHAR2,
564: p_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
565: p_attribute_application_id IN NUMBER := FND_API.G_MISS_NUM,
566: p_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
567: p_category_name IN VARCHAR2:= FND_API.G_MISS_CHAR,
568: p_category_id IN NUMBER := FND_API.G_MISS_NUM,
569: p_application_id IN NUMBER := FND_API.G_MISS_NUM,
570: p_show_all IN VARCHAR2 := FND_API.G_MISS_CHAR,
571: p_caller IN VARCHAR2,
572: p_pass IN NUMBER := 2
565: p_attribute_application_id IN NUMBER := FND_API.G_MISS_NUM,
566: p_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
567: p_category_name IN VARCHAR2:= FND_API.G_MISS_CHAR,
568: p_category_id IN NUMBER := FND_API.G_MISS_NUM,
569: p_application_id IN NUMBER := FND_API.G_MISS_NUM,
570: p_show_all IN VARCHAR2 := FND_API.G_MISS_CHAR,
571: p_caller IN VARCHAR2,
572: p_pass IN NUMBER := 2
573: ) return boolean;
566: p_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
567: p_category_name IN VARCHAR2:= FND_API.G_MISS_CHAR,
568: p_category_id IN NUMBER := FND_API.G_MISS_NUM,
569: p_application_id IN NUMBER := FND_API.G_MISS_NUM,
570: p_show_all IN VARCHAR2 := FND_API.G_MISS_CHAR,
571: p_caller IN VARCHAR2,
572: p_pass IN NUMBER := 2
573: ) return boolean;
574:
630: --
631: -- Version Initial version number = 1.1
632: --=======================================================
633: PROCEDURE CREATE_CATEGORY_USAGE (
634: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
635: p_api_version_number IN NUMBER,
636: p_init_msg_tbl IN BOOLEAN := FALSE,
637: p_msg_count OUT NOCOPY NUMBER,
638: p_msg_data OUT NOCOPY VARCHAR2,
636: p_init_msg_tbl IN BOOLEAN := FALSE,
637: p_msg_count OUT NOCOPY NUMBER,
638: p_msg_data OUT NOCOPY VARCHAR2,
639: p_return_status OUT NOCOPY VARCHAR2,
640: p_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
641: p_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
642: p_attribute_application_id IN NUMBER := FND_API.G_MISS_NUM,
643: p_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
644: p_category_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
637: p_msg_count OUT NOCOPY NUMBER,
638: p_msg_data OUT NOCOPY VARCHAR2,
639: p_return_status OUT NOCOPY VARCHAR2,
640: p_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
641: p_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
642: p_attribute_application_id IN NUMBER := FND_API.G_MISS_NUM,
643: p_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
644: p_category_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
645: p_category_id IN NUMBER := FND_API.G_MISS_NUM,
638: p_msg_data OUT NOCOPY VARCHAR2,
639: p_return_status OUT NOCOPY VARCHAR2,
640: p_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
641: p_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
642: p_attribute_application_id IN NUMBER := FND_API.G_MISS_NUM,
643: p_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
644: p_category_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
645: p_category_id IN NUMBER := FND_API.G_MISS_NUM,
646: p_application_id IN NUMBER := FND_API.G_MISS_NUM,
639: p_return_status OUT NOCOPY VARCHAR2,
640: p_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
641: p_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
642: p_attribute_application_id IN NUMBER := FND_API.G_MISS_NUM,
643: p_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
644: p_category_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
645: p_category_id IN NUMBER := FND_API.G_MISS_NUM,
646: p_application_id IN NUMBER := FND_API.G_MISS_NUM,
647: p_show_all IN VARCHAR2 := FND_API.G_MISS_CHAR,
640: p_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
641: p_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
642: p_attribute_application_id IN NUMBER := FND_API.G_MISS_NUM,
643: p_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
644: p_category_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
645: p_category_id IN NUMBER := FND_API.G_MISS_NUM,
646: p_application_id IN NUMBER := FND_API.G_MISS_NUM,
647: p_show_all IN VARCHAR2 := FND_API.G_MISS_CHAR,
648: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
641: p_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
642: p_attribute_application_id IN NUMBER := FND_API.G_MISS_NUM,
643: p_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
644: p_category_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
645: p_category_id IN NUMBER := FND_API.G_MISS_NUM,
646: p_application_id IN NUMBER := FND_API.G_MISS_NUM,
647: p_show_all IN VARCHAR2 := FND_API.G_MISS_CHAR,
648: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
649: p_creation_date IN DATE := FND_API.G_MISS_DATE,
642: p_attribute_application_id IN NUMBER := FND_API.G_MISS_NUM,
643: p_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
644: p_category_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
645: p_category_id IN NUMBER := FND_API.G_MISS_NUM,
646: p_application_id IN NUMBER := FND_API.G_MISS_NUM,
647: p_show_all IN VARCHAR2 := FND_API.G_MISS_CHAR,
648: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
649: p_creation_date IN DATE := FND_API.G_MISS_DATE,
650: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
643: p_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
644: p_category_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
645: p_category_id IN NUMBER := FND_API.G_MISS_NUM,
646: p_application_id IN NUMBER := FND_API.G_MISS_NUM,
647: p_show_all IN VARCHAR2 := FND_API.G_MISS_CHAR,
648: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
649: p_creation_date IN DATE := FND_API.G_MISS_DATE,
650: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
651: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
644: p_category_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
645: p_category_id IN NUMBER := FND_API.G_MISS_NUM,
646: p_application_id IN NUMBER := FND_API.G_MISS_NUM,
647: p_show_all IN VARCHAR2 := FND_API.G_MISS_CHAR,
648: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
649: p_creation_date IN DATE := FND_API.G_MISS_DATE,
650: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
651: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
652: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
645: p_category_id IN NUMBER := FND_API.G_MISS_NUM,
646: p_application_id IN NUMBER := FND_API.G_MISS_NUM,
647: p_show_all IN VARCHAR2 := FND_API.G_MISS_CHAR,
648: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
649: p_creation_date IN DATE := FND_API.G_MISS_DATE,
650: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
651: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
652: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
653: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
646: p_application_id IN NUMBER := FND_API.G_MISS_NUM,
647: p_show_all IN VARCHAR2 := FND_API.G_MISS_CHAR,
648: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
649: p_creation_date IN DATE := FND_API.G_MISS_DATE,
650: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
651: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
652: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
653: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
654: p_pass IN NUMBER,
647: p_show_all IN VARCHAR2 := FND_API.G_MISS_CHAR,
648: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
649: p_creation_date IN DATE := FND_API.G_MISS_DATE,
650: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
651: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
652: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
653: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
654: p_pass IN NUMBER,
655: p_copy_redo_flag IN OUT NOCOPY BOOLEAN
648: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
649: p_creation_date IN DATE := FND_API.G_MISS_DATE,
650: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
651: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
652: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
653: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
654: p_pass IN NUMBER,
655: p_copy_redo_flag IN OUT NOCOPY BOOLEAN
656: );
649: p_creation_date IN DATE := FND_API.G_MISS_DATE,
650: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
651: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
652: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
653: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
654: p_pass IN NUMBER,
655: p_copy_redo_flag IN OUT NOCOPY BOOLEAN
656: );
657:
678: -- Version Initial version number = 1.0
679: -- History Current version number = 1.0
680: --=======================================================
681: PROCEDURE UPDATE_CATEGORY_USAGE (
682: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
683: p_api_version_number IN NUMBER,
684: p_init_msg_tbl IN BOOLEAN := FALSE,
685: p_msg_count OUT NOCOPY NUMBER,
686: p_msg_data OUT NOCOPY VARCHAR2,
684: p_init_msg_tbl IN BOOLEAN := FALSE,
685: p_msg_count OUT NOCOPY NUMBER,
686: p_msg_data OUT NOCOPY VARCHAR2,
687: p_return_status OUT NOCOPY VARCHAR2,
688: p_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
689: p_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
690: p_attribute_application_id IN NUMBER := FND_API.G_MISS_NUM,
691: p_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
692: p_category_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
685: p_msg_count OUT NOCOPY NUMBER,
686: p_msg_data OUT NOCOPY VARCHAR2,
687: p_return_status OUT NOCOPY VARCHAR2,
688: p_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
689: p_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
690: p_attribute_application_id IN NUMBER := FND_API.G_MISS_NUM,
691: p_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
692: p_category_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
693: p_category_id IN NUMBER := FND_API.G_MISS_NUM,
686: p_msg_data OUT NOCOPY VARCHAR2,
687: p_return_status OUT NOCOPY VARCHAR2,
688: p_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
689: p_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
690: p_attribute_application_id IN NUMBER := FND_API.G_MISS_NUM,
691: p_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
692: p_category_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
693: p_category_id IN NUMBER := FND_API.G_MISS_NUM,
694: p_application_id IN NUMBER := FND_API.G_MISS_NUM,
687: p_return_status OUT NOCOPY VARCHAR2,
688: p_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
689: p_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
690: p_attribute_application_id IN NUMBER := FND_API.G_MISS_NUM,
691: p_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
692: p_category_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
693: p_category_id IN NUMBER := FND_API.G_MISS_NUM,
694: p_application_id IN NUMBER := FND_API.G_MISS_NUM,
695: p_show_all IN VARCHAR2 := FND_API.G_MISS_CHAR,
688: p_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
689: p_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
690: p_attribute_application_id IN NUMBER := FND_API.G_MISS_NUM,
691: p_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
692: p_category_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
693: p_category_id IN NUMBER := FND_API.G_MISS_NUM,
694: p_application_id IN NUMBER := FND_API.G_MISS_NUM,
695: p_show_all IN VARCHAR2 := FND_API.G_MISS_CHAR,
696: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
689: p_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
690: p_attribute_application_id IN NUMBER := FND_API.G_MISS_NUM,
691: p_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
692: p_category_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
693: p_category_id IN NUMBER := FND_API.G_MISS_NUM,
694: p_application_id IN NUMBER := FND_API.G_MISS_NUM,
695: p_show_all IN VARCHAR2 := FND_API.G_MISS_CHAR,
696: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
697: p_creation_date IN DATE := FND_API.G_MISS_DATE,
690: p_attribute_application_id IN NUMBER := FND_API.G_MISS_NUM,
691: p_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
692: p_category_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
693: p_category_id IN NUMBER := FND_API.G_MISS_NUM,
694: p_application_id IN NUMBER := FND_API.G_MISS_NUM,
695: p_show_all IN VARCHAR2 := FND_API.G_MISS_CHAR,
696: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
697: p_creation_date IN DATE := FND_API.G_MISS_DATE,
698: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
691: p_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
692: p_category_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
693: p_category_id IN NUMBER := FND_API.G_MISS_NUM,
694: p_application_id IN NUMBER := FND_API.G_MISS_NUM,
695: p_show_all IN VARCHAR2 := FND_API.G_MISS_CHAR,
696: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
697: p_creation_date IN DATE := FND_API.G_MISS_DATE,
698: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
699: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
692: p_category_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
693: p_category_id IN NUMBER := FND_API.G_MISS_NUM,
694: p_application_id IN NUMBER := FND_API.G_MISS_NUM,
695: p_show_all IN VARCHAR2 := FND_API.G_MISS_CHAR,
696: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
697: p_creation_date IN DATE := FND_API.G_MISS_DATE,
698: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
699: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
700: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
693: p_category_id IN NUMBER := FND_API.G_MISS_NUM,
694: p_application_id IN NUMBER := FND_API.G_MISS_NUM,
695: p_show_all IN VARCHAR2 := FND_API.G_MISS_CHAR,
696: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
697: p_creation_date IN DATE := FND_API.G_MISS_DATE,
698: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
699: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
700: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
701: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
694: p_application_id IN NUMBER := FND_API.G_MISS_NUM,
695: p_show_all IN VARCHAR2 := FND_API.G_MISS_CHAR,
696: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
697: p_creation_date IN DATE := FND_API.G_MISS_DATE,
698: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
699: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
700: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
701: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
702: p_pass IN NUMBER,
695: p_show_all IN VARCHAR2 := FND_API.G_MISS_CHAR,
696: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
697: p_creation_date IN DATE := FND_API.G_MISS_DATE,
698: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
699: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
700: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
701: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
702: p_pass IN NUMBER,
703: p_copy_redo_flag IN OUT NOCOPY BOOLEAN
696: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
697: p_creation_date IN DATE := FND_API.G_MISS_DATE,
698: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
699: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
700: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
701: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
702: p_pass IN NUMBER,
703: p_copy_redo_flag IN OUT NOCOPY BOOLEAN
704: );
697: p_creation_date IN DATE := FND_API.G_MISS_DATE,
698: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
699: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
700: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
701: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
702: p_pass IN NUMBER,
703: p_copy_redo_flag IN OUT NOCOPY BOOLEAN
704: );
705: