DBA Data[Home] [Help]

APPS.IGS_SC_DATA_SEC_APIS_PKG dependencies on FND_OBJECTS_S

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 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,');