[Home] [Help]
229: -- Type : Public
230: -- Function :
231: ************************************************************************************/
232: PROCEDURE get_item_balance(
233: p_items IN inv_ebi_item_list
234: ,x_item_balance_output OUT NOCOPY inv_ebi_item_bal_output_list
235: ,x_return_status OUT NOCOPY VARCHAR2
236: ,x_msg_count OUT NOCOPY NUMBER
237: ,x_msg_data OUT NOCOPY VARCHAR2
239: IS
240: l_return_status VARCHAR2(1);
241: l_msg_count NUMBER;
242: l_msg_data VARCHAR2(1000);
243: l_items inv_ebi_item_list;
244: l_item_balance_input inv_ebi_item_bal_input_list;
245: l_item_bal_input_tbl inv_ebi_item_bal_input_tbl;
246: l_item_bal_input_obj inv_ebi_item_bal_input_obj;
247: l_api_version NUMBER:=1.0;
404: -- Function :
405: ************************************************************************************/
406:
407: PROCEDURE get_item_attributes(
408: p_items IN inv_ebi_item_list
409: ,p_name_val_list IN inv_ebi_name_value_list
410: ,x_item_tbl_obj OUT NOCOPY inv_ebi_item_attr_tbl_obj
411: ,x_return_status OUT NOCOPY VARCHAR2
412: ,x_msg_count OUT NOCOPY NUMBER
415: IS
416: l_return_status VARCHAR2(1);
417: l_msg_count NUMBER;
418: l_msg_data VARCHAR2(1000);
419: l_items inv_ebi_item_list;
420: l_get_item_inp_obj inv_ebi_get_item_input;
421: l_get_opr_attrs_tbl inv_ebi_get_opr_attrs_tbl;
422: l_get_opr_atts inv_ebi_get_operational_attrs;
423: l_inv_ebi_item_attr_tbl_obj inv_ebi_item_attr_tbl_obj;