DBA Data[Home] [Help]

APPS.ICX_QUESTIONS_ADMIN dependencies on FND_FORM_FUNCTIONS_VL

Line 1041: FROM ICX_QUESTION_FUNCTIONS ICX, FND_FORM_FUNCTIONS_VL FND

1037: cursor function_cursor is
1038: SELECT FND.FUNCTION_NAME,
1039: FND.FUNCTION_ID,
1040: FND.USER_FUNCTION_NAME
1041: FROM ICX_QUESTION_FUNCTIONS ICX, FND_FORM_FUNCTIONS_VL FND
1042: WHERE ICX.QUESTION_CODE = P_QUESTION_CODE
1043: AND ICX.FUNCTION_NAME = FND.FUNCTION_NAME
1044: ORDER BY FND.FUNCTION_NAME;
1045:

Line 1203: FROM FND_FORM_FUNCTIONS_VL FND

1199: FND.USER_FUNCTION_NAME
1200: INTO L_FUNCTION_ID,
1201: L_FUNCTION_NAME,
1202: L_USER_FUNCTION_NAME
1203: FROM FND_FORM_FUNCTIONS_VL FND
1204: WHERE FND.FUNCTION_ID = P_FUNCTION_ID;
1205:
1206: elsif (P_ERROR_MESSAGE IS NOT NULL) THEN
1207:

Line 1372: FROM FND_FORM_FUNCTIONS_VL FND

1368: CURSOR c_function_lov (c_find_criteria IN VARCHAR2) IS
1369: SELECT FND.FUNCTION_ID,
1370: FND.FUNCTION_NAME,
1371: FND.USER_FUNCTION_NAME
1372: FROM FND_FORM_FUNCTIONS_VL FND
1373: WHERE FND.FUNCTION_NAME like upper(c_find_criteria)
1374: ORDER BY fnd.function_name;
1375:
1376: CURSOR c_function_display_value (c_id IN VARCHAR2) IS

Line 1401: FROM FND_FORM_FUNCTIONS_VL FND

1397: ** how many matches are available.
1398: */
1399: select count(*)
1400: into l_total_rows
1401: FROM FND_FORM_FUNCTIONS_VL FND
1402: WHERE FND.FUNCTION_NAME like upper(p_display_value||'%');
1403:
1404: wf_lov.g_define_rec.total_rows := l_total_rows;
1405:

Line 1475: FROM FND_FORM_FUNCTIONS_VL FND

1471: BEGIN
1472:
1473: SELECT COUNT(*)
1474: INTO l_count
1475: FROM FND_FORM_FUNCTIONS_VL FND
1476: WHERE FND.FUNCTION_NAME = P_FUNCTION_NAME;
1477:
1478: if (l_count = 0) THEN
1479:

Line 1565: FROM FND_FORM_FUNCTIONS_VL FND

1561: BEGIN
1562:
1563: SELECT COUNT(*)
1564: INTO l_count
1565: FROM FND_FORM_FUNCTIONS_VL FND
1566: WHERE FND.FUNCTION_NAME = P_FUNCTION_NAME;
1567:
1568: if (l_count = 0) THEN
1569: