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.AK_REGION2_PVT dependencies on FND_API

Line 73: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

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,

Line 78: p_line_num IN NUMBER := FND_API.G_MISS_NUM,

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,

Line 114: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

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: );

Line 116: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,

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: --=======================================================

Line 261: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

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,

Line 264: p_region_application_id IN NUMBER := FND_API.G_MISS_NUM,

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,

Line 265: p_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

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,

Line 266: p_attribute_application_id IN NUMBER := FND_API.G_MISS_NUM,

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

Line 267: p_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

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;

Line 268: p_graph_number IN NUMBER := FND_API.G_MISS_NUM,

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: */

Line 305: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

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,

Line 308: p_region_application_id IN NUMBER := FND_API.G_MISS_NUM,

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,

Line 309: p_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

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,

Line 310: p_attribute_application_id IN NUMBER := FND_API.G_MISS_NUM,

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,

Line 311: p_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

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,

Line 312: p_lov_region_appl_id IN NUMBER := FND_API.G_MISS_NUM,

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,

Line 313: p_lov_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

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,

Line 314: p_lov_attribute_appl_id IN NUMBER := FND_API.G_MISS_NUM,

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,

Line 315: p_lov_attribute_code 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,

Line 316: p_base_attribute_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,

Line 317: p_base_attribute_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,

Line 318: p_direction_flag 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,
322: p_pass IN NUMBER := 2

Line 319: p_base_region_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
323: ) return boolean;

Line 320: p_base_region_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;
324:

Line 351: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

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,

Line 357: p_region_application_id IN NUMBER := FND_API.G_MISS_NUM,

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,

Line 358: p_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

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,

Line 359: p_attribute_application_id 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,

Line 360: p_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

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,

Line 361: p_graph_number 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,

Line 362: p_created_by 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,
366: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,

Line 363: p_creation_date IN DATE := FND_API.G_MISS_DATE,

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,

Line 364: p_last_updated_by 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,
368: p_pass IN NUMBER,

Line 365: p_last_update_date IN DATE := FND_API.G_MISS_DATE,

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

Line 366: p_last_update_login 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
370: );

Line 367: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,

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: */

Line 398: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

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,

Line 404: p_region_application_id IN NUMBER := FND_API.G_MISS_NUM,

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,

Line 405: p_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

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,

Line 406: p_attribute_application_id IN NUMBER := FND_API.G_MISS_NUM,

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,

Line 407: p_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

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,

Line 408: p_lov_region_appl_id IN NUMBER := FND_API.G_MISS_NUM,

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,

Line 409: p_lov_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

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,

Line 410: p_lov_attribute_appl_id IN NUMBER := FND_API.G_MISS_NUM,

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,

Line 411: p_lov_attribute_code 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,

Line 412: p_base_attribute_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,

Line 413: p_base_attribute_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,

Line 414: p_direction_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,

Line 415: p_base_region_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,
419: p_creation_date IN DATE := FND_API.G_MISS_DATE,

Line 416: p_base_region_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,
420: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,

Line 417: p_required_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,

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,

Line 418: p_created_by IN NUMBER := FND_API.G_MISS_NUM,

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,

Line 419: p_creation_date IN DATE := FND_API.G_MISS_DATE,

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,

Line 420: p_last_updated_by 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,
424: p_pass IN NUMBER,

Line 421: p_last_update_date IN DATE := FND_API.G_MISS_DATE,

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

Line 422: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,

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: );

Line 423: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,

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:

Line 453: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

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,

Line 459: p_region_application_id IN NUMBER := FND_API.G_MISS_NUM,

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,

Line 460: p_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

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,

Line 461: p_attribute_application_id 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,

Line 462: p_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

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,

Line 463: p_graph_number 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,

Line 464: p_created_by 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,
468: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,

Line 465: p_creation_date IN DATE := FND_API.G_MISS_DATE,

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,

Line 466: p_last_updated_by 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,
470: p_pass IN NUMBER,

Line 467: p_last_update_date IN DATE := FND_API.G_MISS_DATE,

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

Line 468: p_last_update_login 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
472: );

Line 469: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,

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: */

Line 499: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

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,

Line 505: p_region_application_id IN NUMBER := FND_API.G_MISS_NUM,

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,

Line 506: p_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

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,

Line 507: p_attribute_application_id IN NUMBER := FND_API.G_MISS_NUM,

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,

Line 508: p_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

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,

Line 509: p_lov_region_appl_id IN NUMBER := FND_API.G_MISS_NUM,

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,

Line 510: p_lov_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

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,

Line 511: p_lov_attribute_appl_id IN NUMBER := FND_API.G_MISS_NUM,

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,

Line 512: p_lov_attribute_code 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,

Line 513: p_base_attribute_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,

Line 514: p_base_attribute_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,

Line 515: p_direction_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,

Line 516: p_base_region_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,
520: p_creation_date IN DATE := FND_API.G_MISS_DATE,

Line 517: p_base_region_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,
521: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,

Line 518: p_required_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,

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,

Line 519: p_created_by IN NUMBER := FND_API.G_MISS_NUM,

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,

Line 520: p_creation_date IN DATE := FND_API.G_MISS_DATE,

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,

Line 521: p_last_updated_by 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,
525: p_pass IN NUMBER,

Line 522: p_last_update_date IN DATE := FND_API.G_MISS_DATE,

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

Line 523: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,

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: );

Line 524: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,

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:

Line 560: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

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,

Line 563: p_region_application_id IN NUMBER := FND_API.G_MISS_NUM,

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,

Line 564: p_region_code 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,

Line 565: p_attribute_application_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,

Line 566: p_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

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,

Line 567: p_category_name 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,

Line 568: p_category_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,
572: p_pass IN NUMBER := 2

Line 569: p_application_id IN NUMBER := FND_API.G_MISS_NUM,

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;

Line 570: p_show_all IN VARCHAR2 := FND_API.G_MISS_CHAR,

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:

Line 634: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

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,

Line 640: p_region_application_id IN NUMBER := FND_API.G_MISS_NUM,

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,

Line 641: p_region_code 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,

Line 642: p_attribute_application_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,

Line 643: p_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

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,

Line 644: p_category_name 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,

Line 645: p_category_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,
649: p_creation_date IN DATE := FND_API.G_MISS_DATE,

Line 646: p_application_id IN NUMBER := FND_API.G_MISS_NUM,

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,

Line 647: p_show_all IN VARCHAR2 := FND_API.G_MISS_CHAR,

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,

Line 648: p_created_by IN NUMBER := FND_API.G_MISS_NUM,

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,

Line 649: p_creation_date IN DATE := FND_API.G_MISS_DATE,

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,

Line 650: p_last_updated_by 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,
654: p_pass IN NUMBER,

Line 651: p_last_update_date IN DATE := FND_API.G_MISS_DATE,

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

Line 652: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,

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: );

Line 653: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,

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:

Line 682: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

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,

Line 688: p_region_application_id IN NUMBER := FND_API.G_MISS_NUM,

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,

Line 689: p_region_code 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,

Line 690: p_attribute_application_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,

Line 691: p_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

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,

Line 692: p_category_name 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,

Line 693: p_category_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,
697: p_creation_date IN DATE := FND_API.G_MISS_DATE,

Line 694: p_application_id IN NUMBER := FND_API.G_MISS_NUM,

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,

Line 695: p_show_all IN VARCHAR2 := FND_API.G_MISS_CHAR,

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,

Line 696: p_created_by IN NUMBER := FND_API.G_MISS_NUM,

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,

Line 697: p_creation_date IN DATE := FND_API.G_MISS_DATE,

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,

Line 698: p_last_updated_by 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,
702: p_pass IN NUMBER,

Line 699: p_last_update_date IN DATE := FND_API.G_MISS_DATE,

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

Line 700: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,

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: );

Line 701: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,

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: