APPS.EGO_EXT_FWK_PUB dependencies on FND_LOOKUP_VALUES

Line 1790: FROM fnd_lookup_values

1786:
1787: BEGIN
1788:
1789: SELECT meaning into l_p_data_level_disp_name
1790: FROM fnd_lookup_values
1791: WHERE lookup_type = 'EGO_EF_DATA_LEVEL'
1792: AND language = userenv('LANG')
1793: AND lookup_code = p_data_level;
1794:

Line 4703: FROM fnd_lookup_values

4699: IF l_data_level_rec.enable_defaulting = 'Y' THEN
4700: IF p_defaulting IS NOT NULL THEN
4701: SELECT lookup_code
4702: INTO l_defaulting
4703: FROM fnd_lookup_values
4704: WHERE lookup_type = 'EGO_EF_AG_DL_BEHAVIOR'
4705: AND lookup_code = p_defaulting
4706: AND language = USERENV('LANG');
4707: ELSIF p_defaulting_name IS NOT NULL THEN

Line 4710: FROM fnd_lookup_values

4706: AND language = USERENV('LANG');
4707: ELSIF p_defaulting_name IS NOT NULL THEN
4708: SELECT lookup_code
4709: INTO l_defaulting
4710: FROM fnd_lookup_values
4711: WHERE lookup_type = 'EGO_EF_AG_DL_BEHAVIOR'
4712: AND meaning = p_defaulting_name
4713: AND language = USERENV('LANG');
4714: ELSE

Line 5404: FROM FND_LOOKUP_VALUES

5400: -- We are passed in a meaning for 'Yes' or 'No'; we need to get its code --
5401: ---------------------------------------------------------------------------
5402: SELECT LOOKUP_CODE
5403: INTO l_is_column_indexed
5404: FROM FND_LOOKUP_VALUES
5405: WHERE LOOKUP_TYPE = 'YES_NO'
5406: AND LANGUAGE = USERENV('LANG')
5407: AND VIEW_APPLICATION_ID = 0
5408: AND MEANING = p_is_column_indexed;

Line 5412: FROM FND_LOOKUP_VALUES

5408: AND MEANING = p_is_column_indexed;
5409: --look up code for pending table.
5410: SELECT LOOKUP_CODE
5411: INTO l_is_chg_column_indexed
5412: FROM FND_LOOKUP_VALUES
5413: WHERE LOOKUP_TYPE = 'YES_NO'
5414: AND LANGUAGE = USERENV('LANG')
5415: AND VIEW_APPLICATION_ID = 0
5416: AND MEANING = p_is_column_indexed;

Line 6951: l_validation_code FND_LOOKUP_VALUES.LOOKUP_CODE%TYPE;

6947: -- l_add_where_clause VARCHAR2(1000);
6948: l_owner NUMBER;
6949: l_maximum_size NUMBER;
6950: l_format_code FND_FLEX_VALUE_SETS.FORMAT_TYPE%TYPE;
6951: l_validation_code FND_LOOKUP_VALUES.LOOKUP_CODE%TYPE;
6952: l_maximum_value FND_FLEX_VALUE_SETS.MAXIMUM_VALUE%TYPE;
6953: l_minimum_value FND_FLEX_VALUE_SETS.MINIMUM_VALUE%TYPE;
6954: -- l_Sysdate DATE := Sysdate;
6955:

Line 7773: l_validation_code FND_LOOKUP_VALUES.LOOKUP_CODE%TYPE;

7769: ) IS
7770: l_vs_value_count NUMBER;
7771: l_api_name VARCHAR2(30);
7772: l_parent_vs_row ego_value_sets_v%ROWTYPE;
7773: l_validation_code FND_LOOKUP_VALUES.LOOKUP_CODE%TYPE;
7774: l_vs_value_disp_orders EGO_VS_VALUES_DISP_ORDER_TBL
7775: := ego_vs_values_disp_order_tbl();
7776: x_versioned_vs NUMBER :=NULL ;
7777: BEGIN

Line 8463: INSERT INTO fnd_lookup_values

8459: l_owner := p_owner;
8460: END IF;
8461:
8462: /***
8463: INSERT INTO fnd_lookup_values
8464: (
8465: LOOKUP_TYPE
8466: ,LANGUAGE
8467: ,LOOKUP_CODE

Line 8659: UPDATE FND_LOOKUP_VALUES

8655: END IF;
8656: /***
8657: l_lookup_type := 'EGO_EF_'||p_value_set_name||'_TYPE';
8658:
8659: UPDATE FND_LOOKUP_VALUES
8660: SET MEANING = p_display_name,
8661: DESCRIPTION = p_description,
8662: ENABLED_FLAG = p_enabled,
8663: START_DATE_ACTIVE = p_start_date,