DBA Data[Home] [Help]

APPS.IGS_SC_DATA_SEC_APIS_PKG dependencies on FND_OBJECTS

Line 111: p_obj_name IN fnd_objects.obj_name%TYPE ,

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 ,

Line 112: p_database_object_name IN fnd_objects.database_object_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 ,

Line 113: p_pk1_column_name IN fnd_objects.pk1_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 ,

Line 114: p_pk2_column_name IN fnd_objects.pk2_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 ,

Line 115: p_pk3_column_name IN fnd_objects.pk3_column_name%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 ,

Line 116: p_pk4_column_name IN fnd_objects.pk4_column_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 ,
120: p_pk3_column_type IN fnd_objects.pk3_column_type%TYPE ,

Line 117: p_pk5_column_name IN fnd_objects.pk5_column_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 ,
121: p_pk4_column_type IN fnd_objects.pk4_column_type%TYPE ,

Line 118: p_pk1_column_type IN fnd_objects.pk1_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 ,

Line 119: p_pk2_column_type IN fnd_objects.pk2_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',

Line 120: p_pk3_column_type IN fnd_objects.pk3_column_type%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',
124: p_insert_flag IN VARCHAR2 DEFAULT 'Y',

Line 121: p_pk4_column_type IN fnd_objects.pk4_column_type%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',
125: p_update_flag IN VARCHAR2 DEFAULT 'Y',

Line 122: p_pk5_column_type IN fnd_objects.pk5_column_type%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',
126: p_delete_flag IN VARCHAR2 DEFAULT 'Y',

Line 316: p_obj_name IN fnd_objects.obj_name%TYPE ,

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 ,

Line 317: p_database_object_name IN fnd_objects.database_object_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 ,

Line 318: p_pk1_column_name IN fnd_objects.pk1_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 ,

Line 319: p_pk2_column_name IN fnd_objects.pk2_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 ,

Line 320: p_pk3_column_name IN fnd_objects.pk3_column_name%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 ,

Line 321: p_pk4_column_name IN fnd_objects.pk4_column_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 ,
325: p_pk3_column_type IN fnd_objects.pk3_column_type%TYPE ,

Line 322: p_pk5_column_name IN fnd_objects.pk5_column_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 ,
326: p_pk4_column_type IN fnd_objects.pk4_column_type%TYPE ,

Line 323: p_pk1_column_type IN fnd_objects.pk1_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 ,

Line 324: p_pk2_column_type IN fnd_objects.pk2_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',

Line 325: p_pk3_column_type IN fnd_objects.pk3_column_type%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',
329: p_insert_flag IN VARCHAR2 DEFAULT 'Y',

Line 326: p_pk4_column_type IN fnd_objects.pk4_column_type%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',
330: p_update_flag IN VARCHAR2 DEFAULT 'Y',

Line 327: p_pk5_column_type IN fnd_objects.pk5_column_type%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',
331: p_delete_flag IN VARCHAR2 DEFAULT 'Y',

Line 505: p_obj_id IN fnd_objects.object_id%TYPE )

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;