[Home] [Help]
281: PROCEDURE Is_Name_Value_Pairs_Valid
282: ( p_attr_group_id IN NUMBER
283: ,p_data_level_name IN VARCHAR2
284: ,p_class_code_hierarchy IN VARCHAR2
285: ,p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
286: ,x_data_level_id OUT NOCOPY NUMBER
287: ,x_name_value_pair_valid OUT NOCOPY VARCHAR2
288: ) IS
289:
430: -- Private
431: --
432: FUNCTION Get_Hierarchy_For_AG_Type (
433: p_ag_type IN VARCHAR2
434: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
435: )
436: RETURN LOCAL_HIERARCHY_REC
437: IS
438:
623: --
624: PROCEDURE Get_Changed_Attributes (
625: p_dml_operation IN VARCHAR2
626: ,p_object_name IN VARCHAR2
627: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
628: ,p_attr_group_metadata_obj IN EGO_ATTR_GROUP_METADATA_OBJ
629: ,p_ext_table_metadata_obj IN EGO_EXT_TABLE_METADATA_OBJ
630: ,p_data_level IN VARCHAR2 DEFAULT NULL --R12C
631: ,p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
627: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
628: ,p_attr_group_metadata_obj IN EGO_ATTR_GROUP_METADATA_OBJ
629: ,p_ext_table_metadata_obj IN EGO_EXT_TABLE_METADATA_OBJ
630: ,p_data_level IN VARCHAR2 DEFAULT NULL --R12C
631: ,p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
632: ,p_attr_name_value_pairs IN EGO_USER_ATTR_DATA_TABLE
633: ,p_extension_id IN NUMBER DEFAULT NULL
634: ,p_entity_id IN NUMBER DEFAULT NULL
635: ,p_entity_index IN NUMBER DEFAULT NULL
1188: --
1189: -- Private
1190: --
1191: PROCEDURE Propagate_Attributes (
1192: p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
1193: , p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
1194: , p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
1195: , p_attr_diffs IN EGO_USER_ATTR_DIFF_TABLE
1196: , p_transaction_type IN VARCHAR2
1189: -- Private
1190: --
1191: PROCEDURE Propagate_Attributes (
1192: p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
1193: , p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
1194: , p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
1195: , p_attr_diffs IN EGO_USER_ATTR_DIFF_TABLE
1196: , p_transaction_type IN VARCHAR2
1197: , p_attr_group_metadata_obj IN EGO_ATTR_GROUP_METADATA_OBJ
1190: --
1191: PROCEDURE Propagate_Attributes (
1192: p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
1193: , p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
1194: , p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
1195: , p_attr_diffs IN EGO_USER_ATTR_DIFF_TABLE
1196: , p_transaction_type IN VARCHAR2
1197: , p_attr_group_metadata_obj IN EGO_ATTR_GROUP_METADATA_OBJ
1198: , x_return_status OUT NOCOPY VARCHAR2
1547: ,p_data_level_3 IN VARCHAR2
1548: ,p_data_level_4 IN VARCHAR2
1549: ,p_data_level_5 IN VARCHAR2
1550: )
1551: RETURN EGO_COL_NAME_VALUE_PAIR_ARRAY
1552: IS
1553:
1554: l_object_id NUMBER;
1555: l_ext_table_metadata_obj EGO_EXT_TABLE_METADATA_OBJ;
1558: l_data_level_2_name_value_pair EGO_COL_NAME_VALUE_PAIR_OBJ;
1559: l_data_level_3_name_value_pair EGO_COL_NAME_VALUE_PAIR_OBJ;
1560: l_data_level_4_name_value_pair EGO_COL_NAME_VALUE_PAIR_OBJ;
1561: l_data_level_5_name_value_pair EGO_COL_NAME_VALUE_PAIR_OBJ;
1562: l_data_level_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
1563: l_data_level_metadata EGO_DATA_LEVEL_METADATA_OBJ;
1564: BEGIN
1565:
1566: Debug_Msg('In Build_Data_Level_Array, starting', 2);
1592: l_data_level_5_name_value_pair := EGO_COL_NAME_VALUE_PAIR_OBJ(l_data_level_metadata.PK_COLUMN_NAME5,p_data_level_5);
1593: END IF;
1594:
1595: IF (l_data_level_5_name_value_pair IS NOT NULL) THEN
1596: l_data_level_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
1597: l_data_level_1_name_value_pair
1598: ,l_data_level_2_name_value_pair
1599: ,l_data_level_3_name_value_pair
1600: ,l_data_level_4_name_value_pair
1600: ,l_data_level_4_name_value_pair
1601: ,l_data_level_5_name_value_pair
1602: );
1603: ELSIF (l_data_level_4_name_value_pair IS NOT NULL) THEN
1604: l_data_level_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
1605: l_data_level_1_name_value_pair
1606: ,l_data_level_2_name_value_pair
1607: ,l_data_level_3_name_value_pair
1608: ,l_data_level_4_name_value_pair
1607: ,l_data_level_3_name_value_pair
1608: ,l_data_level_4_name_value_pair
1609: );
1610: ELSIF (l_data_level_3_name_value_pair IS NOT NULL) THEN
1611: l_data_level_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
1612: l_data_level_1_name_value_pair
1613: ,l_data_level_2_name_value_pair
1614: ,l_data_level_3_name_value_pair
1615: );
1613: ,l_data_level_2_name_value_pair
1614: ,l_data_level_3_name_value_pair
1615: );
1616: ELSIF (l_data_level_2_name_value_pair IS NOT NULL) THEN
1617: l_data_level_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
1618: l_data_level_1_name_value_pair
1619: ,l_data_level_2_name_value_pair
1620: );
1621: ELSIF (l_data_level_1_name_value_pair IS NOT NULL) THEN
1618: l_data_level_1_name_value_pair
1619: ,l_data_level_2_name_value_pair
1620: );
1621: ELSIF (l_data_level_1_name_value_pair IS NOT NULL) THEN
1622: l_data_level_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
1623: l_data_level_1_name_value_pair
1624: );
1625: ELSE
1626: l_data_level_name_value_pairs := NULL;
1652: END IF;
1653: END IF;
1654:
1655: IF (l_data_level_3_name_value_pair IS NOT NULL) THEN
1656: l_data_level_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
1657: l_data_level_1_name_value_pair
1658: ,l_data_level_2_name_value_pair
1659: ,l_data_level_3_name_value_pair
1660: );
1658: ,l_data_level_2_name_value_pair
1659: ,l_data_level_3_name_value_pair
1660: );
1661: ELSIF (l_data_level_2_name_value_pair IS NOT NULL) THEN
1662: l_data_level_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
1663: l_data_level_1_name_value_pair
1664: ,l_data_level_2_name_value_pair
1665: );
1666: ELSE
1663: l_data_level_1_name_value_pair
1664: ,l_data_level_2_name_value_pair
1665: );
1666: ELSE
1667: l_data_level_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
1668: l_data_level_1_name_value_pair
1669: );
1670:
1671: END IF;
2149:
2150: PROCEDURE Build_Where_Clause (
2151: p_attr_group_metadata_obj IN EGO_ATTR_GROUP_METADATA_OBJ
2152: ,p_ext_table_metadata_obj IN EGO_EXT_TABLE_METADATA_OBJ
2153: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
2154: ,p_data_level IN VARCHAR2 DEFAULT NULL --R12C
2155: ,p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
2156: ,p_attr_name_value_pairs IN EGO_USER_ATTR_DATA_TABLE DEFAULT NULL
2157: ) IS
2151: p_attr_group_metadata_obj IN EGO_ATTR_GROUP_METADATA_OBJ
2152: ,p_ext_table_metadata_obj IN EGO_EXT_TABLE_METADATA_OBJ
2153: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
2154: ,p_data_level IN VARCHAR2 DEFAULT NULL --R12C
2155: ,p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
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';
2309: FUNCTION Tokenized_Val_Set_Query (
2310: p_attr_metadata_obj IN EGO_ATTR_METADATA_OBJ
2311: ,p_attr_group_metadata_obj IN EGO_ATTR_GROUP_METADATA_OBJ
2312: ,p_ext_table_metadata_obj IN EGO_EXT_TABLE_METADATA_OBJ
2313: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
2314: ,p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
2315: ,p_entity_id IN VARCHAR2
2316: ,p_entity_index IN NUMBER
2317: ,p_entity_code IN VARCHAR2
2310: p_attr_metadata_obj IN EGO_ATTR_METADATA_OBJ
2311: ,p_attr_group_metadata_obj IN EGO_ATTR_GROUP_METADATA_OBJ
2312: ,p_ext_table_metadata_obj IN EGO_EXT_TABLE_METADATA_OBJ
2313: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
2314: ,p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
2315: ,p_entity_id IN VARCHAR2
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
2689: p_attr_metadata_obj IN EGO_ATTR_METADATA_OBJ
2690: ,p_attr_value_obj IN EGO_USER_ATTR_DATA_OBJ
2691: ,p_attr_group_metadata_obj IN EGO_ATTR_GROUP_METADATA_OBJ
2692: ,p_ext_table_metadata_obj IN EGO_EXT_TABLE_METADATA_OBJ
2693: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
2694: ,p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
2695: ,p_entity_id IN VARCHAR2
2696: ,p_entity_index IN NUMBER
2697: ,p_entity_code IN VARCHAR2
2690: ,p_attr_value_obj IN EGO_USER_ATTR_DATA_OBJ
2691: ,p_attr_group_metadata_obj IN EGO_ATTR_GROUP_METADATA_OBJ
2692: ,p_ext_table_metadata_obj IN EGO_EXT_TABLE_METADATA_OBJ
2693: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
2694: ,p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
2695: ,p_entity_id IN VARCHAR2
2696: ,p_entity_index IN NUMBER
2697: ,p_entity_code IN VARCHAR2
2698: ,p_attr_name_value_pairs IN EGO_USER_ATTR_DATA_TABLE
2797: p_attr_int_value IN VARCHAR2 DEFAULT NULL
2798: ,p_attr_value_obj IN EGO_USER_ATTR_DATA_OBJ DEFAULT NULL
2799: ,p_attr_metadata_obj IN EGO_ATTR_METADATA_OBJ
2800: ,p_attr_group_metadata_obj IN EGO_ATTR_GROUP_METADATA_OBJ
2801: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
2802: ,p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
2803: ,p_entity_id IN VARCHAR2 DEFAULT NULL
2804: ,p_entity_index IN NUMBER DEFAULT NULL
2805: ,p_entity_code IN VARCHAR2 DEFAULT NULL
2798: ,p_attr_value_obj IN EGO_USER_ATTR_DATA_OBJ DEFAULT NULL
2799: ,p_attr_metadata_obj IN EGO_ATTR_METADATA_OBJ
2800: ,p_attr_group_metadata_obj IN EGO_ATTR_GROUP_METADATA_OBJ
2801: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
2802: ,p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
2803: ,p_entity_id IN VARCHAR2 DEFAULT NULL
2804: ,p_entity_index IN NUMBER DEFAULT NULL
2805: ,p_entity_code IN VARCHAR2 DEFAULT NULL
2806: ,p_attr_name_value_pairs IN EGO_USER_ATTR_DATA_TABLE DEFAULT NULL
2928:
2929: FUNCTION Get_Extension_Id_For_Row (
2930: p_attr_group_metadata_obj IN EGO_ATTR_GROUP_METADATA_OBJ
2931: ,p_ext_table_metadata_obj IN EGO_EXT_TABLE_METADATA_OBJ
2932: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
2933: ,p_data_level IN VARCHAR2 DEFAULT NULL --R12C
2934: ,p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
2935: ,p_attr_name_value_pairs IN EGO_USER_ATTR_DATA_TABLE
2936: ,p_change_obj IN EGO_USER_ATTR_CHANGE_OBJ DEFAULT NULL
2930: p_attr_group_metadata_obj IN EGO_ATTR_GROUP_METADATA_OBJ
2931: ,p_ext_table_metadata_obj IN EGO_EXT_TABLE_METADATA_OBJ
2932: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
2933: ,p_data_level IN VARCHAR2 DEFAULT NULL --R12C
2934: ,p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
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
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
2940: )
2941: RETURN NUMBER
2946: l_change_where_clause VARCHAR2(1000);
2947: l_extra_where_clause VARCHAR2(5000);
2948: l_cursor_id NUMBER;
2949: l_dynamic_sql VARCHAR2(15000);
2950: l_data_level_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
2951: l_number_of_rows NUMBER;
2952: l_extension_id NUMBER;
2953: l_index NUMBER;
2954:
3481:
3482: PROCEDURE Get_Extension_Id_And_Mode (
3483: p_attr_group_metadata_obj IN EGO_ATTR_GROUP_METADATA_OBJ
3484: ,p_ext_table_metadata_obj IN EGO_EXT_TABLE_METADATA_OBJ
3485: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
3486: ,p_data_level IN VARCHAR2 DEFAULT NULL --R12C
3487: ,p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
3488: ,p_attr_name_value_pairs IN EGO_USER_ATTR_DATA_TABLE
3489: ,p_extension_id IN NUMBER DEFAULT NULL
3483: p_attr_group_metadata_obj IN EGO_ATTR_GROUP_METADATA_OBJ
3484: ,p_ext_table_metadata_obj IN EGO_EXT_TABLE_METADATA_OBJ
3485: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
3486: ,p_data_level IN VARCHAR2 DEFAULT NULL --R12C
3487: ,p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
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
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
3493: ,p_pending_b_table_name IN VARCHAR2 DEFAULT NULL
3494: ,p_pending_vl_name IN VARCHAR2 DEFAULT NULL
3495: ,p_entity_id IN VARCHAR2 DEFAULT NULL
3496: ,p_entity_index IN NUMBER DEFAULT NULL
4010:
4011:
4012: FUNCTION Are_These_Col_Names_Right (
4013: p_ext_table_col_metadata IN EGO_COL_METADATA_ARRAY
4014: ,p_col_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
4015: )
4016: RETURN BOOLEAN
4017: IS
4018:
4084: ----------------------------------------------------------------------
4085:
4086: FUNCTION Are_Ext_Table_Col_Names_Right (
4087: p_ext_table_metadata_obj IN EGO_EXT_TABLE_METADATA_OBJ
4088: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
4089: ,p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
4090: )
4091: RETURN BOOLEAN
4092: IS
4085:
4086: FUNCTION Are_Ext_Table_Col_Names_Right (
4087: p_ext_table_metadata_obj IN EGO_EXT_TABLE_METADATA_OBJ
4088: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
4089: ,p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
4090: )
4091: RETURN BOOLEAN
4092: IS
4093:
4126: FUNCTION Is_Data_Level_Correct (
4127: p_object_id IN NUMBER
4128: ,p_attr_group_id IN NUMBER
4129: ,p_ext_table_metadata_obj IN EGO_EXT_TABLE_METADATA_OBJ
4130: ,p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
4131: ,p_data_level IN VARCHAR2 DEFAULT NULL --R12C
4132: ,p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
4133: ,p_attr_group_disp_name IN VARCHAR2
4134: ,x_err_msg_name OUT NOCOPY VARCHAR2
4128: ,p_attr_group_id IN NUMBER
4129: ,p_ext_table_metadata_obj IN EGO_EXT_TABLE_METADATA_OBJ
4130: ,p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
4131: ,p_data_level IN VARCHAR2 DEFAULT NULL --R12C
4132: ,p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
4133: ,p_attr_group_disp_name IN VARCHAR2
4134: ,x_err_msg_name OUT NOCOPY VARCHAR2
4135: ,x_token_table OUT NOCOPY ERROR_HANDLER.Token_Tbl_Type
4136: )
4964: FUNCTION Is_Value_Set_Respected (
4965: p_attr_metadata_obj IN EGO_ATTR_METADATA_OBJ
4966: ,p_attr_group_metadata_obj IN EGO_ATTR_GROUP_METADATA_OBJ
4967: ,p_ext_table_metadata_obj IN EGO_EXT_TABLE_METADATA_OBJ
4968: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
4969: ,p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
4970: ,p_entity_id IN VARCHAR2
4971: ,p_entity_index IN NUMBER
4972: ,p_entity_code IN VARCHAR2
4965: p_attr_metadata_obj IN EGO_ATTR_METADATA_OBJ
4966: ,p_attr_group_metadata_obj IN EGO_ATTR_GROUP_METADATA_OBJ
4967: ,p_ext_table_metadata_obj IN EGO_EXT_TABLE_METADATA_OBJ
4968: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
4969: ,p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
4970: ,p_entity_id IN VARCHAR2
4971: ,p_entity_index IN NUMBER
4972: ,p_entity_code IN VARCHAR2
4973: ,p_attr_name_value_pairs IN EGO_USER_ATTR_DATA_TABLE
5447:
5448: PROCEDURE Generate_Attr_Int_Values (
5449: p_attr_group_metadata_obj IN EGO_ATTR_GROUP_METADATA_OBJ
5450: ,p_ext_table_metadata_obj IN EGO_EXT_TABLE_METADATA_OBJ
5451: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
5452: ,p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
5453: ,p_entity_id IN VARCHAR2 DEFAULT NULL
5454: ,p_entity_index IN NUMBER DEFAULT NULL
5455: ,p_entity_code IN VARCHAR2 DEFAULT NULL
5448: PROCEDURE Generate_Attr_Int_Values (
5449: p_attr_group_metadata_obj IN EGO_ATTR_GROUP_METADATA_OBJ
5450: ,p_ext_table_metadata_obj IN EGO_EXT_TABLE_METADATA_OBJ
5451: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
5452: ,p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
5453: ,p_entity_id IN VARCHAR2 DEFAULT NULL
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
5628: PROCEDURE Raise_WF_Event_If_Enabled (
5629: p_dml_type IN VARCHAR2
5630: ,p_attr_group_metadata_obj IN EGO_ATTR_GROUP_METADATA_OBJ
5631: ,p_extension_id IN NUMBER
5632: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
5633: ,p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
5634: ,p_entity_id IN VARCHAR2
5635: ,p_entity_index IN NUMBER
5636: ,p_entity_code IN VARCHAR2
5629: p_dml_type IN VARCHAR2
5630: ,p_attr_group_metadata_obj IN EGO_ATTR_GROUP_METADATA_OBJ
5631: ,p_extension_id IN NUMBER
5632: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
5633: ,p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
5634: ,p_entity_id IN VARCHAR2
5635: ,p_entity_index IN NUMBER
5636: ,p_entity_code IN VARCHAR2
5637: ,p_pre_event_flag IN VARCHAR2 DEFAULT NULL --4105841
6060: ----------------------------------------------------------------------
6061:
6062: PROCEDURE Perform_Preliminary_Checks (
6063: p_object_name IN VARCHAR2
6064: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
6065: ,p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
6066: ,p_entity_id IN VARCHAR2
6067: ,p_entity_index IN NUMBER
6068: ,p_entity_code IN VARCHAR2
6061:
6062: PROCEDURE Perform_Preliminary_Checks (
6063: p_object_name IN VARCHAR2
6064: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
6065: ,p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
6066: ,p_entity_id IN VARCHAR2
6067: ,p_entity_index IN NUMBER
6068: ,p_entity_code IN VARCHAR2
6069: ,x_return_status OUT NOCOPY VARCHAR2
6399: ,p_entity_code IN VARCHAR2 DEFAULT NULL
6400: ,p_debug_level IN NUMBER
6401: ,p_init_error_handler_flag IN BOOLEAN
6402: ,p_object_name IN VARCHAR2
6403: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
6404: ,p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
6405: ,p_init_fnd_msg_list IN VARCHAR2
6406: ,p_add_errors_to_fnd_stack IN VARCHAR2
6407: ,p_default_user_row_identifier IN NUMBER DEFAULT NULL
6400: ,p_debug_level IN NUMBER
6401: ,p_init_error_handler_flag IN BOOLEAN
6402: ,p_object_name IN VARCHAR2
6403: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
6404: ,p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
6405: ,p_init_fnd_msg_list IN VARCHAR2
6406: ,p_add_errors_to_fnd_stack IN VARCHAR2
6407: ,p_default_user_row_identifier IN NUMBER DEFAULT NULL
6408: ,p_use_def_vals_on_insert_flag IN BOOLEAN DEFAULT FALSE
6757: PROCEDURE Insert_Row (
6758: p_api_version IN NUMBER
6759: ,p_attr_group_metadata_obj IN EGO_ATTR_GROUP_METADATA_OBJ
6760: ,p_ext_table_metadata_obj IN EGO_EXT_TABLE_METADATA_OBJ
6761: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
6762: ,p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
6763: ,p_data_level IN VARCHAR2 DEFAULT NULL --R12C
6764: ,p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
6765: ,p_extension_id IN NUMBER
6758: p_api_version IN NUMBER
6759: ,p_attr_group_metadata_obj IN EGO_ATTR_GROUP_METADATA_OBJ
6760: ,p_ext_table_metadata_obj IN EGO_EXT_TABLE_METADATA_OBJ
6761: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
6762: ,p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
6763: ,p_data_level IN VARCHAR2 DEFAULT NULL --R12C
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
6760: ,p_ext_table_metadata_obj IN EGO_EXT_TABLE_METADATA_OBJ
6761: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
6762: ,p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
6763: ,p_data_level IN VARCHAR2 DEFAULT NULL --R12C
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
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
6771: ,p_pending_b_table_name IN VARCHAR2
6772: ,p_pending_tl_table_name IN VARCHAR2
6773: ,p_execute_dml IN VARCHAR2 DEFAULT FND_API.G_TRUE
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
6771: ,p_pending_b_table_name IN VARCHAR2
6772: ,p_pending_tl_table_name IN VARCHAR2
6773: ,p_execute_dml IN VARCHAR2 DEFAULT FND_API.G_TRUE
6774: ,p_entity_id IN VARCHAR2
7625: PROCEDURE Update_Row (
7626: p_api_version IN NUMBER
7627: ,p_attr_group_metadata_obj IN EGO_ATTR_GROUP_METADATA_OBJ
7628: ,p_ext_table_metadata_obj IN EGO_EXT_TABLE_METADATA_OBJ
7629: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
7630: ,p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
7631: ,p_data_level IN VARCHAR2 DEFAULT NULL --R12C
7632: ,p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
7633: ,p_extension_id IN NUMBER
7626: p_api_version IN NUMBER
7627: ,p_attr_group_metadata_obj IN EGO_ATTR_GROUP_METADATA_OBJ
7628: ,p_ext_table_metadata_obj IN EGO_EXT_TABLE_METADATA_OBJ
7629: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
7630: ,p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
7631: ,p_data_level IN VARCHAR2 DEFAULT NULL --R12C
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
7628: ,p_ext_table_metadata_obj IN EGO_EXT_TABLE_METADATA_OBJ
7629: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
7630: ,p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
7631: ,p_data_level IN VARCHAR2 DEFAULT NULL --R12C
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
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
7639: ,p_pending_b_table_name IN VARCHAR2
7640: ,p_pending_tl_table_name IN VARCHAR2
7641: ,p_execute_dml IN VARCHAR2 DEFAULT FND_API.G_TRUE
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
7639: ,p_pending_b_table_name IN VARCHAR2
7640: ,p_pending_tl_table_name IN VARCHAR2
7641: ,p_execute_dml IN VARCHAR2 DEFAULT FND_API.G_TRUE
7642: ,p_entity_id IN VARCHAR2
8245: ----------------------------------------------------------------------
8246: PROCEDURE Delete_Row (
8247: p_api_version IN NUMBER
8248: ,p_attr_group_metadata_obj IN EGO_ATTR_GROUP_METADATA_OBJ
8249: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
8250: ,p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
8251: ,p_data_level IN VARCHAR2 DEFAULT NULL --R12C
8252: ,p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
8253: ,p_extension_id IN NUMBER
8246: PROCEDURE Delete_Row (
8247: p_api_version IN NUMBER
8248: ,p_attr_group_metadata_obj IN EGO_ATTR_GROUP_METADATA_OBJ
8249: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
8250: ,p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
8251: ,p_data_level IN VARCHAR2 DEFAULT NULL --R12C
8252: ,p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
8253: ,p_extension_id IN NUMBER
8254: -- Start ssingal -For Ucc Net Attribute Propagation
8248: ,p_attr_group_metadata_obj IN EGO_ATTR_GROUP_METADATA_OBJ
8249: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
8250: ,p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
8251: ,p_data_level IN VARCHAR2 DEFAULT NULL --R12C
8252: ,p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
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
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
8260: ,p_extra_pk_col_name_val_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
8261: ,p_pending_b_table_name IN VARCHAR2
8262: ,p_pending_tl_table_name IN VARCHAR2
8263: ,p_execute_dml IN VARCHAR2 DEFAULT FND_API.G_TRUE
8264: -- Start ssingal -For Ucc Net Attribute Propagation
8589: ,p_object_id IN NUMBER
8590: ,p_validate_hierarchy IN VARCHAR2 DEFAULT FND_API.G_TRUE --Added for bugFix:5275391
8591: ,p_attr_group_metadata_obj IN EGO_ATTR_GROUP_METADATA_OBJ
8592: ,p_ext_table_metadata_obj IN EGO_EXT_TABLE_METADATA_OBJ
8593: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
8594: ,p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
8595: ,p_data_level IN VARCHAR2 DEFAULT NULL --R12C
8596: ,p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
8597: ,p_extension_id IN NUMBER
8590: ,p_validate_hierarchy IN VARCHAR2 DEFAULT FND_API.G_TRUE --Added for bugFix:5275391
8591: ,p_attr_group_metadata_obj IN EGO_ATTR_GROUP_METADATA_OBJ
8592: ,p_ext_table_metadata_obj IN EGO_EXT_TABLE_METADATA_OBJ
8593: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
8594: ,p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
8595: ,p_data_level IN VARCHAR2 DEFAULT NULL --R12C
8596: ,p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
8597: ,p_extension_id IN NUMBER
8598: ,p_mode IN VARCHAR2
8592: ,p_ext_table_metadata_obj IN EGO_EXT_TABLE_METADATA_OBJ
8593: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
8594: ,p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
8595: ,p_data_level IN VARCHAR2 DEFAULT NULL --R12C
8596: ,p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
8597: ,p_extension_id IN NUMBER
8598: ,p_mode IN VARCHAR2
8599: ,p_entity_id IN VARCHAR2 DEFAULT NULL
8600: ,p_entity_index IN NUMBER DEFAULT NULL
9048: p_api_version IN NUMBER
9049: ,p_object_id IN NUMBER
9050: ,p_attr_group_metadata_obj IN EGO_ATTR_GROUP_METADATA_OBJ
9051: ,p_ext_table_metadata_obj IN EGO_EXT_TABLE_METADATA_OBJ
9052: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
9053: ,p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
9054: ,p_data_level IN VARCHAR2 DEFAULT NULL --R12C
9055: ,p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
9056: ,p_extension_id IN NUMBER
9049: ,p_object_id IN NUMBER
9050: ,p_attr_group_metadata_obj IN EGO_ATTR_GROUP_METADATA_OBJ
9051: ,p_ext_table_metadata_obj IN EGO_EXT_TABLE_METADATA_OBJ
9052: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
9053: ,p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
9054: ,p_data_level IN VARCHAR2 DEFAULT NULL --R12C
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
9051: ,p_ext_table_metadata_obj IN EGO_EXT_TABLE_METADATA_OBJ
9052: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
9053: ,p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
9054: ,p_data_level IN VARCHAR2 DEFAULT NULL --R12C
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
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
9062: ,p_extra_attr_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
9063: ,p_pending_b_table_name IN VARCHAR2 DEFAULT NULL
9064: ,p_pending_tl_table_name IN VARCHAR2 DEFAULT NULL
9065: ,p_execute_dml IN VARCHAR2 DEFAULT FND_API.G_TRUE
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
9062: ,p_extra_attr_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
9063: ,p_pending_b_table_name IN VARCHAR2 DEFAULT NULL
9064: ,p_pending_tl_table_name IN VARCHAR2 DEFAULT NULL
9065: ,p_execute_dml IN VARCHAR2 DEFAULT FND_API.G_TRUE
9066: ,p_entity_id IN VARCHAR2 DEFAULT NULL
9246: PROCEDURE Perform_DML_On_Template_Row (
9247: p_object_id IN NUMBER
9248: ,p_attr_group_metadata_obj IN EGO_ATTR_GROUP_METADATA_OBJ
9249: ,p_ext_table_metadata_obj IN EGO_EXT_TABLE_METADATA_OBJ
9250: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
9251: ,p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
9252: ,p_data_level IN VARCHAR2
9253: ,p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
9254: ,p_commit IN VARCHAR2
9247: p_object_id IN NUMBER
9248: ,p_attr_group_metadata_obj IN EGO_ATTR_GROUP_METADATA_OBJ
9249: ,p_ext_table_metadata_obj IN EGO_EXT_TABLE_METADATA_OBJ
9250: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
9251: ,p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
9252: ,p_data_level IN VARCHAR2
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
9249: ,p_ext_table_metadata_obj IN EGO_EXT_TABLE_METADATA_OBJ
9250: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
9251: ,p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
9252: ,p_data_level IN VARCHAR2
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:
9368: ,p_attr_group_id IN NUMBER
9369: ,p_application_id IN NUMBER
9370: ,p_attr_group_type IN VARCHAR2
9371: ,p_attr_group_name IN VARCHAR2
9372: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
9373: ,p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
9374: ,p_data_level IN VARCHAR2 DEFAULT NULL --R12C
9375: ,p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
9376: ,p_extension_id IN NUMBER
9369: ,p_application_id IN NUMBER
9370: ,p_attr_group_type IN VARCHAR2
9371: ,p_attr_group_name IN VARCHAR2
9372: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
9373: ,p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
9374: ,p_data_level IN VARCHAR2 DEFAULT NULL --R12C
9375: ,p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
9376: ,p_extension_id IN NUMBER
9377: ,p_entity_id IN VARCHAR2
9371: ,p_attr_group_name IN VARCHAR2
9372: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
9373: ,p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
9374: ,p_data_level IN VARCHAR2 DEFAULT NULL --R12C
9375: ,p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
9376: ,p_extension_id IN NUMBER
9377: ,p_entity_id IN VARCHAR2
9378: ,p_entity_index IN NUMBER
9379: ,p_entity_code IN VARCHAR2
9382: ,p_use_def_vals_on_insert_flag IN BOOLEAN DEFAULT FALSE
9383: ,p_init_fnd_msg_list IN VARCHAR2
9384: ,p_mode IN VARCHAR2
9385: ,p_change_obj IN EGO_USER_ATTR_CHANGE_OBJ DEFAULT NULL
9386: ,p_extra_pk_col_name_val_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
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
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
9671: ,p_pending_b_table_name IN VARCHAR2 DEFAULT NULL
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
9671: ,p_pending_b_table_name IN VARCHAR2 DEFAULT NULL
9672: ,p_pending_tl_table_name IN VARCHAR2 DEFAULT NULL
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
9741: ,p_pending_b_table_name IN VARCHAR2 DEFAULT NULL
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
9741: ,p_pending_b_table_name IN VARCHAR2 DEFAULT NULL
9742: ,p_pending_tl_table_name IN VARCHAR2 DEFAULT NULL
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;
9788: l_msg_count NUMBER;
10167:
10168: PROCEDURE Get_User_Attrs_Data (
10169: p_api_version IN NUMBER
10170: ,p_object_name IN VARCHAR2
10171: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
10172: ,p_attr_group_request_table IN EGO_ATTR_GROUP_REQUEST_TABLE
10173: ,p_user_privileges_on_object IN EGO_VARCHAR_TBL_TYPE DEFAULT NULL
10174: ,p_entity_id IN NUMBER DEFAULT NULL
10175: ,p_entity_index IN NUMBER DEFAULT NULL
10218: l_start_index NUMBER;
10219: l_substring_length NUMBER;
10220: l_temp_db_query_string VARCHAR2(32767);
10221: l_int_to_disp_val_string VARCHAR2(32767);
10222: l_data_level_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
10223: l_pk_col_string VARCHAR2(1000);
10224: l_data_level_string VARCHAR2(1000);
10225: l_dynamic_sql VARCHAR2(32767);
10226: l_cursor_id NUMBER;
11305: ,p_application_id IN NUMBER DEFAULT NULL
11306: ,p_attr_group_type IN VARCHAR2 DEFAULT NULL
11307: ,p_attr_group_name IN VARCHAR2 DEFAULT NULL
11308: ,p_validate_hierarchy IN VARCHAR2 DEFAULT FND_API.G_TRUE--Added for bugFix:5275391
11309: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
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
11306: ,p_attr_group_type IN VARCHAR2 DEFAULT NULL
11307: ,p_attr_group_name IN VARCHAR2 DEFAULT NULL
11308: ,p_validate_hierarchy IN VARCHAR2 DEFAULT FND_API.G_TRUE--Added for bugFix:5275391
11309: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
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
11308: ,p_validate_hierarchy IN VARCHAR2 DEFAULT FND_API.G_TRUE--Added for bugFix:5275391
11309: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
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
11380: ,p_application_id IN NUMBER DEFAULT NULL
11381: ,p_attr_group_type IN VARCHAR2 DEFAULT NULL
11382: ,p_attr_group_name IN VARCHAR2 DEFAULT NULL
11383: ,p_validate_hierarchy IN VARCHAR2 DEFAULT FND_API.G_TRUE--Added for bugFix:5275391
11384: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
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
11381: ,p_attr_group_type IN VARCHAR2 DEFAULT NULL
11382: ,p_attr_group_name IN VARCHAR2 DEFAULT NULL
11383: ,p_validate_hierarchy IN VARCHAR2 DEFAULT FND_API.G_TRUE--Added for bugFix:5275391
11384: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
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
11383: ,p_validate_hierarchy IN VARCHAR2 DEFAULT FND_API.G_TRUE--Added for bugFix:5275391
11384: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
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
11662: ,p_attr_group_id IN NUMBER DEFAULT NULL
11663: ,p_application_id IN NUMBER DEFAULT NULL
11664: ,p_attr_group_type IN VARCHAR2 DEFAULT NULL
11665: ,p_attr_group_name IN VARCHAR2 DEFAULT NULL
11666: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
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
11663: ,p_application_id IN NUMBER DEFAULT NULL
11664: ,p_attr_group_type IN VARCHAR2 DEFAULT NULL
11665: ,p_attr_group_name IN VARCHAR2 DEFAULT NULL
11666: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
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
11665: ,p_attr_group_name IN VARCHAR2 DEFAULT NULL
11666: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
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
11873: ,p_attr_group_id IN NUMBER DEFAULT NULL
11874: ,p_application_id IN NUMBER DEFAULT NULL
11875: ,p_attr_group_type IN VARCHAR2 DEFAULT NULL
11876: ,p_attr_group_name IN VARCHAR2 DEFAULT NULL
11877: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
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
11874: ,p_application_id IN NUMBER DEFAULT NULL
11875: ,p_attr_group_type IN VARCHAR2 DEFAULT NULL
11876: ,p_attr_group_name IN VARCHAR2 DEFAULT NULL
11877: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
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
11876: ,p_attr_group_name IN VARCHAR2 DEFAULT NULL
11877: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
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
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
11887: ,p_alternate_ext_tl_table_name IN VARCHAR2 DEFAULT NULL
11888: ,p_alternate_ext_vl_name IN VARCHAR2 DEFAULT NULL
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
11887: ,p_alternate_ext_tl_table_name IN VARCHAR2 DEFAULT NULL
11888: ,p_alternate_ext_vl_name IN VARCHAR2 DEFAULT NULL
11889: ,p_execute_dml IN VARCHAR2 DEFAULT FND_API.G_FALSE
12179: ,p_attr_group_id IN NUMBER DEFAULT NULL
12180: ,p_application_id IN NUMBER
12181: ,p_attr_group_type IN VARCHAR2
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
12181: ,p_attr_group_type IN VARCHAR2
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
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
12191: ,p_alternate_ext_vl_name IN VARCHAR2 DEFAULT NULL
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
12191: ,p_alternate_ext_vl_name IN VARCHAR2 DEFAULT NULL
12192: ) RETURN NUMBER
12251: ,p_attr_group_id IN NUMBER DEFAULT NULL
12252: ,p_application_id IN NUMBER DEFAULT NULL
12253: ,p_attr_group_type IN VARCHAR2 DEFAULT NULL
12254: ,p_attr_group_name IN VARCHAR2 DEFAULT NULL
12255: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
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
12252: ,p_application_id IN NUMBER DEFAULT NULL
12253: ,p_attr_group_type IN VARCHAR2 DEFAULT NULL
12254: ,p_attr_group_name IN VARCHAR2 DEFAULT NULL
12255: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
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
12254: ,p_attr_group_name IN VARCHAR2 DEFAULT NULL
12255: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
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
12334: ,p_attr_group_id IN NUMBER DEFAULT NULL
12335: ,p_application_id IN NUMBER DEFAULT NULL
12336: ,p_attr_group_type IN VARCHAR2 DEFAULT NULL
12337: ,p_attr_group_name IN VARCHAR2 DEFAULT NULL
12338: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
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
12335: ,p_application_id IN NUMBER DEFAULT NULL
12336: ,p_attr_group_type IN VARCHAR2 DEFAULT NULL
12337: ,p_attr_group_name IN VARCHAR2 DEFAULT NULL
12338: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
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
12337: ,p_attr_group_name IN VARCHAR2 DEFAULT NULL
12338: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
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
12569: PROCEDURE Perform_DML_From_Template (
12570: p_api_version IN NUMBER
12571: ,p_template_id IN NUMBER
12572: ,p_object_name IN VARCHAR2
12573: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
12574: ,p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
12575: ,p_data_level IN VARCHAR2 DEFAULT NULL
12576: ,p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
12577: ,p_attr_group_ids_to_exclude IN EGO_NUMBER_TBL_TYPE DEFAULT NULL
12570: p_api_version IN NUMBER
12571: ,p_template_id IN NUMBER
12572: ,p_object_name IN VARCHAR2
12573: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
12574: ,p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
12575: ,p_data_level IN VARCHAR2 DEFAULT NULL
12576: ,p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
12577: ,p_attr_group_ids_to_exclude IN EGO_NUMBER_TBL_TYPE DEFAULT NULL
12578: ,p_debug_level IN NUMBER DEFAULT 0
12572: ,p_object_name IN VARCHAR2
12573: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
12574: ,p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
12575: ,p_data_level IN VARCHAR2 DEFAULT NULL
12576: ,p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
12577: ,p_attr_group_ids_to_exclude IN EGO_NUMBER_TBL_TYPE DEFAULT NULL
12578: ,p_debug_level IN NUMBER DEFAULT 0
12579: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
12580: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
13249: p_api_version IN NUMBER
13250: ,p_application_id IN NUMBER
13251: ,p_object_id IN NUMBER DEFAULT NULL
13252: ,p_object_name IN VARCHAR2 DEFAULT NULL
13253: ,p_old_pk_col_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
13254: ,p_old_data_level_id IN NUMBER DEFAULT NULL
13255: ,p_old_dtlevel_col_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
13256: ,p_new_pk_col_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
13257: ,p_new_data_level_id IN NUMBER DEFAULT NULL
13251: ,p_object_id IN NUMBER DEFAULT NULL
13252: ,p_object_name IN VARCHAR2 DEFAULT NULL
13253: ,p_old_pk_col_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
13254: ,p_old_data_level_id IN NUMBER DEFAULT NULL
13255: ,p_old_dtlevel_col_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
13256: ,p_new_pk_col_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
13257: ,p_new_data_level_id IN NUMBER DEFAULT NULL
13258: ,p_new_dtlevel_col_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
13259: ,p_new_cc_col_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
13252: ,p_object_name IN VARCHAR2 DEFAULT NULL
13253: ,p_old_pk_col_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
13254: ,p_old_data_level_id IN NUMBER DEFAULT NULL
13255: ,p_old_dtlevel_col_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
13256: ,p_new_pk_col_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
13257: ,p_new_data_level_id IN NUMBER DEFAULT NULL
13258: ,p_new_dtlevel_col_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
13259: ,p_new_cc_col_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
13260: ,p_attr_group_list IN VARCHAR2 DEFAULT NULL
13254: ,p_old_data_level_id IN NUMBER DEFAULT NULL
13255: ,p_old_dtlevel_col_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
13256: ,p_new_pk_col_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
13257: ,p_new_data_level_id IN NUMBER DEFAULT NULL
13258: ,p_new_dtlevel_col_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
13259: ,p_new_cc_col_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
13260: ,p_attr_group_list IN VARCHAR2 DEFAULT NULL
13261: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_FALSE
13262: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
13255: ,p_old_dtlevel_col_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
13256: ,p_new_pk_col_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
13257: ,p_new_data_level_id IN NUMBER DEFAULT NULL
13258: ,p_new_dtlevel_col_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
13259: ,p_new_cc_col_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
13260: ,p_attr_group_list IN VARCHAR2 DEFAULT NULL
13261: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_FALSE
13262: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
13263: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
13866: ,p_change_b_table_name IN VARCHAR2
13867: ,p_change_tl_table_name IN VARCHAR2
13868: ,p_tables_application_id IN NUMBER
13869: ,p_change_line_id IN NUMBER
13870: ,p_old_data_level_nv_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
13871: ,p_new_data_level_nv_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
13872: ,p_related_class_code_function IN VARCHAR2
13873: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
13874: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
13867: ,p_change_tl_table_name IN VARCHAR2
13868: ,p_tables_application_id IN NUMBER
13869: ,p_change_line_id IN NUMBER
13870: ,p_old_data_level_nv_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
13871: ,p_new_data_level_nv_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
13872: ,p_related_class_code_function IN VARCHAR2
13873: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
13874: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
13875: ,x_return_status OUT NOCOPY VARCHAR2
13885: --if we change optional parameters, version goes FROM x.n to x.(n+1)
13886: l_api_version CONSTANT NUMBER := 1.0;
13887:
13888: l_object_id NUMBER;
13889: l_data_level_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
13890: l_current_dl_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
13891: l_ext_table_metadata_obj EGO_EXT_TABLE_METADATA_OBJ;
13892: l_chng_col_names_list VARCHAR2(20000);
13893: l_cols_to_exclude_list VARCHAR2(2000);
13886: l_api_version CONSTANT NUMBER := 1.0;
13887:
13888: l_object_id NUMBER;
13889: l_data_level_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
13890: l_current_dl_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
13891: l_ext_table_metadata_obj EGO_EXT_TABLE_METADATA_OBJ;
13892: l_chng_col_names_list VARCHAR2(20000);
13893: l_cols_to_exclude_list VARCHAR2(2000);
13894: l_pk_column_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
13890: l_current_dl_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
13891: l_ext_table_metadata_obj EGO_EXT_TABLE_METADATA_OBJ;
13892: l_chng_col_names_list VARCHAR2(20000);
13893: l_cols_to_exclude_list VARCHAR2(2000);
13894: l_pk_column_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
13895: l_class_code_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
13896: l_b_chng_cols_list VARCHAR2(10000);
13897: l_tl_chng_cols_list VARCHAR2(10000);
13898: l_history_b_chng_cols_list VARCHAR2(10000);
13891: l_ext_table_metadata_obj EGO_EXT_TABLE_METADATA_OBJ;
13892: l_chng_col_names_list VARCHAR2(20000);
13893: l_cols_to_exclude_list VARCHAR2(2000);
13894: l_pk_column_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
13895: l_class_code_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
13896: l_b_chng_cols_list VARCHAR2(10000);
13897: l_tl_chng_cols_list VARCHAR2(10000);
13898: l_history_b_chng_cols_list VARCHAR2(10000);
13899: l_history_tl_chng_cols_list VARCHAR2(10000);
13980: -- ASSUMPTION: no PKs will ever be DATE objects
13981: --
13982: IF (l_ext_table_metadata_obj.pk_column_metadata.COUNT = 5) THEN
13983: l_pk_column_name_value_pairs :=
13984: EGO_COL_NAME_VALUE_PAIR_ARRAY(
13985: EGO_COL_NAME_VALUE_PAIR_OBJ(
13986: l_ext_table_metadata_obj.pk_column_metadata(1).COL_NAME, NULL
13987: )
13988: ,EGO_COL_NAME_VALUE_PAIR_OBJ(
14020: l_ext_table_metadata_obj.pk_column_metadata(5).COL_NAME||
14021: '''';
14022: ELSIF (l_ext_table_metadata_obj.pk_column_metadata.COUNT = 4) THEN
14023: l_pk_column_name_value_pairs :=
14024: EGO_COL_NAME_VALUE_PAIR_ARRAY(
14025: EGO_COL_NAME_VALUE_PAIR_OBJ(
14026: l_ext_table_metadata_obj.pk_column_metadata(1).COL_NAME, NULL
14027: )
14028: ,EGO_COL_NAME_VALUE_PAIR_OBJ(
14053: l_ext_table_metadata_obj.pk_column_metadata(4).COL_NAME||
14054: '''';
14055: ELSIF (l_ext_table_metadata_obj.pk_column_metadata.COUNT = 3) THEN
14056: l_pk_column_name_value_pairs :=
14057: EGO_COL_NAME_VALUE_PAIR_ARRAY(
14058: EGO_COL_NAME_VALUE_PAIR_OBJ(
14059: l_ext_table_metadata_obj.pk_column_metadata(1).COL_NAME, NULL
14060: )
14061: ,EGO_COL_NAME_VALUE_PAIR_OBJ(
14079: l_ext_table_metadata_obj.pk_column_metadata(3).COL_NAME||
14080: '''';
14081: ELSIF (l_ext_table_metadata_obj.pk_column_metadata.COUNT = 2) THEN
14082: l_pk_column_name_value_pairs :=
14083: EGO_COL_NAME_VALUE_PAIR_ARRAY(
14084: EGO_COL_NAME_VALUE_PAIR_OBJ(
14085: l_ext_table_metadata_obj.pk_column_metadata(1).COL_NAME, NULL
14086: )
14087: ,EGO_COL_NAME_VALUE_PAIR_OBJ(
14098: l_ext_table_metadata_obj.pk_column_metadata(2).COL_NAME||
14099: '''';
14100: ELSIF (l_ext_table_metadata_obj.pk_column_metadata.COUNT = 1) THEN
14101: l_pk_column_name_value_pairs :=
14102: EGO_COL_NAME_VALUE_PAIR_ARRAY(
14103: EGO_COL_NAME_VALUE_PAIR_OBJ(
14104: l_ext_table_metadata_obj.pk_column_metadata(1).COL_NAME, NULL
14105: )
14106: );
14119: IF (l_ext_table_metadata_obj.class_code_metadata IS NOT NULL AND
14120: l_ext_table_metadata_obj.class_code_metadata.COUNT > 0 AND
14121: l_ext_table_metadata_obj.class_code_metadata(1).COL_NAME IS NOT NULL) THEN
14122: l_class_code_name_value_pairs :=
14123: EGO_COL_NAME_VALUE_PAIR_ARRAY(
14124: EGO_COL_NAME_VALUE_PAIR_OBJ(
14125: l_ext_table_metadata_obj.class_code_metadata(1).COL_NAME, NULL
14126: ),
14127: EGO_COL_NAME_VALUE_PAIR_OBJ(
14874: ,p_pk_value3 IN VARCHAR2 DEFAULT NULL
14875: ,p_pk_value4 IN VARCHAR2 DEFAULT NULL
14876: ,p_pk_value5 IN VARCHAR2 DEFAULT NULL
14877: ,p_data_level IN VARCHAR2 DEFAULT NULL
14878: ,p_dl_pk_values IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
14879: ,p_dl_metadata_obj IN EGO_DATA_LEVEL_METADATA_OBJ DEFAULT NULL
14880: ,x_str_val OUT NOCOPY VARCHAR2
14881: ,x_num_val OUT NOCOPY NUMBER
14882: ,x_date_val OUT NOCOPY DATE
15155: ,p_pk_value3 IN VARCHAR2 DEFAULT NULL
15156: ,p_pk_value4 IN VARCHAR2 DEFAULT NULL
15157: ,p_pk_value5 IN VARCHAR2 DEFAULT NULL
15158: ,p_data_level IN VARCHAR2 DEFAULT NULL
15159: ,p_dl_pk_values IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
15160: )
15161: RETURN VARCHAR2
15162: IS
15163:
15164: l_api_name VARCHAR2(30) := 'Get_User_Attr_Val():';
15165: l_attr_group_metadata_obj EGO_ATTR_GROUP_METADATA_OBJ;
15166: -- declared in EGOSEFD2.sql
15167: l_attr_metadata_obj EGO_ATTR_METADATA_OBJ;
15168: l_pk_column_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
15169: l_attr_int_value VARCHAR2(1000);
15170: l_attr_disp_value VARCHAR2(1000);
15171:
15172: l_attr_metadata_table EGO_ATTR_METADATA_TABLE;
15320: p_pk_col3 IS NOT NULL AND
15321: p_pk_col4 IS NOT NULL AND
15322: p_pk_col5 IS NOT NULL) THEN
15323:
15324: l_pk_column_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
15325: EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk_col1, p_pk_value1)
15326: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk_col2, p_pk_value2)
15327: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk_col3, p_pk_value3)
15328: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk_col4, p_pk_value4)
15337: ELSIF (p_pk_col2 IS NOT NULL AND
15338: p_pk_col3 IS NOT NULL AND
15339: p_pk_col4 IS NOT NULL) THEN
15340:
15341: l_pk_column_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
15342: EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk_col1, p_pk_value1)
15343: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk_col2, p_pk_value2)
15344: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk_col3, p_pk_value3)
15345: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk_col4, p_pk_value4)
15347:
15348: ELSIF (p_pk_col2 IS NOT NULL AND
15349: p_pk_col3 IS NOT NULL) THEN
15350:
15351: l_pk_column_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
15352: EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk_col1, p_pk_value1)
15353: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk_col2, p_pk_value2)
15354: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk_col3, p_pk_value3)
15355: );
15355: );
15356:
15357: ELSIF (p_pk_col2 IS NOT NULL) THEN
15358:
15359: l_pk_column_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
15360: EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk_col1, p_pk_value1)
15361: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk_col2, p_pk_value2)
15362: );
15363:
15362: );
15363:
15364: ELSE
15365:
15366: l_pk_column_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
15367: EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk_col1, p_pk_value1)
15368: );
15369:
15370: END IF;
15592:
15593: ----------------------------------------------------------------------
15594:
15595: PROCEDURE Update_Attributes (
15596: p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
15597: , p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
15598: , p_data_level IN VARCHAR2 DEFAULT NULL
15599: , p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
15600: , p_attr_diffs IN EGO_USER_ATTR_DIFF_TABLE
15593: ----------------------------------------------------------------------
15594:
15595: PROCEDURE Update_Attributes (
15596: p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
15597: , p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
15598: , p_data_level IN VARCHAR2 DEFAULT NULL
15599: , p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
15600: , p_attr_diffs IN EGO_USER_ATTR_DIFF_TABLE
15601: , p_transaction_type IN VARCHAR2
15595: PROCEDURE Update_Attributes (
15596: p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
15597: , p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
15598: , p_data_level IN VARCHAR2 DEFAULT NULL
15599: , p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
15600: , p_attr_diffs IN EGO_USER_ATTR_DIFF_TABLE
15601: , p_transaction_type IN VARCHAR2
15602: , p_attr_group_id IN NUMBER DEFAULT NULL
15603: , x_error_message OUT NOCOPY VARCHAR2
15753:
15754: -- Either pass in attr_group_id or attr_group_name
15755: PROCEDURE Get_Attr_Diffs (
15756: p_object_name IN VARCHAR2
15757: , p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
15758: , p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
15759: , p_data_level IN VARCHAR2 DEFAULT NULL --R12C
15760: , p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
15761: , p_attr_group_id IN NUMBER DEFAULT NULL
15754: -- Either pass in attr_group_id or attr_group_name
15755: PROCEDURE Get_Attr_Diffs (
15756: p_object_name IN VARCHAR2
15757: , p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
15758: , p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
15759: , p_data_level IN VARCHAR2 DEFAULT NULL --R12C
15760: , p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
15761: , p_attr_group_id IN NUMBER DEFAULT NULL
15762: , p_application_id IN NUMBER DEFAULT NULL
15756: p_object_name IN VARCHAR2
15757: , p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
15758: , p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
15759: , p_data_level IN VARCHAR2 DEFAULT NULL --R12C
15760: , p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
15761: , p_attr_group_id IN NUMBER DEFAULT NULL
15762: , p_application_id IN NUMBER DEFAULT NULL
15763: , p_attr_group_type IN VARCHAR2 DEFAULT NULL
15764: , p_attr_group_name IN VARCHAR2 DEFAULT NULL
15903: l_attr_value_obj EGO_USER_ATTR_DATA_OBJ;
15904: l_attr_metadata_obj EGO_ATTR_METADATA_OBJ;
15905: l_attr_metadata_obj_table EGO_ATTR_METADATA_TABLE;
15906: l_attr_group_metadata_obj EGO_ATTR_GROUP_METADATA_OBJ;
15907: l_pk_column_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
15908: l_data_level_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
15909: l_attr_disp_value VARCHAR2(5000);
15910: BEGIN
15911: l_attr_value_obj := EGO_USER_ATTR_DATA_OBJ (null
15904: l_attr_metadata_obj EGO_ATTR_METADATA_OBJ;
15905: l_attr_metadata_obj_table EGO_ATTR_METADATA_TABLE;
15906: l_attr_group_metadata_obj EGO_ATTR_GROUP_METADATA_OBJ;
15907: l_pk_column_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
15908: l_data_level_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
15909: l_attr_disp_value VARCHAR2(5000);
15910: BEGIN
15911: l_attr_value_obj := EGO_USER_ATTR_DATA_OBJ (null
15912: ,p_attr_internal_name
15939: END IF;
15940: END LOOP;
15941: END IF;
15942:
15943: l_pk_column_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
15944: EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk1_column_name,p_pk1_value)
15945: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk2_column_name,p_pk2_value)
15946: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk3_column_name,p_pk3_value)
15947: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk4_column_name,p_pk4_value)
15946: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk3_column_name,p_pk3_value)
15947: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk4_column_name,p_pk4_value)
15948: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk5_column_name,p_pk5_value)
15949: );
15950: l_data_level_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
15951: EGO_COL_NAME_VALUE_PAIR_OBJ(p_data_level1_column_name,p_data_level1_value)
15952: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_data_level2_column_name,p_data_level2_value)
15953: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_data_level3_column_name,p_data_level3_value)
15954: );
16019: l_attr_value_obj EGO_USER_ATTR_DATA_OBJ;
16020: l_attr_metadata_obj EGO_ATTR_METADATA_OBJ;
16021: l_attr_metadata_obj_table EGO_ATTR_METADATA_TABLE;
16022: l_attr_group_metadata_obj EGO_ATTR_GROUP_METADATA_OBJ;
16023: l_pk_column_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
16024: l_data_level_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
16025: l_attr_internal_value VARCHAR2(4000);
16026: l_ext_table_metadata_obj EGO_EXT_TABLE_METADATA_OBJ;
16027: BEGIN
16020: l_attr_metadata_obj EGO_ATTR_METADATA_OBJ;
16021: l_attr_metadata_obj_table EGO_ATTR_METADATA_TABLE;
16022: l_attr_group_metadata_obj EGO_ATTR_GROUP_METADATA_OBJ;
16023: l_pk_column_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
16024: l_data_level_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
16025: l_attr_internal_value VARCHAR2(4000);
16026: l_ext_table_metadata_obj EGO_EXT_TABLE_METADATA_OBJ;
16027: BEGIN
16028: l_attr_value_obj := EGO_USER_ATTR_DATA_OBJ (null
16113: END IF;
16114:
16115: END IF;
16116:
16117: l_pk_column_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
16118: EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk1_column_name,p_pk1_value)
16119: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk2_column_name,p_pk2_value)
16120: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk3_column_name,p_pk3_value)
16121: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk4_column_name,p_pk4_value)
16121: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk4_column_name,p_pk4_value)
16122: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk5_column_name,p_pk5_value)
16123: );
16124:
16125: l_data_level_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
16126: EGO_COL_NAME_VALUE_PAIR_OBJ(p_data_level1_column_name,p_data_level1_value)
16127: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_data_level2_column_name,p_data_level2_value)
16128: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_data_level3_column_name,p_data_level3_value)
16129: );
16177:
16178: ---------------------------------------------------------------------------
16179:
16180: PROCEDURE Process_Data_Level_Nvp(
16181: p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
16182: ,x_data_level_obj OUT NOCOPY EGO_COL_NAME_VALUE_PAIR_OBJ
16183: ,x_data_level_index OUT NOCOPY NUMBER
16184: ) IS
16185: l_api_name VARCHAR2(30) := 'Process_data_level_nvp';
16227:
16228: ---------------------------------------------------------------------------
16229:
16230: PROCEDURE Process_Class_Code_Nvp(
16231: p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
16232: ,x_base_class_obj OUT NOCOPY EGO_COL_NAME_VALUE_PAIR_OBJ
16233: ,x_related_class_obj OUT NOCOPY EGO_COL_NAME_VALUE_PAIR_OBJ
16234: ) IS
16235: l_api_name VARCHAR2(30) := 'Process_Class_Code_Nvp';
16275:
16276: ---------------------------------------------------------------------------
16277:
16278: PROCEDURE Build_Class_Code_Table(
16279: p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
16280: ,x_class_code_table OUT NOCOPY LOCAL_MEDIUM_VARCHAR_TABLE
16281: ) IS
16282: l_base_class_obj EGO_COL_NAME_VALUE_PAIR_OBJ;
16283: l_related_class_obj EGO_COL_NAME_VALUE_PAIR_OBJ;
16344:
16345: ----------------------------------------------------------------------------*/
16346: PROCEDURE Extract_Data_Level_Values(
16347: p_data_level_name IN EGO_DATA_LEVEL_VL.DATA_LEVEL_NAME%TYPE
16348: ,p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
16349: ,x_data_level_1 OUT NOCOPY VARCHAR2
16350: ,x_data_level_2 OUT NOCOPY VARCHAR2
16351: ,x_data_level_3 OUT NOCOPY VARCHAR2
16352: )
16480:
16481: ----------------------------------------------------------------------------*/
16482: PROCEDURE Build_Request_Table_For_Obj(
16483: p_object_name IN VARCHAR2
16484: ,p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
16485: ,p_data_level_name IN EGO_DATA_LEVEL_VL.DATA_LEVEL_NAME%TYPE
16486: ,p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
16487: -- the data level key values
16488: ,p_attr_group_type_table IN EGO_VARCHAR_TBL_TYPE
16482: PROCEDURE Build_Request_Table_For_Obj(
16483: p_object_name IN VARCHAR2
16484: ,p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
16485: ,p_data_level_name IN EGO_DATA_LEVEL_VL.DATA_LEVEL_NAME%TYPE
16486: ,p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
16487: -- the data level key values
16488: ,p_attr_group_type_table IN EGO_VARCHAR_TBL_TYPE
16489: ,x_attr_group_request_table OUT NOCOPY EGO_ATTR_GROUP_REQUEST_TABLE
16490: ) IS
16833: --
16834: PROCEDURE Validate_Required_Attrs (
16835: p_api_version IN NUMBER
16836: ,p_object_name IN VARCHAR2
16837: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
16838: ,p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
16839: ,p_data_level_name IN EGO_DATA_LEVEL_B.DATA_LEVEL_NAME%TYPE := NULL
16840: ,p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
16841: ,p_attr_group_type_table IN EGO_VARCHAR_TBL_TYPE
16834: PROCEDURE Validate_Required_Attrs (
16835: p_api_version IN NUMBER
16836: ,p_object_name IN VARCHAR2
16837: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
16838: ,p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
16839: ,p_data_level_name IN EGO_DATA_LEVEL_B.DATA_LEVEL_NAME%TYPE := NULL
16840: ,p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
16841: ,p_attr_group_type_table IN EGO_VARCHAR_TBL_TYPE
16842: ,p_entity_id IN NUMBER DEFAULT NULL
16836: ,p_object_name IN VARCHAR2
16837: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
16838: ,p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
16839: ,p_data_level_name IN EGO_DATA_LEVEL_B.DATA_LEVEL_NAME%TYPE := NULL
16840: ,p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
16841: ,p_attr_group_type_table IN EGO_VARCHAR_TBL_TYPE
16842: ,p_entity_id IN NUMBER DEFAULT NULL
16843: ,p_entity_index IN NUMBER DEFAULT NULL
16844: ,p_entity_code IN VARCHAR2 DEFAULT NULL
17118: p_object_name IN VARCHAR2
17119: ,p_application_id IN NUMBER
17120: ,p_attr_group_type IN VARCHAR2
17121: ,p_attr_groups_to_exclude IN VARCHAR2 DEFAULT NULL
17122: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
17123: ,p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
17124: ,p_data_level IN VARCHAR2 DEFAULT NULL
17125: ,p_data_level_values IN EGO_COL_NAME_VALUE_PAIR_ARRAY
17126: ,p_additional_class_Code_list IN VARCHAR2 DEFAULT NULL
17119: ,p_application_id IN NUMBER
17120: ,p_attr_group_type IN VARCHAR2
17121: ,p_attr_groups_to_exclude IN VARCHAR2 DEFAULT NULL
17122: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
17123: ,p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
17124: ,p_data_level IN VARCHAR2 DEFAULT NULL
17125: ,p_data_level_values IN EGO_COL_NAME_VALUE_PAIR_ARRAY
17126: ,p_additional_class_Code_list IN VARCHAR2 DEFAULT NULL
17127: ,p_entity_id IN NUMBER DEFAULT NULL
17121: ,p_attr_groups_to_exclude IN VARCHAR2 DEFAULT NULL
17122: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
17123: ,p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
17124: ,p_data_level IN VARCHAR2 DEFAULT NULL
17125: ,p_data_level_values IN EGO_COL_NAME_VALUE_PAIR_ARRAY
17126: ,p_additional_class_Code_list IN VARCHAR2 DEFAULT NULL
17127: ,p_entity_id IN NUMBER DEFAULT NULL
17128: ,p_entity_index IN NUMBER DEFAULT NULL
17129: ,p_entity_code IN VARCHAR2 DEFAULT NULL
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:
17177: TYPE DYNAMIC_CUR IS REF CURSOR;