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.

[Home] [Help]

APPS.EGO_USER_ATTRS_DATA_PVT dependencies on EGO_ATTR_METADATA_OBJ

Line 749: l_curr_attr_metadata_obj EGO_ATTR_METADATA_OBJ;

745: l_data_level_string VARCHAR2(1000);
746: l_ag_predicate_list VARCHAR2(20000);
747: l_db_column_query_table LOCAL_BIG_VARCHAR_TABLE;
748: l_curr_ag_request_obj EGO_ATTR_GROUP_REQUEST_OBJ;
749: l_curr_attr_metadata_obj EGO_ATTR_METADATA_OBJ;
750: l_curr_augmented_attr_rec LOCAL_USER_ATTR_DATA_REC;
751: l_curr_aug_table_index NUMBER;
752: l_augmented_data_table LOCAL_AUGMENTED_DATA_TABLE;
753: l_table_of_high_ind_for_AG_ID LOCAL_NUMBER_TABLE;

Line 1998: l_attr_metadata_obj EGO_ATTR_METADATA_OBJ;

1994:
1995: l_metadata_driven BOOLEAN;
1996: l_for_loop_index NUMBER;
1997: l_for_loop_last NUMBER;
1998: l_attr_metadata_obj EGO_ATTR_METADATA_OBJ;
1999: l_attr_data_obj EGO_USER_ATTR_DATA_OBJ;
2000: l_unique_key_flag VARCHAR2(1);
2001: l_data_type VARCHAR2(1);
2002: l_column_name VARCHAR2(30);

Line 2476: l_attr_metadata_obj EGO_ATTR_METADATA_OBJ;

2472:
2473: l_sorted_attr_data_table LOCAL_USER_ATTR_DATA_TABLE;
2474: l_sorted_data_table_index NUMBER;
2475: l_attr_data_index NUMBER;
2476: l_attr_metadata_obj EGO_ATTR_METADATA_OBJ;
2477:
2478: BEGIN
2479:
2480: Debug_Msg('In Sort_Attr_Values_Table, starting', 2);

Line 2531: p_attr_metadata_obj IN EGO_ATTR_METADATA_OBJ

2527: -- If TRUE, we build and return the query itself. In this case, we don't pass
2528: -- p_final_bind_value or p_attr_name_value_pairs, and when replacing Attr Group
2529: -- tokens we construct a nested query to get the value required by the token.
2530: FUNCTION Tokenized_Val_Set_Query (
2531: p_attr_metadata_obj IN EGO_ATTR_METADATA_OBJ
2532: ,p_attr_group_metadata_obj IN EGO_ATTR_GROUP_METADATA_OBJ
2533: ,p_ext_table_metadata_obj IN EGO_EXT_TABLE_METADATA_OBJ
2534: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
2535: ,p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY

Line 2558: l_replacement_attr_metadata EGO_ATTR_METADATA_OBJ;

2554: l_source_of_replacement VARCHAR2(30);
2555: l_token_replacement VARCHAR2(4000); -- Bug 8757354
2556: l_token_data_type VARCHAR2(1);
2557: l_pk_array_index NUMBER;
2558: l_replacement_attr_metadata EGO_ATTR_METADATA_OBJ;
2559: l_replacement_attr_data EGO_USER_ATTR_DATA_OBJ;
2560: l_retrieved_value VARCHAR2(4000); --bug 12979914
2561: l_error_message_name VARCHAR2(30);
2562: l_token_table ERROR_HANDLER.Token_Tbl_Type;

Line 2917: p_attr_metadata_obj IN EGO_ATTR_METADATA_OBJ

2913:
2914: ----------------------------------------------------------------------
2915:
2916: FUNCTION Get_Int_Val_For_Disp_Val (
2917: p_attr_metadata_obj IN EGO_ATTR_METADATA_OBJ
2918: ,p_attr_value_obj IN EGO_USER_ATTR_DATA_OBJ
2919: ,p_attr_group_metadata_obj IN EGO_ATTR_GROUP_METADATA_OBJ
2920: ,p_ext_table_metadata_obj IN EGO_EXT_TABLE_METADATA_OBJ
2921: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY

Line 3027: ,p_attr_metadata_obj IN EGO_ATTR_METADATA_OBJ

3023:
3024: FUNCTION Get_Disp_Val_For_Int_Val (
3025: p_attr_int_value IN VARCHAR2 DEFAULT NULL
3026: ,p_attr_value_obj IN EGO_USER_ATTR_DATA_OBJ DEFAULT NULL
3027: ,p_attr_metadata_obj IN EGO_ATTR_METADATA_OBJ
3028: ,p_attr_group_metadata_obj IN EGO_ATTR_GROUP_METADATA_OBJ
3029: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
3030: ,p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
3031: ,p_entity_id IN VARCHAR2 DEFAULT NULL

Line 3350: l_attr_metadata_obj EGO_ATTR_METADATA_OBJ;

3346: l_uk_attr_names_table LOCAL_MEDIUM_VARCHAR_TABLE;
3347: l_uk_attr_names_table_index NUMBER := 1;
3348: l_uk_attrs_count NUMBER;
3349: l_table_index NUMBER;
3350: l_attr_metadata_obj EGO_ATTR_METADATA_OBJ;
3351:
3352: BEGIN
3353:
3354: ----------------------------------------------------------------

Line 3410: l_attr_metadata_obj EGO_ATTR_METADATA_OBJ;

3406: l_disp_value LOCAL_BIG_VARCHAR_TABLE;
3407: l_attr_value_date VARCHAR2(50);
3408: l_validation_type VARCHAR2(10):= 'NULL';
3409: l_vs_where_clause VARCHAR2(1000);
3410: l_attr_metadata_obj EGO_ATTR_METADATA_OBJ;
3411: l_display_value VARCHAR2(4000);
3412: BEGIN
3413: SELECT validation_type INTO l_validation_type
3414: FROM FND_FLEX_VALUE_SETS WHERE

Line 3555: l_attr_metadata_obj EGO_ATTR_METADATA_OBJ;

3551: l_uk_attr_values_table LOCAL_BIG_VARCHAR_TABLE;
3552: l_uk_attr_values_table_index NUMBER := 1;
3553: l_uk_attrs_count NUMBER;
3554: l_table_index NUMBER;
3555: l_attr_metadata_obj EGO_ATTR_METADATA_OBJ;
3556:
3557: BEGIN
3558:
3559: ----------------------------------------------------------------

Line 4404: l_attr_metadata_obj EGO_ATTR_METADATA_OBJ;

4400: IS
4401:
4402: l_token_table ERROR_HANDLER.Token_Tbl_Type;
4403: l_attr_count NUMBER;
4404: l_attr_metadata_obj EGO_ATTR_METADATA_OBJ;
4405: l_all_exist BOOLEAN := TRUE;
4406:
4407: BEGIN
4408:

Line 4951: p_attr_metadata_obj IN EGO_ATTR_METADATA_OBJ

4947:
4948: ----------------------------------------------------------------------
4949:
4950: FUNCTION Disp_Val_Replacement_Is_Bad (
4951: p_attr_metadata_obj IN EGO_ATTR_METADATA_OBJ
4952: ,px_attr_value_obj IN OUT NOCOPY EGO_USER_ATTR_DATA_OBJ
4953: )
4954: RETURN BOOLEAN
4955: IS

Line 5045: p_attr_metadata_obj IN EGO_ATTR_METADATA_OBJ

5041:
5042: ----------------------------------------------------------------------
5043:
5044: FUNCTION Is_Required_Flag_Respected (
5045: p_attr_metadata_obj IN EGO_ATTR_METADATA_OBJ
5046: ,p_mode IN VARCHAR2
5047: ,p_attr_value_obj IN EGO_USER_ATTR_DATA_OBJ
5048: ,p_attr_group_disp_name IN VARCHAR2
5049: ,x_err_msg_name OUT NOCOPY VARCHAR2

Line 5118: p_attr_metadata_obj IN EGO_ATTR_METADATA_OBJ

5114:
5115: ----------------------------------------------------------------------
5116:
5117: FUNCTION Is_Data_Type_Correct (
5118: p_attr_metadata_obj IN EGO_ATTR_METADATA_OBJ
5119: ,p_attr_value_obj IN EGO_USER_ATTR_DATA_OBJ
5120: ,p_attr_group_disp_name IN VARCHAR2
5121: ,x_err_msg_name OUT NOCOPY VARCHAR2
5122: ,x_token_table OUT NOCOPY ERROR_HANDLER.Token_Tbl_Type

Line 5216: p_attr_metadata_obj IN EGO_ATTR_METADATA_OBJ

5212:
5213: ----------------------------------------------------------------------
5214:
5215: FUNCTION Is_Min_Or_Max_Value_Respected (
5216: p_attr_metadata_obj IN EGO_ATTR_METADATA_OBJ
5217: ,p_attr_value_obj IN EGO_USER_ATTR_DATA_OBJ
5218: ,p_min_or_max IN VARCHAR2
5219: )
5220: RETURN BOOLEAN

Line 5334: p_attr_metadata_obj IN EGO_ATTR_METADATA_OBJ

5330:
5331: ----------------------------------------------------------------------
5332:
5333: FUNCTION Is_Max_Size_Respected (
5334: p_attr_metadata_obj IN EGO_ATTR_METADATA_OBJ
5335: ,p_attr_value_obj IN EGO_USER_ATTR_DATA_OBJ
5336: ,p_attr_group_disp_name IN VARCHAR2
5337: ,x_err_msg_name OUT NOCOPY VARCHAR2
5338: ,x_token_table OUT NOCOPY ERROR_HANDLER.Token_Tbl_Type

Line 5403: p_attr_metadata_obj IN EGO_ATTR_METADATA_OBJ

5399:
5400: ----------------------------------------------------------------------
5401:
5402: FUNCTION Is_UOM_Valid (
5403: p_attr_metadata_obj IN EGO_ATTR_METADATA_OBJ
5404: ,px_attr_value_obj IN OUT NOCOPY EGO_USER_ATTR_DATA_OBJ
5405: )
5406: RETURN BOOLEAN
5407: IS

Line 5460: p_attr_metadata_obj IN EGO_ATTR_METADATA_OBJ

5456:
5457: ----------------------------------------------------------------------
5458:
5459: FUNCTION Is_Value_Set_Respected (
5460: p_attr_metadata_obj IN EGO_ATTR_METADATA_OBJ
5461: ,p_attr_group_metadata_obj IN EGO_ATTR_GROUP_METADATA_OBJ
5462: ,p_ext_table_metadata_obj IN EGO_EXT_TABLE_METADATA_OBJ
5463: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
5464: ,p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY

Line 5723: l_attr_metadata_obj EGO_ATTR_METADATA_OBJ;

5719: IS
5720:
5721: l_has_all_required_attrs BOOLEAN := TRUE;
5722: l_metadata_table_index NUMBER;
5723: l_attr_metadata_obj EGO_ATTR_METADATA_OBJ;
5724: l_passed_attrs_table_index NUMBER;
5725: l_already_processed BOOLEAN;
5726: l_token_table ERROR_HANDLER.Token_Tbl_Type;
5727:

Line 5854: l_candidate_attr EGO_ATTR_METADATA_OBJ;

5850:
5851: l_attr_name_list VARCHAR2(3000) := p_attr_name_list;
5852: l_attr_name_table LOCAL_VARCHAR_TABLE;
5853: l_next_attr_name VARCHAR2(30);
5854: l_candidate_attr EGO_ATTR_METADATA_OBJ;
5855: l_token_table ERROR_HANDLER.Token_Tbl_Type;
5856: l_metadata_table_index NUMBER;
5857: l_found_bad_names BOOLEAN := FALSE;
5858:

Line 5957: l_attr_metadata_obj EGO_ATTR_METADATA_OBJ;

5953: ) IS
5954:
5955: l_token_table ERROR_HANDLER.Token_Tbl_Type;
5956: l_attr_value_index NUMBER;
5957: l_attr_metadata_obj EGO_ATTR_METADATA_OBJ;
5958: l_int_value VARCHAR2(4000); -- Bug 8757354
5959: l_err_msg_name VARCHAR2(30);
5960:
5961: BEGIN

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

6167: l_attr_name_val EGO_ATTR_TABLE;
6168: l_dml_type VARCHAR2(10);
6169: l_dummy NUMBER;
6170: --End 4105841
6171: l_curr_attr_metadata_obj EGO_ATTR_METADATA_OBJ; -- abedajna, Bug 6134504
6172: BEGIN
6173:
6174:
6175: ----------------------------------------------------------------------

Line 9198: l_attr_metadata_obj EGO_ATTR_METADATA_OBJ;

9194: l_token_table ERROR_HANDLER.Token_Tbl_Type;
9195: l_is_duplicate_attr BOOLEAN;
9196: l_duplicate_attr_index NUMBER;
9197: l_attr_value_index NUMBER;
9198: l_attr_metadata_obj EGO_ATTR_METADATA_OBJ;
9199: l_attr_name_table LOCAL_VARCHAR_TABLE;
9200: l_hierarchy_results LOCAL_HIERARCHY_REC;
9201:
9202: BEGIN

Line 11235: l_curr_attr_metadata_obj EGO_ATTR_METADATA_OBJ;

11231: l_can_view_this_attr_group BOOLEAN;
11232: l_augmented_data_table LOCAL_AUGMENTED_DATA_TABLE;
11233: l_requested_attr_names_table LOCAL_VARCHAR_TABLE;
11234: l_attr_list_index NUMBER;
11235: l_curr_attr_metadata_obj EGO_ATTR_METADATA_OBJ;
11236: l_new_attr_metadata_obj EGO_ATTR_METADATA_OBJ;
11237: l_curr_augmented_attr_rec LOCAL_USER_ATTR_DATA_REC;
11238: l_curr_aug_table_index NUMBER;
11239: l_table_of_low_ind_for_AG_ID LOCAL_NUMBER_TABLE;

Line 11236: l_new_attr_metadata_obj EGO_ATTR_METADATA_OBJ;

11232: l_augmented_data_table LOCAL_AUGMENTED_DATA_TABLE;
11233: l_requested_attr_names_table LOCAL_VARCHAR_TABLE;
11234: l_attr_list_index NUMBER;
11235: l_curr_attr_metadata_obj EGO_ATTR_METADATA_OBJ;
11236: l_new_attr_metadata_obj EGO_ATTR_METADATA_OBJ;
11237: l_curr_augmented_attr_rec LOCAL_USER_ATTR_DATA_REC;
11238: l_curr_aug_table_index NUMBER;
11239: l_table_of_low_ind_for_AG_ID LOCAL_NUMBER_TABLE;
11240: l_table_of_high_ind_for_AG_ID LOCAL_NUMBER_TABLE;

Line 13635: l_attr_metadata_obj EGO_ATTR_METADATA_OBJ;

13631: l_at_start_of_ag BOOLEAN;
13632: l_at_start_of_row BOOLEAN;
13633: l_row_index NUMBER := 0;
13634: l_attr_group_metadata_obj EGO_ATTR_GROUP_METADATA_OBJ;
13635: l_attr_metadata_obj EGO_ATTR_METADATA_OBJ;
13636: l_token_table ERROR_HANDLER.Token_Tbl_Type;
13637: l_attr_name_value_pairs EGO_USER_ATTR_DATA_TABLE;
13638: l_extension_id NUMBER;
13639: l_mode VARCHAR2(10);

Line 15065: l_attr_metadata_obj EGO_ATTR_METADATA_OBJ;

15061: l_current_acd_type VARCHAR2(30);
15062: l_attr_group_metadata_obj EGO_ATTR_GROUP_METADATA_OBJ;
15063: l_current_pending_ext_id NUMBER;
15064: l_current_column_name VARCHAR2(30);
15065: l_attr_metadata_obj EGO_ATTR_METADATA_OBJ;
15066: l_dummy_err_msg_name VARCHAR2(30);
15067: l_token_table ERROR_HANDLER.Token_Tbl_Type;
15068: l_attr_name_value_pairs EGO_USER_ATTR_DATA_TABLE := EGO_USER_ATTR_DATA_TABLE();
15069: l_uom_column_nv_pairs LOCAL_COL_NV_PAIR_TABLE;

Line 16016: ,p_attr_metadata_obj IN EGO_ATTR_METADATA_OBJ

16012: --------------------------------------------------------------------
16013:
16014: PROCEDURE Get_Ext_Data (
16015: p_attr_group_metadata_obj IN EGO_ATTR_GROUP_METADATA_OBJ
16016: ,p_attr_metadata_obj IN EGO_ATTR_METADATA_OBJ
16017: ,p_pk_col1 IN VARCHAR2
16018: ,p_pk_col2 IN VARCHAR2 DEFAULT NULL
16019: ,p_pk_col3 IN VARCHAR2 DEFAULT NULL
16020: ,p_pk_col4 IN VARCHAR2 DEFAULT NULL

Line 16317: l_attr_metadata_obj EGO_ATTR_METADATA_OBJ;

16313:
16314: l_api_name VARCHAR2(30) := 'Get_User_Attr_Val():';
16315: l_attr_group_metadata_obj EGO_ATTR_GROUP_METADATA_OBJ;
16316: -- declared in EGOSEFD2.sql
16317: l_attr_metadata_obj EGO_ATTR_METADATA_OBJ;
16318: l_pk_column_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
16319: l_attr_int_value VARCHAR2(4000); -- Bug 8757354
16320: l_attr_disp_value VARCHAR2(4000); -- Bug 8757354
16321:

Line 16325: l_temp_attr_metadata EGO_ATTR_METADATA_OBJ;

16321:
16322: l_attr_metadata_table EGO_ATTR_METADATA_TABLE;
16323: l_attr_name_value_pairs EGO_USER_ATTR_DATA_TABLE;
16324: l_attr_counter NUMBER;
16325: l_temp_attr_metadata EGO_ATTR_METADATA_OBJ;
16326: l_temp_str VARCHAR2(150);
16327: l_temp_num NUMBER;
16328: l_temp_date DATE;
16329: --bug 5094087

Line 16932: l_attr_metadata_obj EGO_ATTR_METADATA_OBJ;

16928: )
16929: IS
16930: l_attr_name_value_pairs EGO_USER_ATTR_DATA_TABLE;
16931: l_attr_name_value_rec EGO_USER_ATTR_DATA_OBJ;
16932: l_attr_metadata_obj EGO_ATTR_METADATA_OBJ;
16933: l_ext_table_metadata_obj EGO_EXT_TABLE_METADATA_OBJ;
16934: l_attr_group_metadata_obj EGO_ATTR_GROUP_METADATA_OBJ;
16935: l_object_id NUMBER;
16936: l_attr_diffs EGO_USER_ATTR_DIFF_TABLE;

Line 17065: l_attr_metadata_obj EGO_ATTR_METADATA_OBJ;

17061: )
17062: RETURN VARCHAR2
17063: IS
17064: l_attr_value_obj EGO_USER_ATTR_DATA_OBJ;
17065: l_attr_metadata_obj EGO_ATTR_METADATA_OBJ;
17066: l_attr_metadata_obj_table EGO_ATTR_METADATA_TABLE;
17067: l_attr_group_metadata_obj EGO_ATTR_GROUP_METADATA_OBJ;
17068: l_pk_column_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
17069: l_data_level_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;

Line 17181: l_attr_metadata_obj EGO_ATTR_METADATA_OBJ;

17177: )
17178: RETURN VARCHAR2
17179: IS
17180: l_attr_value_obj EGO_USER_ATTR_DATA_OBJ;
17181: l_attr_metadata_obj EGO_ATTR_METADATA_OBJ;
17182: l_attr_metadata_obj_table EGO_ATTR_METADATA_TABLE;
17183: l_attr_group_metadata_obj EGO_ATTR_GROUP_METADATA_OBJ;
17184: l_pk_column_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
17185: l_data_level_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;