DBA Data[Home] [Help]

APPS.BSC_CUSTOM_VIEW_UI_WRAPPER dependencies on DUAL

Line 1105: SELECT BSC_SYS_IMAGE_ID_S.NEXTVAL INTO l_next_image_id FROM dual;

1101: SAVEPOINT RollBackPt;
1102: fnd_msg_pub.initialize;
1103: x_return_status := FND_API.G_RET_STS_SUCCESS;
1104:
1105: SELECT BSC_SYS_IMAGE_ID_S.NEXTVAL INTO l_next_image_id FROM dual;
1106: x_image_id := l_next_image_id;
1107:
1108: BEGIN
1109: BSC_SYS_IMAGES_PKG.INSERT_ROW (

Line 1229: SELECT BSC_SYS_IMAGE_ID_S.NEXTVAL INTO l_next_image_id FROM dual;

1225: );
1226:
1227: ELSE
1228: --image not owned by this NLS session, need to create a new image and update the image map
1229: SELECT BSC_SYS_IMAGE_ID_S.NEXTVAL INTO l_next_image_id FROM dual;
1230: x_image_id := l_next_image_id;
1231:
1232: BEGIN
1233: BSC_SYS_IMAGES_PKG.INSERT_ROW (

Line 1618: select FND_FORM_FUNCTIONS_S.NEXTVAL into l_new_function_id from dual;

1614: where FUNCTION_NAME = l_function_name;
1615:
1616: -- check if function has already been created
1617: IF (l_count =0) THEN
1618: select FND_FORM_FUNCTIONS_S.NEXTVAL into l_new_function_id from dual;
1619:
1620: FND_FORM_FUNCTIONS_PKG.INSERT_ROW(
1621: X_ROWID => l_ROWID,
1622: X_FUNCTION_ID => l_new_function_id,