197: /*
198: ** Added by Amay - for propagation of attributes up the hierarchy
199: */
200: PROCEDURE Item_Propagate_Attributes
201: ( p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
202: , p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
203: , p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
204: , p_attr_diffs IN EGO_USER_ATTR_DIFF_TABLE
205: , p_transaction_type IN VARCHAR2
198: ** Added by Amay - for propagation of attributes up the hierarchy
199: */
200: PROCEDURE Item_Propagate_Attributes
201: ( p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
202: , p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
203: , p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
204: , p_attr_diffs IN EGO_USER_ATTR_DIFF_TABLE
205: , p_transaction_type IN VARCHAR2
206: , p_attr_group_id IN NUMBER DEFAULT NULL
199: */
200: PROCEDURE Item_Propagate_Attributes
201: ( p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
202: , p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
203: , p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
204: , p_attr_diffs IN EGO_USER_ATTR_DIFF_TABLE
205: , p_transaction_type IN VARCHAR2
206: , p_attr_group_id IN NUMBER DEFAULT NULL
207: , x_error_message OUT NOCOPY VARCHAR2
230: /*
231: ** Added by Amay - for setting of attributes (called by BOM_COMPUTE_FUNCTIONS)
232: */
233: PROCEDURE Update_Attributes
234: ( p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
235: , p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
236: , p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
237: , p_attr_diffs IN EGO_USER_ATTR_DIFF_TABLE
238: , p_transaction_type IN VARCHAR2
231: ** Added by Amay - for setting of attributes (called by BOM_COMPUTE_FUNCTIONS)
232: */
233: PROCEDURE Update_Attributes
234: ( p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
235: , p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
236: , p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
237: , p_attr_diffs IN EGO_USER_ATTR_DIFF_TABLE
238: , p_transaction_type IN VARCHAR2
239: , p_attr_group_id IN NUMBER DEFAULT NULL
232: */
233: PROCEDURE Update_Attributes
234: ( p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
235: , p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
236: , p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
237: , p_attr_diffs IN EGO_USER_ATTR_DIFF_TABLE
238: , p_transaction_type IN VARCHAR2
239: , p_attr_group_id IN NUMBER DEFAULT NULL
240: , x_error_message OUT NOCOPY VARCHAR2
250: , p_application_id IN NUMBER DEFAULT NULL
251: , p_attr_group_type IN VARCHAR2 DEFAULT NULL
252: , p_attr_group_name IN VARCHAR2 DEFAULT NULL
253: , px_attr_diffs IN OUT NOCOPY EGO_USER_ATTR_DIFF_TABLE
254: , px_pk_column_name_value_pairs OUT NOCOPY EGO_COL_NAME_VALUE_PAIR_ARRAY
255: , px_class_code_name_value_pairs OUT NOCOPY EGO_COL_NAME_VALUE_PAIR_ARRAY
256: , px_data_level_name_value_pairs OUT NOCOPY EGO_COL_NAME_VALUE_PAIR_ARRAY
257: , x_error_message OUT NOCOPY VARCHAR2
258: );
251: , p_attr_group_type IN VARCHAR2 DEFAULT NULL
252: , p_attr_group_name IN VARCHAR2 DEFAULT NULL
253: , px_attr_diffs IN OUT NOCOPY EGO_USER_ATTR_DIFF_TABLE
254: , px_pk_column_name_value_pairs OUT NOCOPY EGO_COL_NAME_VALUE_PAIR_ARRAY
255: , px_class_code_name_value_pairs OUT NOCOPY EGO_COL_NAME_VALUE_PAIR_ARRAY
256: , px_data_level_name_value_pairs OUT NOCOPY EGO_COL_NAME_VALUE_PAIR_ARRAY
257: , x_error_message OUT NOCOPY VARCHAR2
258: );
259:
252: , p_attr_group_name IN VARCHAR2 DEFAULT NULL
253: , px_attr_diffs IN OUT NOCOPY EGO_USER_ATTR_DIFF_TABLE
254: , px_pk_column_name_value_pairs OUT NOCOPY EGO_COL_NAME_VALUE_PAIR_ARRAY
255: , px_class_code_name_value_pairs OUT NOCOPY EGO_COL_NAME_VALUE_PAIR_ARRAY
256: , px_data_level_name_value_pairs OUT NOCOPY EGO_COL_NAME_VALUE_PAIR_ARRAY
257: , x_error_message OUT NOCOPY VARCHAR2
258: );
259:
260: /*