DBA Data[Home] [Help]

APPS.EGO_USER_ATTRS_DATA_PVT dependencies on EGO_EXT_TABLE_METADATA_OBJ

Line 729: ,p_ext_table_metadata_obj IN EGO_EXT_TABLE_METADATA_OBJ

725: p_dml_operation IN VARCHAR2
726: ,p_object_name IN VARCHAR2
727: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
728: ,p_attr_group_metadata_obj IN EGO_ATTR_GROUP_METADATA_OBJ
729: ,p_ext_table_metadata_obj IN EGO_EXT_TABLE_METADATA_OBJ
730: ,p_data_level IN VARCHAR2 DEFAULT NULL --R12C
731: ,p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
732: ,p_attr_name_value_pairs IN EGO_USER_ATTR_DATA_TABLE
733: ,p_extension_id IN NUMBER DEFAULT NULL

Line 1698: l_ext_table_metadata_obj EGO_EXT_TABLE_METADATA_OBJ;

1694: RETURN EGO_COL_NAME_VALUE_PAIR_ARRAY
1695: IS
1696:
1697: l_object_id NUMBER;
1698: l_ext_table_metadata_obj EGO_EXT_TABLE_METADATA_OBJ;
1699: l_data_level_metadata_array EGO_COL_METADATA_ARRAY;
1700: l_data_level_1_name_value_pair EGO_COL_NAME_VALUE_PAIR_OBJ;
1701: l_data_level_2_name_value_pair EGO_COL_NAME_VALUE_PAIR_OBJ;
1702: l_data_level_3_name_value_pair EGO_COL_NAME_VALUE_PAIR_OBJ;

Line 2373: ,p_ext_table_metadata_obj IN EGO_EXT_TABLE_METADATA_OBJ

2369: -- to FND_DSQL procedures.
2370:
2371: PROCEDURE Build_Where_Clause (
2372: p_attr_group_metadata_obj IN EGO_ATTR_GROUP_METADATA_OBJ
2373: ,p_ext_table_metadata_obj IN EGO_EXT_TABLE_METADATA_OBJ
2374: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
2375: ,p_data_level IN VARCHAR2 DEFAULT NULL --R12C
2376: ,p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
2377: ,p_attr_name_value_pairs IN EGO_USER_ATTR_DATA_TABLE DEFAULT NULL

Line 2533: ,p_ext_table_metadata_obj IN EGO_EXT_TABLE_METADATA_OBJ

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
2536: ,p_entity_id IN VARCHAR2
2537: ,p_entity_index IN NUMBER

Line 2920: ,p_ext_table_metadata_obj IN EGO_EXT_TABLE_METADATA_OBJ

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
2922: ,p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
2923: ,p_entity_id IN VARCHAR2
2924: ,p_entity_index IN NUMBER

Line 3035: ,p_ext_table_metadata_obj IN EGO_EXT_TABLE_METADATA_OBJ DEFAULT NULL

3031: ,p_entity_id IN VARCHAR2 DEFAULT NULL
3032: ,p_entity_index IN NUMBER DEFAULT NULL
3033: ,p_entity_code IN VARCHAR2 DEFAULT NULL
3034: ,p_attr_name_value_pairs IN EGO_USER_ATTR_DATA_TABLE DEFAULT NULL
3035: ,p_ext_table_metadata_obj IN EGO_EXT_TABLE_METADATA_OBJ DEFAULT NULL
3036: ,p_object_name IN VARCHAR2 DEFAULT NULL
3037: )
3038: RETURN VARCHAR2
3039: IS

Line 3041: l_ext_table_metadata_obj EGO_EXT_TABLE_METADATA_OBJ;

3037: )
3038: RETURN VARCHAR2
3039: IS
3040:
3041: l_ext_table_metadata_obj EGO_EXT_TABLE_METADATA_OBJ;
3042: l_val_set_query VARCHAR2(32767);
3043: l_attr_int_value VARCHAR2(4000); -- Bug 8757354
3044: l_attr_disp_value VARCHAR2(4000); -- Bug 8757354
3045:

Line 3173: ,p_ext_table_metadata_obj IN EGO_EXT_TABLE_METADATA_OBJ

3169: ----------------------------------------------------------------------
3170:
3171: FUNCTION Get_Extension_Id_For_Row (
3172: p_attr_group_metadata_obj IN EGO_ATTR_GROUP_METADATA_OBJ
3173: ,p_ext_table_metadata_obj IN EGO_EXT_TABLE_METADATA_OBJ
3174: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
3175: ,p_data_level IN VARCHAR2 DEFAULT NULL --R12C
3176: ,p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
3177: ,p_attr_name_value_pairs IN EGO_USER_ATTR_DATA_TABLE

Line 3390: p_ext_table_metadata_obj IN EGO_EXT_TABLE_METADATA_OBJ DEFAULT NULL,

3386: -- or ATTR_VALUE_NUM or ATTR_VALUE_DATE based on the call.
3387: -------------------------------------------------------------------------------
3388:
3389: FUNCTION Fetch_UK_Attr_Display_Values(p_attr_group_metadata_obj IN EGO_ATTR_GROUP_METADATA_OBJ,
3390: p_ext_table_metadata_obj IN EGO_EXT_TABLE_METADATA_OBJ DEFAULT NULL,
3391: p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL,
3392: p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL,
3393: p_entity_id IN VARCHAR2 DEFAULT NULL,
3394: p_entity_index IN NUMBER DEFAULT NULL,

Line 3541: p_ext_table_metadata_obj IN EGO_EXT_TABLE_METADATA_OBJ DEFAULT NULL,

3537: END Fetch_UK_Attr_Display_Values;
3538: ----------------------------------------------------------------------
3539:
3540: FUNCTION Fetch_UK_Attr_Values_Table(p_attr_group_metadata_obj IN EGO_ATTR_GROUP_METADATA_OBJ,
3541: p_ext_table_metadata_obj IN EGO_EXT_TABLE_METADATA_OBJ DEFAULT NULL,
3542: p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL,
3543: p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL,
3544: p_entity_id IN VARCHAR2 DEFAULT NULL,
3545: p_entity_index IN NUMBER DEFAULT NULL,

Line 3786: p_ext_table_metadata_obj IN EGO_EXT_TABLE_METADATA_OBJ DEFAULT NULL,

3782:
3783: ----------------------------------------------------------------------
3784:
3785: PROCEDURE Get_Err_Info_For_UK_Violation(p_attr_group_metadata_obj IN EGO_ATTR_GROUP_METADATA_OBJ,
3786: p_ext_table_metadata_obj IN EGO_EXT_TABLE_METADATA_OBJ DEFAULT NULL,
3787: p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL,
3788: p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL,
3789: p_entity_id IN VARCHAR2 DEFAULT NULL,
3790: p_entity_index IN NUMBER DEFAULT NULL,

Line 3924: ,p_ext_table_metadata_obj IN EGO_EXT_TABLE_METADATA_OBJ

3920: ----------------------------------------------------------------------
3921:
3922: PROCEDURE Get_Extension_Id_And_Mode (
3923: p_attr_group_metadata_obj IN EGO_ATTR_GROUP_METADATA_OBJ
3924: ,p_ext_table_metadata_obj IN EGO_EXT_TABLE_METADATA_OBJ
3925: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
3926: ,p_data_level IN VARCHAR2 DEFAULT NULL --R12C
3927: ,p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
3928: ,p_attr_name_value_pairs IN EGO_USER_ATTR_DATA_TABLE

Line 4538: p_ext_table_metadata_obj IN EGO_EXT_TABLE_METADATA_OBJ

4534:
4535: ----------------------------------------------------------------------
4536:
4537: FUNCTION Are_Ext_Table_Col_Names_Right (
4538: p_ext_table_metadata_obj IN EGO_EXT_TABLE_METADATA_OBJ
4539: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
4540: ,p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
4541: )
4542: RETURN BOOLEAN

Line 4580: ,p_ext_table_metadata_obj IN EGO_EXT_TABLE_METADATA_OBJ

4576:
4577: FUNCTION Is_Data_Level_Correct (
4578: p_object_id IN NUMBER
4579: ,p_attr_group_id IN NUMBER
4580: ,p_ext_table_metadata_obj IN EGO_EXT_TABLE_METADATA_OBJ
4581: ,p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
4582: ,p_data_level IN VARCHAR2 DEFAULT NULL --R12C
4583: ,p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
4584: ,p_attr_group_disp_name IN VARCHAR2

Line 5462: ,p_ext_table_metadata_obj IN EGO_EXT_TABLE_METADATA_OBJ

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
5465: ,p_entity_id IN VARCHAR2
5466: ,p_entity_index IN NUMBER

Line 5945: ,p_ext_table_metadata_obj IN EGO_EXT_TABLE_METADATA_OBJ

5941: ----------------------------------------------------------------------
5942:
5943: PROCEDURE Generate_Attr_Int_Values (
5944: p_attr_group_metadata_obj IN EGO_ATTR_GROUP_METADATA_OBJ
5945: ,p_ext_table_metadata_obj IN EGO_EXT_TABLE_METADATA_OBJ
5946: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
5947: ,p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
5948: ,p_entity_id IN VARCHAR2 DEFAULT NULL
5949: ,p_entity_index IN NUMBER DEFAULT NULL

Line 6569: l_ext_table_metadata_obj EGO_EXT_TABLE_METADATA_OBJ;

6565: ) IS
6566:
6567: l_object_id NUMBER;
6568: l_token_table ERROR_HANDLER.Token_Tbl_Type;
6569: l_ext_table_metadata_obj EGO_EXT_TABLE_METADATA_OBJ;
6570: l_err_msg_name VARCHAR2(30);
6571:
6572: BEGIN
6573:

Line 7274: ,p_ext_table_metadata_obj IN EGO_EXT_TABLE_METADATA_OBJ

7270:
7271: PROCEDURE Insert_Row (
7272: p_api_version IN NUMBER
7273: ,p_attr_group_metadata_obj IN EGO_ATTR_GROUP_METADATA_OBJ
7274: ,p_ext_table_metadata_obj IN EGO_EXT_TABLE_METADATA_OBJ
7275: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
7276: ,p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
7277: ,p_data_level IN VARCHAR2 DEFAULT NULL --R12C
7278: ,p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY

Line 8181: ,p_ext_table_metadata_obj IN EGO_EXT_TABLE_METADATA_OBJ

8177:
8178: PROCEDURE Update_Row (
8179: p_api_version IN NUMBER
8180: ,p_attr_group_metadata_obj IN EGO_ATTR_GROUP_METADATA_OBJ
8181: ,p_ext_table_metadata_obj IN EGO_EXT_TABLE_METADATA_OBJ
8182: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
8183: ,p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
8184: ,p_data_level IN VARCHAR2 DEFAULT NULL --R12C
8185: ,p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY

Line 8835: ,p_ext_table_metadata_obj IN EGO_EXT_TABLE_METADATA_OBJ

8831: ,p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
8832: ,p_extension_id IN NUMBER
8833: -- Start ssingal -For Ucc Net Attribute Propagation
8834: ,p_attr_name_value_pairs IN EGO_USER_ATTR_DATA_TABLE
8835: ,p_ext_table_metadata_obj IN EGO_EXT_TABLE_METADATA_OBJ
8836: -- End ssingal
8837: ,p_language_to_process IN VARCHAR2
8838: ,p_change_obj IN EGO_USER_ATTR_CHANGE_OBJ
8839: ,p_extra_pk_col_name_val_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL

Line 9171: ,p_ext_table_metadata_obj IN EGO_EXT_TABLE_METADATA_OBJ

9167: p_api_version IN NUMBER
9168: ,p_object_id IN NUMBER
9169: ,p_validate_hierarchy IN VARCHAR2 DEFAULT FND_API.G_TRUE --Added for bugFix:5275391
9170: ,p_attr_group_metadata_obj IN EGO_ATTR_GROUP_METADATA_OBJ
9171: ,p_ext_table_metadata_obj IN EGO_EXT_TABLE_METADATA_OBJ
9172: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
9173: ,p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
9174: ,p_data_level IN VARCHAR2 DEFAULT NULL --R12C
9175: ,p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY

Line 9630: ,p_ext_table_metadata_obj IN EGO_EXT_TABLE_METADATA_OBJ

9626: PROCEDURE Perform_DML_On_Row_Pvt (
9627: p_api_version IN NUMBER
9628: ,p_object_id IN NUMBER
9629: ,p_attr_group_metadata_obj IN EGO_ATTR_GROUP_METADATA_OBJ
9630: ,p_ext_table_metadata_obj IN EGO_EXT_TABLE_METADATA_OBJ
9631: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
9632: ,p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
9633: ,p_data_level IN VARCHAR2 DEFAULT NULL --R12C
9634: ,p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY

Line 9829: ,p_ext_table_metadata_obj IN EGO_EXT_TABLE_METADATA_OBJ

9825: ----------------------------------------------------------------------
9826: PROCEDURE Perform_DML_On_Template_Row (
9827: p_object_id IN NUMBER
9828: ,p_attr_group_metadata_obj IN EGO_ATTR_GROUP_METADATA_OBJ
9829: ,p_ext_table_metadata_obj IN EGO_EXT_TABLE_METADATA_OBJ
9830: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
9831: ,p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
9832: ,p_data_level IN VARCHAR2
9833: ,p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY

Line 9973: ,x_ext_table_metadata_obj OUT NOCOPY EGO_EXT_TABLE_METADATA_OBJ

9969: ,p_bulkload_flag IN BOOLEAN DEFAULT FALSE
9970: ,px_object_id IN OUT NOCOPY NUMBER
9971: ,px_attr_name_value_pairs IN OUT NOCOPY EGO_USER_ATTR_DATA_TABLE
9972: ,x_attr_group_metadata_obj OUT NOCOPY EGO_ATTR_GROUP_METADATA_OBJ
9973: ,x_ext_table_metadata_obj OUT NOCOPY EGO_EXT_TABLE_METADATA_OBJ
9974: ,x_extension_id OUT NOCOPY NUMBER
9975: ,x_mode OUT NOCOPY VARCHAR2
9976: ,x_return_status OUT NOCOPY VARCHAR2
9977: ) IS

Line 11227: l_ext_table_metadata_obj EGO_EXT_TABLE_METADATA_OBJ;

11223: --if we change optional parameters, version goes FROM x.n to x.(n+1)
11224: l_api_version CONSTANT NUMBER := 1.0;
11225:
11226: l_object_id NUMBER;
11227: l_ext_table_metadata_obj EGO_EXT_TABLE_METADATA_OBJ;
11228: l_request_table_index NUMBER;
11229: l_curr_ag_request_obj EGO_ATTR_GROUP_REQUEST_OBJ;
11230: l_curr_ag_metadata_obj EGO_ATTR_GROUP_METADATA_OBJ;
11231: l_can_view_this_attr_group BOOLEAN;

Line 12442: l_ext_table_metadata_obj EGO_EXT_TABLE_METADATA_OBJ;

12438:
12439: l_object_id NUMBER;
12440: l_attr_name_value_pairs EGO_USER_ATTR_DATA_TABLE;
12441: l_attr_group_metadata_obj EGO_ATTR_GROUP_METADATA_OBJ;
12442: l_ext_table_metadata_obj EGO_EXT_TABLE_METADATA_OBJ;
12443: l_extension_id NUMBER;
12444: l_mode VARCHAR2(10);
12445:
12446:

Line 12717: l_ext_table_metadata_obj EGO_EXT_TABLE_METADATA_OBJ;

12713:
12714: l_object_id NUMBER;
12715: l_attr_name_value_pairs EGO_USER_ATTR_DATA_TABLE;
12716: l_attr_group_metadata_obj EGO_ATTR_GROUP_METADATA_OBJ;
12717: l_ext_table_metadata_obj EGO_EXT_TABLE_METADATA_OBJ;
12718: l_extension_id NUMBER;
12719: l_mode VARCHAR2(10);
12720:
12721: BEGIN

Line 12944: l_ext_table_metadata_obj EGO_EXT_TABLE_METADATA_OBJ;

12940:
12941: l_object_id NUMBER;
12942: l_attr_name_value_pairs EGO_USER_ATTR_DATA_TABLE;
12943: l_attr_group_metadata_obj EGO_ATTR_GROUP_METADATA_OBJ;
12944: l_ext_table_metadata_obj EGO_EXT_TABLE_METADATA_OBJ;
12945: l_extension_id NUMBER;
12946: l_mode VARCHAR2(10);
12947: l_dml VARCHAR2(32767);
12948: l_b_dml_bind_list EGO_USER_ATTR_DATA_TABLE;

Line 13217: l_ext_table_metadata_obj EGO_EXT_TABLE_METADATA_OBJ;

13213: IS
13214:
13215: l_attr_name_value_pairs EGO_USER_ATTR_DATA_TABLE;
13216: l_attr_group_metadata_obj EGO_ATTR_GROUP_METADATA_OBJ;
13217: l_ext_table_metadata_obj EGO_EXT_TABLE_METADATA_OBJ;
13218: l_ext_id NUMBER;
13219: l_object_id NUMBER;
13220:
13221: BEGIN

Line 13402: l_ext_table_metadata_obj EGO_EXT_TABLE_METADATA_OBJ;

13398:
13399: l_object_id NUMBER;
13400: l_attr_name_value_pairs EGO_USER_ATTR_DATA_TABLE;
13401: l_attr_group_metadata_obj EGO_ATTR_GROUP_METADATA_OBJ;
13402: l_ext_table_metadata_obj EGO_EXT_TABLE_METADATA_OBJ;
13403: l_extension_id NUMBER;
13404: l_mode VARCHAR2(10);
13405:
13406:

Line 13622: l_ext_table_metadata_obj EGO_EXT_TABLE_METADATA_OBJ;

13618: --if we change optional parameters, version goes FROM x.n to x.(n+1)
13619: l_api_version CONSTANT NUMBER := 1.0;
13620:
13621: l_object_id NUMBER;
13622: l_ext_table_metadata_obj EGO_EXT_TABLE_METADATA_OBJ;
13623: l_class_code_hierarchy VARCHAR2(16000);
13624: l_last_loop_index NUMBER;
13625: l_this_loop_index NUMBER;
13626: l_decode_index NUMBER;

Line 14311: l_ext_table_metadata_obj EGO_EXT_TABLE_METADATA_OBJ;

14307: l_object_id NUMBER;
14308: l_b_table_name VARCHAR2(30);
14309: l_tl_table_name VARCHAR2(30);
14310: l_vl_name VARCHAR2(30);
14311: l_ext_table_metadata_obj EGO_EXT_TABLE_METADATA_OBJ;
14312: l_pk_col_metadata_array EGO_COL_METADATA_ARRAY;
14313: l_data_level_metadata_array EGO_COL_METADATA_ARRAY;
14314: l_class_code_metadata_array EGO_COL_METADATA_ARRAY;
14315: l_pk_index NUMBER;

Line 15041: l_ext_table_metadata_obj EGO_EXT_TABLE_METADATA_OBJ;

15037:
15038: l_object_id NUMBER;
15039: l_data_level_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
15040: l_current_dl_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
15041: l_ext_table_metadata_obj EGO_EXT_TABLE_METADATA_OBJ;
15042: l_chng_col_names_list VARCHAR2(20000);
15043: l_cols_to_exclude_list VARCHAR2(2000);
15044: l_pk_column_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
15045: l_class_code_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;

Line 16770: l_ext_table_metadata_obj EGO_EXT_TABLE_METADATA_OBJ;

16766: IS
16767:
16768: l_object_id NUMBER;
16769: l_attr_group_metadata_obj EGO_ATTR_GROUP_METADATA_OBJ;
16770: l_ext_table_metadata_obj EGO_EXT_TABLE_METADATA_OBJ;
16771: l_extension_id NUMBER;
16772: l_old_attr_name_value_pairs EGO_USER_ATTR_DATA_TABLE;
16773: l_new_attr_name_value_pairs EGO_USER_ATTR_DATA_TABLE;
16774: l_mode VARCHAR2(10);

Line 16933: l_ext_table_metadata_obj EGO_EXT_TABLE_METADATA_OBJ;

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;
16937:

Line 17157: ,p_ext_table_metadata_obj IN EGO_EXT_TABLE_METADATA_OBJ

17153: ,p_attr_group_id IN NUMBER
17154: ,p_attr_id IN NUMBER
17155: ,p_return_intf_col IN VARCHAR2
17156: ,p_object_name IN VARCHAR2
17157: ,p_ext_table_metadata_obj IN EGO_EXT_TABLE_METADATA_OBJ
17158: ,p_pk1_column_name IN VARCHAR2
17159: ,p_pk1_value IN VARCHAR2
17160: ,p_pk2_column_name IN VARCHAR2
17161: ,p_pk2_value IN VARCHAR2

Line 17187: l_ext_table_metadata_obj EGO_EXT_TABLE_METADATA_OBJ;

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;
17186: l_attr_internal_value VARCHAR2(4000);
17187: l_ext_table_metadata_obj EGO_EXT_TABLE_METADATA_OBJ;
17188: BEGIN
17189: l_attr_value_obj := EGO_USER_ATTR_DATA_OBJ (null
17190: ,p_attr_internal_name
17191: ,null