111: -- p_attr_grp_pk_tbl : IF Null would get all the appropriate values else would get one appropriate value in the table
112: -- p_attr_grp_pk_tbl refers to the attribute group unique keys for a multi row AG, in the sequence of the corresponding attributes
113: --
114: -- RETURN
115: -- PO_TBL_VARCHAR4000 : The values of the UDA attributes specified in a table
116: ------------------------------------------------------------------------------------------
117:
118: function get_multi_attr_value (
119: p_template_id IN NUMBER,
126: p_attr_grp_id IN NUMBER,
127: p_attr_grp_int_name IN VARCHAR2,
128: p_attr_id IN NUMBER,
129: p_attr_int_name IN VARCHAR2,
130: p_attr_grp_pk_tbl IN PO_TBL_VARCHAR4000 DEFAULT NULL,
131: p_mode IN VARCHAR2 DEFAULT 'INTERNAL_VALUE'
132: ) RETURN PO_TBL_VARCHAR4000;
133:
134:
128: p_attr_id IN NUMBER,
129: p_attr_int_name IN VARCHAR2,
130: p_attr_grp_pk_tbl IN PO_TBL_VARCHAR4000 DEFAULT NULL,
131: p_mode IN VARCHAR2 DEFAULT 'INTERNAL_VALUE'
132: ) RETURN PO_TBL_VARCHAR4000;
133:
134:
135: ------------------------------------------------------------------------------------------
136: -- Procedure: This procedure is used to get the sepecific UDA address attribute values
182: p_attr_grp_int_name IN VARCHAR2 DEFAULT NULL,
183: p_attr_id IN NUMBER DEFAULT NULL,
184: p_attr_int_name IN VARCHAR2 DEFAULT NULL,
185: p_mode IN VARCHAR2 DEFAULT 'INTERNAL_VALUE',
186: p_attr_grp_pk_tbl IN PO_TBL_VARCHAR4000 DEFAULT NULL,
187: x_multi_row_code OUT NOCOPY VARCHAR2,
188: x_single_attr_value OUT NOCOPY VARCHAR2,
189: x_multi_attr_value OUT NOCOPY PO_TBL_VARCHAR4000,
190: x_return_status OUT NOCOPY VARCHAR2,
185: p_mode IN VARCHAR2 DEFAULT 'INTERNAL_VALUE',
186: p_attr_grp_pk_tbl IN PO_TBL_VARCHAR4000 DEFAULT NULL,
187: x_multi_row_code OUT NOCOPY VARCHAR2,
188: x_single_attr_value OUT NOCOPY VARCHAR2,
189: x_multi_attr_value OUT NOCOPY PO_TBL_VARCHAR4000,
190: x_return_status OUT NOCOPY VARCHAR2,
191: x_msg_data OUT NOCOPY VARCHAR2
192: );
193: