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 390: p_attr_name_value_pairs IN EGO_USER_ATTR_DATA_TABLE

386: -- Private
387: -- To Check whether the attribute is null or not
388: --
389: FUNCTION All_Attr_Values_Are_Null (
390: p_attr_name_value_pairs IN EGO_USER_ATTR_DATA_TABLE
391: )
392: RETURN BOOLEAN
393: IS
394:

Line 632: ,p_attr_name_value_pairs IN EGO_USER_ATTR_DATA_TABLE

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
633: ,p_extension_id IN NUMBER DEFAULT NULL
634: ,p_entity_id IN NUMBER DEFAULT NULL
635: ,p_entity_index IN NUMBER DEFAULT NULL
636: ,p_entity_code IN VARCHAR2 DEFAULT NULL

Line 1250: , px_attr_data_tbl IN OUT NOCOPY EGO_USER_ATTR_DATA_TABLE

1246: -- Private
1247: --
1248: PROCEDURE Convert_Attr_Diff_To_Data (
1249: p_attr_diff_tbl IN EGO_USER_ATTR_DIFF_TABLE
1250: , px_attr_data_tbl IN OUT NOCOPY EGO_USER_ATTR_DATA_TABLE
1251: , p_true_if_new IN BOOLEAN := TRUE
1252: -- px_is_delete returns true if this diff object contains a delete operation
1253: , px_is_delete OUT NOCOPY BOOLEAN
1254: , x_error_message OUT NOCOPY VARCHAR2

Line 1271: px_attr_data_tbl := EGO_USER_ATTR_DATA_TABLE();

1267: FOR i IN p_attr_diff_tbl.FIRST..p_attr_diff_tbl.LAST LOOP
1268:
1269: IF px_attr_data_tbl IS NULL THEN
1270: Debug_Msg('In Convert_Attr_Diff_To_Data, px_attr_data_tbl is NULL', 1);
1271: px_attr_data_tbl := EGO_USER_ATTR_DATA_TABLE();
1272: END IF;
1273:
1274: -- Set row identifier based on previous contents of diff table
1275: l_row_identifier := 1;

Line 1347: p_attributes_data_table IN EGO_USER_ATTR_DATA_TABLE

1343: --
1344: -- Private
1345: --
1346: FUNCTION Build_Sorted_Data_Table (
1347: p_attributes_data_table IN EGO_USER_ATTR_DATA_TABLE
1348: )
1349: RETURN LOCAL_USER_ATTR_DATA_TABLE
1350: IS
1351:

Line 1728: p_attr_name_value_pairs IN EGO_USER_ATTR_DATA_TABLE

1724: --
1725: -- Private
1726: --
1727: FUNCTION Find_Name_Value_Pair_For_Attr (
1728: p_attr_name_value_pairs IN EGO_USER_ATTR_DATA_TABLE
1729: ,p_attr_name IN VARCHAR2
1730: )
1731: RETURN EGO_USER_ATTR_DATA_OBJ
1732: IS

Line 1842: ,p_attr_name_value_pairs IN EGO_USER_ATTR_DATA_TABLE

1838: -- 'UNIQUE_KEY': processes passed-in Attributes whose UNIQUE_KEY flag is 'Y'
1839:
1840: PROCEDURE Add_Attr_Info_To_Statement (
1841: p_attr_metadata_table IN EGO_ATTR_METADATA_TABLE
1842: ,p_attr_name_value_pairs IN EGO_USER_ATTR_DATA_TABLE
1843: ,p_separator IN VARCHAR2
1844: ,p_mode IN VARCHAR2
1845: ,p_which_attrs IN VARCHAR2
1846: ) IS

Line 2156: ,p_attr_name_value_pairs IN EGO_USER_ATTR_DATA_TABLE DEFAULT NULL

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
2156: ,p_attr_name_value_pairs IN EGO_USER_ATTR_DATA_TABLE DEFAULT NULL
2157: ) IS
2158:
2159: l_api_name VARCHAR2(30) := 'Build_Where_Clause';
2160: l_pk_col_string VARCHAR2(1000) := '';

Line 2249: ,px_attr_name_value_pairs IN OUT NOCOPY EGO_USER_ATTR_DATA_TABLE

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

Line 2319: ,p_attr_name_value_pairs IN EGO_USER_ATTR_DATA_TABLE

2315: ,p_entity_id IN VARCHAR2
2316: ,p_entity_index IN NUMBER
2317: ,p_entity_code IN VARCHAR2
2318: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
2319: ,p_attr_name_value_pairs IN EGO_USER_ATTR_DATA_TABLE
2320: ,p_is_disp_to_int_query IN BOOLEAN
2321: ,p_final_bind_value IN VARCHAR2
2322: ,p_return_bound_sql IN BOOLEAN DEFAULT FALSE
2323: )

Line 2698: ,p_attr_name_value_pairs IN EGO_USER_ATTR_DATA_TABLE

2694: ,p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
2695: ,p_entity_id IN VARCHAR2
2696: ,p_entity_index IN NUMBER
2697: ,p_entity_code IN VARCHAR2
2698: ,p_attr_name_value_pairs IN EGO_USER_ATTR_DATA_TABLE
2699: )
2700: RETURN VARCHAR2
2701: IS
2702:

Line 2806: ,p_attr_name_value_pairs IN EGO_USER_ATTR_DATA_TABLE DEFAULT NULL

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
2805: ,p_entity_code IN VARCHAR2 DEFAULT NULL
2806: ,p_attr_name_value_pairs IN EGO_USER_ATTR_DATA_TABLE DEFAULT NULL
2807: ,p_ext_table_metadata_obj IN EGO_EXT_TABLE_METADATA_OBJ DEFAULT NULL
2808: ,p_object_name IN VARCHAR2 DEFAULT NULL
2809: )
2810: RETURN VARCHAR2

Line 2935: ,p_attr_name_value_pairs IN EGO_USER_ATTR_DATA_TABLE

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
2935: ,p_attr_name_value_pairs IN EGO_USER_ATTR_DATA_TABLE
2936: ,p_change_obj IN EGO_USER_ATTR_CHANGE_OBJ DEFAULT NULL
2937: ,p_extra_pk_col_name_val_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
2938: ,p_pending_b_table_name IN VARCHAR2 DEFAULT NULL
2939: ,p_pending_vl_name IN VARCHAR2 DEFAULT NULL

Line 3144: ,p_attr_name_value_pairs IN EGO_USER_ATTR_DATA_TABLE

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

Line 3357: ,p_attr_name_value_pairs IN EGO_USER_ATTR_DATA_TABLE

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
3361: ) IS

Line 3488: ,p_attr_name_value_pairs IN EGO_USER_ATTR_DATA_TABLE

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
3488: ,p_attr_name_value_pairs IN EGO_USER_ATTR_DATA_TABLE
3489: ,p_extension_id IN NUMBER DEFAULT NULL
3490: ,p_mode IN VARCHAR2 DEFAULT NULL
3491: ,p_change_obj IN EGO_USER_ATTR_CHANGE_OBJ DEFAULT NULL
3492: ,p_extra_pk_col_name_val_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL

Line 3943: ,p_attr_name_value_pairs IN EGO_USER_ATTR_DATA_TABLE

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

Line 4973: ,p_attr_name_value_pairs IN EGO_USER_ATTR_DATA_TABLE

4969: ,p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
4970: ,p_entity_id IN VARCHAR2
4971: ,p_entity_index IN NUMBER
4972: ,p_entity_code IN VARCHAR2
4973: ,p_attr_name_value_pairs IN EGO_USER_ATTR_DATA_TABLE
4974: ,px_attr_value_obj IN OUT NOCOPY EGO_USER_ATTR_DATA_OBJ
4975: )
4976: RETURN BOOLEAN
4977: IS

Line 5221: ,px_attr_name_value_pairs IN OUT NOCOPY EGO_USER_ATTR_DATA_TABLE

5217: ,p_entity_id IN VARCHAR2
5218: ,p_entity_index IN NUMBER
5219: ,p_entity_code IN VARCHAR2
5220: ,p_attr_group_disp_name IN VARCHAR2
5221: ,px_attr_name_value_pairs IN OUT NOCOPY EGO_USER_ATTR_DATA_TABLE
5222: )
5223: RETURN BOOLEAN
5224: IS
5225:

Line 5456: ,px_attr_name_value_pairs IN OUT NOCOPY EGO_USER_ATTR_DATA_TABLE

5452: ,p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
5453: ,p_entity_id IN VARCHAR2 DEFAULT NULL
5454: ,p_entity_index IN NUMBER DEFAULT NULL
5455: ,p_entity_code IN VARCHAR2 DEFAULT NULL
5456: ,px_attr_name_value_pairs IN OUT NOCOPY EGO_USER_ATTR_DATA_TABLE
5457: ,x_return_status OUT NOCOPY VARCHAR2
5458: ) IS
5459:
5460: l_token_table ERROR_HANDLER.Token_Tbl_Type;

Line 6766: ,p_attr_name_value_pairs IN EGO_USER_ATTR_DATA_TABLE

6762: ,p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
6763: ,p_data_level IN VARCHAR2 DEFAULT NULL --R12C
6764: ,p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
6765: ,p_extension_id IN NUMBER
6766: ,p_attr_name_value_pairs IN EGO_USER_ATTR_DATA_TABLE
6767: ,p_language_to_process IN VARCHAR2
6768: ,p_change_obj IN EGO_USER_ATTR_CHANGE_OBJ
6769: ,p_extra_pk_col_name_val_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
6770: ,p_extra_attr_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL

Line 7634: ,p_attr_name_value_pairs IN EGO_USER_ATTR_DATA_TABLE

7630: ,p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
7631: ,p_data_level IN VARCHAR2 DEFAULT NULL --R12C
7632: ,p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
7633: ,p_extension_id IN NUMBER
7634: ,p_attr_name_value_pairs IN EGO_USER_ATTR_DATA_TABLE
7635: ,p_language_to_process IN VARCHAR2
7636: ,p_change_obj IN EGO_USER_ATTR_CHANGE_OBJ
7637: ,p_extra_attr_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
7638: ,p_extra_pk_col_name_val_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL

Line 8255: ,p_attr_name_value_pairs IN EGO_USER_ATTR_DATA_TABLE

8251: ,p_data_level IN VARCHAR2 DEFAULT NULL --R12C
8252: ,p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
8253: ,p_extension_id IN NUMBER
8254: -- Start ssingal -For Ucc Net Attribute Propagation
8255: ,p_attr_name_value_pairs IN EGO_USER_ATTR_DATA_TABLE
8256: ,p_ext_table_metadata_obj IN EGO_EXT_TABLE_METADATA_OBJ
8257: -- End ssingal
8258: ,p_language_to_process IN VARCHAR2
8259: ,p_change_obj IN EGO_USER_ATTR_CHANGE_OBJ

Line 8602: ,px_attr_name_value_pairs IN OUT NOCOPY EGO_USER_ATTR_DATA_TABLE

8598: ,p_mode IN VARCHAR2
8599: ,p_entity_id IN VARCHAR2 DEFAULT NULL
8600: ,p_entity_index IN NUMBER DEFAULT NULL
8601: ,p_entity_code IN VARCHAR2 DEFAULT NULL
8602: ,px_attr_name_value_pairs IN OUT NOCOPY EGO_USER_ATTR_DATA_TABLE
8603: ,x_return_status OUT NOCOPY VARCHAR2
8604: ) IS
8605:
8606: l_api_name CONSTANT VARCHAR2(30) := 'Validate_Row_Pvt';

Line 9057: ,p_attr_name_value_pairs IN EGO_USER_ATTR_DATA_TABLE

9053: ,p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
9054: ,p_data_level IN VARCHAR2 DEFAULT NULL --R12C
9055: ,p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
9056: ,p_extension_id IN NUMBER
9057: ,p_attr_name_value_pairs IN EGO_USER_ATTR_DATA_TABLE
9058: ,p_language_to_process IN VARCHAR2 DEFAULT NULL
9059: ,p_mode IN VARCHAR2
9060: ,p_change_obj IN EGO_USER_ATTR_CHANGE_OBJ DEFAULT NULL
9061: ,p_extra_pk_col_name_val_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL

Line 9255: ,px_attr_name_value_pairs IN OUT NOCOPY EGO_USER_ATTR_DATA_TABLE

9251: ,p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
9252: ,p_data_level IN VARCHAR2
9253: ,p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
9254: ,p_commit IN VARCHAR2
9255: ,px_attr_name_value_pairs IN OUT NOCOPY EGO_USER_ATTR_DATA_TABLE
9256: ) IS
9257:
9258: l_api_name VARCHAR2(50) := 'Perform_DML_On_Template_Row';
9259: l_extension_id NUMBER;

Line 9391: ,px_attr_name_value_pairs IN OUT NOCOPY EGO_USER_ATTR_DATA_TABLE

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

Line 9666: ,p_attributes_data_table IN EGO_USER_ATTR_DATA_TABLE

9662: PROCEDURE Process_User_Attrs_Data (
9663: p_api_version IN NUMBER
9664: ,p_object_name IN VARCHAR2
9665: ,p_attributes_row_table IN EGO_USER_ATTR_ROW_TABLE
9666: ,p_attributes_data_table IN EGO_USER_ATTR_DATA_TABLE
9667: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
9668: ,p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
9669: ,p_user_privileges_on_object IN EGO_VARCHAR_TBL_TYPE DEFAULT NULL
9670: ,p_change_info_table IN EGO_USER_ATTR_CHANGE_TABLE DEFAULT NULL

Line 9736: ,p_attributes_data_table IN EGO_USER_ATTR_DATA_TABLE

9732: PROCEDURE Process_User_Attrs_Data (
9733: p_api_version IN NUMBER
9734: ,p_object_name IN VARCHAR2
9735: ,p_attributes_row_table IN EGO_USER_ATTR_ROW_TABLE
9736: ,p_attributes_data_table IN EGO_USER_ATTR_DATA_TABLE
9737: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
9738: ,p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
9739: ,p_user_privileges_on_object IN EGO_VARCHAR_TBL_TYPE DEFAULT NULL
9740: ,p_change_info_table IN EGO_USER_ATTR_CHANGE_TABLE DEFAULT NULL

Line 9783: l_row_attrs_table EGO_USER_ATTR_DATA_TABLE;

9779: l_sorted_data_table_index NUMBER;
9780: l_got_all_attrs_for_this_row BOOLEAN := FALSE;
9781: l_current_data_element EGO_USER_ATTR_DATA_OBJ;
9782: l_next_row_id NUMBER;
9783: l_row_attrs_table EGO_USER_ATTR_DATA_TABLE;
9784: l_data_level_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
9785: l_current_row_change_obj EGO_USER_ATTR_CHANGE_OBJ;
9786: l_return_status VARCHAR2(1);
9787: l_errorcode NUMBER;

Line 9882: l_row_attrs_table := EGO_USER_ATTR_DATA_TABLE();

9878: -----------------------------------------------------------
9879: -- Either make a new table or clear out the existing one --
9880: -----------------------------------------------------------
9881: IF (l_row_attrs_table IS NULL) THEN
9882: l_row_attrs_table := EGO_USER_ATTR_DATA_TABLE();
9883: ELSE
9884: l_row_attrs_table.DELETE();
9885: END IF;
9886:

Line 10183: ,x_attributes_data_table OUT NOCOPY EGO_USER_ATTR_DATA_TABLE

10179: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
10180: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
10181: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
10182: ,x_attributes_row_table OUT NOCOPY EGO_USER_ATTR_ROW_TABLE
10183: ,x_attributes_data_table OUT NOCOPY EGO_USER_ATTR_DATA_TABLE
10184: ,x_return_status OUT NOCOPY VARCHAR2
10185: ,x_errorcode OUT NOCOPY NUMBER
10186: ,x_msg_count OUT NOCOPY NUMBER
10187: ,x_msg_data OUT NOCOPY VARCHAR2

Line 11146: x_attributes_data_table := EGO_USER_ATTR_DATA_TABLE();

11142: -- in our case is l_extension_id) to find a row --
11143: -- object for any data object. --
11144: -----------------------------------------------------
11145: IF (x_attributes_data_table IS NULL) THEN
11146: x_attributes_data_table := EGO_USER_ATTR_DATA_TABLE();
11147: END IF;
11148:
11149: x_attributes_data_table.EXTEND();
11150: x_attributes_data_table(x_attributes_data_table.LAST) :=

Line 11314: ,p_attr_name_value_pairs IN EGO_USER_ATTR_DATA_TABLE

11310: ,p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
11311: ,p_data_level IN VARCHAR2 DEFAULT NULL --R12C
11312: ,p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
11313: ,p_extension_id IN NUMBER DEFAULT NULL
11314: ,p_attr_name_value_pairs IN EGO_USER_ATTR_DATA_TABLE
11315: ,p_entity_id IN NUMBER DEFAULT NULL
11316: ,p_entity_index IN NUMBER DEFAULT NULL
11317: ,p_entity_code IN VARCHAR2 DEFAULT NULL
11318: ,p_validate_only IN VARCHAR2 DEFAULT FND_API.G_FALSE

Line 11389: ,p_attr_name_value_pairs IN EGO_USER_ATTR_DATA_TABLE

11385: ,p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
11386: ,p_data_level IN VARCHAR2 DEFAULT NULL --R12C
11387: ,p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
11388: ,p_extension_id IN NUMBER DEFAULT NULL
11389: ,p_attr_name_value_pairs IN EGO_USER_ATTR_DATA_TABLE
11390: ,p_entity_id IN NUMBER DEFAULT NULL
11391: ,p_entity_index IN NUMBER DEFAULT NULL
11392: ,p_entity_code IN VARCHAR2 DEFAULT NULL
11393: ,p_validate_only IN VARCHAR2 DEFAULT FND_API.G_FALSE

Line 11420: l_attr_name_value_pairs EGO_USER_ATTR_DATA_TABLE;

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

Line 11671: ,p_attr_name_value_pairs IN EGO_USER_ATTR_DATA_TABLE

11667: ,p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
11668: ,p_data_level IN VARCHAR2 DEFAULT NULL --R12C
11669: ,p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
11670: ,p_extension_id IN NUMBER DEFAULT NULL
11671: ,p_attr_name_value_pairs IN EGO_USER_ATTR_DATA_TABLE
11672: ,p_entity_id IN NUMBER DEFAULT NULL
11673: ,p_entity_index IN NUMBER DEFAULT NULL
11674: ,p_entity_code IN VARCHAR2 DEFAULT NULL
11675: ,p_mode IN VARCHAR2 DEFAULT G_SYNC_MODE

Line 11695: l_attr_name_value_pairs EGO_USER_ATTR_DATA_TABLE;

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

Line 11882: ,p_attr_name_value_pairs IN EGO_USER_ATTR_DATA_TABLE

11878: ,p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
11879: ,p_data_level IN VARCHAR2 DEFAULT NULL --R12C
11880: ,p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
11881: ,p_extension_id IN NUMBER DEFAULT NULL
11882: ,p_attr_name_value_pairs IN EGO_USER_ATTR_DATA_TABLE
11883: ,p_mode IN VARCHAR2 DEFAULT G_SYNC_MODE
11884: ,p_extra_pk_col_name_val_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
11885: ,p_extra_attr_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
11886: ,p_alternate_ext_b_table_name IN VARCHAR2 DEFAULT NULL

Line 11910: ,x_b_bind_attr_table OUT NOCOPY EGO_USER_ATTR_DATA_TABLE

11906: ,x_b_dml_for_ag OUT NOCOPY VARCHAR2
11907: ,x_tl_dml_for_ag OUT NOCOPY VARCHAR2
11908: ,x_b_bind_count OUT NOCOPY NUMBER
11909: ,x_tl_bind_count OUT NOCOPY NUMBER
11910: ,x_b_bind_attr_table OUT NOCOPY EGO_USER_ATTR_DATA_TABLE
11911: ,x_tl_bind_attr_table OUT NOCOPY EGO_USER_ATTR_DATA_TABLE
11912: ) IS
11913:
11914: l_api_name CONSTANT VARCHAR2(30) := 'Generate_DML_For_Row';

Line 11911: ,x_tl_bind_attr_table OUT NOCOPY EGO_USER_ATTR_DATA_TABLE

11907: ,x_tl_dml_for_ag OUT NOCOPY VARCHAR2
11908: ,x_b_bind_count OUT NOCOPY NUMBER
11909: ,x_tl_bind_count OUT NOCOPY NUMBER
11910: ,x_b_bind_attr_table OUT NOCOPY EGO_USER_ATTR_DATA_TABLE
11911: ,x_tl_bind_attr_table OUT NOCOPY EGO_USER_ATTR_DATA_TABLE
11912: ) IS
11913:
11914: l_api_name CONSTANT VARCHAR2(30) := 'Generate_DML_For_Row';
11915:

Line 11922: l_attr_name_value_pairs EGO_USER_ATTR_DATA_TABLE;

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

Line 11928: l_b_dml_bind_list EGO_USER_ATTR_DATA_TABLE;

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);
11928: l_b_dml_bind_list EGO_USER_ATTR_DATA_TABLE;
11929: l_tl_dml_bind_list EGO_USER_ATTR_DATA_TABLE;
11930: l_bind_name VARCHAR2(100);
11931:
11932: BEGIN

Line 11929: l_tl_dml_bind_list EGO_USER_ATTR_DATA_TABLE;

11925: l_extension_id NUMBER;
11926: l_mode VARCHAR2(10);
11927: l_dml VARCHAR2(32767);
11928: l_b_dml_bind_list EGO_USER_ATTR_DATA_TABLE;
11929: l_tl_dml_bind_list EGO_USER_ATTR_DATA_TABLE;
11930: l_bind_name VARCHAR2(100);
11931:
11932: BEGIN
11933:

Line 12050: l_b_dml_bind_list := EGO_USER_ATTR_DATA_TABLE();

12046: x_tl_dml_for_ag := G_TL_TABLE_DML;
12047: x_b_bind_count := G_B_BIND_INDEX;
12048: x_tl_bind_count := G_TL_BIND_INDEX;
12049:
12050: l_b_dml_bind_list := EGO_USER_ATTR_DATA_TABLE();
12051: l_tl_dml_bind_list := EGO_USER_ATTR_DATA_TABLE();
12052:
12053: FOR i in 1 .. G_B_BIND_INDEX
12054: LOOP

Line 12051: l_tl_dml_bind_list := EGO_USER_ATTR_DATA_TABLE();

12047: x_b_bind_count := G_B_BIND_INDEX;
12048: x_tl_bind_count := G_TL_BIND_INDEX;
12049:
12050: l_b_dml_bind_list := EGO_USER_ATTR_DATA_TABLE();
12051: l_tl_dml_bind_list := EGO_USER_ATTR_DATA_TABLE();
12052:
12053: FOR i in 1 .. G_B_BIND_INDEX
12054: LOOP
12055:

Line 12186: ,p_attr_name_value_pairs IN EGO_USER_ATTR_DATA_TABLE

12182: ,p_attr_group_name IN VARCHAR2 DEFAULT NULL
12183: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
12184: ,p_data_level IN VARCHAR2 DEFAULT NULL --R12C
12185: ,p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
12186: ,p_attr_name_value_pairs IN EGO_USER_ATTR_DATA_TABLE
12187: ,p_extra_pk_col_name_val_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
12188: ,p_extra_attr_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
12189: ,p_alternate_ext_b_table_name IN VARCHAR2 DEFAULT NULL
12190: ,p_alternate_ext_tl_table_name IN VARCHAR2 DEFAULT NULL

Line 12195: l_attr_name_value_pairs EGO_USER_ATTR_DATA_TABLE;

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

Line 12260: ,p_attr_name_value_pairs IN EGO_USER_ATTR_DATA_TABLE

12256: ,p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
12257: ,p_data_level IN VARCHAR2 DEFAULT NULL --R12C
12258: ,p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
12259: ,p_extension_id IN NUMBER DEFAULT NULL
12260: ,p_attr_name_value_pairs IN EGO_USER_ATTR_DATA_TABLE
12261: ,p_mode IN VARCHAR2 DEFAULT G_SYNC_MODE
12262: ,p_change_obj IN EGO_USER_ATTR_CHANGE_OBJ DEFAULT NULL
12263: ,p_pending_b_table_name IN VARCHAR2 DEFAULT NULL
12264: ,p_pending_tl_table_name IN VARCHAR2 DEFAULT NULL

Line 12343: ,p_attr_name_value_pairs IN EGO_USER_ATTR_DATA_TABLE

12339: ,p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
12340: ,p_data_level IN VARCHAR2 DEFAULT NULL --R12C
12341: ,p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
12342: ,p_extension_id IN NUMBER DEFAULT NULL
12343: ,p_attr_name_value_pairs IN EGO_USER_ATTR_DATA_TABLE
12344: ,p_mode IN VARCHAR2 DEFAULT G_SYNC_MODE
12345: ,p_change_obj IN EGO_USER_ATTR_CHANGE_OBJ DEFAULT NULL
12346: ,p_pending_b_table_name IN VARCHAR2 DEFAULT NULL
12347: ,p_pending_tl_table_name IN VARCHAR2 DEFAULT NULL

Line 12376: l_attr_name_value_pairs EGO_USER_ATTR_DATA_TABLE;

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

Line 12611: l_attr_name_value_pairs EGO_USER_ATTR_DATA_TABLE;

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;
12613: l_mode VARCHAR2(10);
12614: l_attr_group_ids_to_exclude VARCHAR2(16000);
12615: l_attr_group_id NUMBER;

Line 12934: l_attr_name_value_pairs := EGO_USER_ATTR_DATA_TABLE();

12930:
12931: l_row_index := l_row_index + 1;
12932:
12933: IF (l_prev_loop_row_number IS NULL) THEN
12934: l_attr_name_value_pairs := EGO_USER_ATTR_DATA_TABLE();
12935: ELSE
12936:
12937: --Start Bug 5211171
12938: /***

Line 13918: l_attr_name_value_pairs EGO_USER_ATTR_DATA_TABLE := EGO_USER_ATTR_DATA_TABLE();

13914: l_current_column_name VARCHAR2(30);
13915: l_attr_metadata_obj EGO_ATTR_METADATA_OBJ;
13916: l_dummy_err_msg_name VARCHAR2(30);
13917: l_token_table ERROR_HANDLER.Token_Tbl_Type;
13918: l_attr_name_value_pairs EGO_USER_ATTR_DATA_TABLE := EGO_USER_ATTR_DATA_TABLE();
13919: l_uom_column_nv_pairs LOCAL_COL_NV_PAIR_TABLE;
13920: l_uom_nv_pairs_index NUMBER := 0;
13921: l_current_uom_col_nv_obj EGO_COL_NAME_VALUE_PAIR_OBJ;
13922: l_attr_col_name_for_uom_col VARCHAR2(30);

Line 15173: l_attr_name_value_pairs EGO_USER_ATTR_DATA_TABLE;

15169: l_attr_int_value VARCHAR2(1000);
15170: l_attr_disp_value VARCHAR2(1000);
15171:
15172: l_attr_metadata_table EGO_ATTR_METADATA_TABLE;
15173: l_attr_name_value_pairs EGO_USER_ATTR_DATA_TABLE;
15174: l_attr_counter NUMBER;
15175: l_temp_attr_metadata EGO_ATTR_METADATA_OBJ;
15176: l_temp_str VARCHAR2(150);
15177: l_temp_num NUMBER;

Line 15423: l_attr_name_value_pairs := EGO_USER_ATTR_DATA_TABLE();

15419: ------------------------------------------------------------
15420: -- We must query up the rest of the attribute data in the --
15421: -- same group in case there are binds --
15422: ------------------------------------------------------------
15423: l_attr_name_value_pairs := EGO_USER_ATTR_DATA_TABLE();
15424:
15425: l_attr_counter := l_attr_metadata_table.FIRST();
15426: WHILE (l_attr_counter IS NOT NULL)
15427: LOOP

Line 15611: l_old_attr_name_value_pairs EGO_USER_ATTR_DATA_TABLE;

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;
15613: l_mode VARCHAR2(10);
15614: l_return_status VARCHAR2(1);
15615: l_row_identifier NUMBER;

Line 15612: l_new_attr_name_value_pairs EGO_USER_ATTR_DATA_TABLE;

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;
15613: l_mode VARCHAR2(10);
15614: l_return_status VARCHAR2(1);
15615: l_row_identifier NUMBER;
15616: l_max_row_identifier NUMBER;

Line 15769: l_attr_name_value_pairs EGO_USER_ATTR_DATA_TABLE;

15765: , px_attr_diffs IN OUT NOCOPY EGO_USER_ATTR_DIFF_TABLE
15766: , x_error_message OUT NOCOPY VARCHAR2
15767: )
15768: IS
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;

Line 15795: l_attr_name_value_pairs := EGO_USER_ATTR_DATA_TABLE();

15791:
15792: l_attr_metadata_obj := l_attr_group_metadata_obj.attr_metadata_table(i);
15793:
15794: IF (l_attr_name_value_pairs IS NULL) THEN
15795: l_attr_name_value_pairs := EGO_USER_ATTR_DATA_TABLE();
15796: END IF;
15797:
15798: -- add all attributes to the name_value pairs table, to pass into Get_Change_Attrs
15799: l_attr_name_value_pairs.EXTEND();

Line 16494: l_attributes_data_table EGO_USER_ATTR_DATA_TABLE;

16490: ) IS
16491:
16492: l_api_name VARCHAR2(30) := 'Build_Request_Table_For_Obj';
16493: l_attributes_row_table EGO_USER_ATTR_ROW_TABLE;
16494: l_attributes_data_table EGO_USER_ATTR_DATA_TABLE;
16495: l_data_level_obj EGO_COL_NAME_VALUE_PAIR_OBJ;
16496: l_data_level_index NUMBER;
16497: l_class_code_table LOCAL_MEDIUM_VARCHAR_TABLE;
16498: l_attr_group_id ego_obj_ag_assocs_b.attr_group_id%TYPE;

Line 16689: ,p_attributes_data_table IN EGO_USER_ATTR_DATA_TABLE

16685:
16686: PROCEDURE Process_Req_Attr_Results(
16687: p_request_table IN EGO_ATTR_GROUP_REQUEST_TABLE
16688: ,p_attributes_row_table IN EGO_USER_ATTR_ROW_TABLE
16689: ,p_attributes_data_table IN EGO_USER_ATTR_DATA_TABLE
16690: ,px_attributes_req_table IN OUT NOCOPY EGO_USER_ATTR_TABLE
16691: ) IS
16692: l_has_value BOOLEAN;
16693: l_ix NUMBER;

Line 16860: l_attributes_data_table EGO_USER_ATTR_DATA_TABLE;

16856: )IS
16857: l_api_name CONSTANT VARCHAR2(30) := 'Validate_Required_Attrs';
16858: l_batch_size CONSTANT NUMBER := 5;
16859: l_attributes_row_table EGO_USER_ATTR_ROW_TABLE;
16860: l_attributes_data_table EGO_USER_ATTR_DATA_TABLE;
16861: l_request_table EGO_ATTR_GROUP_REQUEST_TABLE;
16862: -- request table for ALL attribute groups of the object
16863: l_request_table_batch_iter EGO_ATTR_GROUP_REQUEST_TABLE;
16864: -- request table for one batch of attribute groups

Line 17168: l_attr_data_table EGO_USER_ATTR_DATA_TABLE;

17164: l_number_val NUMBER;
17165: l_str_val VARCHAR2(1000);
17166: l_date_val DATE;
17167: l_attr_row_table EGO_USER_ATTR_ROW_TABLE;
17168: l_attr_data_table EGO_USER_ATTR_DATA_TABLE;
17169: l_transaction_type VARCHAR2(10);
17170: l_temp_date_str VARCHAR2(200);
17171: l_temp_attr_row_table EGO_USER_ATTR_ROW_TABLE;
17172: l_temp_attr_data_table EGO_USER_ATTR_DATA_TABLE;

Line 17172: l_temp_attr_data_table EGO_USER_ATTR_DATA_TABLE;

17168: l_attr_data_table EGO_USER_ATTR_DATA_TABLE;
17169: l_transaction_type VARCHAR2(10);
17170: l_temp_date_str VARCHAR2(200);
17171: l_temp_attr_row_table EGO_USER_ATTR_ROW_TABLE;
17172: l_temp_attr_data_table EGO_USER_ATTR_DATA_TABLE;
17173: l_cc_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
17174: l_has_data_level_id BOOLEAN;
17175: l_data_level_id NUMBER;
17176:

Line 17402: l_attr_data_table := EGO_USER_ATTR_DATA_TABLE();

17398: l_counter1 := 0;
17399: l_counter2 := 0;
17400:
17401: l_attr_row_table := EGO_USER_ATTR_ROW_TABLE();
17402: l_attr_data_table := EGO_USER_ATTR_DATA_TABLE();
17403: l_temp_attr_row_table := EGO_USER_ATTR_ROW_TABLE();
17404: l_temp_attr_data_table := EGO_USER_ATTR_DATA_TABLE();
17405:
17406: Debug_Msg(l_api_name ||' attr rec cursor: '||l_dynamic_sql);

Line 17404: l_temp_attr_data_table := EGO_USER_ATTR_DATA_TABLE();

17400:
17401: l_attr_row_table := EGO_USER_ATTR_ROW_TABLE();
17402: l_attr_data_table := EGO_USER_ATTR_DATA_TABLE();
17403: l_temp_attr_row_table := EGO_USER_ATTR_ROW_TABLE();
17404: l_temp_attr_data_table := EGO_USER_ATTR_DATA_TABLE();
17405:
17406: Debug_Msg(l_api_name ||' attr rec cursor: '||l_dynamic_sql);
17407: Debug_Msg(l_api_name ||' binds are 1: '|| p_application_id ||' 2: '|| p_attr_group_type||
17408: ' 3: '||p_attr_group_type ||' 4: '||p_application_id ||' 5: '||l_object_id ||