[Home] [Help]
567: -- Requirement: bug: 3542670
568: --
569: -- Function: To process value set values.
570: -- Given all the parameters, the data is inserted into
571: -- FND_FLEX_VALUES and FND_FLEX_VALUES_TL
572: --
573: -- Parameters:
574: -- IN
575: -- p_transaction_type : CREATE, UPDATE
6829: INSERT INTO EGO_FLEX_VALUE_VERSION_TL (FLEX_VALUE_ID,DESCRIPTION,VERSION_SEQ_ID,LAST_UPDATE_DATE,LAST_UPDATED_BY,
6830: CREATION_DATE,CREATED_BY,LAST_UPDATE_LOGIN,FLEX_VALUE_MEANING,LANGUAGE,SOURCE_LANG
6831: ) SELECT A.FLEX_VALUE_ID,B.DESCRIPTION ,0,SYSDATE,FND_GLOBAL.PARTY_ID,SYSDATE,FND_GLOBAL.PARTY_ID,FND_GLOBAL.LOGIN_ID,
6832: B.FLEX_VALUE_MEANING,B.LANGUAGE,USERENV('LANG') FROM EGO_FLEX_VALUE_VERSION_B A,
6833: FND_FLEX_VALUES_TL B
6834: WHERE A.FLEX_VALUE_SET_ID = P_VALUE_SET_ID AND
6835: A.VERSION_SEQ_ID = 0 AND A.FLEX_VALUE_ID = B.FLEX_VALUE_ID;
6836: x_return_status := 'S';
6837: COMMIT;
8775: l_value_set_id fnd_flex_values.flex_value_set_id%TYPE;
8776: l_validation_type fnd_flex_value_sets.validation_type%TYPE;
8777:
8778: l_vsv_row fnd_flex_values%ROWTYPE;
8779: l_vsvtl_row fnd_flex_values_tl%ROWTYPE;
8780:
8781: CURSOR c_get_vs_details (cp_value_set_id IN NUMBER) IS
8782: SELECT vsvtl.last_updated_by, vsvtl.last_update_date
8783: FROM FND_FLEX_VALUES vsv, FND_FLEX_VALUES_TL vsvtl
8779: l_vsvtl_row fnd_flex_values_tl%ROWTYPE;
8780:
8781: CURSOR c_get_vs_details (cp_value_set_id IN NUMBER) IS
8782: SELECT vsvtl.last_updated_by, vsvtl.last_update_date
8783: FROM FND_FLEX_VALUES vsv, FND_FLEX_VALUES_TL vsvtl
8784: WHERE vsv.flex_value_set_id = cp_value_set_id
8785: AND vsv.flex_value = p_internal_name
8786: AND vsv.flex_value_id = vsvtl.flex_value_id
8787: AND USERENV('LANG') IN (language, source_lang);
15473:
15474: l_value_set_name FND_FLEX_VALUE_SETS.flex_value_set_name%TYPE;
15475: l_flex_value_id FND_FLEX_VALUES.flex_value_id%TYPE;
15476: l_internal_name FND_FLEX_VALUES.FLEX_VALUE%TYPE;
15477: l_display_name FND_FLEX_VALUES_TL.flex_value_meaning%TYPE;
15478: l_description FND_FLEX_VALUES_TL.description%TYPE;
15479: l_start_date DATE;
15480: l_end_date DATE;
15481: l_enabled FND_FLEX_VALUES.ENABLED_FLAG%TYPE;
15474: l_value_set_name FND_FLEX_VALUE_SETS.flex_value_set_name%TYPE;
15475: l_flex_value_id FND_FLEX_VALUES.flex_value_id%TYPE;
15476: l_internal_name FND_FLEX_VALUES.FLEX_VALUE%TYPE;
15477: l_display_name FND_FLEX_VALUES_TL.flex_value_meaning%TYPE;
15478: l_description FND_FLEX_VALUES_TL.description%TYPE;
15479: l_start_date DATE;
15480: l_end_date DATE;
15481: l_enabled FND_FLEX_VALUES.ENABLED_FLAG%TYPE;
15482:
15484: SELECT FLEX_VALUE_SET_NAME INTO L_VALUE_SET_NAME FROM FND_FLEX_VALUE_SETS
15485: WHERE FLEX_VALUE_SET_ID = p_value_set_id ;
15486: SELECT FLEX_VALUE,FLEX_VALUE_MEANING,DESCRIPTION, START_DATE_ACTIVE,
15487: ENABLED_FLAG INTO l_internal_name,l_display_name,l_description,l_start_date,l_enabled
15488: FROM FND_FLEX_VALUES,FND_FLEX_VALUES_TL WHERE
15489: LANGUAGE = userenv('LANG') AND FND_FLEX_VALUES.FLEX_VALUE_ID = p_value_id
15490: AND FND_FLEX_VALUES_TL.FLEX_VALUE_ID = p_value_id AND ROWNUM=1;
15491: FND_FLEX_VALUES_PKG.UPDATE_ROW
15492: (x_flex_value_id => p_value_id
15486: SELECT FLEX_VALUE,FLEX_VALUE_MEANING,DESCRIPTION, START_DATE_ACTIVE,
15487: ENABLED_FLAG INTO l_internal_name,l_display_name,l_description,l_start_date,l_enabled
15488: FROM FND_FLEX_VALUES,FND_FLEX_VALUES_TL WHERE
15489: LANGUAGE = userenv('LANG') AND FND_FLEX_VALUES.FLEX_VALUE_ID = p_value_id
15490: AND FND_FLEX_VALUES_TL.FLEX_VALUE_ID = p_value_id AND ROWNUM=1;
15491: FND_FLEX_VALUES_PKG.UPDATE_ROW
15492: (x_flex_value_id => p_value_id
15493: ,x_attribute_sort_order => NULL
15494: ,x_flex_value_set_id => p_value_set_id