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_USER_ATTR_DATA_TABLE

Line 490: p_attr_name_value_pairs IN EGO_USER_ATTR_DATA_TABLE

486: -- Private
487: -- To Check whether the attribute is null or not
488: --
489: FUNCTION All_Attr_Values_Are_Null (
490: p_attr_name_value_pairs IN EGO_USER_ATTR_DATA_TABLE
491: )
492: RETURN BOOLEAN
493: IS
494:

Line 732: ,p_attr_name_value_pairs IN EGO_USER_ATTR_DATA_TABLE

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
734: ,p_entity_id IN NUMBER DEFAULT NULL
735: ,p_entity_index IN NUMBER DEFAULT NULL
736: ,p_entity_code IN VARCHAR2 DEFAULT NULL

Line 1350: , px_attr_data_tbl IN OUT NOCOPY EGO_USER_ATTR_DATA_TABLE

1346: -- Private
1347: --
1348: PROCEDURE Convert_Attr_Diff_To_Data (
1349: p_attr_diff_tbl IN EGO_USER_ATTR_DIFF_TABLE
1350: , px_attr_data_tbl IN OUT NOCOPY EGO_USER_ATTR_DATA_TABLE
1351: , p_true_if_new IN BOOLEAN := TRUE
1352: -- px_is_delete returns true if this diff object contains a delete operation
1353: , px_is_delete OUT NOCOPY BOOLEAN
1354: , x_error_message OUT NOCOPY VARCHAR2

Line 1371: px_attr_data_tbl := EGO_USER_ATTR_DATA_TABLE();

1367: FOR i IN p_attr_diff_tbl.FIRST..p_attr_diff_tbl.LAST LOOP
1368:
1369: IF px_attr_data_tbl IS NULL THEN
1370: Debug_Msg('In Convert_Attr_Diff_To_Data, px_attr_data_tbl is NULL', 1);
1371: px_attr_data_tbl := EGO_USER_ATTR_DATA_TABLE();
1372: END IF;
1373:
1374: -- Set row identifier based on previous contents of diff table
1375: l_row_identifier := 1;

Line 1447: p_attributes_data_table IN EGO_USER_ATTR_DATA_TABLE

1443: --
1444: -- Private
1445: --
1446: FUNCTION Build_Sorted_Data_Table (
1447: p_attributes_data_table IN EGO_USER_ATTR_DATA_TABLE
1448: )
1449: RETURN LOCAL_USER_ATTR_DATA_TABLE
1450: IS
1451:

Line 1462: l_sorted_data_element EGO_USER_ATTR_DATA_TABLE;

1458: l_sorted_data_index_table LOCAL_NUMBER_TABLE;
1459: l_s_a_d_table_index NUMBER;
1460: l_sorted_attr_data_table LOCAL_USER_ATTR_DATA_TABLE;
1461: l_sorted_row_id_table LOCAL_NUMBER_TABLE;
1462: l_sorted_data_element EGO_USER_ATTR_DATA_TABLE;
1463: temp EGO_USER_ATTR_DATA_OBJ;
1464:
1465: BEGIN
1466:

Line 1875: p_attr_name_value_pairs IN EGO_USER_ATTR_DATA_TABLE

1871: --
1872: -- Private
1873: --
1874: FUNCTION Find_Name_Value_Pair_For_Attr (
1875: p_attr_name_value_pairs IN EGO_USER_ATTR_DATA_TABLE
1876: ,p_attr_name IN VARCHAR2
1877: )
1878: RETURN EGO_USER_ATTR_DATA_OBJ
1879: IS

Line 1989: ,p_attr_name_value_pairs IN EGO_USER_ATTR_DATA_TABLE

1985: -- 'UNIQUE_KEY': processes passed-in Attributes whose UNIQUE_KEY flag is 'Y'
1986:
1987: PROCEDURE Add_Attr_Info_To_Statement (
1988: p_attr_metadata_table IN EGO_ATTR_METADATA_TABLE
1989: ,p_attr_name_value_pairs IN EGO_USER_ATTR_DATA_TABLE
1990: ,p_separator IN VARCHAR2
1991: ,p_mode IN VARCHAR2
1992: ,p_which_attrs IN VARCHAR2
1993: ) IS

Line 2377: ,p_attr_name_value_pairs IN EGO_USER_ATTR_DATA_TABLE DEFAULT NULL

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
2378: ) IS
2379:
2380: l_api_name VARCHAR2(30) := 'Build_Where_Clause';
2381: l_pk_col_string VARCHAR2(1000) := '';

Line 2470: ,px_attr_name_value_pairs IN OUT NOCOPY EGO_USER_ATTR_DATA_TABLE

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;
2474: l_sorted_data_table_index NUMBER;

Line 2540: ,p_attr_name_value_pairs IN EGO_USER_ATTR_DATA_TABLE

2536: ,p_entity_id IN VARCHAR2
2537: ,p_entity_index IN NUMBER
2538: ,p_entity_code IN VARCHAR2
2539: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
2540: ,p_attr_name_value_pairs IN EGO_USER_ATTR_DATA_TABLE
2541: ,p_is_disp_to_int_query IN BOOLEAN
2542: ,p_final_bind_value IN VARCHAR2
2543: ,p_return_bound_sql IN BOOLEAN DEFAULT FALSE
2544: )

Line 2926: ,p_attr_name_value_pairs IN EGO_USER_ATTR_DATA_TABLE

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
2925: ,p_entity_code IN VARCHAR2
2926: ,p_attr_name_value_pairs IN EGO_USER_ATTR_DATA_TABLE
2927: )
2928: RETURN VARCHAR2
2929: IS
2930:

Line 3034: ,p_attr_name_value_pairs IN EGO_USER_ATTR_DATA_TABLE DEFAULT NULL

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

Line 3177: ,p_attr_name_value_pairs IN EGO_USER_ATTR_DATA_TABLE

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
3178: ,p_change_obj IN EGO_USER_ATTR_CHANGE_OBJ DEFAULT NULL
3179: ,p_extra_pk_col_name_val_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
3180: ,p_pending_b_table_name IN VARCHAR2 DEFAULT NULL
3181: ,p_pending_vl_name IN VARCHAR2 DEFAULT NULL

Line 3396: p_attr_name_value_pairs IN EGO_USER_ATTR_DATA_TABLE,

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,
3395: p_entity_code IN VARCHAR2 DEFAULT NULL,
3396: p_attr_name_value_pairs IN EGO_USER_ATTR_DATA_TABLE,
3397: p_attr_name_value IN VARCHAR2,
3398: l_table_index IN NUMBER
3399: )
3400: RETURN varchar2

Line 3547: p_attr_name_value_pairs IN EGO_USER_ATTR_DATA_TABLE)

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,
3546: p_entity_code IN VARCHAR2 DEFAULT NULL,
3547: p_attr_name_value_pairs IN EGO_USER_ATTR_DATA_TABLE)
3548: RETURN LOCAL_BIG_VARCHAR_TABLE
3549: IS
3550:
3551: l_uk_attr_values_table LOCAL_BIG_VARCHAR_TABLE;

Line 3792: p_attr_name_value_pairs IN EGO_USER_ATTR_DATA_TABLE,

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,
3791: p_entity_code IN VARCHAR2 DEFAULT NULL,
3792: p_attr_name_value_pairs IN EGO_USER_ATTR_DATA_TABLE,
3793: p_is_err_in_production_table IN BOOLEAN,
3794: x_unique_key_err_msg OUT NOCOPY VARCHAR2,
3795: x_token_table OUT NOCOPY ERROR_HANDLER.Token_Tbl_Type) IS
3796:

Line 3928: ,p_attr_name_value_pairs IN EGO_USER_ATTR_DATA_TABLE

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
3929: ,p_extension_id IN NUMBER DEFAULT NULL
3930: ,p_mode IN VARCHAR2 DEFAULT NULL
3931: ,p_change_obj IN EGO_USER_ATTR_CHANGE_OBJ DEFAULT NULL
3932: ,p_extra_pk_col_name_val_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL

Line 4394: ,p_attr_name_value_pairs IN EGO_USER_ATTR_DATA_TABLE

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
4398: )

Line 5468: ,p_attr_name_value_pairs IN EGO_USER_ATTR_DATA_TABLE

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
5467: ,p_entity_code IN VARCHAR2
5468: ,p_attr_name_value_pairs IN EGO_USER_ATTR_DATA_TABLE
5469: ,px_attr_value_obj IN OUT NOCOPY EGO_USER_ATTR_DATA_OBJ
5470: )
5471: RETURN BOOLEAN
5472: IS

Line 5716: ,px_attr_name_value_pairs IN OUT NOCOPY EGO_USER_ATTR_DATA_TABLE

5712: ,p_entity_id IN VARCHAR2
5713: ,p_entity_index IN NUMBER
5714: ,p_entity_code IN VARCHAR2
5715: ,p_attr_group_disp_name IN VARCHAR2
5716: ,px_attr_name_value_pairs IN OUT NOCOPY EGO_USER_ATTR_DATA_TABLE
5717: )
5718: RETURN BOOLEAN
5719: IS
5720:

Line 5951: ,px_attr_name_value_pairs IN OUT NOCOPY EGO_USER_ATTR_DATA_TABLE

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
5950: ,p_entity_code IN VARCHAR2 DEFAULT NULL
5951: ,px_attr_name_value_pairs IN OUT NOCOPY EGO_USER_ATTR_DATA_TABLE
5952: ,x_return_status OUT NOCOPY VARCHAR2
5953: ) IS
5954:
5955: l_token_table ERROR_HANDLER.Token_Tbl_Type;

Line 7280: ,p_attr_name_value_pairs IN EGO_USER_ATTR_DATA_TABLE

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
7279: ,p_extension_id IN NUMBER
7280: ,p_attr_name_value_pairs IN EGO_USER_ATTR_DATA_TABLE
7281: ,p_language_to_process IN VARCHAR2
7282: ,p_change_obj IN EGO_USER_ATTR_CHANGE_OBJ
7283: ,p_extra_pk_col_name_val_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
7284: ,p_extra_attr_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL

Line 8187: ,p_attr_name_value_pairs IN EGO_USER_ATTR_DATA_TABLE

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
8186: ,p_extension_id IN NUMBER
8187: ,p_attr_name_value_pairs IN EGO_USER_ATTR_DATA_TABLE
8188: ,p_language_to_process IN VARCHAR2
8189: ,p_change_obj IN EGO_USER_ATTR_CHANGE_OBJ
8190: ,p_extra_attr_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
8191: ,p_extra_pk_col_name_val_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL

Line 8834: ,p_attr_name_value_pairs IN EGO_USER_ATTR_DATA_TABLE

8830: ,p_data_level IN VARCHAR2 DEFAULT NULL --R12C
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

Line 9181: ,px_attr_name_value_pairs IN OUT NOCOPY EGO_USER_ATTR_DATA_TABLE

9177: ,p_mode IN VARCHAR2
9178: ,p_entity_id IN VARCHAR2 DEFAULT NULL
9179: ,p_entity_index IN NUMBER DEFAULT NULL
9180: ,p_entity_code IN VARCHAR2 DEFAULT NULL
9181: ,px_attr_name_value_pairs IN OUT NOCOPY EGO_USER_ATTR_DATA_TABLE
9182: ,x_return_status OUT NOCOPY VARCHAR2
9183: ) IS
9184:
9185: l_api_name CONSTANT VARCHAR2(30) := 'Validate_Row_Pvt';

Line 9636: ,p_attr_name_value_pairs IN EGO_USER_ATTR_DATA_TABLE

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
9635: ,p_extension_id IN NUMBER
9636: ,p_attr_name_value_pairs IN EGO_USER_ATTR_DATA_TABLE
9637: ,p_language_to_process IN VARCHAR2 DEFAULT NULL
9638: ,p_mode IN VARCHAR2
9639: ,p_change_obj IN EGO_USER_ATTR_CHANGE_OBJ DEFAULT NULL
9640: ,p_extra_pk_col_name_val_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL

Line 9835: ,px_attr_name_value_pairs IN OUT NOCOPY EGO_USER_ATTR_DATA_TABLE

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
9834: ,p_commit IN VARCHAR2
9835: ,px_attr_name_value_pairs IN OUT NOCOPY EGO_USER_ATTR_DATA_TABLE
9836: ) IS
9837:
9838: l_api_name VARCHAR2(50) := 'Perform_DML_On_Template_Row';
9839: l_extension_id NUMBER;

Line 9971: ,px_attr_name_value_pairs IN OUT NOCOPY EGO_USER_ATTR_DATA_TABLE

9967: ,p_pending_b_table_name IN VARCHAR2 DEFAULT NULL
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

Line 10246: ,p_attributes_data_table IN EGO_USER_ATTR_DATA_TABLE

10242: PROCEDURE Process_User_Attrs_Data (
10243: p_api_version IN NUMBER
10244: ,p_object_name IN VARCHAR2
10245: ,p_attributes_row_table IN EGO_USER_ATTR_ROW_TABLE
10246: ,p_attributes_data_table IN EGO_USER_ATTR_DATA_TABLE
10247: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
10248: ,p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
10249: ,p_user_privileges_on_object IN EGO_VARCHAR_TBL_TYPE DEFAULT NULL
10250: ,p_change_info_table IN EGO_USER_ATTR_CHANGE_TABLE DEFAULT NULL

Line 10316: ,p_attributes_data_table IN EGO_USER_ATTR_DATA_TABLE

10312: PROCEDURE Process_User_Attrs_Data (
10313: p_api_version IN NUMBER
10314: ,p_object_name IN VARCHAR2
10315: ,p_attributes_row_table IN EGO_USER_ATTR_ROW_TABLE
10316: ,p_attributes_data_table IN EGO_USER_ATTR_DATA_TABLE
10317: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
10318: ,p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
10319: ,p_user_privileges_on_object IN EGO_VARCHAR_TBL_TYPE DEFAULT NULL
10320: ,p_change_info_table IN EGO_USER_ATTR_CHANGE_TABLE DEFAULT NULL

Line 10363: l_row_attrs_table EGO_USER_ATTR_DATA_TABLE;

10359: l_sorted_data_table_index NUMBER;
10360: l_got_all_attrs_for_this_row BOOLEAN := FALSE;
10361: l_current_data_element EGO_USER_ATTR_DATA_OBJ;
10362: l_next_row_id NUMBER;
10363: l_row_attrs_table EGO_USER_ATTR_DATA_TABLE;
10364: l_data_level_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
10365: l_current_row_change_obj EGO_USER_ATTR_CHANGE_OBJ;
10366: l_return_status VARCHAR2(1);
10367: l_errorcode NUMBER;

Line 10462: l_row_attrs_table := EGO_USER_ATTR_DATA_TABLE();

10458: -----------------------------------------------------------
10459: -- Either make a new table or clear out the existing one --
10460: -----------------------------------------------------------
10461: IF (l_row_attrs_table IS NULL) THEN
10462: l_row_attrs_table := EGO_USER_ATTR_DATA_TABLE();
10463: ELSE
10464: l_row_attrs_table.DELETE();
10465: END IF;
10466:

Line 11212: ,x_attributes_data_table OUT NOCOPY EGO_USER_ATTR_DATA_TABLE

11208: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
11209: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
11210: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
11211: ,x_attributes_row_table OUT NOCOPY EGO_USER_ATTR_ROW_TABLE
11212: ,x_attributes_data_table OUT NOCOPY EGO_USER_ATTR_DATA_TABLE
11213: ,x_return_status OUT NOCOPY VARCHAR2
11214: ,x_errorcode OUT NOCOPY NUMBER
11215: ,x_msg_count OUT NOCOPY NUMBER
11216: ,x_msg_data OUT NOCOPY VARCHAR2

Line 12165: x_attributes_data_table := EGO_USER_ATTR_DATA_TABLE();

12161: -- in our case is l_extension_id) to find a row --
12162: -- object for any data object. --
12163: -----------------------------------------------------
12164: IF (x_attributes_data_table IS NULL) THEN
12165: x_attributes_data_table := EGO_USER_ATTR_DATA_TABLE();
12166: END IF;
12167:
12168: x_attributes_data_table.EXTEND();
12169: x_attributes_data_table(x_attributes_data_table.LAST) :=

Line 12333: ,p_attr_name_value_pairs IN EGO_USER_ATTR_DATA_TABLE

12329: ,p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
12330: ,p_data_level IN VARCHAR2 DEFAULT NULL --R12C
12331: ,p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
12332: ,p_extension_id IN NUMBER DEFAULT NULL
12333: ,p_attr_name_value_pairs IN EGO_USER_ATTR_DATA_TABLE
12334: ,p_entity_id IN NUMBER DEFAULT NULL
12335: ,p_entity_index IN NUMBER DEFAULT NULL
12336: ,p_entity_code IN VARCHAR2 DEFAULT NULL
12337: ,p_validate_only IN VARCHAR2 DEFAULT FND_API.G_FALSE

Line 12409: ,p_attr_name_value_pairs IN EGO_USER_ATTR_DATA_TABLE

12405: ,p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
12406: ,p_data_level IN VARCHAR2 DEFAULT NULL --R12C
12407: ,p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
12408: ,p_extension_id IN NUMBER DEFAULT NULL
12409: ,p_attr_name_value_pairs IN EGO_USER_ATTR_DATA_TABLE
12410: ,p_entity_id IN NUMBER DEFAULT NULL
12411: ,p_entity_index IN NUMBER DEFAULT NULL
12412: ,p_entity_code IN VARCHAR2 DEFAULT NULL
12413: ,p_validate_only IN VARCHAR2 DEFAULT FND_API.G_FALSE

Line 12440: l_attr_name_value_pairs EGO_USER_ATTR_DATA_TABLE;

12436: --if we change optional parameters, version goes FROM x.n to x.(n+1)
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);

Line 12691: ,p_attr_name_value_pairs IN EGO_USER_ATTR_DATA_TABLE

12687: ,p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
12688: ,p_data_level IN VARCHAR2 DEFAULT NULL --R12C
12689: ,p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
12690: ,p_extension_id IN NUMBER DEFAULT NULL
12691: ,p_attr_name_value_pairs IN EGO_USER_ATTR_DATA_TABLE
12692: ,p_entity_id IN NUMBER DEFAULT NULL
12693: ,p_entity_index IN NUMBER DEFAULT NULL
12694: ,p_entity_code IN VARCHAR2 DEFAULT NULL
12695: ,p_mode IN VARCHAR2 DEFAULT G_SYNC_MODE

Line 12715: l_attr_name_value_pairs EGO_USER_ATTR_DATA_TABLE;

12711: --if we change optional parameters, version goes FROM x.n to x.(n+1)
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);

Line 12902: ,p_attr_name_value_pairs IN EGO_USER_ATTR_DATA_TABLE

12898: ,p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
12899: ,p_data_level IN VARCHAR2 DEFAULT NULL --R12C
12900: ,p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
12901: ,p_extension_id IN NUMBER DEFAULT NULL
12902: ,p_attr_name_value_pairs IN EGO_USER_ATTR_DATA_TABLE
12903: ,p_mode IN VARCHAR2 DEFAULT G_SYNC_MODE
12904: ,p_extra_pk_col_name_val_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
12905: ,p_extra_attr_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
12906: ,p_alternate_ext_b_table_name IN VARCHAR2 DEFAULT NULL

Line 12930: ,x_b_bind_attr_table OUT NOCOPY EGO_USER_ATTR_DATA_TABLE

12926: ,x_b_dml_for_ag OUT NOCOPY VARCHAR2
12927: ,x_tl_dml_for_ag OUT NOCOPY VARCHAR2
12928: ,x_b_bind_count OUT NOCOPY NUMBER
12929: ,x_tl_bind_count OUT NOCOPY NUMBER
12930: ,x_b_bind_attr_table OUT NOCOPY EGO_USER_ATTR_DATA_TABLE
12931: ,x_tl_bind_attr_table OUT NOCOPY EGO_USER_ATTR_DATA_TABLE
12932: ) IS
12933:
12934: l_api_name CONSTANT VARCHAR2(30) := 'Generate_DML_For_Row';

Line 12931: ,x_tl_bind_attr_table OUT NOCOPY EGO_USER_ATTR_DATA_TABLE

12927: ,x_tl_dml_for_ag OUT NOCOPY VARCHAR2
12928: ,x_b_bind_count OUT NOCOPY NUMBER
12929: ,x_tl_bind_count OUT NOCOPY NUMBER
12930: ,x_b_bind_attr_table OUT NOCOPY EGO_USER_ATTR_DATA_TABLE
12931: ,x_tl_bind_attr_table OUT NOCOPY EGO_USER_ATTR_DATA_TABLE
12932: ) IS
12933:
12934: l_api_name CONSTANT VARCHAR2(30) := 'Generate_DML_For_Row';
12935:

Line 12942: l_attr_name_value_pairs EGO_USER_ATTR_DATA_TABLE;

12938: --if we change optional parameters, version goes FROM x.n to x.(n+1)
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);

Line 12948: l_b_dml_bind_list EGO_USER_ATTR_DATA_TABLE;

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;
12949: l_tl_dml_bind_list EGO_USER_ATTR_DATA_TABLE;
12950: l_bind_name VARCHAR2(100);
12951:
12952: BEGIN

Line 12949: l_tl_dml_bind_list EGO_USER_ATTR_DATA_TABLE;

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;
12949: l_tl_dml_bind_list EGO_USER_ATTR_DATA_TABLE;
12950: l_bind_name VARCHAR2(100);
12951:
12952: BEGIN
12953:

Line 13070: l_b_dml_bind_list := EGO_USER_ATTR_DATA_TABLE();

13066: x_tl_dml_for_ag := G_TL_TABLE_DML;
13067: x_b_bind_count := G_B_BIND_INDEX;
13068: x_tl_bind_count := G_TL_BIND_INDEX;
13069:
13070: l_b_dml_bind_list := EGO_USER_ATTR_DATA_TABLE();
13071: l_tl_dml_bind_list := EGO_USER_ATTR_DATA_TABLE();
13072:
13073: FOR i in 1 .. G_B_BIND_INDEX
13074: LOOP

Line 13071: l_tl_dml_bind_list := EGO_USER_ATTR_DATA_TABLE();

13067: x_b_bind_count := G_B_BIND_INDEX;
13068: x_tl_bind_count := G_TL_BIND_INDEX;
13069:
13070: l_b_dml_bind_list := EGO_USER_ATTR_DATA_TABLE();
13071: l_tl_dml_bind_list := EGO_USER_ATTR_DATA_TABLE();
13072:
13073: FOR i in 1 .. G_B_BIND_INDEX
13074: LOOP
13075:

Line 13206: ,p_attr_name_value_pairs IN EGO_USER_ATTR_DATA_TABLE

13202: ,p_attr_group_name IN VARCHAR2 DEFAULT NULL
13203: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
13204: ,p_data_level IN VARCHAR2 DEFAULT NULL --R12C
13205: ,p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
13206: ,p_attr_name_value_pairs IN EGO_USER_ATTR_DATA_TABLE
13207: ,p_extra_pk_col_name_val_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
13208: ,p_extra_attr_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
13209: ,p_alternate_ext_b_table_name IN VARCHAR2 DEFAULT NULL
13210: ,p_alternate_ext_tl_table_name IN VARCHAR2 DEFAULT NULL

Line 13215: l_attr_name_value_pairs EGO_USER_ATTR_DATA_TABLE;

13211: ,p_alternate_ext_vl_name IN VARCHAR2 DEFAULT NULL
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;

Line 13280: ,p_attr_name_value_pairs IN EGO_USER_ATTR_DATA_TABLE

13276: ,p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
13277: ,p_data_level IN VARCHAR2 DEFAULT NULL --R12C
13278: ,p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
13279: ,p_extension_id IN NUMBER DEFAULT NULL
13280: ,p_attr_name_value_pairs IN EGO_USER_ATTR_DATA_TABLE
13281: ,p_mode IN VARCHAR2 DEFAULT G_SYNC_MODE
13282: ,p_change_obj IN EGO_USER_ATTR_CHANGE_OBJ DEFAULT NULL
13283: ,p_pending_b_table_name IN VARCHAR2 DEFAULT NULL
13284: ,p_pending_tl_table_name IN VARCHAR2 DEFAULT NULL

Line 13363: ,p_attr_name_value_pairs IN EGO_USER_ATTR_DATA_TABLE

13359: ,p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
13360: ,p_data_level IN VARCHAR2 DEFAULT NULL --R12C
13361: ,p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
13362: ,p_extension_id IN NUMBER DEFAULT NULL
13363: ,p_attr_name_value_pairs IN EGO_USER_ATTR_DATA_TABLE
13364: ,p_mode IN VARCHAR2 DEFAULT G_SYNC_MODE
13365: ,p_change_obj IN EGO_USER_ATTR_CHANGE_OBJ DEFAULT NULL
13366: ,p_pending_b_table_name IN VARCHAR2 DEFAULT NULL
13367: ,p_pending_tl_table_name IN VARCHAR2 DEFAULT NULL

Line 13400: l_attr_name_value_pairs EGO_USER_ATTR_DATA_TABLE;

13396: --if we change optional parameters, version goes FROM x.n to x.(n+1)
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);

Line 13637: l_attr_name_value_pairs EGO_USER_ATTR_DATA_TABLE;

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);
13640: l_attr_group_ids_to_exclude VARCHAR2(16000);
13641: l_attr_group_id NUMBER;

Line 13960: l_attr_name_value_pairs := EGO_USER_ATTR_DATA_TABLE();

13956:
13957: l_row_index := l_row_index + 1;
13958:
13959: IF (l_prev_loop_row_number IS NULL) THEN
13960: l_attr_name_value_pairs := EGO_USER_ATTR_DATA_TABLE();
13961: ELSE
13962:
13963: --Start Bug 5211171
13964: /***

Line 15068: l_attr_name_value_pairs EGO_USER_ATTR_DATA_TABLE := EGO_USER_ATTR_DATA_TABLE();

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;
15070: l_uom_nv_pairs_index NUMBER := 0;
15071: l_current_uom_col_nv_obj EGO_COL_NAME_VALUE_PAIR_OBJ;
15072: l_attr_col_name_for_uom_col VARCHAR2(30);

Line 16323: l_attr_name_value_pairs EGO_USER_ATTR_DATA_TABLE;

16319: l_attr_int_value VARCHAR2(4000); -- Bug 8757354
16320: l_attr_disp_value VARCHAR2(4000); -- Bug 8757354
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;

Line 16579: l_attr_name_value_pairs := EGO_USER_ATTR_DATA_TABLE();

16575: ------------------------------------------------------------
16576: -- We must query up the rest of the attribute data in the --
16577: -- same group in case there are binds --
16578: ------------------------------------------------------------
16579: l_attr_name_value_pairs := EGO_USER_ATTR_DATA_TABLE();
16580:
16581: l_attr_counter := l_attr_metadata_table.FIRST();
16582: WHILE (l_attr_counter IS NOT NULL)
16583: LOOP

Line 16772: l_old_attr_name_value_pairs EGO_USER_ATTR_DATA_TABLE;

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);
16775: l_return_status VARCHAR2(1);
16776: l_row_identifier NUMBER;

Line 16773: l_new_attr_name_value_pairs EGO_USER_ATTR_DATA_TABLE;

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);
16775: l_return_status VARCHAR2(1);
16776: l_row_identifier NUMBER;
16777: l_max_row_identifier NUMBER;

Line 16930: l_attr_name_value_pairs EGO_USER_ATTR_DATA_TABLE;

16926: , px_attr_diffs IN OUT NOCOPY EGO_USER_ATTR_DIFF_TABLE
16927: , x_error_message OUT NOCOPY VARCHAR2
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;

Line 16956: l_attr_name_value_pairs := EGO_USER_ATTR_DATA_TABLE();

16952:
16953: l_attr_metadata_obj := l_attr_group_metadata_obj.attr_metadata_table(i);
16954:
16955: IF (l_attr_name_value_pairs IS NULL) THEN
16956: l_attr_name_value_pairs := EGO_USER_ATTR_DATA_TABLE();
16957: END IF;
16958:
16959: -- add all attributes to the name_value pairs table, to pass into Get_Change_Attrs
16960: l_attr_name_value_pairs.EXTEND();

Line 17655: l_attributes_data_table EGO_USER_ATTR_DATA_TABLE;

17651: ) IS
17652:
17653: l_api_name VARCHAR2(30) := 'Build_Request_Table_For_Obj';
17654: l_attributes_row_table EGO_USER_ATTR_ROW_TABLE;
17655: l_attributes_data_table EGO_USER_ATTR_DATA_TABLE;
17656: l_data_level_obj EGO_COL_NAME_VALUE_PAIR_OBJ;
17657: l_data_level_index NUMBER;
17658: l_class_code_table LOCAL_MEDIUM_VARCHAR_TABLE;
17659: l_attr_group_id ego_obj_ag_assocs_b.attr_group_id%TYPE;

Line 17850: ,p_attributes_data_table IN EGO_USER_ATTR_DATA_TABLE

17846:
17847: PROCEDURE Process_Req_Attr_Results(
17848: p_request_table IN EGO_ATTR_GROUP_REQUEST_TABLE
17849: ,p_attributes_row_table IN EGO_USER_ATTR_ROW_TABLE
17850: ,p_attributes_data_table IN EGO_USER_ATTR_DATA_TABLE
17851: ,px_attributes_req_table IN OUT NOCOPY EGO_USER_ATTR_TABLE
17852: ) IS
17853: l_has_value BOOLEAN;
17854: l_ix NUMBER;

Line 18021: l_attributes_data_table EGO_USER_ATTR_DATA_TABLE;

18017: )IS
18018: l_api_name CONSTANT VARCHAR2(30) := 'Validate_Required_Attrs';
18019: l_batch_size CONSTANT NUMBER := 5;
18020: l_attributes_row_table EGO_USER_ATTR_ROW_TABLE;
18021: l_attributes_data_table EGO_USER_ATTR_DATA_TABLE;
18022: l_request_table EGO_ATTR_GROUP_REQUEST_TABLE;
18023: -- request table for ALL attribute groups of the object
18024: l_request_table_batch_iter EGO_ATTR_GROUP_REQUEST_TABLE;
18025: -- request table for one batch of attribute groups

Line 18329: l_attr_data_table EGO_USER_ATTR_DATA_TABLE;

18325: l_number_val NUMBER;
18326: l_str_val VARCHAR2(4000); -- Bug 8757354
18327: l_date_val DATE;
18328: l_attr_row_table EGO_USER_ATTR_ROW_TABLE;
18329: l_attr_data_table EGO_USER_ATTR_DATA_TABLE;
18330: l_transaction_type VARCHAR2(10);
18331: l_temp_date_str VARCHAR2(200);
18332: l_temp_attr_row_table EGO_USER_ATTR_ROW_TABLE;
18333: l_temp_attr_data_table EGO_USER_ATTR_DATA_TABLE;

Line 18333: l_temp_attr_data_table EGO_USER_ATTR_DATA_TABLE;

18329: l_attr_data_table EGO_USER_ATTR_DATA_TABLE;
18330: l_transaction_type VARCHAR2(10);
18331: l_temp_date_str VARCHAR2(200);
18332: l_temp_attr_row_table EGO_USER_ATTR_ROW_TABLE;
18333: l_temp_attr_data_table EGO_USER_ATTR_DATA_TABLE;
18334: l_cc_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
18335: l_has_data_level_id BOOLEAN;
18336: l_data_level_id NUMBER;
18337:

Line 18565: l_attr_data_table := EGO_USER_ATTR_DATA_TABLE();

18561: l_counter1 := 0;
18562: l_counter2 := 0;
18563:
18564: l_attr_row_table := EGO_USER_ATTR_ROW_TABLE();
18565: l_attr_data_table := EGO_USER_ATTR_DATA_TABLE();
18566: l_temp_attr_row_table := EGO_USER_ATTR_ROW_TABLE();
18567: l_temp_attr_data_table := EGO_USER_ATTR_DATA_TABLE();
18568:
18569: Debug_Msg(l_api_name ||' attr rec cursor: '||l_dynamic_sql);

Line 18567: l_temp_attr_data_table := EGO_USER_ATTR_DATA_TABLE();

18563:
18564: l_attr_row_table := EGO_USER_ATTR_ROW_TABLE();
18565: l_attr_data_table := EGO_USER_ATTR_DATA_TABLE();
18566: l_temp_attr_row_table := EGO_USER_ATTR_ROW_TABLE();
18567: l_temp_attr_data_table := EGO_USER_ATTR_DATA_TABLE();
18568:
18569: Debug_Msg(l_api_name ||' attr rec cursor: '||l_dynamic_sql);
18570: Debug_Msg(l_api_name ||' binds are 1: '|| p_application_id ||' 2: '|| p_attr_group_type||
18571: ' 3: '||p_attr_group_type ||' 4: '||p_application_id ||' 5: '||l_object_id ||