58: ,p_attr_group_id IN NUMBER
59: ,p_application_id IN NUMBER
60: ,p_attr_group_type IN VARCHAR2
61: ,p_attr_group_name IN VARCHAR2
62: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
63: ,p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
64: ,P_DATA_LEVEL_NAME IN VARCHAR2
65: ,p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY :=null
66: ,p_attr_name_value_pairs IN EGO_USER_ATTR_DATA_TABLE
59: ,p_application_id IN NUMBER
60: ,p_attr_group_type IN VARCHAR2
61: ,p_attr_group_name IN VARCHAR2
62: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
63: ,p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
64: ,P_DATA_LEVEL_NAME IN VARCHAR2
65: ,p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY :=null
66: ,p_attr_name_value_pairs IN EGO_USER_ATTR_DATA_TABLE
67: ,p_mode IN VARCHAR2
61: ,p_attr_group_name IN VARCHAR2
62: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
63: ,p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
64: ,P_DATA_LEVEL_NAME IN VARCHAR2
65: ,p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY :=null
66: ,p_attr_name_value_pairs IN EGO_USER_ATTR_DATA_TABLE
67: ,p_mode IN VARCHAR2
68: ,p_extra_pk_col_name_val_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
69: ,p_extension_id IN NUMBER
64: ,P_DATA_LEVEL_NAME IN VARCHAR2
65: ,p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY :=null
66: ,p_attr_name_value_pairs IN EGO_USER_ATTR_DATA_TABLE
67: ,p_mode IN VARCHAR2
68: ,p_extra_pk_col_name_val_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
69: ,p_extension_id IN NUMBER
70: ,p_pending_b_table_name IN VARCHAR2
71: ,p_pending_tl_table_name IN VARCHAR2
72: ,p_pending_vl_name IN VARCHAR2
89: ,p_application_id IN NUMBER
90: ,p_attr_group_name IN VARCHAR2
91: ,p_attributes_data_table IN EGO_USER_ATTR_DATA_TABLE
92: ,p_extension_id IN NUMBER
93: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
94: ,p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
95: ,p_extra_pk_col_name_val_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
96: ,p_extra_attr_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
97: ,p_alternate_ext_b_table_name IN VARCHAR2 DEFAULT NULL
90: ,p_attr_group_name IN VARCHAR2
91: ,p_attributes_data_table IN EGO_USER_ATTR_DATA_TABLE
92: ,p_extension_id IN NUMBER
93: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
94: ,p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
95: ,p_extra_pk_col_name_val_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
96: ,p_extra_attr_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
97: ,p_alternate_ext_b_table_name IN VARCHAR2 DEFAULT NULL
98: ,p_alternate_ext_tl_table_name IN VARCHAR2 DEFAULT NULL
91: ,p_attributes_data_table IN EGO_USER_ATTR_DATA_TABLE
92: ,p_extension_id IN NUMBER
93: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
94: ,p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
95: ,p_extra_pk_col_name_val_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
96: ,p_extra_attr_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
97: ,p_alternate_ext_b_table_name IN VARCHAR2 DEFAULT NULL
98: ,p_alternate_ext_tl_table_name IN VARCHAR2 DEFAULT NULL
99: ,p_alternate_ext_vl_name IN VARCHAR2 DEFAULT NULL
92: ,p_extension_id IN NUMBER
93: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
94: ,p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
95: ,p_extra_pk_col_name_val_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
96: ,p_extra_attr_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
97: ,p_alternate_ext_b_table_name IN VARCHAR2 DEFAULT NULL
98: ,p_alternate_ext_tl_table_name IN VARCHAR2 DEFAULT NULL
99: ,p_alternate_ext_vl_name IN VARCHAR2 DEFAULT NULL
100: ,p_user_privileges_on_object IN EGO_VARCHAR_TBL_TYPE DEFAULT NULL
109: ,x_msg_count OUT NOCOPY NUMBER
110: ,x_msg_data OUT NOCOPY VARCHAR2
111: ,p_key_attr_upd IN VARCHAR2
112: ,p_data_level_name IN VARCHAR2
113: ,p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
114: );
115:
116: PROCEDURE SETUP_IMPL_ATTR_DATA_ROW
117: (
120: ,p_attr_group_id IN NUMBER
121: ,p_application_id IN NUMBER
122: ,p_attr_group_type IN VARCHAR2
123: ,p_attr_group_name IN VARCHAR2
124: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
125: ,p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
126: ,p_data_level_name IN VARCHAR2
127: ,p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
128: ,p_attr_name_value_pairs IN EGO_USER_ATTR_DATA_TABLE DEFAULT NULL
121: ,p_application_id IN NUMBER
122: ,p_attr_group_type IN VARCHAR2
123: ,p_attr_group_name IN VARCHAR2
124: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
125: ,p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
126: ,p_data_level_name IN VARCHAR2
127: ,p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
128: ,p_attr_name_value_pairs IN EGO_USER_ATTR_DATA_TABLE DEFAULT NULL
129: ,x_setup_attr_data OUT NOCOPY EGO_USER_ATTR_DATA_TABLE
123: ,p_attr_group_name IN VARCHAR2
124: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
125: ,p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
126: ,p_data_level_name IN VARCHAR2
127: ,p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
128: ,p_attr_name_value_pairs IN EGO_USER_ATTR_DATA_TABLE DEFAULT NULL
129: ,x_setup_attr_data OUT NOCOPY EGO_USER_ATTR_DATA_TABLE
130: ,x_return_status OUT NOCOPY VARCHAR2
131: ,x_errorcode OUT NOCOPY NUMBER
143: ,x_msg_data OUT NOCOPY VARCHAR2
144:
145: );
146:
147: PROCEDURE UPDATE_DATA_LEVEL(P_PK_ATTR_NAME_VALUE_PAIRS EGO_COL_NAME_VALUE_PAIR_ARRAY
148: ,P_NEW_DL_NAME_VALUE_PAIRS EGO_COL_NAME_VALUE_PAIR_ARRAY
149: ,P_OLD_DL_NAME_VALUE_PAIRS EGO_COL_NAME_VALUE_PAIR_ARRAY
150: ,P_OBJECT_NAME VARCHAR2
151: ,P_APPLICATION_ID NUMBER);
144:
145: );
146:
147: PROCEDURE UPDATE_DATA_LEVEL(P_PK_ATTR_NAME_VALUE_PAIRS EGO_COL_NAME_VALUE_PAIR_ARRAY
148: ,P_NEW_DL_NAME_VALUE_PAIRS EGO_COL_NAME_VALUE_PAIR_ARRAY
149: ,P_OLD_DL_NAME_VALUE_PAIRS EGO_COL_NAME_VALUE_PAIR_ARRAY
150: ,P_OBJECT_NAME VARCHAR2
151: ,P_APPLICATION_ID NUMBER);
152:
145: );
146:
147: PROCEDURE UPDATE_DATA_LEVEL(P_PK_ATTR_NAME_VALUE_PAIRS EGO_COL_NAME_VALUE_PAIR_ARRAY
148: ,P_NEW_DL_NAME_VALUE_PAIRS EGO_COL_NAME_VALUE_PAIR_ARRAY
149: ,P_OLD_DL_NAME_VALUE_PAIRS EGO_COL_NAME_VALUE_PAIR_ARRAY
150: ,P_OBJECT_NAME VARCHAR2
151: ,P_APPLICATION_ID NUMBER);
152:
153:
235: ,P_CHANGE_ID IN NUMBER
236: ,P_CHANGE_LINE_ID IN NUMBER
237: ,P_ORG_ID IN NUMBER
238: ,P_DATA_LEVEL_NAME IN VARCHAR2
239: ,P_DATA_LEVEL_NAME_VALUE_PAIRS IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
240: );
241:
242: PROCEDURE SAVE_ITEM_NUM_DESC( p_change_id IN NUMBER
243: , p_change_line_id IN number