DBA Data[Home] [Help]

APPS.EGO_EXT_FWK_PUB dependencies on FND_FLEX_VALUES

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 567: l_flex_value_id FND_FLEX_VALUES.flex_value_id%TYPE;

563: ,x_return_status OUT NOCOPY VARCHAR2
564: ) IS
565:
566: l_api_name VARCHAR2(30);
567: l_flex_value_id FND_FLEX_VALUES.flex_value_id%TYPE;
568: l_value_set_id FND_FLEX_VALUES.flex_value_set_id%TYPE;
569: l_Sysdate DATE;
570: l_rowid VARCHAR2(100);
571:

Line 568: l_value_set_id FND_FLEX_VALUES.flex_value_set_id%TYPE;

564: ) IS
565:
566: l_api_name VARCHAR2(30);
567: l_flex_value_id FND_FLEX_VALUES.flex_value_id%TYPE;
568: l_value_set_id FND_FLEX_VALUES.flex_value_set_id%TYPE;
569: l_Sysdate DATE;
570: l_rowid VARCHAR2(100);
571:
572: l_validation_type fnd_flex_value_sets.validation_type%TYPE;

Line 613: SELECT fnd_flex_values_s.NEXTVAL

609: WHERE flex_value_set_name = p_value_set_name;
610:
611: IF p_transaction_type = 'CREATE' THEN
612: -- create an translatable independent value set
613: SELECT fnd_flex_values_s.NEXTVAL
614: INTO l_flex_value_id
615: FROM dual;
616: FND_FLEX_VALUES_PKG.INSERT_ROW
617: (x_rowid => l_rowid

Line 616: FND_FLEX_VALUES_PKG.INSERT_ROW

612: -- create an translatable independent value set
613: SELECT fnd_flex_values_s.NEXTVAL
614: INTO l_flex_value_id
615: FROM dual;
616: FND_FLEX_VALUES_PKG.INSERT_ROW
617: (x_rowid => l_rowid
618: ,x_flex_value_id => l_flex_value_id
619: ,x_attribute_sort_order => NULL
620: ,x_flex_value_set_id => l_value_set_id

Line 693: FROM fnd_flex_values

689:
690: ELSIF p_transaction_type = 'UPDATE' THEN
691: SELECT flex_value_id
692: INTO l_flex_value_id
693: FROM fnd_flex_values
694: WHERE flex_value_set_id = l_value_set_id
695: AND flex_value = p_internal_name;
696:
697: FND_FLEX_VALUES_PKG.UPDATE_ROW

Line 697: FND_FLEX_VALUES_PKG.UPDATE_ROW

693: FROM fnd_flex_values
694: WHERE flex_value_set_id = l_value_set_id
695: AND flex_value = p_internal_name;
696:
697: FND_FLEX_VALUES_PKG.UPDATE_ROW
698: (x_flex_value_id => l_flex_value_id
699: ,x_attribute_sort_order => NULL
700: ,x_flex_value_set_id => l_value_set_id
701: ,x_flex_value => p_internal_name

Line 7521: l_flex_value_id FND_FLEX_VALUES.flex_value_id%TYPE;

7517: --if we change optional parameters, version goes from x.n to x.(n+1)
7518: l_api_version NUMBER;
7519: l_storage_value VARCHAR2(32767);
7520:
7521: l_flex_value_id FND_FLEX_VALUES.flex_value_id%TYPE;
7522: -- l_Sysdate DATE;
7523: l_rowid VARCHAR2(100);
7524: l_owner NUMBER;
7525:

Line 7826: l_flex_value_id fnd_flex_values.flex_value_id%TYPE;

7822: ,x_return_status OUT NOCOPY VARCHAR2
7823: ,x_msg_count OUT NOCOPY NUMBER
7824: ,x_msg_data OUT NOCOPY VARCHAR2
7825: ) IS
7826: l_flex_value_id fnd_flex_values.flex_value_id%TYPE;
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;

Line 7827: l_value_set_id fnd_flex_values.flex_value_set_id%TYPE;

7823: ,x_msg_count OUT NOCOPY NUMBER
7824: ,x_msg_data OUT NOCOPY VARCHAR2
7825: ) IS
7826: l_flex_value_id fnd_flex_values.flex_value_id%TYPE;
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;

Line 7830: l_vsv_row fnd_flex_values%ROWTYPE;

7826: l_flex_value_id fnd_flex_values.flex_value_id%TYPE;
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

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);

Line 7842: l_last_update_login fnd_flex_values.last_update_login%TYPE;

7838: AND vsv.flex_value_id = vsvtl.flex_value_id
7839: AND USERENV('LANG') IN (language, source_lang);
7840:
7841:
7842: l_last_update_login fnd_flex_values.last_update_login%TYPE;
7843: l_last_update_date fnd_flex_values.last_update_date%TYPE;
7844: l_last_updated_by fnd_flex_values.last_updated_by%TYPE;
7845:
7846: BEGIN

Line 7843: l_last_update_date fnd_flex_values.last_update_date%TYPE;

7839: AND USERENV('LANG') IN (language, source_lang);
7840:
7841:
7842: l_last_update_login fnd_flex_values.last_update_login%TYPE;
7843: l_last_update_date fnd_flex_values.last_update_date%TYPE;
7844: l_last_updated_by fnd_flex_values.last_updated_by%TYPE;
7845:
7846: BEGIN
7847: SELECT vs.flex_value_set_id, vs.validation_type

Line 7844: l_last_updated_by fnd_flex_values.last_updated_by%TYPE;

7840:
7841:
7842: l_last_update_login fnd_flex_values.last_update_login%TYPE;
7843: l_last_update_date fnd_flex_values.last_update_date%TYPE;
7844: l_last_updated_by fnd_flex_values.last_updated_by%TYPE;
7845:
7846: BEGIN
7847: SELECT vs.flex_value_set_id, vs.validation_type
7848: INTO l_value_set_id, l_validation_type

Line 7867: FROM FND_FLEX_VALUES vsv

7863: ,l_last_update_date
7864: ,NULL)) THEN
7865: SELECT vsv.*
7866: INTO l_vsv_row
7867: FROM FND_FLEX_VALUES vsv
7868: WHERE vsv.flex_value_set_id = l_value_set_id
7869: AND vsv.flex_value = p_internal_name;
7870:
7871: FND_FLEX_VALUES_PKG.UPDATE_ROW

Line 7871: FND_FLEX_VALUES_PKG.UPDATE_ROW

7867: FROM FND_FLEX_VALUES vsv
7868: WHERE vsv.flex_value_set_id = l_value_set_id
7869: AND vsv.flex_value = p_internal_name;
7870:
7871: FND_FLEX_VALUES_PKG.UPDATE_ROW
7872: (x_flex_value_id => l_vsv_row.flex_value_id
7873: ,x_attribute_sort_order => l_vsv_row.attribute_sort_order
7874: ,x_flex_value_set_id => l_value_set_id
7875: ,x_flex_value => p_internal_name

Line 8037: l_vsv_created_by fnd_flex_values.created_by%TYPE;

8033: -- T is VS Value is editable
8034: -- F if VS Value is not editable.
8035: l_return_status VARCHAR2(1);
8036:
8037: l_vsv_created_by fnd_flex_values.created_by%TYPE;
8038: l_vs_created_by fnd_flex_values.created_by%TYPE;
8039: l_vs_format_type fnd_flex_value_sets.format_type%TYPE;
8040: l_vs_validation_type fnd_flex_value_sets.validation_type%TYPE;
8041: l_vs_alpha_numeric_allowed fnd_flex_value_sets.alphanumeric_allowed_flag%TYPE;

Line 8038: l_vs_created_by fnd_flex_values.created_by%TYPE;

8034: -- F if VS Value is not editable.
8035: l_return_status VARCHAR2(1);
8036:
8037: l_vsv_created_by fnd_flex_values.created_by%TYPE;
8038: l_vs_created_by fnd_flex_values.created_by%TYPE;
8039: l_vs_format_type fnd_flex_value_sets.format_type%TYPE;
8040: l_vs_validation_type fnd_flex_value_sets.validation_type%TYPE;
8041: l_vs_alpha_numeric_allowed fnd_flex_value_sets.alphanumeric_allowed_flag%TYPE;
8042: l_vs_uppercase_only fnd_flex_value_sets.uppercase_only_flag%TYPE;

Line 8055: FROM fnd_flex_values a, fnd_flex_value_sets b

8051: b.numeric_mode_enabled_flag, b.security_enabled_flag, b.created_by
8052: INTO l_vsv_created_by, l_vs_format_type, l_vs_validation_type,
8053: l_vs_alpha_numeric_allowed, l_vs_uppercase_only,
8054: l_vs_numeric_mode_enabled, l_vs_security_enabled, l_vs_created_by
8055: FROM fnd_flex_values a, fnd_flex_value_sets b
8056: WHERE a.flex_value_id = cp_vs_value_id
8057: AND a.flex_value_set_id = b.flex_value_set_id;
8058:
8059: IF l_vsv_created_by IN (1,2)

Line 8126: l_value_set_value_id fnd_flex_values.flex_value_id%TYPE;

8122: ) IS
8123:
8124: l_api_name VARCHAR2(30);
8125: l_api_version NUMBER;
8126: l_value_set_value_id fnd_flex_values.flex_value_id%TYPE;
8127: l_value_set_id fnd_flex_value_sets.flex_value_set_id%TYPE;
8128: l_sequence EGO_VS_VALUES_DISP_ORDER.disp_sequence%TYPE;
8129: l_invalid_params BOOLEAN;
8130: l_create_sequence BOOLEAN;

Line 8187: FROM fnd_flex_values

8183: IF p_value_set_value_id IS NOT NULL THEN
8184: BEGIN
8185: SELECT flex_value_id, flex_value_set_id
8186: INTO l_value_set_value_id, l_value_set_id
8187: FROM fnd_flex_values
8188: WHERE flex_value_id = p_value_set_value_id;
8189: EXCEPTION
8190: WHEN OTHERS THEN
8191: l_invalid_params := TRUE;

Line 8197: FROM fnd_flex_values a, fnd_flex_value_sets b

8193: ELSE
8194: BEGIN
8195: SELECT a.flex_value_id, a.flex_value_set_id
8196: INTO l_value_set_value_id, l_value_set_id
8197: FROM fnd_flex_values a, fnd_flex_value_sets b
8198: WHERE a.flex_value_set_id = b.flex_value_set_id
8199: AND a.flex_value = p_value_set_value
8200: AND (b.flex_value_set_id = p_value_set_id OR b.flex_value_set_name = p_value_set_name);
8201: EXCEPTION