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_GROUP_METADATA_OBJ

Line 728: ,p_attr_group_metadata_obj IN EGO_ATTR_GROUP_METADATA_OBJ

724: PROCEDURE Get_Changed_Attributes (
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

Line 1297: , p_attr_group_metadata_obj IN EGO_ATTR_GROUP_METADATA_OBJ

1293: , p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
1294: , p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
1295: , p_attr_diffs IN EGO_USER_ATTR_DIFF_TABLE
1296: , p_transaction_type IN VARCHAR2
1297: , p_attr_group_metadata_obj IN EGO_ATTR_GROUP_METADATA_OBJ
1298: , x_return_status OUT NOCOPY VARCHAR2
1299: , x_error_message OUT NOCOPY VARCHAR2
1300: )
1301: IS

Line 2372: p_attr_group_metadata_obj IN EGO_ATTR_GROUP_METADATA_OBJ

2368: -- executes that statement; it just adds text and bind variables through calls
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

Line 2469: p_attr_group_metadata_obj IN EGO_ATTR_GROUP_METADATA_OBJ

2465:
2466: ----------------------------------------------------------------------
2467:
2468: PROCEDURE Sort_Attr_Values_Table (
2469: p_attr_group_metadata_obj IN EGO_ATTR_GROUP_METADATA_OBJ
2470: ,px_attr_name_value_pairs IN OUT NOCOPY EGO_USER_ATTR_DATA_TABLE
2471: ) IS
2472:
2473: l_sorted_attr_data_table LOCAL_USER_ATTR_DATA_TABLE;

Line 2532: ,p_attr_group_metadata_obj IN EGO_ATTR_GROUP_METADATA_OBJ

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

Line 2919: ,p_attr_group_metadata_obj IN EGO_ATTR_GROUP_METADATA_OBJ

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

Line 3028: ,p_attr_group_metadata_obj IN EGO_ATTR_GROUP_METADATA_OBJ

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

Line 3172: p_attr_group_metadata_obj IN EGO_ATTR_GROUP_METADATA_OBJ

3168:
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

Line 3341: p_attr_group_metadata_obj IN EGO_ATTR_GROUP_METADATA_OBJ

3337:
3338: ----------------------------------------------------------------------
3339:
3340: FUNCTION Fetch_UK_Attr_Names_Table (
3341: p_attr_group_metadata_obj IN EGO_ATTR_GROUP_METADATA_OBJ
3342: )
3343: RETURN LOCAL_MEDIUM_VARCHAR_TABLE
3344: IS
3345:

Line 3389: FUNCTION Fetch_UK_Attr_Display_Values(p_attr_group_metadata_obj IN EGO_ATTR_GROUP_METADATA_OBJ,

3385: -- p_attr_group_metadata_obj.ATTR_DISP_VALUE with either ATTR_VALUE_STR
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,

Line 3540: FUNCTION Fetch_UK_Attr_Values_Table(p_attr_group_metadata_obj IN EGO_ATTR_GROUP_METADATA_OBJ,

3536:
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,

Line 3693: p_attr_group_metadata_obj IN EGO_ATTR_GROUP_METADATA_OBJ

3689:
3690: ----------------------------------------------------------------------
3691:
3692: PROCEDURE Get_Err_Info_For_UK_Not_Resp (
3693: p_attr_group_metadata_obj IN EGO_ATTR_GROUP_METADATA_OBJ
3694: ,p_is_err_in_production_table IN BOOLEAN
3695: ,x_unique_key_err_msg OUT NOCOPY VARCHAR2
3696: ,x_token_table OUT NOCOPY ERROR_HANDLER.Token_Tbl_Type
3697: ) IS

Line 3785: PROCEDURE Get_Err_Info_For_UK_Violation(p_attr_group_metadata_obj IN EGO_ATTR_GROUP_METADATA_OBJ,

3781: END Get_Err_Info_For_UK_Not_Resp;
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,

Line 3923: p_attr_group_metadata_obj IN EGO_ATTR_GROUP_METADATA_OBJ

3919:
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

Line 4393: p_attr_group_metadata_obj IN EGO_ATTR_GROUP_METADATA_OBJ

4389:
4390: ----------------------------------------------------------------------
4391:
4392: FUNCTION Do_All_Attrs_Exist (
4393: p_attr_group_metadata_obj IN EGO_ATTR_GROUP_METADATA_OBJ
4394: ,p_attr_name_value_pairs IN EGO_USER_ATTR_DATA_TABLE
4395: ,p_entity_id IN VARCHAR2
4396: ,p_entity_index IN NUMBER
4397: ,p_entity_code IN VARCHAR2

Line 4603: l_attr_group_metadata_obj EGO_ATTR_GROUP_METADATA_OBJ;

4599: l_data_level_index NUMBER;
4600: l_data_level_progress_point VARCHAR2(10);
4601: l_wrong_data_level VARCHAR2(80);
4602: l_item_ag_count INT;
4603: l_attr_group_metadata_obj EGO_ATTR_GROUP_METADATA_OBJ;
4604: l_enabled_data_level_table EGO_DATA_LEVEL_TABLE;
4605: l_data_level_metadata EGO_DATA_LEVEL_METADATA_OBJ;
4606: l_column_matched BOOLEAN;
4607: l_data_level_matched BOOLEAN;

Line 5461: ,p_attr_group_metadata_obj IN EGO_ATTR_GROUP_METADATA_OBJ

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

Line 5944: p_attr_group_metadata_obj IN EGO_ATTR_GROUP_METADATA_OBJ

5940:
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

Line 6125: ,p_attr_group_metadata_obj IN EGO_ATTR_GROUP_METADATA_OBJ

6121:
6122: ----------------------------------------------------------------------
6123: PROCEDURE Raise_WF_Event_If_Enabled (
6124: p_dml_type IN VARCHAR2
6125: ,p_attr_group_metadata_obj IN EGO_ATTR_GROUP_METADATA_OBJ
6126: ,p_extension_id IN NUMBER
6127: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
6128: ,p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
6129: ,p_entity_id IN VARCHAR2

Line 6738: p_attr_group_metadata_obj IN EGO_ATTR_GROUP_METADATA_OBJ

6734: -- the privilege will be taken from data_level_row_obj
6735: -- else it is taken from p_attr_group_metadata_obj
6736: ----------------------------------------------------------------------
6737: PROCEDURE Check_Privileges (
6738: p_attr_group_metadata_obj IN EGO_ATTR_GROUP_METADATA_OBJ
6739: ,p_data_level_row_obj IN EGO_DATA_LEVEL_ROW_OBJ DEFAULT NULL
6740: ,p_ignore_edit_privilege IN BOOLEAN DEFAULT FALSE
6741: ,p_entity_id IN NUMBER DEFAULT NULL
6742: ,p_entity_index IN NUMBER DEFAULT NULL

Line 7273: ,p_attr_group_metadata_obj IN EGO_ATTR_GROUP_METADATA_OBJ

7269: ----------------------------------------------------------------------
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

Line 8180: ,p_attr_group_metadata_obj IN EGO_ATTR_GROUP_METADATA_OBJ

8176: ----------------------------------------------------------------------
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

Line 8827: ,p_attr_group_metadata_obj IN EGO_ATTR_GROUP_METADATA_OBJ

8823:
8824: ----------------------------------------------------------------------
8825: PROCEDURE Delete_Row (
8826: p_api_version IN NUMBER
8827: ,p_attr_group_metadata_obj IN EGO_ATTR_GROUP_METADATA_OBJ
8828: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
8829: ,p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
8830: ,p_data_level IN VARCHAR2 DEFAULT NULL --R12C
8831: ,p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY

Line 9170: ,p_attr_group_metadata_obj IN EGO_ATTR_GROUP_METADATA_OBJ

9166: PROCEDURE Validate_Row_Pvt (
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

Line 9629: ,p_attr_group_metadata_obj IN EGO_ATTR_GROUP_METADATA_OBJ

9625:
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

Line 9828: ,p_attr_group_metadata_obj IN EGO_ATTR_GROUP_METADATA_OBJ

9824: -- private procedure
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

Line 9972: ,x_attr_group_metadata_obj OUT NOCOPY EGO_ATTR_GROUP_METADATA_OBJ

9968: ,p_pending_vl_name IN VARCHAR2 DEFAULT NULL
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

Line 10371: l_attr_group_metadata_obj EGO_ATTR_GROUP_METADATA_OBJ;

10367: l_errorcode NUMBER;
10368: l_msg_count NUMBER;
10369: l_msg_data VARCHAR2(1000);
10370: l_data_level_id NUMBER;
10371: l_attr_group_metadata_obj EGO_ATTR_GROUP_METADATA_OBJ;
10372:
10373: l_dummy_row EGO_USER_ATTR_ROW_OBJ;
10374: BEGIN
10375:

Line 11230: l_curr_ag_metadata_obj EGO_ATTR_GROUP_METADATA_OBJ;

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;
11232: l_augmented_data_table LOCAL_AUGMENTED_DATA_TABLE;
11233: l_requested_attr_names_table LOCAL_VARCHAR_TABLE;
11234: l_attr_list_index NUMBER;

Line 12441: l_attr_group_metadata_obj EGO_ATTR_GROUP_METADATA_OBJ;

12437: l_api_version CONSTANT NUMBER := 1.0;
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:

Line 12716: l_attr_group_metadata_obj EGO_ATTR_GROUP_METADATA_OBJ;

12712: l_api_version CONSTANT NUMBER := 1.0;
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:

Line 12943: l_attr_group_metadata_obj EGO_ATTR_GROUP_METADATA_OBJ;

12939: l_api_version CONSTANT NUMBER := 1.0;
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);

Line 13216: l_attr_group_metadata_obj EGO_ATTR_GROUP_METADATA_OBJ;

13212: ) RETURN NUMBER
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:

Line 13401: l_attr_group_metadata_obj EGO_ATTR_GROUP_METADATA_OBJ;

13397: l_api_version CONSTANT NUMBER := 1.0;
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:

Line 13634: l_attr_group_metadata_obj EGO_ATTR_GROUP_METADATA_OBJ;

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

Line 15062: l_attr_group_metadata_obj EGO_ATTR_GROUP_METADATA_OBJ;

15058: l_current_column_index NUMBER;
15059: l_current_row_language VARCHAR2(30);
15060: l_current_row_source_lang VARCHAR2(30);
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);

Line 16015: p_attr_group_metadata_obj IN EGO_ATTR_GROUP_METADATA_OBJ

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

Line 16315: l_attr_group_metadata_obj EGO_ATTR_GROUP_METADATA_OBJ;

16311: RETURN VARCHAR2
16312: IS
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

Line 16769: l_attr_group_metadata_obj EGO_ATTR_GROUP_METADATA_OBJ;

16765: )
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;

Line 16934: l_attr_group_metadata_obj EGO_ATTR_GROUP_METADATA_OBJ;

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:
16938: BEGIN

Line 17067: l_attr_group_metadata_obj EGO_ATTR_GROUP_METADATA_OBJ;

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

Line 17183: l_attr_group_metadata_obj EGO_ATTR_GROUP_METADATA_OBJ;

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