DBA Data[Home] [Help]

APPS.EGO_EXT_FWK_PUB dependencies on FND_LOOKUP_VALUES

Line 1708: FROM fnd_lookup_values

1704:
1705: BEGIN
1706:
1707: SELECT meaning into l_p_data_level_disp_name
1708: FROM fnd_lookup_values
1709: WHERE lookup_type = 'EGO_EF_DATA_LEVEL'
1710: AND language = userenv('LANG')
1711: AND lookup_code = p_data_level;
1712:

Line 4567: FROM fnd_lookup_values

4563: IF l_data_level_rec.enable_defaulting = 'Y' THEN
4564: IF p_defaulting IS NOT NULL THEN
4565: SELECT lookup_code
4566: INTO l_defaulting
4567: FROM fnd_lookup_values
4568: WHERE lookup_type = 'EGO_EF_AG_DL_BEHAVIOR'
4569: AND lookup_code = p_defaulting
4570: AND language = USERENV('LANG');
4571: ELSIF p_defaulting_name IS NOT NULL THEN

Line 4574: FROM fnd_lookup_values

4570: AND language = USERENV('LANG');
4571: ELSIF p_defaulting_name IS NOT NULL THEN
4572: SELECT lookup_code
4573: INTO l_defaulting
4574: FROM fnd_lookup_values
4575: WHERE lookup_type = 'EGO_EF_AG_DL_BEHAVIOR'
4576: AND meaning = p_defaulting_name
4577: AND language = USERENV('LANG');
4578: ELSE

Line 5196: FROM FND_LOOKUP_VALUES

5192: -- We are passed in a meaning for 'Yes' or 'No'; we need to get its code --
5193: ---------------------------------------------------------------------------
5194: SELECT LOOKUP_CODE
5195: INTO l_is_column_indexed
5196: FROM FND_LOOKUP_VALUES
5197: WHERE LOOKUP_TYPE = 'YES_NO'
5198: AND LANGUAGE = USERENV('LANG')
5199: AND VIEW_APPLICATION_ID = 0
5200: AND MEANING = p_is_column_indexed;

Line 5205: FROM FND_LOOKUP_VALUES

5201:
5202: --look up code for pending table.
5203: SELECT LOOKUP_CODE
5204: INTO l_is_chg_column_indexed
5205: FROM FND_LOOKUP_VALUES
5206: WHERE LOOKUP_TYPE = 'YES_NO'
5207: AND LANGUAGE = USERENV('LANG')
5208: AND VIEW_APPLICATION_ID = 0
5209: AND MEANING = p_is_column_indexed;

Line 6211: l_validation_code FND_LOOKUP_VALUES.LOOKUP_CODE%TYPE;

6207: -- l_add_where_clause VARCHAR2(1000);
6208: l_owner NUMBER;
6209: l_maximum_size NUMBER;
6210: l_format_code FND_FLEX_VALUE_SETS.FORMAT_TYPE%TYPE;
6211: l_validation_code FND_LOOKUP_VALUES.LOOKUP_CODE%TYPE;
6212: l_maximum_value FND_FLEX_VALUE_SETS.MAXIMUM_VALUE%TYPE;
6213: l_minimum_value FND_FLEX_VALUE_SETS.MINIMUM_VALUE%TYPE;
6214: -- l_Sysdate DATE := Sysdate;
6215:

Line 7016: l_validation_code FND_LOOKUP_VALUES.LOOKUP_CODE%TYPE;

7012: ) IS
7013: l_vs_value_count NUMBER;
7014: l_api_name VARCHAR2(30);
7015: l_parent_vs_row ego_value_sets_v%ROWTYPE;
7016: l_validation_code FND_LOOKUP_VALUES.LOOKUP_CODE%TYPE;
7017: l_vs_value_disp_orders EGO_VS_VALUES_DISP_ORDER_TBL
7018: := ego_vs_values_disp_order_tbl();
7019: BEGIN
7020:

Line 7555: INSERT INTO fnd_lookup_values

7551: l_owner := p_owner;
7552: END IF;
7553:
7554: /***
7555: INSERT INTO fnd_lookup_values
7556: (
7557: LOOKUP_TYPE
7558: ,LANGUAGE
7559: ,LOOKUP_CODE

Line 7741: UPDATE FND_LOOKUP_VALUES

7737: END IF;
7738: /***
7739: l_lookup_type := 'EGO_EF_'||p_value_set_name||'_TYPE';
7740:
7741: UPDATE FND_LOOKUP_VALUES
7742: SET MEANING = p_display_name,
7743: DESCRIPTION = p_description,
7744: ENABLED_FLAG = p_enabled,
7745: START_DATE_ACTIVE = p_start_date,