DBA Data[Home] [Help]

APPS.EGO_EXT_FWK_PUB dependencies on FND_FLEX_VALUES_TL

Line 535: -- FND_FLEX_VALUES and FND_FLEX_VALUES_TL

531: -- Requirement: bug: 3542670
532: --
533: -- Function: To process value set values.
534: -- Given all the parameters, the data is inserted into
535: -- FND_FLEX_VALUES and FND_FLEX_VALUES_TL
536: --
537: -- Parameters:
538: -- IN
539: -- p_transaction_type : CREATE, UPDATE

Line 7831: l_vsvtl_row fnd_flex_values_tl%ROWTYPE;

7827: l_value_set_id fnd_flex_values.flex_value_set_id%TYPE;
7828: l_validation_type fnd_flex_value_sets.validation_type%TYPE;
7829:
7830: l_vsv_row fnd_flex_values%ROWTYPE;
7831: l_vsvtl_row fnd_flex_values_tl%ROWTYPE;
7832:
7833: CURSOR c_get_vs_details (cp_value_set_id IN NUMBER) IS
7834: SELECT vsvtl.last_updated_by, vsvtl.last_update_date
7835: FROM FND_FLEX_VALUES vsv, FND_FLEX_VALUES_TL vsvtl

Line 7835: FROM FND_FLEX_VALUES vsv, FND_FLEX_VALUES_TL vsvtl

7831: l_vsvtl_row fnd_flex_values_tl%ROWTYPE;
7832:
7833: CURSOR c_get_vs_details (cp_value_set_id IN NUMBER) IS
7834: SELECT vsvtl.last_updated_by, vsvtl.last_update_date
7835: FROM FND_FLEX_VALUES vsv, FND_FLEX_VALUES_TL vsvtl
7836: WHERE vsv.flex_value_set_id = cp_value_set_id
7837: AND vsv.flex_value = p_internal_name
7838: AND vsv.flex_value_id = vsvtl.flex_value_id
7839: AND USERENV('LANG') IN (language, source_lang);