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.IGS_SC_DATA_SEC_APIS_PKG dependencies on FND_OBJECTS

Line 51: FROM fnd_objects

47: -- Define other procedures that are to be used internally here.
48: -- -----------------------------------------------------------------
49: CURSOR c_table_name (v_object_id NUMBER) IS
50: SELECT database_object_name
51: FROM fnd_objects
52: WHERE object_id = v_object_id;
53:
54:
55:

Line 926: l_object_name fnd_objects.database_object_name%TYPE;

922: l_object_id igs_sc_obj_att_mths.object_id%TYPE;
923: l_obj_attrib_id igs_sc_obj_att_mths.obj_attrib_id%TYPE;
924: l_obj_attrib_type igs_sc_obj_att_mths.obj_attrib_type%TYPE;
925: l_static_type igs_sc_obj_att_mths.static_type%TYPE;
926: l_object_name fnd_objects.database_object_name%TYPE;
927:
928: BEGIN
929:
930: SAVEPOINT Insert_Object_Attr_Method_SP;

Line 1264: groups and the fnd objects resident in the system.

1260: Date Created By : April 23, 2003
1261: Purpose : The purpose of this procedure is to handle
1262: the insertion of the data into igs_sc_objects
1263: table. This ensures a link between the object
1264: groups and the fnd objects resident in the system.
1265: There is validation to ensure that the object_id,
1266: and the obj_group_id are valid and present in the
1267: data model.
1268: Remarks :

Line 1281: p_obj_name IN fnd_objects.obj_name%TYPE ,

1277: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1278: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1279: p_object_id IN OUT NOCOPY igs_sc_objects.object_id%TYPE,
1280: p_obj_group_id IN igs_sc_objects.obj_group_id%TYPE,
1281: p_obj_name IN fnd_objects.obj_name%TYPE ,
1282: p_database_object_name IN fnd_objects.database_object_name%TYPE ,
1283: p_pk1_column_name IN fnd_objects.pk1_column_name%TYPE ,
1284: p_pk2_column_name IN fnd_objects.pk2_column_name%TYPE ,
1285: p_pk3_column_name IN fnd_objects.pk3_column_name%TYPE ,

Line 1282: p_database_object_name IN fnd_objects.database_object_name%TYPE ,

1278: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1279: p_object_id IN OUT NOCOPY igs_sc_objects.object_id%TYPE,
1280: p_obj_group_id IN igs_sc_objects.obj_group_id%TYPE,
1281: p_obj_name IN fnd_objects.obj_name%TYPE ,
1282: p_database_object_name IN fnd_objects.database_object_name%TYPE ,
1283: p_pk1_column_name IN fnd_objects.pk1_column_name%TYPE ,
1284: p_pk2_column_name IN fnd_objects.pk2_column_name%TYPE ,
1285: p_pk3_column_name IN fnd_objects.pk3_column_name%TYPE ,
1286: p_pk4_column_name IN fnd_objects.pk4_column_name%TYPE ,

Line 1283: p_pk1_column_name IN fnd_objects.pk1_column_name%TYPE ,

1279: p_object_id IN OUT NOCOPY igs_sc_objects.object_id%TYPE,
1280: p_obj_group_id IN igs_sc_objects.obj_group_id%TYPE,
1281: p_obj_name IN fnd_objects.obj_name%TYPE ,
1282: p_database_object_name IN fnd_objects.database_object_name%TYPE ,
1283: p_pk1_column_name IN fnd_objects.pk1_column_name%TYPE ,
1284: p_pk2_column_name IN fnd_objects.pk2_column_name%TYPE ,
1285: p_pk3_column_name IN fnd_objects.pk3_column_name%TYPE ,
1286: p_pk4_column_name IN fnd_objects.pk4_column_name%TYPE ,
1287: p_pk5_column_name IN fnd_objects.pk5_column_name%TYPE ,

Line 1284: p_pk2_column_name IN fnd_objects.pk2_column_name%TYPE ,

1280: p_obj_group_id IN igs_sc_objects.obj_group_id%TYPE,
1281: p_obj_name IN fnd_objects.obj_name%TYPE ,
1282: p_database_object_name IN fnd_objects.database_object_name%TYPE ,
1283: p_pk1_column_name IN fnd_objects.pk1_column_name%TYPE ,
1284: p_pk2_column_name IN fnd_objects.pk2_column_name%TYPE ,
1285: p_pk3_column_name IN fnd_objects.pk3_column_name%TYPE ,
1286: p_pk4_column_name IN fnd_objects.pk4_column_name%TYPE ,
1287: p_pk5_column_name IN fnd_objects.pk5_column_name%TYPE ,
1288: p_pk1_column_type IN fnd_objects.pk1_column_type%TYPE ,

Line 1285: p_pk3_column_name IN fnd_objects.pk3_column_name%TYPE ,

1281: p_obj_name IN fnd_objects.obj_name%TYPE ,
1282: p_database_object_name IN fnd_objects.database_object_name%TYPE ,
1283: p_pk1_column_name IN fnd_objects.pk1_column_name%TYPE ,
1284: p_pk2_column_name IN fnd_objects.pk2_column_name%TYPE ,
1285: p_pk3_column_name IN fnd_objects.pk3_column_name%TYPE ,
1286: p_pk4_column_name IN fnd_objects.pk4_column_name%TYPE ,
1287: p_pk5_column_name IN fnd_objects.pk5_column_name%TYPE ,
1288: p_pk1_column_type IN fnd_objects.pk1_column_type%TYPE ,
1289: p_pk2_column_type IN fnd_objects.pk2_column_type%TYPE ,

Line 1286: p_pk4_column_name IN fnd_objects.pk4_column_name%TYPE ,

1282: p_database_object_name IN fnd_objects.database_object_name%TYPE ,
1283: p_pk1_column_name IN fnd_objects.pk1_column_name%TYPE ,
1284: p_pk2_column_name IN fnd_objects.pk2_column_name%TYPE ,
1285: p_pk3_column_name IN fnd_objects.pk3_column_name%TYPE ,
1286: p_pk4_column_name IN fnd_objects.pk4_column_name%TYPE ,
1287: p_pk5_column_name IN fnd_objects.pk5_column_name%TYPE ,
1288: p_pk1_column_type IN fnd_objects.pk1_column_type%TYPE ,
1289: p_pk2_column_type IN fnd_objects.pk2_column_type%TYPE ,
1290: p_pk3_column_type IN fnd_objects.pk3_column_type%TYPE ,

Line 1287: p_pk5_column_name IN fnd_objects.pk5_column_name%TYPE ,

1283: p_pk1_column_name IN fnd_objects.pk1_column_name%TYPE ,
1284: p_pk2_column_name IN fnd_objects.pk2_column_name%TYPE ,
1285: p_pk3_column_name IN fnd_objects.pk3_column_name%TYPE ,
1286: p_pk4_column_name IN fnd_objects.pk4_column_name%TYPE ,
1287: p_pk5_column_name IN fnd_objects.pk5_column_name%TYPE ,
1288: p_pk1_column_type IN fnd_objects.pk1_column_type%TYPE ,
1289: p_pk2_column_type IN fnd_objects.pk2_column_type%TYPE ,
1290: p_pk3_column_type IN fnd_objects.pk3_column_type%TYPE ,
1291: p_pk4_column_type IN fnd_objects.pk4_column_type%TYPE ,

Line 1288: p_pk1_column_type IN fnd_objects.pk1_column_type%TYPE ,

1284: p_pk2_column_name IN fnd_objects.pk2_column_name%TYPE ,
1285: p_pk3_column_name IN fnd_objects.pk3_column_name%TYPE ,
1286: p_pk4_column_name IN fnd_objects.pk4_column_name%TYPE ,
1287: p_pk5_column_name IN fnd_objects.pk5_column_name%TYPE ,
1288: p_pk1_column_type IN fnd_objects.pk1_column_type%TYPE ,
1289: p_pk2_column_type IN fnd_objects.pk2_column_type%TYPE ,
1290: p_pk3_column_type IN fnd_objects.pk3_column_type%TYPE ,
1291: p_pk4_column_type IN fnd_objects.pk4_column_type%TYPE ,
1292: p_pk5_column_type IN fnd_objects.pk5_column_type%TYPE ,

Line 1289: p_pk2_column_type IN fnd_objects.pk2_column_type%TYPE ,

1285: p_pk3_column_name IN fnd_objects.pk3_column_name%TYPE ,
1286: p_pk4_column_name IN fnd_objects.pk4_column_name%TYPE ,
1287: p_pk5_column_name IN fnd_objects.pk5_column_name%TYPE ,
1288: p_pk1_column_type IN fnd_objects.pk1_column_type%TYPE ,
1289: p_pk2_column_type IN fnd_objects.pk2_column_type%TYPE ,
1290: p_pk3_column_type IN fnd_objects.pk3_column_type%TYPE ,
1291: p_pk4_column_type IN fnd_objects.pk4_column_type%TYPE ,
1292: p_pk5_column_type IN fnd_objects.pk5_column_type%TYPE ,
1293: p_select_flag IN VARCHAR2 DEFAULT 'Y',

Line 1290: p_pk3_column_type IN fnd_objects.pk3_column_type%TYPE ,

1286: p_pk4_column_name IN fnd_objects.pk4_column_name%TYPE ,
1287: p_pk5_column_name IN fnd_objects.pk5_column_name%TYPE ,
1288: p_pk1_column_type IN fnd_objects.pk1_column_type%TYPE ,
1289: p_pk2_column_type IN fnd_objects.pk2_column_type%TYPE ,
1290: p_pk3_column_type IN fnd_objects.pk3_column_type%TYPE ,
1291: p_pk4_column_type IN fnd_objects.pk4_column_type%TYPE ,
1292: p_pk5_column_type IN fnd_objects.pk5_column_type%TYPE ,
1293: p_select_flag IN VARCHAR2 DEFAULT 'Y',
1294: p_insert_flag IN VARCHAR2 DEFAULT 'Y',

Line 1291: p_pk4_column_type IN fnd_objects.pk4_column_type%TYPE ,

1287: p_pk5_column_name IN fnd_objects.pk5_column_name%TYPE ,
1288: p_pk1_column_type IN fnd_objects.pk1_column_type%TYPE ,
1289: p_pk2_column_type IN fnd_objects.pk2_column_type%TYPE ,
1290: p_pk3_column_type IN fnd_objects.pk3_column_type%TYPE ,
1291: p_pk4_column_type IN fnd_objects.pk4_column_type%TYPE ,
1292: p_pk5_column_type IN fnd_objects.pk5_column_type%TYPE ,
1293: p_select_flag IN VARCHAR2 DEFAULT 'Y',
1294: p_insert_flag IN VARCHAR2 DEFAULT 'Y',
1295: p_update_flag IN VARCHAR2 DEFAULT 'Y',

Line 1292: p_pk5_column_type IN fnd_objects.pk5_column_type%TYPE ,

1288: p_pk1_column_type IN fnd_objects.pk1_column_type%TYPE ,
1289: p_pk2_column_type IN fnd_objects.pk2_column_type%TYPE ,
1290: p_pk3_column_type IN fnd_objects.pk3_column_type%TYPE ,
1291: p_pk4_column_type IN fnd_objects.pk4_column_type%TYPE ,
1292: p_pk5_column_type IN fnd_objects.pk5_column_type%TYPE ,
1293: p_select_flag IN VARCHAR2 DEFAULT 'Y',
1294: p_insert_flag IN VARCHAR2 DEFAULT 'Y',
1295: p_update_flag IN VARCHAR2 DEFAULT 'Y',
1296: p_delete_flag IN VARCHAR2 DEFAULT 'Y',

Line 1319: FROM fnd_objects

1315: l_application_id NUMBER;
1316:
1317: CURSOR c_obj IS
1318: SELECT object_id
1319: FROM fnd_objects
1320: WHERE obj_name = p_obj_name;
1321:
1322: -- -----------------------------------------------------------------
1323: -- Define the cursors to be used in procedure.

Line 1393: SELECT fnd_objects_s.nextval INTO l_object_id FROM DUAL;

1389: IF l_object_id IS NULL THEN
1390: -- populate ID Insert table into FND
1391:
1392: IF p_object_id IS NULL THEN
1393: SELECT fnd_objects_s.nextval INTO l_object_id FROM DUAL;
1394: ELSE
1395: l_object_id := p_object_id;
1396: END IF;
1397:

Line 1398: FND_OBJECTS_PKG.INSERT_ROW (

1394: ELSE
1395: l_object_id := p_object_id;
1396: END IF;
1397:
1398: FND_OBJECTS_PKG.INSERT_ROW (
1399: x_rowid => l_rowid,
1400: x_object_id =>l_object_id,
1401: x_obj_name => p_obj_name,
1402: x_pk1_column_name => p_pk1_column_name,

Line 2084: groups and the fnd objects resident in the system.

2080: Date Created By : April 23, 2003
2081: Purpose : The purpose of this procedure is to handle
2082: the insertion of the data into igs_sc_objects
2083: table. This ensures a link between the object
2084: groups and the fnd objects resident in the system.
2085: There is validation to ensure that the object_id,
2086: and the obj_group_id are valid and present in the
2087: data model.
2088: Remarks :

Line 2101: p_obj_name IN fnd_objects.obj_name%TYPE ,

2097: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
2098: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
2099: p_object_id IN igs_sc_objects.object_id%TYPE,
2100: p_obj_group_id IN igs_sc_objects.obj_group_id%TYPE,
2101: p_obj_name IN fnd_objects.obj_name%TYPE ,
2102: p_database_object_name IN fnd_objects.database_object_name%TYPE ,
2103: p_pk1_column_name IN fnd_objects.pk1_column_name%TYPE ,
2104: p_pk2_column_name IN fnd_objects.pk2_column_name%TYPE ,
2105: p_pk3_column_name IN fnd_objects.pk3_column_name%TYPE ,

Line 2102: p_database_object_name IN fnd_objects.database_object_name%TYPE ,

2098: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
2099: p_object_id IN igs_sc_objects.object_id%TYPE,
2100: p_obj_group_id IN igs_sc_objects.obj_group_id%TYPE,
2101: p_obj_name IN fnd_objects.obj_name%TYPE ,
2102: p_database_object_name IN fnd_objects.database_object_name%TYPE ,
2103: p_pk1_column_name IN fnd_objects.pk1_column_name%TYPE ,
2104: p_pk2_column_name IN fnd_objects.pk2_column_name%TYPE ,
2105: p_pk3_column_name IN fnd_objects.pk3_column_name%TYPE ,
2106: p_pk4_column_name IN fnd_objects.pk4_column_name%TYPE ,

Line 2103: p_pk1_column_name IN fnd_objects.pk1_column_name%TYPE ,

2099: p_object_id IN igs_sc_objects.object_id%TYPE,
2100: p_obj_group_id IN igs_sc_objects.obj_group_id%TYPE,
2101: p_obj_name IN fnd_objects.obj_name%TYPE ,
2102: p_database_object_name IN fnd_objects.database_object_name%TYPE ,
2103: p_pk1_column_name IN fnd_objects.pk1_column_name%TYPE ,
2104: p_pk2_column_name IN fnd_objects.pk2_column_name%TYPE ,
2105: p_pk3_column_name IN fnd_objects.pk3_column_name%TYPE ,
2106: p_pk4_column_name IN fnd_objects.pk4_column_name%TYPE ,
2107: p_pk5_column_name IN fnd_objects.pk5_column_name%TYPE ,

Line 2104: p_pk2_column_name IN fnd_objects.pk2_column_name%TYPE ,

2100: p_obj_group_id IN igs_sc_objects.obj_group_id%TYPE,
2101: p_obj_name IN fnd_objects.obj_name%TYPE ,
2102: p_database_object_name IN fnd_objects.database_object_name%TYPE ,
2103: p_pk1_column_name IN fnd_objects.pk1_column_name%TYPE ,
2104: p_pk2_column_name IN fnd_objects.pk2_column_name%TYPE ,
2105: p_pk3_column_name IN fnd_objects.pk3_column_name%TYPE ,
2106: p_pk4_column_name IN fnd_objects.pk4_column_name%TYPE ,
2107: p_pk5_column_name IN fnd_objects.pk5_column_name%TYPE ,
2108: p_pk1_column_type IN fnd_objects.pk1_column_type%TYPE ,

Line 2105: p_pk3_column_name IN fnd_objects.pk3_column_name%TYPE ,

2101: p_obj_name IN fnd_objects.obj_name%TYPE ,
2102: p_database_object_name IN fnd_objects.database_object_name%TYPE ,
2103: p_pk1_column_name IN fnd_objects.pk1_column_name%TYPE ,
2104: p_pk2_column_name IN fnd_objects.pk2_column_name%TYPE ,
2105: p_pk3_column_name IN fnd_objects.pk3_column_name%TYPE ,
2106: p_pk4_column_name IN fnd_objects.pk4_column_name%TYPE ,
2107: p_pk5_column_name IN fnd_objects.pk5_column_name%TYPE ,
2108: p_pk1_column_type IN fnd_objects.pk1_column_type%TYPE ,
2109: p_pk2_column_type IN fnd_objects.pk2_column_type%TYPE ,

Line 2106: p_pk4_column_name IN fnd_objects.pk4_column_name%TYPE ,

2102: p_database_object_name IN fnd_objects.database_object_name%TYPE ,
2103: p_pk1_column_name IN fnd_objects.pk1_column_name%TYPE ,
2104: p_pk2_column_name IN fnd_objects.pk2_column_name%TYPE ,
2105: p_pk3_column_name IN fnd_objects.pk3_column_name%TYPE ,
2106: p_pk4_column_name IN fnd_objects.pk4_column_name%TYPE ,
2107: p_pk5_column_name IN fnd_objects.pk5_column_name%TYPE ,
2108: p_pk1_column_type IN fnd_objects.pk1_column_type%TYPE ,
2109: p_pk2_column_type IN fnd_objects.pk2_column_type%TYPE ,
2110: p_pk3_column_type IN fnd_objects.pk3_column_type%TYPE ,

Line 2107: p_pk5_column_name IN fnd_objects.pk5_column_name%TYPE ,

2103: p_pk1_column_name IN fnd_objects.pk1_column_name%TYPE ,
2104: p_pk2_column_name IN fnd_objects.pk2_column_name%TYPE ,
2105: p_pk3_column_name IN fnd_objects.pk3_column_name%TYPE ,
2106: p_pk4_column_name IN fnd_objects.pk4_column_name%TYPE ,
2107: p_pk5_column_name IN fnd_objects.pk5_column_name%TYPE ,
2108: p_pk1_column_type IN fnd_objects.pk1_column_type%TYPE ,
2109: p_pk2_column_type IN fnd_objects.pk2_column_type%TYPE ,
2110: p_pk3_column_type IN fnd_objects.pk3_column_type%TYPE ,
2111: p_pk4_column_type IN fnd_objects.pk4_column_type%TYPE ,

Line 2108: p_pk1_column_type IN fnd_objects.pk1_column_type%TYPE ,

2104: p_pk2_column_name IN fnd_objects.pk2_column_name%TYPE ,
2105: p_pk3_column_name IN fnd_objects.pk3_column_name%TYPE ,
2106: p_pk4_column_name IN fnd_objects.pk4_column_name%TYPE ,
2107: p_pk5_column_name IN fnd_objects.pk5_column_name%TYPE ,
2108: p_pk1_column_type IN fnd_objects.pk1_column_type%TYPE ,
2109: p_pk2_column_type IN fnd_objects.pk2_column_type%TYPE ,
2110: p_pk3_column_type IN fnd_objects.pk3_column_type%TYPE ,
2111: p_pk4_column_type IN fnd_objects.pk4_column_type%TYPE ,
2112: p_pk5_column_type IN fnd_objects.pk5_column_type%TYPE ,

Line 2109: p_pk2_column_type IN fnd_objects.pk2_column_type%TYPE ,

2105: p_pk3_column_name IN fnd_objects.pk3_column_name%TYPE ,
2106: p_pk4_column_name IN fnd_objects.pk4_column_name%TYPE ,
2107: p_pk5_column_name IN fnd_objects.pk5_column_name%TYPE ,
2108: p_pk1_column_type IN fnd_objects.pk1_column_type%TYPE ,
2109: p_pk2_column_type IN fnd_objects.pk2_column_type%TYPE ,
2110: p_pk3_column_type IN fnd_objects.pk3_column_type%TYPE ,
2111: p_pk4_column_type IN fnd_objects.pk4_column_type%TYPE ,
2112: p_pk5_column_type IN fnd_objects.pk5_column_type%TYPE ,
2113: p_select_flag IN VARCHAR2 DEFAULT 'Y',

Line 2110: p_pk3_column_type IN fnd_objects.pk3_column_type%TYPE ,

2106: p_pk4_column_name IN fnd_objects.pk4_column_name%TYPE ,
2107: p_pk5_column_name IN fnd_objects.pk5_column_name%TYPE ,
2108: p_pk1_column_type IN fnd_objects.pk1_column_type%TYPE ,
2109: p_pk2_column_type IN fnd_objects.pk2_column_type%TYPE ,
2110: p_pk3_column_type IN fnd_objects.pk3_column_type%TYPE ,
2111: p_pk4_column_type IN fnd_objects.pk4_column_type%TYPE ,
2112: p_pk5_column_type IN fnd_objects.pk5_column_type%TYPE ,
2113: p_select_flag IN VARCHAR2 DEFAULT 'Y',
2114: p_insert_flag IN VARCHAR2 DEFAULT 'Y',

Line 2111: p_pk4_column_type IN fnd_objects.pk4_column_type%TYPE ,

2107: p_pk5_column_name IN fnd_objects.pk5_column_name%TYPE ,
2108: p_pk1_column_type IN fnd_objects.pk1_column_type%TYPE ,
2109: p_pk2_column_type IN fnd_objects.pk2_column_type%TYPE ,
2110: p_pk3_column_type IN fnd_objects.pk3_column_type%TYPE ,
2111: p_pk4_column_type IN fnd_objects.pk4_column_type%TYPE ,
2112: p_pk5_column_type IN fnd_objects.pk5_column_type%TYPE ,
2113: p_select_flag IN VARCHAR2 DEFAULT 'Y',
2114: p_insert_flag IN VARCHAR2 DEFAULT 'Y',
2115: p_update_flag IN VARCHAR2 DEFAULT 'Y',

Line 2112: p_pk5_column_type IN fnd_objects.pk5_column_type%TYPE ,

2108: p_pk1_column_type IN fnd_objects.pk1_column_type%TYPE ,
2109: p_pk2_column_type IN fnd_objects.pk2_column_type%TYPE ,
2110: p_pk3_column_type IN fnd_objects.pk3_column_type%TYPE ,
2111: p_pk4_column_type IN fnd_objects.pk4_column_type%TYPE ,
2112: p_pk5_column_type IN fnd_objects.pk5_column_type%TYPE ,
2113: p_select_flag IN VARCHAR2 DEFAULT 'Y',
2114: p_insert_flag IN VARCHAR2 DEFAULT 'Y',
2115: p_update_flag IN VARCHAR2 DEFAULT 'Y',
2116: p_delete_flag IN VARCHAR2 DEFAULT 'Y',

Line 2135: l_object_name fnd_objects.database_object_name%TYPE ;

2131: l_return_status VARCHAR2(30);
2132: l_object_id igs_sc_objects.object_id%TYPE;
2133: l_obj_group_id igs_sc_objects.obj_group_id%TYPE;
2134: l_rowid VARCHAR2(255);
2135: l_object_name fnd_objects.database_object_name%TYPE ;
2136:
2137: -- -----------------------------------------------------------------
2138: -- Define the cursors to be used in procedure.
2139: -- -----------------------------------------------------------------

Line 2206: FND_OBJECTS_PKG.UPDATE_ROW (

2202: RAISE FND_API.G_EXC_ERROR;
2203:
2204: END IF;
2205:
2206: FND_OBJECTS_PKG.UPDATE_ROW (
2207: x_object_id =>p_object_id,
2208: x_obj_name => p_obj_name,
2209: x_pk1_column_name => p_pk1_column_name,
2210: x_pk2_column_name => p_pk2_column_name,

Line 3323: l_object_name fnd_objects.database_object_name%TYPE;

3319: l_static_type igs_sc_obj_att_mths.static_type%TYPE;
3320: l_select_text igs_sc_obj_att_mths.select_text%TYPE;
3321: l_grant_id igs_sc_grants.grant_id%TYPE;
3322: l_grant_name igs_sc_grants.grant_name%TYPE;
3323: l_object_name fnd_objects.database_object_name%TYPE;
3324:
3325:
3326: -- -----------------------------------------------------------------
3327: -- Define the cursors to be used in procedure.

Line 5218: FROM fnd_objects

5214: l_database_object_name VARCHAR2(255);
5215:
5216: CURSOR c_obj IS
5217: SELECT database_object_name
5218: FROM fnd_objects
5219: WHERE object_id = p_object_id;
5220: BEGIN
5221:
5222: SAVEPOINT Delete_Object_SP;

Line 5271: -- FND_OBJECTS_PKG.DELETE_ROW (x_object_id =>p_object_id);

5267: FETCH c_obj INTO l_database_object_name;
5268: CLOSE c_obj;
5269:
5270:
5271: -- FND_OBJECTS_PKG.DELETE_ROW (x_object_id =>p_object_id);
5272:
5273:
5274: modify_policy(l_database_object_name,'DROP');
5275:

Line 7059: l_object_id fnd_objects.object_id%TYPE;

7055: -- -----------------------------------------------------------------
7056: -- Define local variables to be used.
7057: -- -----------------------------------------------------------------
7058: l_api_name CONSTANT VARCHAR2(30) := 'Validate_Object_ID';
7059: l_object_id fnd_objects.object_id%TYPE;
7060:
7061: -- -----------------------------------------------------------------
7062: -- Define the cursors to be used in procedure.
7063: -- -----------------------------------------------------------------

Line 7066: FROM fnd_objects objs

7062: -- Define the cursors to be used in procedure.
7063: -- -----------------------------------------------------------------
7064: CURSOR c_check_object_id IS
7065: SELECT objs.object_id
7066: FROM fnd_objects objs
7067: WHERE objs.object_id = p_object_id;
7068:
7069: BEGIN
7070:

Line 7554: FND_OBJECTS FND

7550: DECODE(DELETE_FLAG, 'Y','D',NULL) DELETE_FLAG,
7551: DECODE(INSERT_FLAG, 'Y','I',NULL) INSERT_FLAG,
7552: DECODE(ENFORCE_PAR_SEC_FLAG,'Y','Y',NULL) ENFORCE_PAR_SEC_FLAG
7553: FROM IGS_SC_OBJECTS SC,
7554: FND_OBJECTS FND
7555: WHERE FND.OBJ_NAME = p_database_object_name
7556: AND SC.OBJECT_ID = FND.OBJECT_ID
7557: AND SC.ACTIVE_FLAG = 'Y';
7558:

Line 8145: p_obj_id IN fnd_objects.object_id%TYPE )

8141:
8142: END replace_string;
8143:
8144: FUNCTION get_obj_name (
8145: p_obj_id IN fnd_objects.object_id%TYPE )
8146: RETURN VARCHAR2 IS
8147:
8148: l_obj_name fnd_objects.database_object_name%TYPE ;
8149:

Line 8148: l_obj_name fnd_objects.database_object_name%TYPE ;

8144: FUNCTION get_obj_name (
8145: p_obj_id IN fnd_objects.object_id%TYPE )
8146: RETURN VARCHAR2 IS
8147:
8148: l_obj_name fnd_objects.database_object_name%TYPE ;
8149:
8150: CURSOR c_objects IS
8151: SELECT DATABASE_OBJECT_NAME
8152: FROM FND_OBJECTS

Line 8152: FROM FND_OBJECTS

8148: l_obj_name fnd_objects.database_object_name%TYPE ;
8149:
8150: CURSOR c_objects IS
8151: SELECT DATABASE_OBJECT_NAME
8152: FROM FND_OBJECTS
8153: WHERE OBJECT_ID = p_obj_id;
8154: BEGIN
8155:
8156: OPEN c_objects;

Line 8325: FROM FND_OBJECTS

8321: PK4_COLUMN_TYPE ,
8322: PK5_COLUMN_TYPE ,
8323: APPLICATION_ID ,
8324: OBJ_NAME
8325: FROM FND_OBJECTS
8326: WHERE OBJ_NAME LIKE 'IGS%'
8327: ORDER BY OBJ_NAME;
8328:
8329: BEGIN

Line 8337: UTL_FILE.PUT_LINE ( p_file_ptr,' FROM fnd_objects ');

8333: UTL_FILE.PUT_LINE ( p_file_ptr,' DECLARE');
8334:
8335: UTL_FILE.PUT_LINE ( p_file_ptr,' CURSOR c_obj (v_database_object_name VARCHAR2 ) IS');
8336: UTL_FILE.PUT_LINE ( p_file_ptr,' SELECT object_id');
8337: UTL_FILE.PUT_LINE ( p_file_ptr,' FROM fnd_objects ');
8338: UTL_FILE.PUT_LINE ( p_file_ptr,' WHERE database_object_name = v_database_object_name;');
8339:
8340: UTL_FILE.PUT_LINE ( p_file_ptr,' TYPE l_obj_rec_tbl IS TABLE OF fnd_objects%ROWTYPE INDEX BY BINARY_INTEGER;');
8341:

Line 8340: UTL_FILE.PUT_LINE ( p_file_ptr,' TYPE l_obj_rec_tbl IS TABLE OF fnd_objects%ROWTYPE INDEX BY BINARY_INTEGER;');

8336: UTL_FILE.PUT_LINE ( p_file_ptr,' SELECT object_id');
8337: UTL_FILE.PUT_LINE ( p_file_ptr,' FROM fnd_objects ');
8338: UTL_FILE.PUT_LINE ( p_file_ptr,' WHERE database_object_name = v_database_object_name;');
8339:
8340: UTL_FILE.PUT_LINE ( p_file_ptr,' TYPE l_obj_rec_tbl IS TABLE OF fnd_objects%ROWTYPE INDEX BY BINARY_INTEGER;');
8341:
8342: UTL_FILE.PUT_LINE ( p_file_ptr,' l_obj_tbl l_obj_rec_tbl;');
8343: UTL_FILE.PUT_LINE ( p_file_ptr,' l_object_id fnd_objects.object_id%TYPE;');
8344: UTL_FILE.PUT_LINE ( p_file_ptr,' l_record_num NUMBER(10);');

Line 8343: UTL_FILE.PUT_LINE ( p_file_ptr,' l_object_id fnd_objects.object_id%TYPE;');

8339:
8340: UTL_FILE.PUT_LINE ( p_file_ptr,' TYPE l_obj_rec_tbl IS TABLE OF fnd_objects%ROWTYPE INDEX BY BINARY_INTEGER;');
8341:
8342: UTL_FILE.PUT_LINE ( p_file_ptr,' l_obj_tbl l_obj_rec_tbl;');
8343: UTL_FILE.PUT_LINE ( p_file_ptr,' l_object_id fnd_objects.object_id%TYPE;');
8344: UTL_FILE.PUT_LINE ( p_file_ptr,' l_record_num NUMBER(10);');
8345: UTL_FILE.PUT_LINE ( p_file_ptr,' l_cur_num NUMBER(10) := 0;');
8346: UTL_FILE.PUT_LINE ( p_file_ptr,' l_total NUMBER(9) :=0;');
8347: UTL_FILE.PUT_LINE ( p_file_ptr,' l_rowid VARCHAR2(255);');

Line 8399: UTL_FILE.PUT_LINE ( p_file_ptr,' SELECT fnd_objects_s.nextval INTO l_object_id FROM DUAL;');

8395: UTL_FILE.PUT_LINE ( p_file_ptr,' OPEN c_obj ( l_obj_tbl(l_cur_num).DATABASE_OBJECT_NAME);');
8396: UTL_FILE.PUT_LINE ( p_file_ptr,' FETCH c_obj INTO l_object_id;');
8397: UTL_FILE.PUT_LINE ( p_file_ptr,' CLOSE c_obj;');
8398: UTL_FILE.PUT_LINE ( p_file_ptr,' IF l_object_id IS NULL THEN ');
8399: UTL_FILE.PUT_LINE ( p_file_ptr,' SELECT fnd_objects_s.nextval INTO l_object_id FROM DUAL;');
8400: UTL_FILE.PUT_LINE ( p_file_ptr,' FND_OBJECTS_PKG.INSERT_ROW (');
8401: UTL_FILE.PUT_LINE ( p_file_ptr,' x_rowid => l_rowid,');
8402: UTL_FILE.PUT_LINE ( p_file_ptr,' x_object_id =>l_object_id,');
8403: UTL_FILE.PUT_LINE ( p_file_ptr,' x_obj_name => l_obj_tbl(l_cur_num).OBJ_NAME,');

Line 8400: UTL_FILE.PUT_LINE ( p_file_ptr,' FND_OBJECTS_PKG.INSERT_ROW (');

8396: UTL_FILE.PUT_LINE ( p_file_ptr,' FETCH c_obj INTO l_object_id;');
8397: UTL_FILE.PUT_LINE ( p_file_ptr,' CLOSE c_obj;');
8398: UTL_FILE.PUT_LINE ( p_file_ptr,' IF l_object_id IS NULL THEN ');
8399: UTL_FILE.PUT_LINE ( p_file_ptr,' SELECT fnd_objects_s.nextval INTO l_object_id FROM DUAL;');
8400: UTL_FILE.PUT_LINE ( p_file_ptr,' FND_OBJECTS_PKG.INSERT_ROW (');
8401: UTL_FILE.PUT_LINE ( p_file_ptr,' x_rowid => l_rowid,');
8402: UTL_FILE.PUT_LINE ( p_file_ptr,' x_object_id =>l_object_id,');
8403: UTL_FILE.PUT_LINE ( p_file_ptr,' x_obj_name => l_obj_tbl(l_cur_num).OBJ_NAME,');
8404: UTL_FILE.PUT_LINE ( p_file_ptr,' x_pk1_column_name => l_obj_tbl(l_cur_num).PK1_COLUMN_NAME ,');

Line 8426: UTL_FILE.PUT_LINE ( p_file_ptr,' FND_OBJECTS_PKG.UPDATE_ROW (');

8422: UTL_FILE.PUT_LINE ( p_file_ptr,' x_last_update_login => nvl(fnd_global.login_id, -1));');
8423:
8424: UTL_FILE.PUT_LINE ( p_file_ptr,' ELSE');
8425:
8426: UTL_FILE.PUT_LINE ( p_file_ptr,' FND_OBJECTS_PKG.UPDATE_ROW (');
8427: UTL_FILE.PUT_LINE ( p_file_ptr,' x_object_id =>l_object_id,');
8428: UTL_FILE.PUT_LINE ( p_file_ptr,' x_obj_name => l_obj_tbl(l_cur_num).OBJ_NAME,');
8429: UTL_FILE.PUT_LINE ( p_file_ptr,' x_pk1_column_name => l_obj_tbl(l_cur_num).PK1_COLUMN_NAME ,');
8430: UTL_FILE.PUT_LINE ( p_file_ptr,' x_pk2_column_name => l_obj_tbl(l_cur_num).PK2_COLUMN_NAME ,');