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_USER_ATTRS_DATA_PVT dependencies on EGO_ATTR_METADATA_OBJ

Line 649: l_curr_attr_metadata_obj EGO_ATTR_METADATA_OBJ;

645: l_data_level_string VARCHAR2(1000);
646: l_ag_predicate_list VARCHAR2(20000);
647: l_db_column_query_table LOCAL_BIG_VARCHAR_TABLE;
648: l_curr_ag_request_obj EGO_ATTR_GROUP_REQUEST_OBJ;
649: l_curr_attr_metadata_obj EGO_ATTR_METADATA_OBJ;
650: l_curr_augmented_attr_rec LOCAL_USER_ATTR_DATA_REC;
651: l_curr_aug_table_index NUMBER;
652: l_augmented_data_table LOCAL_AUGMENTED_DATA_TABLE;
653: l_table_of_high_ind_for_AG_ID LOCAL_NUMBER_TABLE;

Line 1851: l_attr_metadata_obj EGO_ATTR_METADATA_OBJ;

1847:
1848: l_metadata_driven BOOLEAN;
1849: l_for_loop_index NUMBER;
1850: l_for_loop_last NUMBER;
1851: l_attr_metadata_obj EGO_ATTR_METADATA_OBJ;
1852: l_attr_data_obj EGO_USER_ATTR_DATA_OBJ;
1853: l_unique_key_flag VARCHAR2(1);
1854: l_data_type VARCHAR2(1);
1855: l_column_name VARCHAR2(30);

Line 2255: l_attr_metadata_obj EGO_ATTR_METADATA_OBJ;

2251:
2252: l_sorted_attr_data_table LOCAL_USER_ATTR_DATA_TABLE;
2253: l_sorted_data_table_index NUMBER;
2254: l_attr_data_index NUMBER;
2255: l_attr_metadata_obj EGO_ATTR_METADATA_OBJ;
2256:
2257: BEGIN
2258:
2259: Debug_Msg('In Sort_Attr_Values_Table, starting', 2);

Line 2310: p_attr_metadata_obj IN EGO_ATTR_METADATA_OBJ

2306: -- If TRUE, we build and return the query itself. In this case, we don't pass
2307: -- p_final_bind_value or p_attr_name_value_pairs, and when replacing Attr Group
2308: -- tokens we construct a nested query to get the value required by the token.
2309: FUNCTION Tokenized_Val_Set_Query (
2310: p_attr_metadata_obj IN EGO_ATTR_METADATA_OBJ
2311: ,p_attr_group_metadata_obj IN EGO_ATTR_GROUP_METADATA_OBJ
2312: ,p_ext_table_metadata_obj IN EGO_EXT_TABLE_METADATA_OBJ
2313: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
2314: ,p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY

Line 2337: l_replacement_attr_metadata EGO_ATTR_METADATA_OBJ;

2333: l_source_of_replacement VARCHAR2(30);
2334: l_token_replacement VARCHAR2(1000);
2335: l_token_data_type VARCHAR2(1);
2336: l_pk_array_index NUMBER;
2337: l_replacement_attr_metadata EGO_ATTR_METADATA_OBJ;
2338: l_replacement_attr_data EGO_USER_ATTR_DATA_OBJ;
2339: l_retrieved_value VARCHAR2(1000);
2340: l_error_message_name VARCHAR2(30);
2341: l_token_table ERROR_HANDLER.Token_Tbl_Type;

Line 2689: p_attr_metadata_obj IN EGO_ATTR_METADATA_OBJ

2685:
2686: ----------------------------------------------------------------------
2687:
2688: FUNCTION Get_Int_Val_For_Disp_Val (
2689: p_attr_metadata_obj IN EGO_ATTR_METADATA_OBJ
2690: ,p_attr_value_obj IN EGO_USER_ATTR_DATA_OBJ
2691: ,p_attr_group_metadata_obj IN EGO_ATTR_GROUP_METADATA_OBJ
2692: ,p_ext_table_metadata_obj IN EGO_EXT_TABLE_METADATA_OBJ
2693: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY

Line 2799: ,p_attr_metadata_obj IN EGO_ATTR_METADATA_OBJ

2795:
2796: FUNCTION Get_Disp_Val_For_Int_Val (
2797: p_attr_int_value IN VARCHAR2 DEFAULT NULL
2798: ,p_attr_value_obj IN EGO_USER_ATTR_DATA_OBJ DEFAULT NULL
2799: ,p_attr_metadata_obj IN EGO_ATTR_METADATA_OBJ
2800: ,p_attr_group_metadata_obj IN EGO_ATTR_GROUP_METADATA_OBJ
2801: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
2802: ,p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
2803: ,p_entity_id IN VARCHAR2 DEFAULT NULL

Line 3108: l_attr_metadata_obj EGO_ATTR_METADATA_OBJ;

3104: l_uk_attr_names_table LOCAL_MEDIUM_VARCHAR_TABLE;
3105: l_uk_attr_names_table_index NUMBER := 1;
3106: l_uk_attrs_count NUMBER;
3107: l_table_index NUMBER;
3108: l_attr_metadata_obj EGO_ATTR_METADATA_OBJ;
3109:
3110: BEGIN
3111:
3112: ----------------------------------------------------------------

Line 3153: l_attr_metadata_obj EGO_ATTR_METADATA_OBJ;

3149: l_uk_attr_values_table LOCAL_BIG_VARCHAR_TABLE;
3150: l_uk_attr_values_table_index NUMBER := 1;
3151: l_uk_attrs_count NUMBER;
3152: l_table_index NUMBER;
3153: l_attr_metadata_obj EGO_ATTR_METADATA_OBJ;
3154:
3155: BEGIN
3156:
3157: ----------------------------------------------------------------

Line 3953: l_attr_metadata_obj EGO_ATTR_METADATA_OBJ;

3949: IS
3950:
3951: l_token_table ERROR_HANDLER.Token_Tbl_Type;
3952: l_attr_count NUMBER;
3953: l_attr_metadata_obj EGO_ATTR_METADATA_OBJ;
3954: l_all_exist BOOLEAN := TRUE;
3955:
3956: BEGIN
3957:

Line 4485: p_attr_metadata_obj IN EGO_ATTR_METADATA_OBJ

4481:
4482: ----------------------------------------------------------------------
4483:
4484: FUNCTION Disp_Val_Replacement_Is_Bad (
4485: p_attr_metadata_obj IN EGO_ATTR_METADATA_OBJ
4486: ,px_attr_value_obj IN OUT NOCOPY EGO_USER_ATTR_DATA_OBJ
4487: )
4488: RETURN BOOLEAN
4489: IS

Line 4559: p_attr_metadata_obj IN EGO_ATTR_METADATA_OBJ

4555:
4556: ----------------------------------------------------------------------
4557:
4558: FUNCTION Is_Required_Flag_Respected (
4559: p_attr_metadata_obj IN EGO_ATTR_METADATA_OBJ
4560: ,p_mode IN VARCHAR2
4561: ,p_attr_value_obj IN EGO_USER_ATTR_DATA_OBJ
4562: ,p_attr_group_disp_name IN VARCHAR2
4563: ,x_err_msg_name OUT NOCOPY VARCHAR2

Line 4632: p_attr_metadata_obj IN EGO_ATTR_METADATA_OBJ

4628:
4629: ----------------------------------------------------------------------
4630:
4631: FUNCTION Is_Data_Type_Correct (
4632: p_attr_metadata_obj IN EGO_ATTR_METADATA_OBJ
4633: ,p_attr_value_obj IN EGO_USER_ATTR_DATA_OBJ
4634: ,p_attr_group_disp_name IN VARCHAR2
4635: ,x_err_msg_name OUT NOCOPY VARCHAR2
4636: ,x_token_table OUT NOCOPY ERROR_HANDLER.Token_Tbl_Type

Line 4730: p_attr_metadata_obj IN EGO_ATTR_METADATA_OBJ

4726:
4727: ----------------------------------------------------------------------
4728:
4729: FUNCTION Is_Min_Or_Max_Value_Respected (
4730: p_attr_metadata_obj IN EGO_ATTR_METADATA_OBJ
4731: ,p_attr_value_obj IN EGO_USER_ATTR_DATA_OBJ
4732: ,p_min_or_max IN VARCHAR2
4733: )
4734: RETURN BOOLEAN

Line 4848: p_attr_metadata_obj IN EGO_ATTR_METADATA_OBJ

4844:
4845: ----------------------------------------------------------------------
4846:
4847: FUNCTION Is_Max_Size_Respected (
4848: p_attr_metadata_obj IN EGO_ATTR_METADATA_OBJ
4849: ,p_attr_value_obj IN EGO_USER_ATTR_DATA_OBJ
4850: ,p_attr_group_disp_name IN VARCHAR2
4851: ,x_err_msg_name OUT NOCOPY VARCHAR2
4852: ,x_token_table OUT NOCOPY ERROR_HANDLER.Token_Tbl_Type

Line 4917: p_attr_metadata_obj IN EGO_ATTR_METADATA_OBJ

4913:
4914: ----------------------------------------------------------------------
4915:
4916: FUNCTION Is_UOM_Valid (
4917: p_attr_metadata_obj IN EGO_ATTR_METADATA_OBJ
4918: ,px_attr_value_obj IN OUT NOCOPY EGO_USER_ATTR_DATA_OBJ
4919: )
4920: RETURN BOOLEAN
4921: IS

Line 4965: p_attr_metadata_obj IN EGO_ATTR_METADATA_OBJ

4961:
4962: ----------------------------------------------------------------------
4963:
4964: FUNCTION Is_Value_Set_Respected (
4965: p_attr_metadata_obj IN EGO_ATTR_METADATA_OBJ
4966: ,p_attr_group_metadata_obj IN EGO_ATTR_GROUP_METADATA_OBJ
4967: ,p_ext_table_metadata_obj IN EGO_EXT_TABLE_METADATA_OBJ
4968: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
4969: ,p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY

Line 5228: l_attr_metadata_obj EGO_ATTR_METADATA_OBJ;

5224: IS
5225:
5226: l_has_all_required_attrs BOOLEAN := TRUE;
5227: l_metadata_table_index NUMBER;
5228: l_attr_metadata_obj EGO_ATTR_METADATA_OBJ;
5229: l_passed_attrs_table_index NUMBER;
5230: l_already_processed BOOLEAN;
5231: l_token_table ERROR_HANDLER.Token_Tbl_Type;
5232:

Line 5359: l_candidate_attr EGO_ATTR_METADATA_OBJ;

5355:
5356: l_attr_name_list VARCHAR2(3000) := p_attr_name_list;
5357: l_attr_name_table LOCAL_VARCHAR_TABLE;
5358: l_next_attr_name VARCHAR2(30);
5359: l_candidate_attr EGO_ATTR_METADATA_OBJ;
5360: l_token_table ERROR_HANDLER.Token_Tbl_Type;
5361: l_metadata_table_index NUMBER;
5362: l_found_bad_names BOOLEAN := FALSE;
5363:

Line 5462: l_attr_metadata_obj EGO_ATTR_METADATA_OBJ;

5458: ) IS
5459:
5460: l_token_table ERROR_HANDLER.Token_Tbl_Type;
5461: l_attr_value_index NUMBER;
5462: l_attr_metadata_obj EGO_ATTR_METADATA_OBJ;
5463: l_int_value VARCHAR2(1000);
5464: l_err_msg_name VARCHAR2(30);
5465:
5466: BEGIN

Line 5676: l_curr_attr_metadata_obj EGO_ATTR_METADATA_OBJ; -- abedajna, Bug 6134504

5672: l_attr_name_val EGO_ATTR_TABLE;
5673: l_dml_type VARCHAR2(10);
5674: l_dummy NUMBER;
5675: --End 4105841
5676: l_curr_attr_metadata_obj EGO_ATTR_METADATA_OBJ; -- abedajna, Bug 6134504
5677: BEGIN
5678:
5679:
5680: ----------------------------------------------------------------------

Line 8619: l_attr_metadata_obj EGO_ATTR_METADATA_OBJ;

8615: l_token_table ERROR_HANDLER.Token_Tbl_Type;
8616: l_is_duplicate_attr BOOLEAN;
8617: l_duplicate_attr_index NUMBER;
8618: l_attr_value_index NUMBER;
8619: l_attr_metadata_obj EGO_ATTR_METADATA_OBJ;
8620: l_attr_name_table LOCAL_VARCHAR_TABLE;
8621: l_hierarchy_results LOCAL_HIERARCHY_REC;
8622:
8623: BEGIN

Line 10206: l_curr_attr_metadata_obj EGO_ATTR_METADATA_OBJ;

10202: l_can_view_this_attr_group BOOLEAN;
10203: l_augmented_data_table LOCAL_AUGMENTED_DATA_TABLE;
10204: l_requested_attr_names_table LOCAL_VARCHAR_TABLE;
10205: l_attr_list_index NUMBER;
10206: l_curr_attr_metadata_obj EGO_ATTR_METADATA_OBJ;
10207: l_curr_augmented_attr_rec LOCAL_USER_ATTR_DATA_REC;
10208: l_curr_aug_table_index NUMBER;
10209: l_table_of_low_ind_for_AG_ID LOCAL_NUMBER_TABLE;
10210: l_table_of_high_ind_for_AG_ID LOCAL_NUMBER_TABLE;

Line 12609: l_attr_metadata_obj EGO_ATTR_METADATA_OBJ;

12605: l_at_start_of_ag BOOLEAN;
12606: l_at_start_of_row BOOLEAN;
12607: l_row_index NUMBER := 0;
12608: l_attr_group_metadata_obj EGO_ATTR_GROUP_METADATA_OBJ;
12609: l_attr_metadata_obj EGO_ATTR_METADATA_OBJ;
12610: l_token_table ERROR_HANDLER.Token_Tbl_Type;
12611: l_attr_name_value_pairs EGO_USER_ATTR_DATA_TABLE;
12612: l_extension_id NUMBER;
12613: l_mode VARCHAR2(10);

Line 13915: l_attr_metadata_obj EGO_ATTR_METADATA_OBJ;

13911: l_current_acd_type VARCHAR2(30);
13912: l_attr_group_metadata_obj EGO_ATTR_GROUP_METADATA_OBJ;
13913: l_current_pending_ext_id NUMBER;
13914: l_current_column_name VARCHAR2(30);
13915: l_attr_metadata_obj EGO_ATTR_METADATA_OBJ;
13916: l_dummy_err_msg_name VARCHAR2(30);
13917: l_token_table ERROR_HANDLER.Token_Tbl_Type;
13918: l_attr_name_value_pairs EGO_USER_ATTR_DATA_TABLE := EGO_USER_ATTR_DATA_TABLE();
13919: l_uom_column_nv_pairs LOCAL_COL_NV_PAIR_TABLE;

Line 14866: ,p_attr_metadata_obj IN EGO_ATTR_METADATA_OBJ

14862: --------------------------------------------------------------------
14863:
14864: PROCEDURE Get_Ext_Data (
14865: p_attr_group_metadata_obj IN EGO_ATTR_GROUP_METADATA_OBJ
14866: ,p_attr_metadata_obj IN EGO_ATTR_METADATA_OBJ
14867: ,p_pk_col1 IN VARCHAR2
14868: ,p_pk_col2 IN VARCHAR2 DEFAULT NULL
14869: ,p_pk_col3 IN VARCHAR2 DEFAULT NULL
14870: ,p_pk_col4 IN VARCHAR2 DEFAULT NULL

Line 15167: l_attr_metadata_obj EGO_ATTR_METADATA_OBJ;

15163:
15164: l_api_name VARCHAR2(30) := 'Get_User_Attr_Val():';
15165: l_attr_group_metadata_obj EGO_ATTR_GROUP_METADATA_OBJ;
15166: -- declared in EGOSEFD2.sql
15167: l_attr_metadata_obj EGO_ATTR_METADATA_OBJ;
15168: l_pk_column_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
15169: l_attr_int_value VARCHAR2(1000);
15170: l_attr_disp_value VARCHAR2(1000);
15171:

Line 15175: l_temp_attr_metadata EGO_ATTR_METADATA_OBJ;

15171:
15172: l_attr_metadata_table EGO_ATTR_METADATA_TABLE;
15173: l_attr_name_value_pairs EGO_USER_ATTR_DATA_TABLE;
15174: l_attr_counter NUMBER;
15175: l_temp_attr_metadata EGO_ATTR_METADATA_OBJ;
15176: l_temp_str VARCHAR2(150);
15177: l_temp_num NUMBER;
15178: l_temp_date DATE;
15179: --bug 5094087

Line 15771: l_attr_metadata_obj EGO_ATTR_METADATA_OBJ;

15767: )
15768: IS
15769: l_attr_name_value_pairs EGO_USER_ATTR_DATA_TABLE;
15770: l_attr_name_value_rec EGO_USER_ATTR_DATA_OBJ;
15771: l_attr_metadata_obj EGO_ATTR_METADATA_OBJ;
15772: l_ext_table_metadata_obj EGO_EXT_TABLE_METADATA_OBJ;
15773: l_attr_group_metadata_obj EGO_ATTR_GROUP_METADATA_OBJ;
15774: l_object_id NUMBER;
15775: l_attr_diffs EGO_USER_ATTR_DIFF_TABLE;

Line 15904: l_attr_metadata_obj EGO_ATTR_METADATA_OBJ;

15900: )
15901: RETURN VARCHAR2
15902: IS
15903: l_attr_value_obj EGO_USER_ATTR_DATA_OBJ;
15904: l_attr_metadata_obj EGO_ATTR_METADATA_OBJ;
15905: l_attr_metadata_obj_table EGO_ATTR_METADATA_TABLE;
15906: l_attr_group_metadata_obj EGO_ATTR_GROUP_METADATA_OBJ;
15907: l_pk_column_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
15908: l_data_level_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;

Line 16020: l_attr_metadata_obj EGO_ATTR_METADATA_OBJ;

16016: )
16017: RETURN VARCHAR2
16018: IS
16019: l_attr_value_obj EGO_USER_ATTR_DATA_OBJ;
16020: l_attr_metadata_obj EGO_ATTR_METADATA_OBJ;
16021: l_attr_metadata_obj_table EGO_ATTR_METADATA_TABLE;
16022: l_attr_group_metadata_obj EGO_ATTR_GROUP_METADATA_OBJ;
16023: l_pk_column_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
16024: l_data_level_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;