APPS.IGS_SC_DATA_SEC_APIS_PKG dependencies on DUAL

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 1626: IF NOT check_attrib_text ( 'DUAL', p_select_text,l_user_attrib_type) THEN

1622: FND_MSG_PUB.Add;
1623: RAISE FND_API.G_EXC_ERROR;
1624: END IF;
1625:
1626: IF NOT check_attrib_text ( 'DUAL', p_select_text,l_user_attrib_type) THEN
1627:
1628: FND_MESSAGE.SET_NAME('IGS', 'IGS_SC_GRNT_TXT_ERR');
1629: FND_MESSAGE.SET_TOKEN('OBJ_NAME','USER_ATTRIB');
1630: FND_MESSAGE.SET_TOKEN('GRNT_TEXT', p_select_text);

Line 4150: IF NOT check_attrib_text ( 'DUAL', l_select_text,l_user_attrib_type) THEN

4146: END IF;
4147:
4148:
4149:
4150: IF NOT check_attrib_text ( 'DUAL', l_select_text,l_user_attrib_type) THEN
4151:
4152: FND_MESSAGE.SET_NAME('IGS', 'IGS_SC_GRNT_TXT_ERR');
4153: FND_MESSAGE.SET_TOKEN('OBJ_NAME','USER_ATTRIB');
4154: FND_MESSAGE.SET_TOKEN('GRNT_TEXT', l_select_text);

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