[Home] [Help]
381: PROCEDURE Is_Name_Value_Pairs_Valid
382: ( p_attr_group_id IN NUMBER
383: ,p_data_level_name IN VARCHAR2
384: ,p_class_code_hierarchy IN VARCHAR2
385: ,p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
386: ,x_data_level_id OUT NOCOPY NUMBER
387: ,x_name_value_pair_valid OUT NOCOPY VARCHAR2
388: ) IS
389:
530: -- Private
531: --
532: FUNCTION Get_Hierarchy_For_AG_Type (
533: p_ag_type IN VARCHAR2
534: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
535: )
536: RETURN LOCAL_HIERARCHY_REC
537: IS
538:
723: --
724: PROCEDURE Get_Changed_Attributes (
725: p_dml_operation IN VARCHAR2
726: ,p_object_name IN VARCHAR2
727: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
728: ,p_attr_group_metadata_obj IN EGO_ATTR_GROUP_METADATA_OBJ
729: ,p_ext_table_metadata_obj IN EGO_EXT_TABLE_METADATA_OBJ
730: ,p_data_level IN VARCHAR2 DEFAULT NULL --R12C
731: ,p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
727: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
728: ,p_attr_group_metadata_obj IN EGO_ATTR_GROUP_METADATA_OBJ
729: ,p_ext_table_metadata_obj IN EGO_EXT_TABLE_METADATA_OBJ
730: ,p_data_level IN VARCHAR2 DEFAULT NULL --R12C
731: ,p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
732: ,p_attr_name_value_pairs IN EGO_USER_ATTR_DATA_TABLE
733: ,p_extension_id IN NUMBER DEFAULT NULL
734: ,p_entity_id IN NUMBER DEFAULT NULL
735: ,p_entity_index IN NUMBER DEFAULT NULL
1288: --
1289: -- Private
1290: --
1291: PROCEDURE Propagate_Attributes (
1292: p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
1293: , p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
1294: , p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
1295: , p_attr_diffs IN EGO_USER_ATTR_DIFF_TABLE
1296: , p_transaction_type IN VARCHAR2
1289: -- Private
1290: --
1291: PROCEDURE Propagate_Attributes (
1292: p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
1293: , p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
1294: , p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
1295: , p_attr_diffs IN EGO_USER_ATTR_DIFF_TABLE
1296: , p_transaction_type IN VARCHAR2
1297: , p_attr_group_metadata_obj IN EGO_ATTR_GROUP_METADATA_OBJ
1290: --
1291: PROCEDURE Propagate_Attributes (
1292: p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
1293: , p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
1294: , p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
1295: , p_attr_diffs IN EGO_USER_ATTR_DIFF_TABLE
1296: , p_transaction_type IN VARCHAR2
1297: , p_attr_group_metadata_obj IN EGO_ATTR_GROUP_METADATA_OBJ
1298: , x_return_status OUT NOCOPY VARCHAR2
1690: ,p_data_level_3 IN VARCHAR2
1691: ,p_data_level_4 IN VARCHAR2
1692: ,p_data_level_5 IN VARCHAR2
1693: )
1694: RETURN EGO_COL_NAME_VALUE_PAIR_ARRAY
1695: IS
1696:
1697: l_object_id NUMBER;
1698: l_ext_table_metadata_obj EGO_EXT_TABLE_METADATA_OBJ;
1701: l_data_level_2_name_value_pair EGO_COL_NAME_VALUE_PAIR_OBJ;
1702: l_data_level_3_name_value_pair EGO_COL_NAME_VALUE_PAIR_OBJ;
1703: l_data_level_4_name_value_pair EGO_COL_NAME_VALUE_PAIR_OBJ;
1704: l_data_level_5_name_value_pair EGO_COL_NAME_VALUE_PAIR_OBJ;
1705: l_data_level_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
1706: l_data_level_metadata EGO_DATA_LEVEL_METADATA_OBJ;
1707: BEGIN
1708:
1709: Debug_Msg('In Build_Data_Level_Array, starting', 2);
1735: l_data_level_5_name_value_pair := EGO_COL_NAME_VALUE_PAIR_OBJ(l_data_level_metadata.PK_COLUMN_NAME5,p_data_level_5);
1736: END IF;
1737:
1738: IF (l_data_level_5_name_value_pair IS NOT NULL) THEN
1739: l_data_level_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
1740: l_data_level_1_name_value_pair
1741: ,l_data_level_2_name_value_pair
1742: ,l_data_level_3_name_value_pair
1743: ,l_data_level_4_name_value_pair
1743: ,l_data_level_4_name_value_pair
1744: ,l_data_level_5_name_value_pair
1745: );
1746: ELSIF (l_data_level_4_name_value_pair IS NOT NULL) THEN
1747: l_data_level_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
1748: l_data_level_1_name_value_pair
1749: ,l_data_level_2_name_value_pair
1750: ,l_data_level_3_name_value_pair
1751: ,l_data_level_4_name_value_pair
1750: ,l_data_level_3_name_value_pair
1751: ,l_data_level_4_name_value_pair
1752: );
1753: ELSIF (l_data_level_3_name_value_pair IS NOT NULL) THEN
1754: l_data_level_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
1755: l_data_level_1_name_value_pair
1756: ,l_data_level_2_name_value_pair
1757: ,l_data_level_3_name_value_pair
1758: );
1756: ,l_data_level_2_name_value_pair
1757: ,l_data_level_3_name_value_pair
1758: );
1759: ELSIF (l_data_level_2_name_value_pair IS NOT NULL) THEN
1760: l_data_level_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
1761: l_data_level_1_name_value_pair
1762: ,l_data_level_2_name_value_pair
1763: );
1764: ELSIF (l_data_level_1_name_value_pair IS NOT NULL) THEN
1761: l_data_level_1_name_value_pair
1762: ,l_data_level_2_name_value_pair
1763: );
1764: ELSIF (l_data_level_1_name_value_pair IS NOT NULL) THEN
1765: l_data_level_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
1766: l_data_level_1_name_value_pair
1767: );
1768: ELSE
1769: l_data_level_name_value_pairs := NULL;
1799: END IF;
1800: END IF;
1801:
1802: IF (l_data_level_3_name_value_pair IS NOT NULL) THEN
1803: l_data_level_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
1804: l_data_level_1_name_value_pair
1805: ,l_data_level_2_name_value_pair
1806: ,l_data_level_3_name_value_pair
1807: );
1805: ,l_data_level_2_name_value_pair
1806: ,l_data_level_3_name_value_pair
1807: );
1808: ELSIF (l_data_level_2_name_value_pair IS NOT NULL) THEN
1809: l_data_level_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
1810: l_data_level_1_name_value_pair
1811: ,l_data_level_2_name_value_pair
1812: );
1813: ELSE
1810: l_data_level_1_name_value_pair
1811: ,l_data_level_2_name_value_pair
1812: );
1813: ELSE
1814: l_data_level_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
1815: l_data_level_1_name_value_pair
1816: );
1817:
1818: END IF;
2370:
2371: PROCEDURE Build_Where_Clause (
2372: p_attr_group_metadata_obj IN EGO_ATTR_GROUP_METADATA_OBJ
2373: ,p_ext_table_metadata_obj IN EGO_EXT_TABLE_METADATA_OBJ
2374: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
2375: ,p_data_level IN VARCHAR2 DEFAULT NULL --R12C
2376: ,p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
2377: ,p_attr_name_value_pairs IN EGO_USER_ATTR_DATA_TABLE DEFAULT NULL
2378: ) IS
2372: p_attr_group_metadata_obj IN EGO_ATTR_GROUP_METADATA_OBJ
2373: ,p_ext_table_metadata_obj IN EGO_EXT_TABLE_METADATA_OBJ
2374: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
2375: ,p_data_level IN VARCHAR2 DEFAULT NULL --R12C
2376: ,p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
2377: ,p_attr_name_value_pairs IN EGO_USER_ATTR_DATA_TABLE DEFAULT NULL
2378: ) IS
2379:
2380: l_api_name VARCHAR2(30) := 'Build_Where_Clause';
2530: FUNCTION Tokenized_Val_Set_Query (
2531: p_attr_metadata_obj IN EGO_ATTR_METADATA_OBJ
2532: ,p_attr_group_metadata_obj IN EGO_ATTR_GROUP_METADATA_OBJ
2533: ,p_ext_table_metadata_obj IN EGO_EXT_TABLE_METADATA_OBJ
2534: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
2535: ,p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
2536: ,p_entity_id IN VARCHAR2
2537: ,p_entity_index IN NUMBER
2538: ,p_entity_code IN VARCHAR2
2531: p_attr_metadata_obj IN EGO_ATTR_METADATA_OBJ
2532: ,p_attr_group_metadata_obj IN EGO_ATTR_GROUP_METADATA_OBJ
2533: ,p_ext_table_metadata_obj IN EGO_EXT_TABLE_METADATA_OBJ
2534: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
2535: ,p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
2536: ,p_entity_id IN VARCHAR2
2537: ,p_entity_index IN NUMBER
2538: ,p_entity_code IN VARCHAR2
2539: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
2917: p_attr_metadata_obj IN EGO_ATTR_METADATA_OBJ
2918: ,p_attr_value_obj IN EGO_USER_ATTR_DATA_OBJ
2919: ,p_attr_group_metadata_obj IN EGO_ATTR_GROUP_METADATA_OBJ
2920: ,p_ext_table_metadata_obj IN EGO_EXT_TABLE_METADATA_OBJ
2921: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
2922: ,p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
2923: ,p_entity_id IN VARCHAR2
2924: ,p_entity_index IN NUMBER
2925: ,p_entity_code IN VARCHAR2
2918: ,p_attr_value_obj IN EGO_USER_ATTR_DATA_OBJ
2919: ,p_attr_group_metadata_obj IN EGO_ATTR_GROUP_METADATA_OBJ
2920: ,p_ext_table_metadata_obj IN EGO_EXT_TABLE_METADATA_OBJ
2921: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
2922: ,p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
2923: ,p_entity_id IN VARCHAR2
2924: ,p_entity_index IN NUMBER
2925: ,p_entity_code IN VARCHAR2
2926: ,p_attr_name_value_pairs IN EGO_USER_ATTR_DATA_TABLE
3025: p_attr_int_value IN VARCHAR2 DEFAULT NULL
3026: ,p_attr_value_obj IN EGO_USER_ATTR_DATA_OBJ DEFAULT NULL
3027: ,p_attr_metadata_obj IN EGO_ATTR_METADATA_OBJ
3028: ,p_attr_group_metadata_obj IN EGO_ATTR_GROUP_METADATA_OBJ
3029: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
3030: ,p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
3031: ,p_entity_id IN VARCHAR2 DEFAULT NULL
3032: ,p_entity_index IN NUMBER DEFAULT NULL
3033: ,p_entity_code IN VARCHAR2 DEFAULT NULL
3026: ,p_attr_value_obj IN EGO_USER_ATTR_DATA_OBJ DEFAULT NULL
3027: ,p_attr_metadata_obj IN EGO_ATTR_METADATA_OBJ
3028: ,p_attr_group_metadata_obj IN EGO_ATTR_GROUP_METADATA_OBJ
3029: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
3030: ,p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
3031: ,p_entity_id IN VARCHAR2 DEFAULT NULL
3032: ,p_entity_index IN NUMBER DEFAULT NULL
3033: ,p_entity_code IN VARCHAR2 DEFAULT NULL
3034: ,p_attr_name_value_pairs IN EGO_USER_ATTR_DATA_TABLE DEFAULT NULL
3170:
3171: FUNCTION Get_Extension_Id_For_Row (
3172: p_attr_group_metadata_obj IN EGO_ATTR_GROUP_METADATA_OBJ
3173: ,p_ext_table_metadata_obj IN EGO_EXT_TABLE_METADATA_OBJ
3174: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
3175: ,p_data_level IN VARCHAR2 DEFAULT NULL --R12C
3176: ,p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
3177: ,p_attr_name_value_pairs IN EGO_USER_ATTR_DATA_TABLE
3178: ,p_change_obj IN EGO_USER_ATTR_CHANGE_OBJ DEFAULT NULL
3172: p_attr_group_metadata_obj IN EGO_ATTR_GROUP_METADATA_OBJ
3173: ,p_ext_table_metadata_obj IN EGO_EXT_TABLE_METADATA_OBJ
3174: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
3175: ,p_data_level IN VARCHAR2 DEFAULT NULL --R12C
3176: ,p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
3177: ,p_attr_name_value_pairs IN EGO_USER_ATTR_DATA_TABLE
3178: ,p_change_obj IN EGO_USER_ATTR_CHANGE_OBJ DEFAULT NULL
3179: ,p_extra_pk_col_name_val_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
3180: ,p_pending_b_table_name IN VARCHAR2 DEFAULT NULL
3175: ,p_data_level IN VARCHAR2 DEFAULT NULL --R12C
3176: ,p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
3177: ,p_attr_name_value_pairs IN EGO_USER_ATTR_DATA_TABLE
3178: ,p_change_obj IN EGO_USER_ATTR_CHANGE_OBJ DEFAULT NULL
3179: ,p_extra_pk_col_name_val_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
3180: ,p_pending_b_table_name IN VARCHAR2 DEFAULT NULL
3181: ,p_pending_vl_name IN VARCHAR2 DEFAULT NULL
3182: )
3183: RETURN NUMBER
3188: l_change_where_clause VARCHAR2(1000);
3189: l_extra_where_clause VARCHAR2(5000);
3190: l_cursor_id NUMBER;
3191: l_dynamic_sql VARCHAR2(15000);
3192: l_data_level_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
3193: l_number_of_rows NUMBER;
3194: l_extension_id NUMBER;
3195: l_index NUMBER;
3196:
3387: -------------------------------------------------------------------------------
3388:
3389: FUNCTION Fetch_UK_Attr_Display_Values(p_attr_group_metadata_obj IN EGO_ATTR_GROUP_METADATA_OBJ,
3390: p_ext_table_metadata_obj IN EGO_EXT_TABLE_METADATA_OBJ DEFAULT NULL,
3391: p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL,
3392: p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL,
3393: p_entity_id IN VARCHAR2 DEFAULT NULL,
3394: p_entity_index IN NUMBER DEFAULT NULL,
3395: p_entity_code IN VARCHAR2 DEFAULT NULL,
3388:
3389: FUNCTION Fetch_UK_Attr_Display_Values(p_attr_group_metadata_obj IN EGO_ATTR_GROUP_METADATA_OBJ,
3390: p_ext_table_metadata_obj IN EGO_EXT_TABLE_METADATA_OBJ DEFAULT NULL,
3391: p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL,
3392: p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL,
3393: p_entity_id IN VARCHAR2 DEFAULT NULL,
3394: p_entity_index IN NUMBER DEFAULT NULL,
3395: p_entity_code IN VARCHAR2 DEFAULT NULL,
3396: p_attr_name_value_pairs IN EGO_USER_ATTR_DATA_TABLE,
3538: ----------------------------------------------------------------------
3539:
3540: FUNCTION Fetch_UK_Attr_Values_Table(p_attr_group_metadata_obj IN EGO_ATTR_GROUP_METADATA_OBJ,
3541: p_ext_table_metadata_obj IN EGO_EXT_TABLE_METADATA_OBJ DEFAULT NULL,
3542: p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL,
3543: p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL,
3544: p_entity_id IN VARCHAR2 DEFAULT NULL,
3545: p_entity_index IN NUMBER DEFAULT NULL,
3546: p_entity_code IN VARCHAR2 DEFAULT NULL,
3539:
3540: FUNCTION Fetch_UK_Attr_Values_Table(p_attr_group_metadata_obj IN EGO_ATTR_GROUP_METADATA_OBJ,
3541: p_ext_table_metadata_obj IN EGO_EXT_TABLE_METADATA_OBJ DEFAULT NULL,
3542: p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL,
3543: p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL,
3544: p_entity_id IN VARCHAR2 DEFAULT NULL,
3545: p_entity_index IN NUMBER DEFAULT NULL,
3546: p_entity_code IN VARCHAR2 DEFAULT NULL,
3547: p_attr_name_value_pairs IN EGO_USER_ATTR_DATA_TABLE)
3783: ----------------------------------------------------------------------
3784:
3785: PROCEDURE Get_Err_Info_For_UK_Violation(p_attr_group_metadata_obj IN EGO_ATTR_GROUP_METADATA_OBJ,
3786: p_ext_table_metadata_obj IN EGO_EXT_TABLE_METADATA_OBJ DEFAULT NULL,
3787: p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL,
3788: p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL,
3789: p_entity_id IN VARCHAR2 DEFAULT NULL,
3790: p_entity_index IN NUMBER DEFAULT NULL,
3791: p_entity_code IN VARCHAR2 DEFAULT NULL,
3784:
3785: PROCEDURE Get_Err_Info_For_UK_Violation(p_attr_group_metadata_obj IN EGO_ATTR_GROUP_METADATA_OBJ,
3786: p_ext_table_metadata_obj IN EGO_EXT_TABLE_METADATA_OBJ DEFAULT NULL,
3787: p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL,
3788: p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL,
3789: p_entity_id IN VARCHAR2 DEFAULT NULL,
3790: p_entity_index IN NUMBER DEFAULT NULL,
3791: p_entity_code IN VARCHAR2 DEFAULT NULL,
3792: p_attr_name_value_pairs IN EGO_USER_ATTR_DATA_TABLE,
3921:
3922: PROCEDURE Get_Extension_Id_And_Mode (
3923: p_attr_group_metadata_obj IN EGO_ATTR_GROUP_METADATA_OBJ
3924: ,p_ext_table_metadata_obj IN EGO_EXT_TABLE_METADATA_OBJ
3925: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
3926: ,p_data_level IN VARCHAR2 DEFAULT NULL --R12C
3927: ,p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
3928: ,p_attr_name_value_pairs IN EGO_USER_ATTR_DATA_TABLE
3929: ,p_extension_id IN NUMBER DEFAULT NULL
3923: p_attr_group_metadata_obj IN EGO_ATTR_GROUP_METADATA_OBJ
3924: ,p_ext_table_metadata_obj IN EGO_EXT_TABLE_METADATA_OBJ
3925: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
3926: ,p_data_level IN VARCHAR2 DEFAULT NULL --R12C
3927: ,p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
3928: ,p_attr_name_value_pairs IN EGO_USER_ATTR_DATA_TABLE
3929: ,p_extension_id IN NUMBER DEFAULT NULL
3930: ,p_mode IN VARCHAR2 DEFAULT NULL
3931: ,p_change_obj IN EGO_USER_ATTR_CHANGE_OBJ DEFAULT NULL
3928: ,p_attr_name_value_pairs IN EGO_USER_ATTR_DATA_TABLE
3929: ,p_extension_id IN NUMBER DEFAULT NULL
3930: ,p_mode IN VARCHAR2 DEFAULT NULL
3931: ,p_change_obj IN EGO_USER_ATTR_CHANGE_OBJ DEFAULT NULL
3932: ,p_extra_pk_col_name_val_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
3933: ,p_pending_b_table_name IN VARCHAR2 DEFAULT NULL
3934: ,p_pending_vl_name IN VARCHAR2 DEFAULT NULL
3935: ,p_entity_id IN VARCHAR2 DEFAULT NULL
3936: ,p_entity_index IN NUMBER DEFAULT NULL
4461:
4462:
4463: FUNCTION Are_These_Col_Names_Right (
4464: p_ext_table_col_metadata IN EGO_COL_METADATA_ARRAY
4465: ,p_col_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
4466: )
4467: RETURN BOOLEAN
4468: IS
4469:
4535: ----------------------------------------------------------------------
4536:
4537: FUNCTION Are_Ext_Table_Col_Names_Right (
4538: p_ext_table_metadata_obj IN EGO_EXT_TABLE_METADATA_OBJ
4539: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
4540: ,p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
4541: )
4542: RETURN BOOLEAN
4543: IS
4536:
4537: FUNCTION Are_Ext_Table_Col_Names_Right (
4538: p_ext_table_metadata_obj IN EGO_EXT_TABLE_METADATA_OBJ
4539: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
4540: ,p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
4541: )
4542: RETURN BOOLEAN
4543: IS
4544:
4577: FUNCTION Is_Data_Level_Correct (
4578: p_object_id IN NUMBER
4579: ,p_attr_group_id IN NUMBER
4580: ,p_ext_table_metadata_obj IN EGO_EXT_TABLE_METADATA_OBJ
4581: ,p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
4582: ,p_data_level IN VARCHAR2 DEFAULT NULL --R12C
4583: ,p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
4584: ,p_attr_group_disp_name IN VARCHAR2
4585: ,x_err_msg_name OUT NOCOPY VARCHAR2
4579: ,p_attr_group_id IN NUMBER
4580: ,p_ext_table_metadata_obj IN EGO_EXT_TABLE_METADATA_OBJ
4581: ,p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
4582: ,p_data_level IN VARCHAR2 DEFAULT NULL --R12C
4583: ,p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
4584: ,p_attr_group_disp_name IN VARCHAR2
4585: ,x_err_msg_name OUT NOCOPY VARCHAR2
4586: ,x_token_table OUT NOCOPY ERROR_HANDLER.Token_Tbl_Type
4587: )
5459: FUNCTION Is_Value_Set_Respected (
5460: p_attr_metadata_obj IN EGO_ATTR_METADATA_OBJ
5461: ,p_attr_group_metadata_obj IN EGO_ATTR_GROUP_METADATA_OBJ
5462: ,p_ext_table_metadata_obj IN EGO_EXT_TABLE_METADATA_OBJ
5463: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
5464: ,p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
5465: ,p_entity_id IN VARCHAR2
5466: ,p_entity_index IN NUMBER
5467: ,p_entity_code IN VARCHAR2
5460: p_attr_metadata_obj IN EGO_ATTR_METADATA_OBJ
5461: ,p_attr_group_metadata_obj IN EGO_ATTR_GROUP_METADATA_OBJ
5462: ,p_ext_table_metadata_obj IN EGO_EXT_TABLE_METADATA_OBJ
5463: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
5464: ,p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
5465: ,p_entity_id IN VARCHAR2
5466: ,p_entity_index IN NUMBER
5467: ,p_entity_code IN VARCHAR2
5468: ,p_attr_name_value_pairs IN EGO_USER_ATTR_DATA_TABLE
5942:
5943: PROCEDURE Generate_Attr_Int_Values (
5944: p_attr_group_metadata_obj IN EGO_ATTR_GROUP_METADATA_OBJ
5945: ,p_ext_table_metadata_obj IN EGO_EXT_TABLE_METADATA_OBJ
5946: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
5947: ,p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
5948: ,p_entity_id IN VARCHAR2 DEFAULT NULL
5949: ,p_entity_index IN NUMBER DEFAULT NULL
5950: ,p_entity_code IN VARCHAR2 DEFAULT NULL
5943: PROCEDURE Generate_Attr_Int_Values (
5944: p_attr_group_metadata_obj IN EGO_ATTR_GROUP_METADATA_OBJ
5945: ,p_ext_table_metadata_obj IN EGO_EXT_TABLE_METADATA_OBJ
5946: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
5947: ,p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
5948: ,p_entity_id IN VARCHAR2 DEFAULT NULL
5949: ,p_entity_index IN NUMBER DEFAULT NULL
5950: ,p_entity_code IN VARCHAR2 DEFAULT NULL
5951: ,px_attr_name_value_pairs IN OUT NOCOPY EGO_USER_ATTR_DATA_TABLE
6123: PROCEDURE Raise_WF_Event_If_Enabled (
6124: p_dml_type IN VARCHAR2
6125: ,p_attr_group_metadata_obj IN EGO_ATTR_GROUP_METADATA_OBJ
6126: ,p_extension_id IN NUMBER
6127: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
6128: ,p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
6129: ,p_entity_id IN VARCHAR2
6130: ,p_entity_index IN NUMBER
6131: ,p_entity_code IN VARCHAR2
6124: p_dml_type IN VARCHAR2
6125: ,p_attr_group_metadata_obj IN EGO_ATTR_GROUP_METADATA_OBJ
6126: ,p_extension_id IN NUMBER
6127: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
6128: ,p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
6129: ,p_entity_id IN VARCHAR2
6130: ,p_entity_index IN NUMBER
6131: ,p_entity_code IN VARCHAR2
6132: ,p_pre_event_flag IN VARCHAR2 DEFAULT NULL --4105841
6555: ----------------------------------------------------------------------
6556:
6557: PROCEDURE Perform_Preliminary_Checks (
6558: p_object_name IN VARCHAR2
6559: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
6560: ,p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
6561: ,p_entity_id IN VARCHAR2
6562: ,p_entity_index IN NUMBER
6563: ,p_entity_code IN VARCHAR2
6556:
6557: PROCEDURE Perform_Preliminary_Checks (
6558: p_object_name IN VARCHAR2
6559: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
6560: ,p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
6561: ,p_entity_id IN VARCHAR2
6562: ,p_entity_index IN NUMBER
6563: ,p_entity_code IN VARCHAR2
6564: ,x_return_status OUT NOCOPY VARCHAR2
6894: ,p_entity_code IN VARCHAR2 DEFAULT NULL
6895: ,p_debug_level IN NUMBER
6896: ,p_init_error_handler_flag IN BOOLEAN
6897: ,p_object_name IN VARCHAR2
6898: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
6899: ,p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
6900: ,p_init_fnd_msg_list IN VARCHAR2
6901: ,p_add_errors_to_fnd_stack IN VARCHAR2
6902: ,p_default_user_row_identifier IN NUMBER DEFAULT NULL
6895: ,p_debug_level IN NUMBER
6896: ,p_init_error_handler_flag IN BOOLEAN
6897: ,p_object_name IN VARCHAR2
6898: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
6899: ,p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
6900: ,p_init_fnd_msg_list IN VARCHAR2
6901: ,p_add_errors_to_fnd_stack IN VARCHAR2
6902: ,p_default_user_row_identifier IN NUMBER DEFAULT NULL
6903: ,p_use_def_vals_on_insert_flag IN BOOLEAN DEFAULT FALSE
7271: PROCEDURE Insert_Row (
7272: p_api_version IN NUMBER
7273: ,p_attr_group_metadata_obj IN EGO_ATTR_GROUP_METADATA_OBJ
7274: ,p_ext_table_metadata_obj IN EGO_EXT_TABLE_METADATA_OBJ
7275: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
7276: ,p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
7277: ,p_data_level IN VARCHAR2 DEFAULT NULL --R12C
7278: ,p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
7279: ,p_extension_id IN NUMBER
7272: p_api_version IN NUMBER
7273: ,p_attr_group_metadata_obj IN EGO_ATTR_GROUP_METADATA_OBJ
7274: ,p_ext_table_metadata_obj IN EGO_EXT_TABLE_METADATA_OBJ
7275: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
7276: ,p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
7277: ,p_data_level IN VARCHAR2 DEFAULT NULL --R12C
7278: ,p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
7279: ,p_extension_id IN NUMBER
7280: ,p_attr_name_value_pairs IN EGO_USER_ATTR_DATA_TABLE
7274: ,p_ext_table_metadata_obj IN EGO_EXT_TABLE_METADATA_OBJ
7275: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
7276: ,p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
7277: ,p_data_level IN VARCHAR2 DEFAULT NULL --R12C
7278: ,p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
7279: ,p_extension_id IN NUMBER
7280: ,p_attr_name_value_pairs IN EGO_USER_ATTR_DATA_TABLE
7281: ,p_language_to_process IN VARCHAR2
7282: ,p_change_obj IN EGO_USER_ATTR_CHANGE_OBJ
7279: ,p_extension_id IN NUMBER
7280: ,p_attr_name_value_pairs IN EGO_USER_ATTR_DATA_TABLE
7281: ,p_language_to_process IN VARCHAR2
7282: ,p_change_obj IN EGO_USER_ATTR_CHANGE_OBJ
7283: ,p_extra_pk_col_name_val_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
7284: ,p_extra_attr_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
7285: ,p_pending_b_table_name IN VARCHAR2
7286: ,p_pending_tl_table_name IN VARCHAR2
7287: ,p_execute_dml IN VARCHAR2 DEFAULT FND_API.G_TRUE
7280: ,p_attr_name_value_pairs IN EGO_USER_ATTR_DATA_TABLE
7281: ,p_language_to_process IN VARCHAR2
7282: ,p_change_obj IN EGO_USER_ATTR_CHANGE_OBJ
7283: ,p_extra_pk_col_name_val_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
7284: ,p_extra_attr_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
7285: ,p_pending_b_table_name IN VARCHAR2
7286: ,p_pending_tl_table_name IN VARCHAR2
7287: ,p_execute_dml IN VARCHAR2 DEFAULT FND_API.G_TRUE
7288: ,p_entity_id IN VARCHAR2
8178: PROCEDURE Update_Row (
8179: p_api_version IN NUMBER
8180: ,p_attr_group_metadata_obj IN EGO_ATTR_GROUP_METADATA_OBJ
8181: ,p_ext_table_metadata_obj IN EGO_EXT_TABLE_METADATA_OBJ
8182: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
8183: ,p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
8184: ,p_data_level IN VARCHAR2 DEFAULT NULL --R12C
8185: ,p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
8186: ,p_extension_id IN NUMBER
8179: p_api_version IN NUMBER
8180: ,p_attr_group_metadata_obj IN EGO_ATTR_GROUP_METADATA_OBJ
8181: ,p_ext_table_metadata_obj IN EGO_EXT_TABLE_METADATA_OBJ
8182: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
8183: ,p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
8184: ,p_data_level IN VARCHAR2 DEFAULT NULL --R12C
8185: ,p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
8186: ,p_extension_id IN NUMBER
8187: ,p_attr_name_value_pairs IN EGO_USER_ATTR_DATA_TABLE
8181: ,p_ext_table_metadata_obj IN EGO_EXT_TABLE_METADATA_OBJ
8182: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
8183: ,p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
8184: ,p_data_level IN VARCHAR2 DEFAULT NULL --R12C
8185: ,p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
8186: ,p_extension_id IN NUMBER
8187: ,p_attr_name_value_pairs IN EGO_USER_ATTR_DATA_TABLE
8188: ,p_language_to_process IN VARCHAR2
8189: ,p_change_obj IN EGO_USER_ATTR_CHANGE_OBJ
8186: ,p_extension_id IN NUMBER
8187: ,p_attr_name_value_pairs IN EGO_USER_ATTR_DATA_TABLE
8188: ,p_language_to_process IN VARCHAR2
8189: ,p_change_obj IN EGO_USER_ATTR_CHANGE_OBJ
8190: ,p_extra_attr_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
8191: ,p_extra_pk_col_name_val_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
8192: ,p_pending_b_table_name IN VARCHAR2
8193: ,p_pending_tl_table_name IN VARCHAR2
8194: ,p_execute_dml IN VARCHAR2 DEFAULT FND_API.G_TRUE
8187: ,p_attr_name_value_pairs IN EGO_USER_ATTR_DATA_TABLE
8188: ,p_language_to_process IN VARCHAR2
8189: ,p_change_obj IN EGO_USER_ATTR_CHANGE_OBJ
8190: ,p_extra_attr_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
8191: ,p_extra_pk_col_name_val_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
8192: ,p_pending_b_table_name IN VARCHAR2
8193: ,p_pending_tl_table_name IN VARCHAR2
8194: ,p_execute_dml IN VARCHAR2 DEFAULT FND_API.G_TRUE
8195: ,p_entity_id IN VARCHAR2
8824: ----------------------------------------------------------------------
8825: PROCEDURE Delete_Row (
8826: p_api_version IN NUMBER
8827: ,p_attr_group_metadata_obj IN EGO_ATTR_GROUP_METADATA_OBJ
8828: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
8829: ,p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
8830: ,p_data_level IN VARCHAR2 DEFAULT NULL --R12C
8831: ,p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
8832: ,p_extension_id IN NUMBER
8825: PROCEDURE Delete_Row (
8826: p_api_version IN NUMBER
8827: ,p_attr_group_metadata_obj IN EGO_ATTR_GROUP_METADATA_OBJ
8828: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
8829: ,p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
8830: ,p_data_level IN VARCHAR2 DEFAULT NULL --R12C
8831: ,p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
8832: ,p_extension_id IN NUMBER
8833: -- Start ssingal -For Ucc Net Attribute Propagation
8827: ,p_attr_group_metadata_obj IN EGO_ATTR_GROUP_METADATA_OBJ
8828: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
8829: ,p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
8830: ,p_data_level IN VARCHAR2 DEFAULT NULL --R12C
8831: ,p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
8832: ,p_extension_id IN NUMBER
8833: -- Start ssingal -For Ucc Net Attribute Propagation
8834: ,p_attr_name_value_pairs IN EGO_USER_ATTR_DATA_TABLE
8835: ,p_ext_table_metadata_obj IN EGO_EXT_TABLE_METADATA_OBJ
8835: ,p_ext_table_metadata_obj IN EGO_EXT_TABLE_METADATA_OBJ
8836: -- End ssingal
8837: ,p_language_to_process IN VARCHAR2
8838: ,p_change_obj IN EGO_USER_ATTR_CHANGE_OBJ
8839: ,p_extra_pk_col_name_val_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
8840: ,p_pending_b_table_name IN VARCHAR2
8841: ,p_pending_tl_table_name IN VARCHAR2
8842: ,p_execute_dml IN VARCHAR2 DEFAULT FND_API.G_TRUE
8843: -- Start ssingal -For Ucc Net Attribute Propagation
9168: ,p_object_id IN NUMBER
9169: ,p_validate_hierarchy IN VARCHAR2 DEFAULT FND_API.G_TRUE --Added for bugFix:5275391
9170: ,p_attr_group_metadata_obj IN EGO_ATTR_GROUP_METADATA_OBJ
9171: ,p_ext_table_metadata_obj IN EGO_EXT_TABLE_METADATA_OBJ
9172: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
9173: ,p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
9174: ,p_data_level IN VARCHAR2 DEFAULT NULL --R12C
9175: ,p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
9176: ,p_extension_id IN NUMBER
9169: ,p_validate_hierarchy IN VARCHAR2 DEFAULT FND_API.G_TRUE --Added for bugFix:5275391
9170: ,p_attr_group_metadata_obj IN EGO_ATTR_GROUP_METADATA_OBJ
9171: ,p_ext_table_metadata_obj IN EGO_EXT_TABLE_METADATA_OBJ
9172: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
9173: ,p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
9174: ,p_data_level IN VARCHAR2 DEFAULT NULL --R12C
9175: ,p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
9176: ,p_extension_id IN NUMBER
9177: ,p_mode IN VARCHAR2
9171: ,p_ext_table_metadata_obj IN EGO_EXT_TABLE_METADATA_OBJ
9172: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
9173: ,p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
9174: ,p_data_level IN VARCHAR2 DEFAULT NULL --R12C
9175: ,p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
9176: ,p_extension_id IN NUMBER
9177: ,p_mode IN VARCHAR2
9178: ,p_entity_id IN VARCHAR2 DEFAULT NULL
9179: ,p_entity_index IN NUMBER DEFAULT NULL
9627: p_api_version IN NUMBER
9628: ,p_object_id IN NUMBER
9629: ,p_attr_group_metadata_obj IN EGO_ATTR_GROUP_METADATA_OBJ
9630: ,p_ext_table_metadata_obj IN EGO_EXT_TABLE_METADATA_OBJ
9631: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
9632: ,p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
9633: ,p_data_level IN VARCHAR2 DEFAULT NULL --R12C
9634: ,p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
9635: ,p_extension_id IN NUMBER
9628: ,p_object_id IN NUMBER
9629: ,p_attr_group_metadata_obj IN EGO_ATTR_GROUP_METADATA_OBJ
9630: ,p_ext_table_metadata_obj IN EGO_EXT_TABLE_METADATA_OBJ
9631: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
9632: ,p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
9633: ,p_data_level IN VARCHAR2 DEFAULT NULL --R12C
9634: ,p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
9635: ,p_extension_id IN NUMBER
9636: ,p_attr_name_value_pairs IN EGO_USER_ATTR_DATA_TABLE
9630: ,p_ext_table_metadata_obj IN EGO_EXT_TABLE_METADATA_OBJ
9631: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
9632: ,p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
9633: ,p_data_level IN VARCHAR2 DEFAULT NULL --R12C
9634: ,p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
9635: ,p_extension_id IN NUMBER
9636: ,p_attr_name_value_pairs IN EGO_USER_ATTR_DATA_TABLE
9637: ,p_language_to_process IN VARCHAR2 DEFAULT NULL
9638: ,p_mode IN VARCHAR2
9636: ,p_attr_name_value_pairs IN EGO_USER_ATTR_DATA_TABLE
9637: ,p_language_to_process IN VARCHAR2 DEFAULT NULL
9638: ,p_mode IN VARCHAR2
9639: ,p_change_obj IN EGO_USER_ATTR_CHANGE_OBJ DEFAULT NULL
9640: ,p_extra_pk_col_name_val_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
9641: ,p_extra_attr_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
9642: ,p_pending_b_table_name IN VARCHAR2 DEFAULT NULL
9643: ,p_pending_tl_table_name IN VARCHAR2 DEFAULT NULL
9644: ,p_execute_dml IN VARCHAR2 DEFAULT FND_API.G_TRUE
9637: ,p_language_to_process IN VARCHAR2 DEFAULT NULL
9638: ,p_mode IN VARCHAR2
9639: ,p_change_obj IN EGO_USER_ATTR_CHANGE_OBJ DEFAULT NULL
9640: ,p_extra_pk_col_name_val_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
9641: ,p_extra_attr_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
9642: ,p_pending_b_table_name IN VARCHAR2 DEFAULT NULL
9643: ,p_pending_tl_table_name IN VARCHAR2 DEFAULT NULL
9644: ,p_execute_dml IN VARCHAR2 DEFAULT FND_API.G_TRUE
9645: ,p_entity_id IN VARCHAR2 DEFAULT NULL
9826: PROCEDURE Perform_DML_On_Template_Row (
9827: p_object_id IN NUMBER
9828: ,p_attr_group_metadata_obj IN EGO_ATTR_GROUP_METADATA_OBJ
9829: ,p_ext_table_metadata_obj IN EGO_EXT_TABLE_METADATA_OBJ
9830: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
9831: ,p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
9832: ,p_data_level IN VARCHAR2
9833: ,p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
9834: ,p_commit IN VARCHAR2
9827: p_object_id IN NUMBER
9828: ,p_attr_group_metadata_obj IN EGO_ATTR_GROUP_METADATA_OBJ
9829: ,p_ext_table_metadata_obj IN EGO_EXT_TABLE_METADATA_OBJ
9830: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
9831: ,p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
9832: ,p_data_level IN VARCHAR2
9833: ,p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
9834: ,p_commit IN VARCHAR2
9835: ,px_attr_name_value_pairs IN OUT NOCOPY EGO_USER_ATTR_DATA_TABLE
9829: ,p_ext_table_metadata_obj IN EGO_EXT_TABLE_METADATA_OBJ
9830: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
9831: ,p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
9832: ,p_data_level IN VARCHAR2
9833: ,p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
9834: ,p_commit IN VARCHAR2
9835: ,px_attr_name_value_pairs IN OUT NOCOPY EGO_USER_ATTR_DATA_TABLE
9836: ) IS
9837:
9948: ,p_attr_group_id IN NUMBER
9949: ,p_application_id IN NUMBER
9950: ,p_attr_group_type IN VARCHAR2
9951: ,p_attr_group_name IN VARCHAR2
9952: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
9953: ,p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
9954: ,p_data_level IN VARCHAR2 DEFAULT NULL --R12C
9955: ,p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
9956: ,p_extension_id IN NUMBER
9949: ,p_application_id IN NUMBER
9950: ,p_attr_group_type IN VARCHAR2
9951: ,p_attr_group_name IN VARCHAR2
9952: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
9953: ,p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
9954: ,p_data_level IN VARCHAR2 DEFAULT NULL --R12C
9955: ,p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
9956: ,p_extension_id IN NUMBER
9957: ,p_entity_id IN VARCHAR2
9951: ,p_attr_group_name IN VARCHAR2
9952: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
9953: ,p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
9954: ,p_data_level IN VARCHAR2 DEFAULT NULL --R12C
9955: ,p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
9956: ,p_extension_id IN NUMBER
9957: ,p_entity_id IN VARCHAR2
9958: ,p_entity_index IN NUMBER
9959: ,p_entity_code IN VARCHAR2
9962: ,p_use_def_vals_on_insert_flag IN BOOLEAN DEFAULT FALSE
9963: ,p_init_fnd_msg_list IN VARCHAR2
9964: ,p_mode IN VARCHAR2
9965: ,p_change_obj IN EGO_USER_ATTR_CHANGE_OBJ DEFAULT NULL
9966: ,p_extra_pk_col_name_val_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
9967: ,p_pending_b_table_name IN VARCHAR2 DEFAULT NULL
9968: ,p_pending_vl_name IN VARCHAR2 DEFAULT NULL
9969: ,p_bulkload_flag IN BOOLEAN DEFAULT FALSE
9970: ,px_object_id IN OUT NOCOPY NUMBER
10243: p_api_version IN NUMBER
10244: ,p_object_name IN VARCHAR2
10245: ,p_attributes_row_table IN EGO_USER_ATTR_ROW_TABLE
10246: ,p_attributes_data_table IN EGO_USER_ATTR_DATA_TABLE
10247: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
10248: ,p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
10249: ,p_user_privileges_on_object IN EGO_VARCHAR_TBL_TYPE DEFAULT NULL
10250: ,p_change_info_table IN EGO_USER_ATTR_CHANGE_TABLE DEFAULT NULL
10251: ,p_pending_b_table_name IN VARCHAR2 DEFAULT NULL
10244: ,p_object_name IN VARCHAR2
10245: ,p_attributes_row_table IN EGO_USER_ATTR_ROW_TABLE
10246: ,p_attributes_data_table IN EGO_USER_ATTR_DATA_TABLE
10247: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
10248: ,p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
10249: ,p_user_privileges_on_object IN EGO_VARCHAR_TBL_TYPE DEFAULT NULL
10250: ,p_change_info_table IN EGO_USER_ATTR_CHANGE_TABLE DEFAULT NULL
10251: ,p_pending_b_table_name IN VARCHAR2 DEFAULT NULL
10252: ,p_pending_tl_table_name IN VARCHAR2 DEFAULT NULL
10313: p_api_version IN NUMBER
10314: ,p_object_name IN VARCHAR2
10315: ,p_attributes_row_table IN EGO_USER_ATTR_ROW_TABLE
10316: ,p_attributes_data_table IN EGO_USER_ATTR_DATA_TABLE
10317: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
10318: ,p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
10319: ,p_user_privileges_on_object IN EGO_VARCHAR_TBL_TYPE DEFAULT NULL
10320: ,p_change_info_table IN EGO_USER_ATTR_CHANGE_TABLE DEFAULT NULL
10321: ,p_pending_b_table_name IN VARCHAR2 DEFAULT NULL
10314: ,p_object_name IN VARCHAR2
10315: ,p_attributes_row_table IN EGO_USER_ATTR_ROW_TABLE
10316: ,p_attributes_data_table IN EGO_USER_ATTR_DATA_TABLE
10317: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
10318: ,p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
10319: ,p_user_privileges_on_object IN EGO_VARCHAR_TBL_TYPE DEFAULT NULL
10320: ,p_change_info_table IN EGO_USER_ATTR_CHANGE_TABLE DEFAULT NULL
10321: ,p_pending_b_table_name IN VARCHAR2 DEFAULT NULL
10322: ,p_pending_tl_table_name IN VARCHAR2 DEFAULT NULL
10360: l_got_all_attrs_for_this_row BOOLEAN := FALSE;
10361: l_current_data_element EGO_USER_ATTR_DATA_OBJ;
10362: l_next_row_id NUMBER;
10363: l_row_attrs_table EGO_USER_ATTR_DATA_TABLE;
10364: l_data_level_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
10365: l_current_row_change_obj EGO_USER_ATTR_CHANGE_OBJ;
10366: l_return_status VARCHAR2(1);
10367: l_errorcode NUMBER;
10368: l_msg_count NUMBER;
10779: -- this method.
10780: --
10781: PROCEDURE add_nameval_predicate (
10782: p_col_metadata IN EGO_COL_METADATA_ARRAY,
10783: p_nameval_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY,
10784: p_add_and IN BOOLEAN,
10785: x_predicate_added OUT NOCOPY boolean) IS
10786:
10787: l_predicate VARCHAR2(32767);
10905: p_data_level_id IN NUMBER,
10906: p_has_data_level_col IN BOOLEAN,
10907: p_ext_data_level_metadata IN EGO_COL_METADATA_ARRAY,
10908: p_data_level_metadata IN EGO_DATA_LEVEL_METADATA_OBJ,
10909: p_data_level_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY,
10910: p_add_and IN BOOLEAN,
10911: x_predicate_added OUT NOCOPY BOOLEAN) IS
10912:
10913: l_ret BOOLEAN;
11020: --
11021: --
11022: FUNCTION get_itmmgmt_pkcol(p_attr_group_id IN NUMBER,
11023: p_data_level IN VARCHAR2,
11024: p_pkcol_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY)
11025: RETURN EGO_COL_NAME_VALUE_PAIR_ARRAY IS
11026:
11027: l_pk_column_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
11028: l_inventory_item_id mtl_system_items_b.inventory_item_id%TYPE;
11021: --
11022: FUNCTION get_itmmgmt_pkcol(p_attr_group_id IN NUMBER,
11023: p_data_level IN VARCHAR2,
11024: p_pkcol_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY)
11025: RETURN EGO_COL_NAME_VALUE_PAIR_ARRAY IS
11026:
11027: l_pk_column_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
11028: l_inventory_item_id mtl_system_items_b.inventory_item_id%TYPE;
11029: l_organization_id mtl_system_items_b.organization_id%TYPE;
11023: p_data_level IN VARCHAR2,
11024: p_pkcol_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY)
11025: RETURN EGO_COL_NAME_VALUE_PAIR_ARRAY IS
11026:
11027: l_pk_column_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
11028: l_inventory_item_id mtl_system_items_b.inventory_item_id%TYPE;
11029: l_organization_id mtl_system_items_b.organization_id%TYPE;
11030: l_style_item_flag mtl_system_items_b.style_item_flag%TYPE;
11031: l_style_item_id mtl_system_items_b.style_item_id%TYPE;
11071:
11072: -- style flag is N for SKUs
11073: IF (l_style_item_flag = 'N') THEN
11074:
11075: l_pk_column_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY
11076: (EGO_COL_NAME_VALUE_PAIR_OBJ( 'INVENTORY_ITEM_ID' , to_char(l_style_item_id))
11077: ,EGO_COL_NAME_VALUE_PAIR_OBJ( 'ORGANIZATION_ID' , to_char(l_organization_id))
11078: );
11079:
11102:
11103: PROCEDURE add_pkcol_predicate (p_attr_group_type IN VARCHAR2,
11104: p_attr_group_id IN NUMBER,
11105: p_data_level IN VARCHAR2,
11106: p_pkcol_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY,
11107: p_pk_column_metadata IN EGO_COL_METADATA_ARRAY,
11108: p_add_and IN BOOLEAN,
11109: x_predicate_added OUT NOCOPY BOOLEAN) IS
11110:
11107: p_pk_column_metadata IN EGO_COL_METADATA_ARRAY,
11108: p_add_and IN BOOLEAN,
11109: x_predicate_added OUT NOCOPY BOOLEAN) IS
11110:
11111: l_pk_column_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
11112: BEGIN
11113: l_pk_column_name_value_pairs := p_pkcol_value_pairs;
11114: IF (p_attr_group_type = 'EGO_ITEMMGMT_GROUP') THEN
11115: l_pk_column_name_value_pairs := get_itmmgmt_pkcol(p_attr_group_id => p_attr_group_id,
11196:
11197: PROCEDURE Get_User_Attrs_Data (
11198: p_api_version IN NUMBER
11199: ,p_object_name IN VARCHAR2
11200: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
11201: ,p_attr_group_request_table IN EGO_ATTR_GROUP_REQUEST_TABLE
11202: ,p_user_privileges_on_object IN EGO_VARCHAR_TBL_TYPE DEFAULT NULL
11203: ,p_entity_id IN NUMBER DEFAULT NULL
11204: ,p_entity_index IN NUMBER DEFAULT NULL
11248: l_start_index NUMBER;
11249: l_substring_length NUMBER;
11250: l_temp_db_query_string VARCHAR2(32767);
11251: l_int_to_disp_val_string VARCHAR2(32767);
11252: l_data_level_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
11253: l_pk_col_string VARCHAR2(1000);
11254: l_data_level_string VARCHAR2(1000);
11255: l_dynamic_sql VARCHAR2(32767);
11256: l_cursor_id NUMBER;
11295: l_style_item_flag_query VARCHAR2(3000);
11296: l_style_item_flag VARCHAR2(5);
11297: l_style_item_id NUMBER;
11298: l_input_data_level_id NUMBER;
11299: l_pk_column_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
11300: -- Bug 12765239.
11301: l_add_and BOOLEAN := false;
11302: l_predicate_added BOOLEAN := false;
11303: BEGIN
12324: ,p_application_id IN NUMBER DEFAULT NULL
12325: ,p_attr_group_type IN VARCHAR2 DEFAULT NULL
12326: ,p_attr_group_name IN VARCHAR2 DEFAULT NULL
12327: ,p_validate_hierarchy IN VARCHAR2 DEFAULT FND_API.G_TRUE--Added for bugFix:5275391
12328: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
12329: ,p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
12330: ,p_data_level IN VARCHAR2 DEFAULT NULL --R12C
12331: ,p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
12332: ,p_extension_id IN NUMBER DEFAULT NULL
12325: ,p_attr_group_type IN VARCHAR2 DEFAULT NULL
12326: ,p_attr_group_name IN VARCHAR2 DEFAULT NULL
12327: ,p_validate_hierarchy IN VARCHAR2 DEFAULT FND_API.G_TRUE--Added for bugFix:5275391
12328: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
12329: ,p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
12330: ,p_data_level IN VARCHAR2 DEFAULT NULL --R12C
12331: ,p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
12332: ,p_extension_id IN NUMBER DEFAULT NULL
12333: ,p_attr_name_value_pairs IN EGO_USER_ATTR_DATA_TABLE
12327: ,p_validate_hierarchy IN VARCHAR2 DEFAULT FND_API.G_TRUE--Added for bugFix:5275391
12328: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
12329: ,p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
12330: ,p_data_level IN VARCHAR2 DEFAULT NULL --R12C
12331: ,p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
12332: ,p_extension_id IN NUMBER DEFAULT NULL
12333: ,p_attr_name_value_pairs IN EGO_USER_ATTR_DATA_TABLE
12334: ,p_entity_id IN NUMBER DEFAULT NULL
12335: ,p_entity_index IN NUMBER DEFAULT NULL
12400: ,p_application_id IN NUMBER DEFAULT NULL
12401: ,p_attr_group_type IN VARCHAR2 DEFAULT NULL
12402: ,p_attr_group_name IN VARCHAR2 DEFAULT NULL
12403: ,p_validate_hierarchy IN VARCHAR2 DEFAULT FND_API.G_TRUE--Added for bugFix:5275391
12404: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
12405: ,p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
12406: ,p_data_level IN VARCHAR2 DEFAULT NULL --R12C
12407: ,p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
12408: ,p_extension_id IN NUMBER DEFAULT NULL
12401: ,p_attr_group_type IN VARCHAR2 DEFAULT NULL
12402: ,p_attr_group_name IN VARCHAR2 DEFAULT NULL
12403: ,p_validate_hierarchy IN VARCHAR2 DEFAULT FND_API.G_TRUE--Added for bugFix:5275391
12404: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
12405: ,p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
12406: ,p_data_level IN VARCHAR2 DEFAULT NULL --R12C
12407: ,p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
12408: ,p_extension_id IN NUMBER DEFAULT NULL
12409: ,p_attr_name_value_pairs IN EGO_USER_ATTR_DATA_TABLE
12403: ,p_validate_hierarchy IN VARCHAR2 DEFAULT FND_API.G_TRUE--Added for bugFix:5275391
12404: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
12405: ,p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
12406: ,p_data_level IN VARCHAR2 DEFAULT NULL --R12C
12407: ,p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
12408: ,p_extension_id IN NUMBER DEFAULT NULL
12409: ,p_attr_name_value_pairs IN EGO_USER_ATTR_DATA_TABLE
12410: ,p_entity_id IN NUMBER DEFAULT NULL
12411: ,p_entity_index IN NUMBER DEFAULT NULL
12682: ,p_attr_group_id IN NUMBER DEFAULT NULL
12683: ,p_application_id IN NUMBER DEFAULT NULL
12684: ,p_attr_group_type IN VARCHAR2 DEFAULT NULL
12685: ,p_attr_group_name IN VARCHAR2 DEFAULT NULL
12686: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
12687: ,p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
12688: ,p_data_level IN VARCHAR2 DEFAULT NULL --R12C
12689: ,p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
12690: ,p_extension_id IN NUMBER DEFAULT NULL
12683: ,p_application_id IN NUMBER DEFAULT NULL
12684: ,p_attr_group_type IN VARCHAR2 DEFAULT NULL
12685: ,p_attr_group_name IN VARCHAR2 DEFAULT NULL
12686: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
12687: ,p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
12688: ,p_data_level IN VARCHAR2 DEFAULT NULL --R12C
12689: ,p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
12690: ,p_extension_id IN NUMBER DEFAULT NULL
12691: ,p_attr_name_value_pairs IN EGO_USER_ATTR_DATA_TABLE
12685: ,p_attr_group_name IN VARCHAR2 DEFAULT NULL
12686: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
12687: ,p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
12688: ,p_data_level IN VARCHAR2 DEFAULT NULL --R12C
12689: ,p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
12690: ,p_extension_id IN NUMBER DEFAULT NULL
12691: ,p_attr_name_value_pairs IN EGO_USER_ATTR_DATA_TABLE
12692: ,p_entity_id IN NUMBER DEFAULT NULL
12693: ,p_entity_index IN NUMBER DEFAULT NULL
12893: ,p_attr_group_id IN NUMBER DEFAULT NULL
12894: ,p_application_id IN NUMBER DEFAULT NULL
12895: ,p_attr_group_type IN VARCHAR2 DEFAULT NULL
12896: ,p_attr_group_name IN VARCHAR2 DEFAULT NULL
12897: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
12898: ,p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
12899: ,p_data_level IN VARCHAR2 DEFAULT NULL --R12C
12900: ,p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
12901: ,p_extension_id IN NUMBER DEFAULT NULL
12894: ,p_application_id IN NUMBER DEFAULT NULL
12895: ,p_attr_group_type IN VARCHAR2 DEFAULT NULL
12896: ,p_attr_group_name IN VARCHAR2 DEFAULT NULL
12897: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
12898: ,p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
12899: ,p_data_level IN VARCHAR2 DEFAULT NULL --R12C
12900: ,p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
12901: ,p_extension_id IN NUMBER DEFAULT NULL
12902: ,p_attr_name_value_pairs IN EGO_USER_ATTR_DATA_TABLE
12896: ,p_attr_group_name IN VARCHAR2 DEFAULT NULL
12897: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
12898: ,p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
12899: ,p_data_level IN VARCHAR2 DEFAULT NULL --R12C
12900: ,p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
12901: ,p_extension_id IN NUMBER DEFAULT NULL
12902: ,p_attr_name_value_pairs IN EGO_USER_ATTR_DATA_TABLE
12903: ,p_mode IN VARCHAR2 DEFAULT G_SYNC_MODE
12904: ,p_extra_pk_col_name_val_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
12900: ,p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
12901: ,p_extension_id IN NUMBER DEFAULT NULL
12902: ,p_attr_name_value_pairs IN EGO_USER_ATTR_DATA_TABLE
12903: ,p_mode IN VARCHAR2 DEFAULT G_SYNC_MODE
12904: ,p_extra_pk_col_name_val_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
12905: ,p_extra_attr_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
12906: ,p_alternate_ext_b_table_name IN VARCHAR2 DEFAULT NULL
12907: ,p_alternate_ext_tl_table_name IN VARCHAR2 DEFAULT NULL
12908: ,p_alternate_ext_vl_name IN VARCHAR2 DEFAULT NULL
12901: ,p_extension_id IN NUMBER DEFAULT NULL
12902: ,p_attr_name_value_pairs IN EGO_USER_ATTR_DATA_TABLE
12903: ,p_mode IN VARCHAR2 DEFAULT G_SYNC_MODE
12904: ,p_extra_pk_col_name_val_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
12905: ,p_extra_attr_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
12906: ,p_alternate_ext_b_table_name IN VARCHAR2 DEFAULT NULL
12907: ,p_alternate_ext_tl_table_name IN VARCHAR2 DEFAULT NULL
12908: ,p_alternate_ext_vl_name IN VARCHAR2 DEFAULT NULL
12909: ,p_execute_dml IN VARCHAR2 DEFAULT FND_API.G_FALSE
13199: ,p_attr_group_id IN NUMBER DEFAULT NULL
13200: ,p_application_id IN NUMBER
13201: ,p_attr_group_type IN VARCHAR2
13202: ,p_attr_group_name IN VARCHAR2 DEFAULT NULL
13203: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
13204: ,p_data_level IN VARCHAR2 DEFAULT NULL --R12C
13205: ,p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
13206: ,p_attr_name_value_pairs IN EGO_USER_ATTR_DATA_TABLE
13207: ,p_extra_pk_col_name_val_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
13201: ,p_attr_group_type IN VARCHAR2
13202: ,p_attr_group_name IN VARCHAR2 DEFAULT NULL
13203: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
13204: ,p_data_level IN VARCHAR2 DEFAULT NULL --R12C
13205: ,p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
13206: ,p_attr_name_value_pairs IN EGO_USER_ATTR_DATA_TABLE
13207: ,p_extra_pk_col_name_val_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
13208: ,p_extra_attr_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
13209: ,p_alternate_ext_b_table_name IN VARCHAR2 DEFAULT NULL
13203: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
13204: ,p_data_level IN VARCHAR2 DEFAULT NULL --R12C
13205: ,p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
13206: ,p_attr_name_value_pairs IN EGO_USER_ATTR_DATA_TABLE
13207: ,p_extra_pk_col_name_val_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
13208: ,p_extra_attr_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
13209: ,p_alternate_ext_b_table_name IN VARCHAR2 DEFAULT NULL
13210: ,p_alternate_ext_tl_table_name IN VARCHAR2 DEFAULT NULL
13211: ,p_alternate_ext_vl_name IN VARCHAR2 DEFAULT NULL
13204: ,p_data_level IN VARCHAR2 DEFAULT NULL --R12C
13205: ,p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
13206: ,p_attr_name_value_pairs IN EGO_USER_ATTR_DATA_TABLE
13207: ,p_extra_pk_col_name_val_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
13208: ,p_extra_attr_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
13209: ,p_alternate_ext_b_table_name IN VARCHAR2 DEFAULT NULL
13210: ,p_alternate_ext_tl_table_name IN VARCHAR2 DEFAULT NULL
13211: ,p_alternate_ext_vl_name IN VARCHAR2 DEFAULT NULL
13212: ) RETURN NUMBER
13271: ,p_attr_group_id IN NUMBER DEFAULT NULL
13272: ,p_application_id IN NUMBER DEFAULT NULL
13273: ,p_attr_group_type IN VARCHAR2 DEFAULT NULL
13274: ,p_attr_group_name IN VARCHAR2 DEFAULT NULL
13275: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
13276: ,p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
13277: ,p_data_level IN VARCHAR2 DEFAULT NULL --R12C
13278: ,p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
13279: ,p_extension_id IN NUMBER DEFAULT NULL
13272: ,p_application_id IN NUMBER DEFAULT NULL
13273: ,p_attr_group_type IN VARCHAR2 DEFAULT NULL
13274: ,p_attr_group_name IN VARCHAR2 DEFAULT NULL
13275: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
13276: ,p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
13277: ,p_data_level IN VARCHAR2 DEFAULT NULL --R12C
13278: ,p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
13279: ,p_extension_id IN NUMBER DEFAULT NULL
13280: ,p_attr_name_value_pairs IN EGO_USER_ATTR_DATA_TABLE
13274: ,p_attr_group_name IN VARCHAR2 DEFAULT NULL
13275: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
13276: ,p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
13277: ,p_data_level IN VARCHAR2 DEFAULT NULL --R12C
13278: ,p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
13279: ,p_extension_id IN NUMBER DEFAULT NULL
13280: ,p_attr_name_value_pairs IN EGO_USER_ATTR_DATA_TABLE
13281: ,p_mode IN VARCHAR2 DEFAULT G_SYNC_MODE
13282: ,p_change_obj IN EGO_USER_ATTR_CHANGE_OBJ DEFAULT NULL
13354: ,p_attr_group_id IN NUMBER DEFAULT NULL
13355: ,p_application_id IN NUMBER DEFAULT NULL
13356: ,p_attr_group_type IN VARCHAR2 DEFAULT NULL
13357: ,p_attr_group_name IN VARCHAR2 DEFAULT NULL
13358: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
13359: ,p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
13360: ,p_data_level IN VARCHAR2 DEFAULT NULL --R12C
13361: ,p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
13362: ,p_extension_id IN NUMBER DEFAULT NULL
13355: ,p_application_id IN NUMBER DEFAULT NULL
13356: ,p_attr_group_type IN VARCHAR2 DEFAULT NULL
13357: ,p_attr_group_name IN VARCHAR2 DEFAULT NULL
13358: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
13359: ,p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
13360: ,p_data_level IN VARCHAR2 DEFAULT NULL --R12C
13361: ,p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
13362: ,p_extension_id IN NUMBER DEFAULT NULL
13363: ,p_attr_name_value_pairs IN EGO_USER_ATTR_DATA_TABLE
13357: ,p_attr_group_name IN VARCHAR2 DEFAULT NULL
13358: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
13359: ,p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
13360: ,p_data_level IN VARCHAR2 DEFAULT NULL --R12C
13361: ,p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
13362: ,p_extension_id IN NUMBER DEFAULT NULL
13363: ,p_attr_name_value_pairs IN EGO_USER_ATTR_DATA_TABLE
13364: ,p_mode IN VARCHAR2 DEFAULT G_SYNC_MODE
13365: ,p_change_obj IN EGO_USER_ATTR_CHANGE_OBJ DEFAULT NULL
13595: PROCEDURE Perform_DML_From_Template (
13596: p_api_version IN NUMBER
13597: ,p_template_id IN NUMBER
13598: ,p_object_name IN VARCHAR2
13599: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
13600: ,p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
13601: ,p_data_level IN VARCHAR2 DEFAULT NULL
13602: ,p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
13603: ,p_attr_group_ids_to_exclude IN EGO_NUMBER_TBL_TYPE DEFAULT NULL
13596: p_api_version IN NUMBER
13597: ,p_template_id IN NUMBER
13598: ,p_object_name IN VARCHAR2
13599: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
13600: ,p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
13601: ,p_data_level IN VARCHAR2 DEFAULT NULL
13602: ,p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
13603: ,p_attr_group_ids_to_exclude IN EGO_NUMBER_TBL_TYPE DEFAULT NULL
13604: ,p_debug_level IN NUMBER DEFAULT 0
13598: ,p_object_name IN VARCHAR2
13599: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
13600: ,p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
13601: ,p_data_level IN VARCHAR2 DEFAULT NULL
13602: ,p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
13603: ,p_attr_group_ids_to_exclude IN EGO_NUMBER_TBL_TYPE DEFAULT NULL
13604: ,p_debug_level IN NUMBER DEFAULT 0
13605: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
13606: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
14278: p_api_version IN NUMBER
14279: ,p_application_id IN NUMBER
14280: ,p_object_id IN NUMBER DEFAULT NULL
14281: ,p_object_name IN VARCHAR2 DEFAULT NULL
14282: ,p_old_pk_col_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
14283: ,p_old_data_level_id IN NUMBER DEFAULT NULL
14284: ,p_old_dtlevel_col_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
14285: ,p_new_pk_col_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
14286: ,p_new_data_level_id IN NUMBER DEFAULT NULL
14280: ,p_object_id IN NUMBER DEFAULT NULL
14281: ,p_object_name IN VARCHAR2 DEFAULT NULL
14282: ,p_old_pk_col_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
14283: ,p_old_data_level_id IN NUMBER DEFAULT NULL
14284: ,p_old_dtlevel_col_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
14285: ,p_new_pk_col_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
14286: ,p_new_data_level_id IN NUMBER DEFAULT NULL
14287: ,p_new_dtlevel_col_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
14288: ,p_new_cc_col_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
14281: ,p_object_name IN VARCHAR2 DEFAULT NULL
14282: ,p_old_pk_col_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
14283: ,p_old_data_level_id IN NUMBER DEFAULT NULL
14284: ,p_old_dtlevel_col_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
14285: ,p_new_pk_col_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
14286: ,p_new_data_level_id IN NUMBER DEFAULT NULL
14287: ,p_new_dtlevel_col_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
14288: ,p_new_cc_col_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
14289: ,p_attr_group_list IN VARCHAR2 DEFAULT NULL
14283: ,p_old_data_level_id IN NUMBER DEFAULT NULL
14284: ,p_old_dtlevel_col_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
14285: ,p_new_pk_col_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
14286: ,p_new_data_level_id IN NUMBER DEFAULT NULL
14287: ,p_new_dtlevel_col_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
14288: ,p_new_cc_col_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
14289: ,p_attr_group_list IN VARCHAR2 DEFAULT NULL
14290: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_FALSE
14291: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
14284: ,p_old_dtlevel_col_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
14285: ,p_new_pk_col_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
14286: ,p_new_data_level_id IN NUMBER DEFAULT NULL
14287: ,p_new_dtlevel_col_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
14288: ,p_new_cc_col_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
14289: ,p_attr_group_list IN VARCHAR2 DEFAULT NULL
14290: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_FALSE
14291: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
14292: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
15016: ,p_change_b_table_name IN VARCHAR2
15017: ,p_change_tl_table_name IN VARCHAR2
15018: ,p_tables_application_id IN NUMBER
15019: ,p_change_line_id IN NUMBER
15020: ,p_old_data_level_nv_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
15021: ,p_new_data_level_nv_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
15022: ,p_related_class_code_function IN VARCHAR2
15023: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
15024: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
15017: ,p_change_tl_table_name IN VARCHAR2
15018: ,p_tables_application_id IN NUMBER
15019: ,p_change_line_id IN NUMBER
15020: ,p_old_data_level_nv_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
15021: ,p_new_data_level_nv_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
15022: ,p_related_class_code_function IN VARCHAR2
15023: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
15024: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
15025: ,x_return_status OUT NOCOPY VARCHAR2
15035: --if we change optional parameters, version goes FROM x.n to x.(n+1)
15036: l_api_version CONSTANT NUMBER := 1.0;
15037:
15038: l_object_id NUMBER;
15039: l_data_level_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
15040: l_current_dl_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
15041: l_ext_table_metadata_obj EGO_EXT_TABLE_METADATA_OBJ;
15042: l_chng_col_names_list VARCHAR2(20000);
15043: l_cols_to_exclude_list VARCHAR2(2000);
15036: l_api_version CONSTANT NUMBER := 1.0;
15037:
15038: l_object_id NUMBER;
15039: l_data_level_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
15040: l_current_dl_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
15041: l_ext_table_metadata_obj EGO_EXT_TABLE_METADATA_OBJ;
15042: l_chng_col_names_list VARCHAR2(20000);
15043: l_cols_to_exclude_list VARCHAR2(2000);
15044: l_pk_column_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
15040: l_current_dl_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
15041: l_ext_table_metadata_obj EGO_EXT_TABLE_METADATA_OBJ;
15042: l_chng_col_names_list VARCHAR2(20000);
15043: l_cols_to_exclude_list VARCHAR2(2000);
15044: l_pk_column_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
15045: l_class_code_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
15046: l_b_chng_cols_list VARCHAR2(10000);
15047: l_tl_chng_cols_list VARCHAR2(10000);
15048: l_history_b_chng_cols_list VARCHAR2(10000);
15041: l_ext_table_metadata_obj EGO_EXT_TABLE_METADATA_OBJ;
15042: l_chng_col_names_list VARCHAR2(20000);
15043: l_cols_to_exclude_list VARCHAR2(2000);
15044: l_pk_column_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
15045: l_class_code_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
15046: l_b_chng_cols_list VARCHAR2(10000);
15047: l_tl_chng_cols_list VARCHAR2(10000);
15048: l_history_b_chng_cols_list VARCHAR2(10000);
15049: l_history_tl_chng_cols_list VARCHAR2(10000);
15130: -- ASSUMPTION: no PKs will ever be DATE objects
15131: --
15132: IF (l_ext_table_metadata_obj.pk_column_metadata.COUNT = 5) THEN
15133: l_pk_column_name_value_pairs :=
15134: EGO_COL_NAME_VALUE_PAIR_ARRAY(
15135: EGO_COL_NAME_VALUE_PAIR_OBJ(
15136: l_ext_table_metadata_obj.pk_column_metadata(1).COL_NAME, NULL
15137: )
15138: ,EGO_COL_NAME_VALUE_PAIR_OBJ(
15170: l_ext_table_metadata_obj.pk_column_metadata(5).COL_NAME||
15171: '''';
15172: ELSIF (l_ext_table_metadata_obj.pk_column_metadata.COUNT = 4) THEN
15173: l_pk_column_name_value_pairs :=
15174: EGO_COL_NAME_VALUE_PAIR_ARRAY(
15175: EGO_COL_NAME_VALUE_PAIR_OBJ(
15176: l_ext_table_metadata_obj.pk_column_metadata(1).COL_NAME, NULL
15177: )
15178: ,EGO_COL_NAME_VALUE_PAIR_OBJ(
15203: l_ext_table_metadata_obj.pk_column_metadata(4).COL_NAME||
15204: '''';
15205: ELSIF (l_ext_table_metadata_obj.pk_column_metadata.COUNT = 3) THEN
15206: l_pk_column_name_value_pairs :=
15207: EGO_COL_NAME_VALUE_PAIR_ARRAY(
15208: EGO_COL_NAME_VALUE_PAIR_OBJ(
15209: l_ext_table_metadata_obj.pk_column_metadata(1).COL_NAME, NULL
15210: )
15211: ,EGO_COL_NAME_VALUE_PAIR_OBJ(
15229: l_ext_table_metadata_obj.pk_column_metadata(3).COL_NAME||
15230: '''';
15231: ELSIF (l_ext_table_metadata_obj.pk_column_metadata.COUNT = 2) THEN
15232: l_pk_column_name_value_pairs :=
15233: EGO_COL_NAME_VALUE_PAIR_ARRAY(
15234: EGO_COL_NAME_VALUE_PAIR_OBJ(
15235: l_ext_table_metadata_obj.pk_column_metadata(1).COL_NAME, NULL
15236: )
15237: ,EGO_COL_NAME_VALUE_PAIR_OBJ(
15248: l_ext_table_metadata_obj.pk_column_metadata(2).COL_NAME||
15249: '''';
15250: ELSIF (l_ext_table_metadata_obj.pk_column_metadata.COUNT = 1) THEN
15251: l_pk_column_name_value_pairs :=
15252: EGO_COL_NAME_VALUE_PAIR_ARRAY(
15253: EGO_COL_NAME_VALUE_PAIR_OBJ(
15254: l_ext_table_metadata_obj.pk_column_metadata(1).COL_NAME, NULL
15255: )
15256: );
15269: IF (l_ext_table_metadata_obj.class_code_metadata IS NOT NULL AND
15270: l_ext_table_metadata_obj.class_code_metadata.COUNT > 0 AND
15271: l_ext_table_metadata_obj.class_code_metadata(1).COL_NAME IS NOT NULL) THEN
15272: l_class_code_name_value_pairs :=
15273: EGO_COL_NAME_VALUE_PAIR_ARRAY(
15274: EGO_COL_NAME_VALUE_PAIR_OBJ(
15275: l_ext_table_metadata_obj.class_code_metadata(1).COL_NAME, NULL
15276: ),
15277: EGO_COL_NAME_VALUE_PAIR_OBJ(
16024: ,p_pk_value3 IN VARCHAR2 DEFAULT NULL
16025: ,p_pk_value4 IN VARCHAR2 DEFAULT NULL
16026: ,p_pk_value5 IN VARCHAR2 DEFAULT NULL
16027: ,p_data_level IN VARCHAR2 DEFAULT NULL
16028: ,p_dl_pk_values IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
16029: ,p_dl_metadata_obj IN EGO_DATA_LEVEL_METADATA_OBJ DEFAULT NULL
16030: ,x_str_val OUT NOCOPY VARCHAR2
16031: ,x_num_val OUT NOCOPY NUMBER
16032: ,x_date_val OUT NOCOPY DATE
16305: ,p_pk_value3 IN VARCHAR2 DEFAULT NULL
16306: ,p_pk_value4 IN VARCHAR2 DEFAULT NULL
16307: ,p_pk_value5 IN VARCHAR2 DEFAULT NULL
16308: ,p_data_level IN VARCHAR2 DEFAULT NULL
16309: ,p_dl_pk_values IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
16310: )
16311: RETURN VARCHAR2
16312: IS
16313:
16314: l_api_name VARCHAR2(30) := 'Get_User_Attr_Val():';
16315: l_attr_group_metadata_obj EGO_ATTR_GROUP_METADATA_OBJ;
16316: -- declared in EGOSEFD2.sql
16317: l_attr_metadata_obj EGO_ATTR_METADATA_OBJ;
16318: l_pk_column_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
16319: l_attr_int_value VARCHAR2(4000); -- Bug 8757354
16320: l_attr_disp_value VARCHAR2(4000); -- Bug 8757354
16321:
16322: l_attr_metadata_table EGO_ATTR_METADATA_TABLE;
16470: p_pk_col3 IS NOT NULL AND
16471: p_pk_col4 IS NOT NULL AND
16472: p_pk_col5 IS NOT NULL) THEN
16473:
16474: l_pk_column_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
16475: EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk_col1, p_pk_value1)
16476: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk_col2, p_pk_value2)
16477: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk_col3, p_pk_value3)
16478: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk_col4, p_pk_value4)
16487: ELSIF (p_pk_col2 IS NOT NULL AND
16488: p_pk_col3 IS NOT NULL AND
16489: p_pk_col4 IS NOT NULL) THEN
16490:
16491: l_pk_column_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
16492: EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk_col1, p_pk_value1)
16493: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk_col2, p_pk_value2)
16494: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk_col3, p_pk_value3)
16495: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk_col4, p_pk_value4)
16497:
16498: ELSIF (p_pk_col2 IS NOT NULL AND
16499: p_pk_col3 IS NOT NULL) THEN
16500:
16501: l_pk_column_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
16502: EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk_col1, p_pk_value1)
16503: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk_col2, p_pk_value2)
16504: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk_col3, p_pk_value3)
16505: );
16505: );
16506:
16507: ELSIF (p_pk_col2 IS NOT NULL) THEN
16508:
16509: l_pk_column_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
16510: EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk_col1, p_pk_value1)
16511: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk_col2, p_pk_value2)
16512: );
16513:
16512: );
16513:
16514: ELSE
16515:
16516: l_pk_column_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
16517: EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk_col1, p_pk_value1)
16518: );
16519:
16520: END IF;
16753:
16754: ----------------------------------------------------------------------
16755:
16756: PROCEDURE Update_Attributes (
16757: p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
16758: , p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
16759: , p_data_level IN VARCHAR2 DEFAULT NULL
16760: , p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
16761: , p_attr_diffs IN EGO_USER_ATTR_DIFF_TABLE
16754: ----------------------------------------------------------------------
16755:
16756: PROCEDURE Update_Attributes (
16757: p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
16758: , p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
16759: , p_data_level IN VARCHAR2 DEFAULT NULL
16760: , p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
16761: , p_attr_diffs IN EGO_USER_ATTR_DIFF_TABLE
16762: , p_transaction_type IN VARCHAR2
16756: PROCEDURE Update_Attributes (
16757: p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
16758: , p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
16759: , p_data_level IN VARCHAR2 DEFAULT NULL
16760: , p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
16761: , p_attr_diffs IN EGO_USER_ATTR_DIFF_TABLE
16762: , p_transaction_type IN VARCHAR2
16763: , p_attr_group_id IN NUMBER DEFAULT NULL
16764: , x_error_message OUT NOCOPY VARCHAR2
16914:
16915: -- Either pass in attr_group_id or attr_group_name
16916: PROCEDURE Get_Attr_Diffs (
16917: p_object_name IN VARCHAR2
16918: , p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
16919: , p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
16920: , p_data_level IN VARCHAR2 DEFAULT NULL --R12C
16921: , p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
16922: , p_attr_group_id IN NUMBER DEFAULT NULL
16915: -- Either pass in attr_group_id or attr_group_name
16916: PROCEDURE Get_Attr_Diffs (
16917: p_object_name IN VARCHAR2
16918: , p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
16919: , p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
16920: , p_data_level IN VARCHAR2 DEFAULT NULL --R12C
16921: , p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
16922: , p_attr_group_id IN NUMBER DEFAULT NULL
16923: , p_application_id IN NUMBER DEFAULT NULL
16917: p_object_name IN VARCHAR2
16918: , p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
16919: , p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
16920: , p_data_level IN VARCHAR2 DEFAULT NULL --R12C
16921: , p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
16922: , p_attr_group_id IN NUMBER DEFAULT NULL
16923: , p_application_id IN NUMBER DEFAULT NULL
16924: , p_attr_group_type IN VARCHAR2 DEFAULT NULL
16925: , p_attr_group_name IN VARCHAR2 DEFAULT NULL
17064: l_attr_value_obj EGO_USER_ATTR_DATA_OBJ;
17065: l_attr_metadata_obj EGO_ATTR_METADATA_OBJ;
17066: l_attr_metadata_obj_table EGO_ATTR_METADATA_TABLE;
17067: l_attr_group_metadata_obj EGO_ATTR_GROUP_METADATA_OBJ;
17068: l_pk_column_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
17069: l_data_level_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
17070: l_attr_disp_value VARCHAR2(5000);
17071: BEGIN
17072: l_attr_value_obj := EGO_USER_ATTR_DATA_OBJ (null
17065: l_attr_metadata_obj EGO_ATTR_METADATA_OBJ;
17066: l_attr_metadata_obj_table EGO_ATTR_METADATA_TABLE;
17067: l_attr_group_metadata_obj EGO_ATTR_GROUP_METADATA_OBJ;
17068: l_pk_column_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
17069: l_data_level_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
17070: l_attr_disp_value VARCHAR2(5000);
17071: BEGIN
17072: l_attr_value_obj := EGO_USER_ATTR_DATA_OBJ (null
17073: ,p_attr_internal_name
17100: END IF;
17101: END LOOP;
17102: END IF;
17103:
17104: l_pk_column_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
17105: EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk1_column_name,p_pk1_value)
17106: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk2_column_name,p_pk2_value)
17107: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk3_column_name,p_pk3_value)
17108: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk4_column_name,p_pk4_value)
17107: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk3_column_name,p_pk3_value)
17108: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk4_column_name,p_pk4_value)
17109: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk5_column_name,p_pk5_value)
17110: );
17111: l_data_level_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
17112: EGO_COL_NAME_VALUE_PAIR_OBJ(p_data_level1_column_name,p_data_level1_value)
17113: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_data_level2_column_name,p_data_level2_value)
17114: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_data_level3_column_name,p_data_level3_value)
17115: );
17180: l_attr_value_obj EGO_USER_ATTR_DATA_OBJ;
17181: l_attr_metadata_obj EGO_ATTR_METADATA_OBJ;
17182: l_attr_metadata_obj_table EGO_ATTR_METADATA_TABLE;
17183: l_attr_group_metadata_obj EGO_ATTR_GROUP_METADATA_OBJ;
17184: l_pk_column_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
17185: l_data_level_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
17186: l_attr_internal_value VARCHAR2(4000);
17187: l_ext_table_metadata_obj EGO_EXT_TABLE_METADATA_OBJ;
17188: BEGIN
17181: l_attr_metadata_obj EGO_ATTR_METADATA_OBJ;
17182: l_attr_metadata_obj_table EGO_ATTR_METADATA_TABLE;
17183: l_attr_group_metadata_obj EGO_ATTR_GROUP_METADATA_OBJ;
17184: l_pk_column_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
17185: l_data_level_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
17186: l_attr_internal_value VARCHAR2(4000);
17187: l_ext_table_metadata_obj EGO_EXT_TABLE_METADATA_OBJ;
17188: BEGIN
17189: l_attr_value_obj := EGO_USER_ATTR_DATA_OBJ (null
17274: END IF;
17275:
17276: END IF;
17277:
17278: l_pk_column_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
17279: EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk1_column_name,p_pk1_value)
17280: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk2_column_name,p_pk2_value)
17281: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk3_column_name,p_pk3_value)
17282: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk4_column_name,p_pk4_value)
17282: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk4_column_name,p_pk4_value)
17283: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk5_column_name,p_pk5_value)
17284: );
17285:
17286: l_data_level_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
17287: EGO_COL_NAME_VALUE_PAIR_OBJ(p_data_level1_column_name,p_data_level1_value)
17288: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_data_level2_column_name,p_data_level2_value)
17289: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_data_level3_column_name,p_data_level3_value)
17290: );
17338:
17339: ---------------------------------------------------------------------------
17340:
17341: PROCEDURE Process_Data_Level_Nvp(
17342: p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
17343: ,x_data_level_obj OUT NOCOPY EGO_COL_NAME_VALUE_PAIR_OBJ
17344: ,x_data_level_index OUT NOCOPY NUMBER
17345: ) IS
17346: l_api_name VARCHAR2(30) := 'Process_data_level_nvp';
17388:
17389: ---------------------------------------------------------------------------
17390:
17391: PROCEDURE Process_Class_Code_Nvp(
17392: p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
17393: ,x_base_class_obj OUT NOCOPY EGO_COL_NAME_VALUE_PAIR_OBJ
17394: ,x_related_class_obj OUT NOCOPY EGO_COL_NAME_VALUE_PAIR_OBJ
17395: ) IS
17396: l_api_name VARCHAR2(30) := 'Process_Class_Code_Nvp';
17436:
17437: ---------------------------------------------------------------------------
17438:
17439: PROCEDURE Build_Class_Code_Table(
17440: p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
17441: ,x_class_code_table OUT NOCOPY LOCAL_MEDIUM_VARCHAR_TABLE
17442: ) IS
17443: l_base_class_obj EGO_COL_NAME_VALUE_PAIR_OBJ;
17444: l_related_class_obj EGO_COL_NAME_VALUE_PAIR_OBJ;
17505:
17506: ----------------------------------------------------------------------------*/
17507: PROCEDURE Extract_Data_Level_Values(
17508: p_data_level_name IN EGO_DATA_LEVEL_VL.DATA_LEVEL_NAME%TYPE
17509: ,p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
17510: ,x_data_level_1 OUT NOCOPY VARCHAR2
17511: ,x_data_level_2 OUT NOCOPY VARCHAR2
17512: ,x_data_level_3 OUT NOCOPY VARCHAR2
17513: )
17641:
17642: ----------------------------------------------------------------------------*/
17643: PROCEDURE Build_Request_Table_For_Obj(
17644: p_object_name IN VARCHAR2
17645: ,p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
17646: ,p_data_level_name IN EGO_DATA_LEVEL_VL.DATA_LEVEL_NAME%TYPE
17647: ,p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
17648: -- the data level key values
17649: ,p_attr_group_type_table IN EGO_VARCHAR_TBL_TYPE
17643: PROCEDURE Build_Request_Table_For_Obj(
17644: p_object_name IN VARCHAR2
17645: ,p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
17646: ,p_data_level_name IN EGO_DATA_LEVEL_VL.DATA_LEVEL_NAME%TYPE
17647: ,p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
17648: -- the data level key values
17649: ,p_attr_group_type_table IN EGO_VARCHAR_TBL_TYPE
17650: ,x_attr_group_request_table OUT NOCOPY EGO_ATTR_GROUP_REQUEST_TABLE
17651: ) IS
17994: --
17995: PROCEDURE Validate_Required_Attrs (
17996: p_api_version IN NUMBER
17997: ,p_object_name IN VARCHAR2
17998: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
17999: ,p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
18000: ,p_data_level_name IN EGO_DATA_LEVEL_B.DATA_LEVEL_NAME%TYPE := NULL
18001: ,p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
18002: ,p_attr_group_type_table IN EGO_VARCHAR_TBL_TYPE
17995: PROCEDURE Validate_Required_Attrs (
17996: p_api_version IN NUMBER
17997: ,p_object_name IN VARCHAR2
17998: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
17999: ,p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
18000: ,p_data_level_name IN EGO_DATA_LEVEL_B.DATA_LEVEL_NAME%TYPE := NULL
18001: ,p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
18002: ,p_attr_group_type_table IN EGO_VARCHAR_TBL_TYPE
18003: ,p_entity_id IN NUMBER DEFAULT NULL
17997: ,p_object_name IN VARCHAR2
17998: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
17999: ,p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
18000: ,p_data_level_name IN EGO_DATA_LEVEL_B.DATA_LEVEL_NAME%TYPE := NULL
18001: ,p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
18002: ,p_attr_group_type_table IN EGO_VARCHAR_TBL_TYPE
18003: ,p_entity_id IN NUMBER DEFAULT NULL
18004: ,p_entity_index IN NUMBER DEFAULT NULL
18005: ,p_entity_code IN VARCHAR2 DEFAULT NULL
18279: p_object_name IN VARCHAR2
18280: ,p_application_id IN NUMBER
18281: ,p_attr_group_type IN VARCHAR2
18282: ,p_attr_groups_to_exclude IN VARCHAR2 DEFAULT NULL
18283: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
18284: ,p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
18285: ,p_data_level IN VARCHAR2 DEFAULT NULL
18286: ,p_data_level_values IN EGO_COL_NAME_VALUE_PAIR_ARRAY
18287: ,p_additional_class_Code_list IN VARCHAR2 DEFAULT NULL
18280: ,p_application_id IN NUMBER
18281: ,p_attr_group_type IN VARCHAR2
18282: ,p_attr_groups_to_exclude IN VARCHAR2 DEFAULT NULL
18283: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
18284: ,p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
18285: ,p_data_level IN VARCHAR2 DEFAULT NULL
18286: ,p_data_level_values IN EGO_COL_NAME_VALUE_PAIR_ARRAY
18287: ,p_additional_class_Code_list IN VARCHAR2 DEFAULT NULL
18288: ,p_entity_id IN NUMBER DEFAULT NULL
18282: ,p_attr_groups_to_exclude IN VARCHAR2 DEFAULT NULL
18283: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
18284: ,p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
18285: ,p_data_level IN VARCHAR2 DEFAULT NULL
18286: ,p_data_level_values IN EGO_COL_NAME_VALUE_PAIR_ARRAY
18287: ,p_additional_class_Code_list IN VARCHAR2 DEFAULT NULL
18288: ,p_entity_id IN NUMBER DEFAULT NULL
18289: ,p_entity_index IN NUMBER DEFAULT NULL
18290: ,p_entity_code IN VARCHAR2 DEFAULT NULL
18330: l_transaction_type VARCHAR2(10);
18331: l_temp_date_str VARCHAR2(200);
18332: l_temp_attr_row_table EGO_USER_ATTR_ROW_TABLE;
18333: l_temp_attr_data_table EGO_USER_ATTR_DATA_TABLE;
18334: l_cc_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
18335: l_has_data_level_id BOOLEAN;
18336: l_data_level_id NUMBER;
18337:
18338: TYPE DYNAMIC_CUR IS REF CURSOR;