DBA Data[Home] [Help]

APPS.EGO_USER_ATTRS_DATA_PVT dependencies on EGO_ATTR_GROUP_METADATA_OBJ

Line 628: ,p_attr_group_metadata_obj IN EGO_ATTR_GROUP_METADATA_OBJ

624: PROCEDURE Get_Changed_Attributes (
625: p_dml_operation IN VARCHAR2
626: ,p_object_name IN VARCHAR2
627: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
628: ,p_attr_group_metadata_obj IN EGO_ATTR_GROUP_METADATA_OBJ
629: ,p_ext_table_metadata_obj IN EGO_EXT_TABLE_METADATA_OBJ
630: ,p_data_level IN VARCHAR2 DEFAULT NULL --R12C
631: ,p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
632: ,p_attr_name_value_pairs IN EGO_USER_ATTR_DATA_TABLE

Line 1197: , p_attr_group_metadata_obj IN EGO_ATTR_GROUP_METADATA_OBJ

1193: , p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
1194: , p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
1195: , p_attr_diffs IN EGO_USER_ATTR_DIFF_TABLE
1196: , p_transaction_type IN VARCHAR2
1197: , p_attr_group_metadata_obj IN EGO_ATTR_GROUP_METADATA_OBJ
1198: , x_return_status OUT NOCOPY VARCHAR2
1199: , x_error_message OUT NOCOPY VARCHAR2
1200: )
1201: IS

Line 2151: p_attr_group_metadata_obj IN EGO_ATTR_GROUP_METADATA_OBJ

2147: -- executes that statement; it just adds text and bind variables through calls
2148: -- to FND_DSQL procedures.
2149:
2150: PROCEDURE Build_Where_Clause (
2151: p_attr_group_metadata_obj IN EGO_ATTR_GROUP_METADATA_OBJ
2152: ,p_ext_table_metadata_obj IN EGO_EXT_TABLE_METADATA_OBJ
2153: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
2154: ,p_data_level IN VARCHAR2 DEFAULT NULL --R12C
2155: ,p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY

Line 2248: p_attr_group_metadata_obj IN EGO_ATTR_GROUP_METADATA_OBJ

2244:
2245: ----------------------------------------------------------------------
2246:
2247: PROCEDURE Sort_Attr_Values_Table (
2248: p_attr_group_metadata_obj IN EGO_ATTR_GROUP_METADATA_OBJ
2249: ,px_attr_name_value_pairs IN OUT NOCOPY EGO_USER_ATTR_DATA_TABLE
2250: ) IS
2251:
2252: l_sorted_attr_data_table LOCAL_USER_ATTR_DATA_TABLE;

Line 2311: ,p_attr_group_metadata_obj IN EGO_ATTR_GROUP_METADATA_OBJ

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
2315: ,p_entity_id IN VARCHAR2

Line 2691: ,p_attr_group_metadata_obj IN EGO_ATTR_GROUP_METADATA_OBJ

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
2694: ,p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
2695: ,p_entity_id IN VARCHAR2

Line 2800: ,p_attr_group_metadata_obj IN EGO_ATTR_GROUP_METADATA_OBJ

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
2804: ,p_entity_index IN NUMBER DEFAULT NULL

Line 2930: p_attr_group_metadata_obj IN EGO_ATTR_GROUP_METADATA_OBJ

2926:
2927: ----------------------------------------------------------------------
2928:
2929: FUNCTION Get_Extension_Id_For_Row (
2930: p_attr_group_metadata_obj IN EGO_ATTR_GROUP_METADATA_OBJ
2931: ,p_ext_table_metadata_obj IN EGO_EXT_TABLE_METADATA_OBJ
2932: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
2933: ,p_data_level IN VARCHAR2 DEFAULT NULL --R12C
2934: ,p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY

Line 3099: p_attr_group_metadata_obj IN EGO_ATTR_GROUP_METADATA_OBJ

3095:
3096: ----------------------------------------------------------------------
3097:
3098: FUNCTION Fetch_UK_Attr_Names_Table (
3099: p_attr_group_metadata_obj IN EGO_ATTR_GROUP_METADATA_OBJ
3100: )
3101: RETURN LOCAL_MEDIUM_VARCHAR_TABLE
3102: IS
3103:

Line 3143: p_attr_group_metadata_obj IN EGO_ATTR_GROUP_METADATA_OBJ

3139:
3140: ----------------------------------------------------------------------
3141:
3142: FUNCTION Fetch_UK_Attr_Values_Table (
3143: p_attr_group_metadata_obj IN EGO_ATTR_GROUP_METADATA_OBJ
3144: ,p_attr_name_value_pairs IN EGO_USER_ATTR_DATA_TABLE
3145: )
3146: RETURN LOCAL_BIG_VARCHAR_TABLE
3147: IS

Line 3263: p_attr_group_metadata_obj IN EGO_ATTR_GROUP_METADATA_OBJ

3259:
3260: ----------------------------------------------------------------------
3261:
3262: PROCEDURE Get_Err_Info_For_UK_Not_Resp (
3263: p_attr_group_metadata_obj IN EGO_ATTR_GROUP_METADATA_OBJ
3264: ,p_is_err_in_production_table IN BOOLEAN
3265: ,x_unique_key_err_msg OUT NOCOPY VARCHAR2
3266: ,x_token_table OUT NOCOPY ERROR_HANDLER.Token_Tbl_Type
3267: ) IS

Line 3356: p_attr_group_metadata_obj IN EGO_ATTR_GROUP_METADATA_OBJ

3352:
3353: ----------------------------------------------------------------------
3354:
3355: PROCEDURE Get_Err_Info_For_UK_Violation (
3356: p_attr_group_metadata_obj IN EGO_ATTR_GROUP_METADATA_OBJ
3357: ,p_attr_name_value_pairs IN EGO_USER_ATTR_DATA_TABLE
3358: ,p_is_err_in_production_table IN BOOLEAN
3359: ,x_unique_key_err_msg OUT NOCOPY VARCHAR2
3360: ,x_token_table OUT NOCOPY ERROR_HANDLER.Token_Tbl_Type

Line 3483: p_attr_group_metadata_obj IN EGO_ATTR_GROUP_METADATA_OBJ

3479:
3480: ----------------------------------------------------------------------
3481:
3482: PROCEDURE Get_Extension_Id_And_Mode (
3483: p_attr_group_metadata_obj IN EGO_ATTR_GROUP_METADATA_OBJ
3484: ,p_ext_table_metadata_obj IN EGO_EXT_TABLE_METADATA_OBJ
3485: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
3486: ,p_data_level IN VARCHAR2 DEFAULT NULL --R12C
3487: ,p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY

Line 3942: p_attr_group_metadata_obj IN EGO_ATTR_GROUP_METADATA_OBJ

3938:
3939: ----------------------------------------------------------------------
3940:
3941: FUNCTION Do_All_Attrs_Exist (
3942: p_attr_group_metadata_obj IN EGO_ATTR_GROUP_METADATA_OBJ
3943: ,p_attr_name_value_pairs IN EGO_USER_ATTR_DATA_TABLE
3944: ,p_entity_id IN VARCHAR2
3945: ,p_entity_index IN NUMBER
3946: ,p_entity_code IN VARCHAR2

Line 4151: l_attr_group_metadata_obj EGO_ATTR_GROUP_METADATA_OBJ;

4147: l_dynamic_sql VARCHAR2(5500);
4148: l_data_level_index NUMBER;
4149: l_data_level_progress_point VARCHAR2(10);
4150: l_wrong_data_level VARCHAR2(80);
4151: l_attr_group_metadata_obj EGO_ATTR_GROUP_METADATA_OBJ;
4152: l_enabled_data_level_table EGO_DATA_LEVEL_TABLE;
4153: l_data_level_metadata EGO_DATA_LEVEL_METADATA_OBJ;
4154: l_column_matched BOOLEAN;
4155: l_data_level_matched BOOLEAN;

Line 4966: ,p_attr_group_metadata_obj IN EGO_ATTR_GROUP_METADATA_OBJ

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
4970: ,p_entity_id IN VARCHAR2

Line 5449: p_attr_group_metadata_obj IN EGO_ATTR_GROUP_METADATA_OBJ

5445:
5446: ----------------------------------------------------------------------
5447:
5448: PROCEDURE Generate_Attr_Int_Values (
5449: p_attr_group_metadata_obj IN EGO_ATTR_GROUP_METADATA_OBJ
5450: ,p_ext_table_metadata_obj IN EGO_EXT_TABLE_METADATA_OBJ
5451: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
5452: ,p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
5453: ,p_entity_id IN VARCHAR2 DEFAULT NULL

Line 5630: ,p_attr_group_metadata_obj IN EGO_ATTR_GROUP_METADATA_OBJ

5626:
5627: ----------------------------------------------------------------------
5628: PROCEDURE Raise_WF_Event_If_Enabled (
5629: p_dml_type IN VARCHAR2
5630: ,p_attr_group_metadata_obj IN EGO_ATTR_GROUP_METADATA_OBJ
5631: ,p_extension_id IN NUMBER
5632: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
5633: ,p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
5634: ,p_entity_id IN VARCHAR2

Line 6243: p_attr_group_metadata_obj IN EGO_ATTR_GROUP_METADATA_OBJ

6239: -- the privilege will be taken from data_level_row_obj
6240: -- else it is taken from p_attr_group_metadata_obj
6241: ----------------------------------------------------------------------
6242: PROCEDURE Check_Privileges (
6243: p_attr_group_metadata_obj IN EGO_ATTR_GROUP_METADATA_OBJ
6244: ,p_data_level_row_obj IN EGO_DATA_LEVEL_ROW_OBJ DEFAULT NULL
6245: ,p_ignore_edit_privilege IN BOOLEAN DEFAULT FALSE
6246: ,p_entity_id IN NUMBER DEFAULT NULL
6247: ,p_entity_index IN NUMBER DEFAULT NULL

Line 6759: ,p_attr_group_metadata_obj IN EGO_ATTR_GROUP_METADATA_OBJ

6755: ----------------------------------------------------------------------
6756:
6757: PROCEDURE Insert_Row (
6758: p_api_version IN NUMBER
6759: ,p_attr_group_metadata_obj IN EGO_ATTR_GROUP_METADATA_OBJ
6760: ,p_ext_table_metadata_obj IN EGO_EXT_TABLE_METADATA_OBJ
6761: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
6762: ,p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
6763: ,p_data_level IN VARCHAR2 DEFAULT NULL --R12C

Line 7627: ,p_attr_group_metadata_obj IN EGO_ATTR_GROUP_METADATA_OBJ

7623: ----------------------------------------------------------------------
7624:
7625: PROCEDURE Update_Row (
7626: p_api_version IN NUMBER
7627: ,p_attr_group_metadata_obj IN EGO_ATTR_GROUP_METADATA_OBJ
7628: ,p_ext_table_metadata_obj IN EGO_EXT_TABLE_METADATA_OBJ
7629: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
7630: ,p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
7631: ,p_data_level IN VARCHAR2 DEFAULT NULL --R12C

Line 8248: ,p_attr_group_metadata_obj IN EGO_ATTR_GROUP_METADATA_OBJ

8244:
8245: ----------------------------------------------------------------------
8246: PROCEDURE Delete_Row (
8247: p_api_version IN NUMBER
8248: ,p_attr_group_metadata_obj IN EGO_ATTR_GROUP_METADATA_OBJ
8249: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
8250: ,p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
8251: ,p_data_level IN VARCHAR2 DEFAULT NULL --R12C
8252: ,p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY

Line 8591: ,p_attr_group_metadata_obj IN EGO_ATTR_GROUP_METADATA_OBJ

8587: PROCEDURE Validate_Row_Pvt (
8588: p_api_version IN NUMBER
8589: ,p_object_id IN NUMBER
8590: ,p_validate_hierarchy IN VARCHAR2 DEFAULT FND_API.G_TRUE --Added for bugFix:5275391
8591: ,p_attr_group_metadata_obj IN EGO_ATTR_GROUP_METADATA_OBJ
8592: ,p_ext_table_metadata_obj IN EGO_EXT_TABLE_METADATA_OBJ
8593: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
8594: ,p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
8595: ,p_data_level IN VARCHAR2 DEFAULT NULL --R12C

Line 9050: ,p_attr_group_metadata_obj IN EGO_ATTR_GROUP_METADATA_OBJ

9046:
9047: PROCEDURE Perform_DML_On_Row_Pvt (
9048: p_api_version IN NUMBER
9049: ,p_object_id IN NUMBER
9050: ,p_attr_group_metadata_obj IN EGO_ATTR_GROUP_METADATA_OBJ
9051: ,p_ext_table_metadata_obj IN EGO_EXT_TABLE_METADATA_OBJ
9052: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
9053: ,p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
9054: ,p_data_level IN VARCHAR2 DEFAULT NULL --R12C

Line 9248: ,p_attr_group_metadata_obj IN EGO_ATTR_GROUP_METADATA_OBJ

9244: -- private procedure
9245: ----------------------------------------------------------------------
9246: PROCEDURE Perform_DML_On_Template_Row (
9247: p_object_id IN NUMBER
9248: ,p_attr_group_metadata_obj IN EGO_ATTR_GROUP_METADATA_OBJ
9249: ,p_ext_table_metadata_obj IN EGO_EXT_TABLE_METADATA_OBJ
9250: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
9251: ,p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
9252: ,p_data_level IN VARCHAR2

Line 9392: ,x_attr_group_metadata_obj OUT NOCOPY EGO_ATTR_GROUP_METADATA_OBJ

9388: ,p_pending_vl_name IN VARCHAR2 DEFAULT NULL
9389: ,p_bulkload_flag IN BOOLEAN DEFAULT FALSE
9390: ,px_object_id IN OUT NOCOPY NUMBER
9391: ,px_attr_name_value_pairs IN OUT NOCOPY EGO_USER_ATTR_DATA_TABLE
9392: ,x_attr_group_metadata_obj OUT NOCOPY EGO_ATTR_GROUP_METADATA_OBJ
9393: ,x_ext_table_metadata_obj OUT NOCOPY EGO_EXT_TABLE_METADATA_OBJ
9394: ,x_extension_id OUT NOCOPY NUMBER
9395: ,x_mode OUT NOCOPY VARCHAR2
9396: ,x_return_status OUT NOCOPY VARCHAR2

Line 9791: l_attr_group_metadata_obj EGO_ATTR_GROUP_METADATA_OBJ;

9787: l_errorcode NUMBER;
9788: l_msg_count NUMBER;
9789: l_msg_data VARCHAR2(1000);
9790: l_data_level_id NUMBER;
9791: l_attr_group_metadata_obj EGO_ATTR_GROUP_METADATA_OBJ;
9792:
9793: l_dummy_row EGO_USER_ATTR_ROW_OBJ;
9794: BEGIN
9795:

Line 10201: l_curr_ag_metadata_obj EGO_ATTR_GROUP_METADATA_OBJ;

10197: l_object_id NUMBER;
10198: l_ext_table_metadata_obj EGO_EXT_TABLE_METADATA_OBJ;
10199: l_request_table_index NUMBER;
10200: l_curr_ag_request_obj EGO_ATTR_GROUP_REQUEST_OBJ;
10201: l_curr_ag_metadata_obj EGO_ATTR_GROUP_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;

Line 11421: l_attr_group_metadata_obj EGO_ATTR_GROUP_METADATA_OBJ;

11417: l_api_version CONSTANT NUMBER := 1.0;
11418:
11419: l_object_id NUMBER;
11420: l_attr_name_value_pairs EGO_USER_ATTR_DATA_TABLE;
11421: l_attr_group_metadata_obj EGO_ATTR_GROUP_METADATA_OBJ;
11422: l_ext_table_metadata_obj EGO_EXT_TABLE_METADATA_OBJ;
11423: l_extension_id NUMBER;
11424: l_mode VARCHAR2(10);
11425:

Line 11696: l_attr_group_metadata_obj EGO_ATTR_GROUP_METADATA_OBJ;

11692: l_api_version CONSTANT NUMBER := 1.0;
11693:
11694: l_object_id NUMBER;
11695: l_attr_name_value_pairs EGO_USER_ATTR_DATA_TABLE;
11696: l_attr_group_metadata_obj EGO_ATTR_GROUP_METADATA_OBJ;
11697: l_ext_table_metadata_obj EGO_EXT_TABLE_METADATA_OBJ;
11698: l_extension_id NUMBER;
11699: l_mode VARCHAR2(10);
11700:

Line 11923: l_attr_group_metadata_obj EGO_ATTR_GROUP_METADATA_OBJ;

11919: l_api_version CONSTANT NUMBER := 1.0;
11920:
11921: l_object_id NUMBER;
11922: l_attr_name_value_pairs EGO_USER_ATTR_DATA_TABLE;
11923: l_attr_group_metadata_obj EGO_ATTR_GROUP_METADATA_OBJ;
11924: l_ext_table_metadata_obj EGO_EXT_TABLE_METADATA_OBJ;
11925: l_extension_id NUMBER;
11926: l_mode VARCHAR2(10);
11927: l_dml VARCHAR2(32767);

Line 12196: l_attr_group_metadata_obj EGO_ATTR_GROUP_METADATA_OBJ;

12192: ) RETURN NUMBER
12193: IS
12194:
12195: l_attr_name_value_pairs EGO_USER_ATTR_DATA_TABLE;
12196: l_attr_group_metadata_obj EGO_ATTR_GROUP_METADATA_OBJ;
12197: l_ext_table_metadata_obj EGO_EXT_TABLE_METADATA_OBJ;
12198: l_ext_id NUMBER;
12199: l_object_id NUMBER;
12200:

Line 12377: l_attr_group_metadata_obj EGO_ATTR_GROUP_METADATA_OBJ;

12373: l_api_version CONSTANT NUMBER := 1.0;
12374:
12375: l_object_id NUMBER;
12376: l_attr_name_value_pairs EGO_USER_ATTR_DATA_TABLE;
12377: l_attr_group_metadata_obj EGO_ATTR_GROUP_METADATA_OBJ;
12378: l_ext_table_metadata_obj EGO_EXT_TABLE_METADATA_OBJ;
12379: l_extension_id NUMBER;
12380: l_mode VARCHAR2(10);
12381:

Line 12608: l_attr_group_metadata_obj EGO_ATTR_GROUP_METADATA_OBJ;

12604: l_prev_loop_row_number NUMBER;
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;

Line 13912: l_attr_group_metadata_obj EGO_ATTR_GROUP_METADATA_OBJ;

13908: l_current_column_index NUMBER;
13909: l_current_row_language VARCHAR2(30);
13910: l_current_row_source_lang VARCHAR2(30);
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);

Line 14865: p_attr_group_metadata_obj IN EGO_ATTR_GROUP_METADATA_OBJ

14861: -- internal value for an attribute. --
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

Line 15165: l_attr_group_metadata_obj EGO_ATTR_GROUP_METADATA_OBJ;

15161: RETURN VARCHAR2
15162: IS
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);

Line 15608: l_attr_group_metadata_obj EGO_ATTR_GROUP_METADATA_OBJ;

15604: )
15605: IS
15606:
15607: l_object_id NUMBER;
15608: l_attr_group_metadata_obj EGO_ATTR_GROUP_METADATA_OBJ;
15609: l_ext_table_metadata_obj EGO_EXT_TABLE_METADATA_OBJ;
15610: l_extension_id NUMBER;
15611: l_old_attr_name_value_pairs EGO_USER_ATTR_DATA_TABLE;
15612: l_new_attr_name_value_pairs EGO_USER_ATTR_DATA_TABLE;

Line 15773: l_attr_group_metadata_obj EGO_ATTR_GROUP_METADATA_OBJ;

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;
15776:
15777: BEGIN

Line 15906: l_attr_group_metadata_obj EGO_ATTR_GROUP_METADATA_OBJ;

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;
15909: l_attr_disp_value VARCHAR2(5000);
15910: BEGIN

Line 16022: l_attr_group_metadata_obj EGO_ATTR_GROUP_METADATA_OBJ;

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;
16025: l_attr_internal_value VARCHAR2(4000);
16026: l_ext_table_metadata_obj EGO_EXT_TABLE_METADATA_OBJ;