eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.EGO_EXT_FWK_PUB dependencies on EGO_VALUE_SETS_V

Line 55: p_parent_vs_row IN ego_value_sets_v%ROWTYPE

51: NOTES
52:
53: -----------------------------------------------------------------------------*/
54: PROCEDURE Convert_Child_VS_Select_Expr (
55: p_parent_vs_row IN ego_value_sets_v%ROWTYPE
56: , p_convert_date IN VARCHAR2 := FND_API.G_FALSE
57: , x_column_name IN OUT NOCOPY VARCHAR2
58: )
59: IS

Line 107: p_parent_vs_row IN ego_value_sets_v%ROWTYPE

103: correctly in the Java layer.
104:
105: -----------------------------------------------------------------------------*/
106: PROCEDURE Build_Child_VS_Select_Exprs (
107: p_parent_vs_row IN ego_value_sets_v%ROWTYPE
108: , x_id_column_type OUT NOCOPY fnd_flex_validation_tables.id_column_type%TYPE
109: , x_value_column_type OUT NOCOPY fnd_flex_validation_tables.value_column_type%TYPE
110: , x_id_column_name OUT NOCOPY fnd_flex_validation_tables.id_column_name%TYPE
111: , x_value_column_name OUT NOCOPY fnd_flex_validation_tables.value_column_name%TYPE

Line 7227: l_parent_vs_row ego_value_sets_v%ROWTYPE;

7223: ,x_msg_count OUT NOCOPY NUMBER
7224: ,x_msg_data OUT NOCOPY VARCHAR2
7225: ) IS
7226: l_api_name VARCHAR2(30);
7227: l_parent_vs_row ego_value_sets_v%ROWTYPE;
7228: l_maximum_size ego_value_sets_v.maximum_size%TYPE;
7229: l_format_code ego_value_sets_v.format_code%TYPE;
7230: l_minimum_value ego_value_sets_v.minimum_value%TYPE;
7231: l_maximum_value ego_value_sets_v.maximum_value%TYPE;

Line 7228: l_maximum_size ego_value_sets_v.maximum_size%TYPE;

7224: ,x_msg_data OUT NOCOPY VARCHAR2
7225: ) IS
7226: l_api_name VARCHAR2(30);
7227: l_parent_vs_row ego_value_sets_v%ROWTYPE;
7228: l_maximum_size ego_value_sets_v.maximum_size%TYPE;
7229: l_format_code ego_value_sets_v.format_code%TYPE;
7230: l_minimum_value ego_value_sets_v.minimum_value%TYPE;
7231: l_maximum_value ego_value_sets_v.maximum_value%TYPE;
7232: l_long_list_flag ego_value_sets_v.longlist_flag%TYPE;

Line 7229: l_format_code ego_value_sets_v.format_code%TYPE;

7225: ) IS
7226: l_api_name VARCHAR2(30);
7227: l_parent_vs_row ego_value_sets_v%ROWTYPE;
7228: l_maximum_size ego_value_sets_v.maximum_size%TYPE;
7229: l_format_code ego_value_sets_v.format_code%TYPE;
7230: l_minimum_value ego_value_sets_v.minimum_value%TYPE;
7231: l_maximum_value ego_value_sets_v.maximum_value%TYPE;
7232: l_long_list_flag ego_value_sets_v.longlist_flag%TYPE;
7233: l_owner NUMBER;

Line 7230: l_minimum_value ego_value_sets_v.minimum_value%TYPE;

7226: l_api_name VARCHAR2(30);
7227: l_parent_vs_row ego_value_sets_v%ROWTYPE;
7228: l_maximum_size ego_value_sets_v.maximum_size%TYPE;
7229: l_format_code ego_value_sets_v.format_code%TYPE;
7230: l_minimum_value ego_value_sets_v.minimum_value%TYPE;
7231: l_maximum_value ego_value_sets_v.maximum_value%TYPE;
7232: l_long_list_flag ego_value_sets_v.longlist_flag%TYPE;
7233: l_owner NUMBER;
7234: l_return_status_inf VARCHAR2(1);

Line 7231: l_maximum_value ego_value_sets_v.maximum_value%TYPE;

7227: l_parent_vs_row ego_value_sets_v%ROWTYPE;
7228: l_maximum_size ego_value_sets_v.maximum_size%TYPE;
7229: l_format_code ego_value_sets_v.format_code%TYPE;
7230: l_minimum_value ego_value_sets_v.minimum_value%TYPE;
7231: l_maximum_value ego_value_sets_v.maximum_value%TYPE;
7232: l_long_list_flag ego_value_sets_v.longlist_flag%TYPE;
7233: l_owner NUMBER;
7234: l_return_status_inf VARCHAR2(1);
7235: l_inf_where_clause VARCHAR2(1000);

Line 7232: l_long_list_flag ego_value_sets_v.longlist_flag%TYPE;

7228: l_maximum_size ego_value_sets_v.maximum_size%TYPE;
7229: l_format_code ego_value_sets_v.format_code%TYPE;
7230: l_minimum_value ego_value_sets_v.minimum_value%TYPE;
7231: l_maximum_value ego_value_sets_v.maximum_value%TYPE;
7232: l_long_list_flag ego_value_sets_v.longlist_flag%TYPE;
7233: l_owner NUMBER;
7234: l_return_status_inf VARCHAR2(1);
7235: l_inf_where_clause VARCHAR2(1000);
7236: l_id_column_name fnd_flex_validation_tables.id_column_name%TYPE;

Line 7263: FROM ego_value_sets_v

7259: -- Get the Parent Value Set
7260: --
7261: SELECT *
7262: INTO l_parent_vs_row
7263: FROM ego_value_sets_v
7264: WHERE value_set_id = p_parent_vs_id;
7265:
7266: -- Inherit all necessary properties from the parent value set initially.
7267: -- Later we'll override them with what has been passed to this procedure, if

Line 7571: l_value_set_rec EGO_VALUE_SETS_V%ROWTYPE;

7567: l_format_code FND_FLEX_VALUE_SETS.FORMAT_TYPE%TYPE;
7568: l_maximum_value FND_FLEX_VALUE_SETS.MAXIMUM_VALUE%TYPE;
7569: l_minimum_value FND_FLEX_VALUE_SETS.MINIMUM_VALUE%TYPE;
7570:
7571: l_value_set_rec EGO_VALUE_SETS_V%ROWTYPE;
7572: --changes FOR P4T
7573: isVersionedVS NUMBER ;
7574:
7575: BEGIN

Line 7662: -- where the ego_value_sets_v.value_set_id is in the list of child value

7658: --
7659: -- REASON FOR SUB-OPTIMAL SYNTAX
7660: --
7661: -- Unfortunately, we cannot use a single update statement on all rows
7662: -- where the ego_value_sets_v.value_set_id is in the list of child value
7663: -- ids. While we can obtain a collection of child value IDs:
7664: --
7665: -- EXECUTE IMMEDIATE
7666: -- 'SELECT value_set_id FROM ego_value_sets_v ' ||

Line 7666: -- 'SELECT value_set_id FROM ego_value_sets_v ' ||

7662: -- where the ego_value_sets_v.value_set_id is in the list of child value
7663: -- ids. While we can obtain a collection of child value IDs:
7664: --
7665: -- EXECUTE IMMEDIATE
7666: -- 'SELECT value_set_id FROM ego_value_sets_v ' ||
7667: -- 'WHERE parent_value_set_id = p_value_set_id'
7668: -- BULK COLLECT INTO child_value_set_ids;
7669: --
7670: -- we cannot use it in a SQL Update statement like this:

Line 7686: FROM ego_value_sets_v

7682:
7683: <>
7684: FOR l_value_set_rec IN
7685: (SELECT *
7686: FROM ego_value_sets_v
7687: WHERE parent_value_set_id = p_value_set_id)
7688: LOOP
7689:
7690: -- Update the long list display type

Line 7772: l_parent_vs_row ego_value_sets_v%ROWTYPE;

7768: ,x_msg_data OUT NOCOPY VARCHAR2
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 ;

Line 7798: FROM ego_value_sets_v vs, ego_value_sets_v pvs

7794: ----------------------------------------------------------------------------
7795:
7796: SELECT pvs.*
7797: INTO l_parent_vs_row
7798: FROM ego_value_sets_v vs, ego_value_sets_v pvs
7799: WHERE vs.parent_value_set_id = pvs.value_set_id
7800: AND vs.value_set_id = p_value_set_id;
7801:
7802: l_validation_code := l_parent_vs_row.validation_code_admin;