107: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
108: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
109: p_object_id IN OUT NOCOPY igs_sc_objects.object_id%TYPE,
110: p_obj_group_id IN igs_sc_objects.obj_group_id%TYPE,
111: p_obj_name IN fnd_objects.obj_name%TYPE ,
112: p_database_object_name IN fnd_objects.database_object_name%TYPE ,
113: p_pk1_column_name IN fnd_objects.pk1_column_name%TYPE ,
114: p_pk2_column_name IN fnd_objects.pk2_column_name%TYPE ,
115: p_pk3_column_name IN fnd_objects.pk3_column_name%TYPE ,
108: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
109: p_object_id IN OUT NOCOPY igs_sc_objects.object_id%TYPE,
110: p_obj_group_id IN igs_sc_objects.obj_group_id%TYPE,
111: p_obj_name IN fnd_objects.obj_name%TYPE ,
112: p_database_object_name IN fnd_objects.database_object_name%TYPE ,
113: p_pk1_column_name IN fnd_objects.pk1_column_name%TYPE ,
114: p_pk2_column_name IN fnd_objects.pk2_column_name%TYPE ,
115: p_pk3_column_name IN fnd_objects.pk3_column_name%TYPE ,
116: p_pk4_column_name IN fnd_objects.pk4_column_name%TYPE ,
109: p_object_id IN OUT NOCOPY igs_sc_objects.object_id%TYPE,
110: p_obj_group_id IN igs_sc_objects.obj_group_id%TYPE,
111: p_obj_name IN fnd_objects.obj_name%TYPE ,
112: p_database_object_name IN fnd_objects.database_object_name%TYPE ,
113: p_pk1_column_name IN fnd_objects.pk1_column_name%TYPE ,
114: p_pk2_column_name IN fnd_objects.pk2_column_name%TYPE ,
115: p_pk3_column_name IN fnd_objects.pk3_column_name%TYPE ,
116: p_pk4_column_name IN fnd_objects.pk4_column_name%TYPE ,
117: p_pk5_column_name IN fnd_objects.pk5_column_name%TYPE ,
110: p_obj_group_id IN igs_sc_objects.obj_group_id%TYPE,
111: p_obj_name IN fnd_objects.obj_name%TYPE ,
112: p_database_object_name IN fnd_objects.database_object_name%TYPE ,
113: p_pk1_column_name IN fnd_objects.pk1_column_name%TYPE ,
114: p_pk2_column_name IN fnd_objects.pk2_column_name%TYPE ,
115: p_pk3_column_name IN fnd_objects.pk3_column_name%TYPE ,
116: p_pk4_column_name IN fnd_objects.pk4_column_name%TYPE ,
117: p_pk5_column_name IN fnd_objects.pk5_column_name%TYPE ,
118: p_pk1_column_type IN fnd_objects.pk1_column_type%TYPE ,
111: p_obj_name IN fnd_objects.obj_name%TYPE ,
112: p_database_object_name IN fnd_objects.database_object_name%TYPE ,
113: p_pk1_column_name IN fnd_objects.pk1_column_name%TYPE ,
114: p_pk2_column_name IN fnd_objects.pk2_column_name%TYPE ,
115: p_pk3_column_name IN fnd_objects.pk3_column_name%TYPE ,
116: p_pk4_column_name IN fnd_objects.pk4_column_name%TYPE ,
117: p_pk5_column_name IN fnd_objects.pk5_column_name%TYPE ,
118: p_pk1_column_type IN fnd_objects.pk1_column_type%TYPE ,
119: p_pk2_column_type IN fnd_objects.pk2_column_type%TYPE ,
112: p_database_object_name IN fnd_objects.database_object_name%TYPE ,
113: p_pk1_column_name IN fnd_objects.pk1_column_name%TYPE ,
114: p_pk2_column_name IN fnd_objects.pk2_column_name%TYPE ,
115: p_pk3_column_name IN fnd_objects.pk3_column_name%TYPE ,
116: p_pk4_column_name IN fnd_objects.pk4_column_name%TYPE ,
117: p_pk5_column_name IN fnd_objects.pk5_column_name%TYPE ,
118: p_pk1_column_type IN fnd_objects.pk1_column_type%TYPE ,
119: p_pk2_column_type IN fnd_objects.pk2_column_type%TYPE ,
120: p_pk3_column_type IN fnd_objects.pk3_column_type%TYPE ,
113: p_pk1_column_name IN fnd_objects.pk1_column_name%TYPE ,
114: p_pk2_column_name IN fnd_objects.pk2_column_name%TYPE ,
115: p_pk3_column_name IN fnd_objects.pk3_column_name%TYPE ,
116: p_pk4_column_name IN fnd_objects.pk4_column_name%TYPE ,
117: p_pk5_column_name IN fnd_objects.pk5_column_name%TYPE ,
118: p_pk1_column_type IN fnd_objects.pk1_column_type%TYPE ,
119: p_pk2_column_type IN fnd_objects.pk2_column_type%TYPE ,
120: p_pk3_column_type IN fnd_objects.pk3_column_type%TYPE ,
121: p_pk4_column_type IN fnd_objects.pk4_column_type%TYPE ,
114: p_pk2_column_name IN fnd_objects.pk2_column_name%TYPE ,
115: p_pk3_column_name IN fnd_objects.pk3_column_name%TYPE ,
116: p_pk4_column_name IN fnd_objects.pk4_column_name%TYPE ,
117: p_pk5_column_name IN fnd_objects.pk5_column_name%TYPE ,
118: p_pk1_column_type IN fnd_objects.pk1_column_type%TYPE ,
119: p_pk2_column_type IN fnd_objects.pk2_column_type%TYPE ,
120: p_pk3_column_type IN fnd_objects.pk3_column_type%TYPE ,
121: p_pk4_column_type IN fnd_objects.pk4_column_type%TYPE ,
122: p_pk5_column_type IN fnd_objects.pk5_column_type%TYPE ,
115: p_pk3_column_name IN fnd_objects.pk3_column_name%TYPE ,
116: p_pk4_column_name IN fnd_objects.pk4_column_name%TYPE ,
117: p_pk5_column_name IN fnd_objects.pk5_column_name%TYPE ,
118: p_pk1_column_type IN fnd_objects.pk1_column_type%TYPE ,
119: p_pk2_column_type IN fnd_objects.pk2_column_type%TYPE ,
120: p_pk3_column_type IN fnd_objects.pk3_column_type%TYPE ,
121: p_pk4_column_type IN fnd_objects.pk4_column_type%TYPE ,
122: p_pk5_column_type IN fnd_objects.pk5_column_type%TYPE ,
123: p_select_flag IN VARCHAR2 DEFAULT 'Y',
116: p_pk4_column_name IN fnd_objects.pk4_column_name%TYPE ,
117: p_pk5_column_name IN fnd_objects.pk5_column_name%TYPE ,
118: p_pk1_column_type IN fnd_objects.pk1_column_type%TYPE ,
119: p_pk2_column_type IN fnd_objects.pk2_column_type%TYPE ,
120: p_pk3_column_type IN fnd_objects.pk3_column_type%TYPE ,
121: p_pk4_column_type IN fnd_objects.pk4_column_type%TYPE ,
122: p_pk5_column_type IN fnd_objects.pk5_column_type%TYPE ,
123: p_select_flag IN VARCHAR2 DEFAULT 'Y',
124: p_insert_flag IN VARCHAR2 DEFAULT 'Y',
117: p_pk5_column_name IN fnd_objects.pk5_column_name%TYPE ,
118: p_pk1_column_type IN fnd_objects.pk1_column_type%TYPE ,
119: p_pk2_column_type IN fnd_objects.pk2_column_type%TYPE ,
120: p_pk3_column_type IN fnd_objects.pk3_column_type%TYPE ,
121: p_pk4_column_type IN fnd_objects.pk4_column_type%TYPE ,
122: p_pk5_column_type IN fnd_objects.pk5_column_type%TYPE ,
123: p_select_flag IN VARCHAR2 DEFAULT 'Y',
124: p_insert_flag IN VARCHAR2 DEFAULT 'Y',
125: p_update_flag IN VARCHAR2 DEFAULT 'Y',
118: p_pk1_column_type IN fnd_objects.pk1_column_type%TYPE ,
119: p_pk2_column_type IN fnd_objects.pk2_column_type%TYPE ,
120: p_pk3_column_type IN fnd_objects.pk3_column_type%TYPE ,
121: p_pk4_column_type IN fnd_objects.pk4_column_type%TYPE ,
122: p_pk5_column_type IN fnd_objects.pk5_column_type%TYPE ,
123: p_select_flag IN VARCHAR2 DEFAULT 'Y',
124: p_insert_flag IN VARCHAR2 DEFAULT 'Y',
125: p_update_flag IN VARCHAR2 DEFAULT 'Y',
126: p_delete_flag IN VARCHAR2 DEFAULT 'Y',
312: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
313: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
314: p_object_id IN igs_sc_objects.object_id%TYPE,
315: p_obj_group_id IN igs_sc_objects.obj_group_id%TYPE,
316: p_obj_name IN fnd_objects.obj_name%TYPE ,
317: p_database_object_name IN fnd_objects.database_object_name%TYPE ,
318: p_pk1_column_name IN fnd_objects.pk1_column_name%TYPE ,
319: p_pk2_column_name IN fnd_objects.pk2_column_name%TYPE ,
320: p_pk3_column_name IN fnd_objects.pk3_column_name%TYPE ,
313: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
314: p_object_id IN igs_sc_objects.object_id%TYPE,
315: p_obj_group_id IN igs_sc_objects.obj_group_id%TYPE,
316: p_obj_name IN fnd_objects.obj_name%TYPE ,
317: p_database_object_name IN fnd_objects.database_object_name%TYPE ,
318: p_pk1_column_name IN fnd_objects.pk1_column_name%TYPE ,
319: p_pk2_column_name IN fnd_objects.pk2_column_name%TYPE ,
320: p_pk3_column_name IN fnd_objects.pk3_column_name%TYPE ,
321: p_pk4_column_name IN fnd_objects.pk4_column_name%TYPE ,
314: p_object_id IN igs_sc_objects.object_id%TYPE,
315: p_obj_group_id IN igs_sc_objects.obj_group_id%TYPE,
316: p_obj_name IN fnd_objects.obj_name%TYPE ,
317: p_database_object_name IN fnd_objects.database_object_name%TYPE ,
318: p_pk1_column_name IN fnd_objects.pk1_column_name%TYPE ,
319: p_pk2_column_name IN fnd_objects.pk2_column_name%TYPE ,
320: p_pk3_column_name IN fnd_objects.pk3_column_name%TYPE ,
321: p_pk4_column_name IN fnd_objects.pk4_column_name%TYPE ,
322: p_pk5_column_name IN fnd_objects.pk5_column_name%TYPE ,
315: p_obj_group_id IN igs_sc_objects.obj_group_id%TYPE,
316: p_obj_name IN fnd_objects.obj_name%TYPE ,
317: p_database_object_name IN fnd_objects.database_object_name%TYPE ,
318: p_pk1_column_name IN fnd_objects.pk1_column_name%TYPE ,
319: p_pk2_column_name IN fnd_objects.pk2_column_name%TYPE ,
320: p_pk3_column_name IN fnd_objects.pk3_column_name%TYPE ,
321: p_pk4_column_name IN fnd_objects.pk4_column_name%TYPE ,
322: p_pk5_column_name IN fnd_objects.pk5_column_name%TYPE ,
323: p_pk1_column_type IN fnd_objects.pk1_column_type%TYPE ,
316: p_obj_name IN fnd_objects.obj_name%TYPE ,
317: p_database_object_name IN fnd_objects.database_object_name%TYPE ,
318: p_pk1_column_name IN fnd_objects.pk1_column_name%TYPE ,
319: p_pk2_column_name IN fnd_objects.pk2_column_name%TYPE ,
320: p_pk3_column_name IN fnd_objects.pk3_column_name%TYPE ,
321: p_pk4_column_name IN fnd_objects.pk4_column_name%TYPE ,
322: p_pk5_column_name IN fnd_objects.pk5_column_name%TYPE ,
323: p_pk1_column_type IN fnd_objects.pk1_column_type%TYPE ,
324: p_pk2_column_type IN fnd_objects.pk2_column_type%TYPE ,
317: p_database_object_name IN fnd_objects.database_object_name%TYPE ,
318: p_pk1_column_name IN fnd_objects.pk1_column_name%TYPE ,
319: p_pk2_column_name IN fnd_objects.pk2_column_name%TYPE ,
320: p_pk3_column_name IN fnd_objects.pk3_column_name%TYPE ,
321: p_pk4_column_name IN fnd_objects.pk4_column_name%TYPE ,
322: p_pk5_column_name IN fnd_objects.pk5_column_name%TYPE ,
323: p_pk1_column_type IN fnd_objects.pk1_column_type%TYPE ,
324: p_pk2_column_type IN fnd_objects.pk2_column_type%TYPE ,
325: p_pk3_column_type IN fnd_objects.pk3_column_type%TYPE ,
318: p_pk1_column_name IN fnd_objects.pk1_column_name%TYPE ,
319: p_pk2_column_name IN fnd_objects.pk2_column_name%TYPE ,
320: p_pk3_column_name IN fnd_objects.pk3_column_name%TYPE ,
321: p_pk4_column_name IN fnd_objects.pk4_column_name%TYPE ,
322: p_pk5_column_name IN fnd_objects.pk5_column_name%TYPE ,
323: p_pk1_column_type IN fnd_objects.pk1_column_type%TYPE ,
324: p_pk2_column_type IN fnd_objects.pk2_column_type%TYPE ,
325: p_pk3_column_type IN fnd_objects.pk3_column_type%TYPE ,
326: p_pk4_column_type IN fnd_objects.pk4_column_type%TYPE ,
319: p_pk2_column_name IN fnd_objects.pk2_column_name%TYPE ,
320: p_pk3_column_name IN fnd_objects.pk3_column_name%TYPE ,
321: p_pk4_column_name IN fnd_objects.pk4_column_name%TYPE ,
322: p_pk5_column_name IN fnd_objects.pk5_column_name%TYPE ,
323: p_pk1_column_type IN fnd_objects.pk1_column_type%TYPE ,
324: p_pk2_column_type IN fnd_objects.pk2_column_type%TYPE ,
325: p_pk3_column_type IN fnd_objects.pk3_column_type%TYPE ,
326: p_pk4_column_type IN fnd_objects.pk4_column_type%TYPE ,
327: p_pk5_column_type IN fnd_objects.pk5_column_type%TYPE ,
320: p_pk3_column_name IN fnd_objects.pk3_column_name%TYPE ,
321: p_pk4_column_name IN fnd_objects.pk4_column_name%TYPE ,
322: p_pk5_column_name IN fnd_objects.pk5_column_name%TYPE ,
323: p_pk1_column_type IN fnd_objects.pk1_column_type%TYPE ,
324: p_pk2_column_type IN fnd_objects.pk2_column_type%TYPE ,
325: p_pk3_column_type IN fnd_objects.pk3_column_type%TYPE ,
326: p_pk4_column_type IN fnd_objects.pk4_column_type%TYPE ,
327: p_pk5_column_type IN fnd_objects.pk5_column_type%TYPE ,
328: p_select_flag IN VARCHAR2 DEFAULT 'Y',
321: p_pk4_column_name IN fnd_objects.pk4_column_name%TYPE ,
322: p_pk5_column_name IN fnd_objects.pk5_column_name%TYPE ,
323: p_pk1_column_type IN fnd_objects.pk1_column_type%TYPE ,
324: p_pk2_column_type IN fnd_objects.pk2_column_type%TYPE ,
325: p_pk3_column_type IN fnd_objects.pk3_column_type%TYPE ,
326: p_pk4_column_type IN fnd_objects.pk4_column_type%TYPE ,
327: p_pk5_column_type IN fnd_objects.pk5_column_type%TYPE ,
328: p_select_flag IN VARCHAR2 DEFAULT 'Y',
329: p_insert_flag IN VARCHAR2 DEFAULT 'Y',
322: p_pk5_column_name IN fnd_objects.pk5_column_name%TYPE ,
323: p_pk1_column_type IN fnd_objects.pk1_column_type%TYPE ,
324: p_pk2_column_type IN fnd_objects.pk2_column_type%TYPE ,
325: p_pk3_column_type IN fnd_objects.pk3_column_type%TYPE ,
326: p_pk4_column_type IN fnd_objects.pk4_column_type%TYPE ,
327: p_pk5_column_type IN fnd_objects.pk5_column_type%TYPE ,
328: p_select_flag IN VARCHAR2 DEFAULT 'Y',
329: p_insert_flag IN VARCHAR2 DEFAULT 'Y',
330: p_update_flag IN VARCHAR2 DEFAULT 'Y',
323: p_pk1_column_type IN fnd_objects.pk1_column_type%TYPE ,
324: p_pk2_column_type IN fnd_objects.pk2_column_type%TYPE ,
325: p_pk3_column_type IN fnd_objects.pk3_column_type%TYPE ,
326: p_pk4_column_type IN fnd_objects.pk4_column_type%TYPE ,
327: p_pk5_column_type IN fnd_objects.pk5_column_type%TYPE ,
328: p_select_flag IN VARCHAR2 DEFAULT 'Y',
329: p_insert_flag IN VARCHAR2 DEFAULT 'Y',
330: p_update_flag IN VARCHAR2 DEFAULT 'Y',
331: p_delete_flag IN VARCHAR2 DEFAULT 'Y',
501: p_out_file_name IN VARCHAR2
502: );
503:
504: FUNCTION get_obj_name (
505: p_obj_id IN fnd_objects.object_id%TYPE )
506: RETURN VARCHAR2;
507:
508: END IGS_SC_DATA_SEC_APIS_PKG;