10: l_msg_count NUMBER;
11: l_msg_data VARCHAR2(4000);
12: l_attr_group_disp_name VARCHAR2(255);
13: l_attrgroup_counter NUMBER := 0;
14: pos_obj_list pos_supp_uda_obj_tbl := pos_supp_uda_obj_tbl();
15:
16: PROCEDURE intialize IS
17: i NUMBER := 0;
18: BEGIN
27: l_msg_count := '';
28: l_msg_data := '';
29: l_attr_group_disp_name := '';
30: l_attrgroup_counter := 0;
31: pos_obj_list := pos_supp_uda_obj_tbl();
32:
33: EXCEPTION
34: WHEN OTHERS THEN
35: null;
80: IF l_attributes_data_table IS NOT NULL THEN
81:
82: pos_obj_list.extend;
83: l_attrgroup_counter := l_attrgroup_counter + 1;
84: pos_obj_list(l_attrgroup_counter) := pos_supp_uda_obj(l_data_level_2, --party_site_id,
85: l_data_level_3, --supplier_site_id,
86: l_attr_group_id,
87: l_attr_group_disp_name,
88: l_attributes_data_table);
110: PROCEDURE get_uda_data(p_party_id IN NUMBER,
111: p_party_site_id IN NUMBER,
112: p_supplier_site_id IN NUMBER,
113: p_supp_data_level IN VARCHAR2,
114: x_pos_supplier_uda OUT NOCOPY pos_supp_uda_obj_tbl,
115: x_return_status OUT NOCOPY VARCHAR2,
116: x_msg_count OUT NOCOPY NUMBER,
117: x_msg_data OUT NOCOPY VARCHAR2) IS
118:
201: PROCEDURE get_uda_data_party_site(p_party_id IN NUMBER,
202: p_party_site_id IN NUMBER,
203: p_supplier_site_id IN NUMBER,
204: p_supp_data_level IN VARCHAR2,
205: x_pos_supplier_uda OUT NOCOPY pos_supp_uda_obj_tbl,
206: x_return_status OUT NOCOPY VARCHAR2,
207: x_msg_count OUT NOCOPY NUMBER,
208: x_msg_data OUT NOCOPY VARCHAR2) IS
209:
216: FUNCTION get_uda_for_supplier_site(p_party_id IN NUMBER,
217: p_party_site_id IN NUMBER,
218: p_supplier_site_id IN NUMBER,
219: p_supp_data_level IN VARCHAR2)
220: RETURN pos_supp_uda_obj_tbl IS
221: x_pos_supplier_uda pos_supp_uda_obj_tbl := pos_supp_uda_obj_tbl();
222: x_return_status VARCHAR2(1);
223: x_msg_count NUMBER;
224: x_msg_data VARCHAR2(1000);
217: p_party_site_id IN NUMBER,
218: p_supplier_site_id IN NUMBER,
219: p_supp_data_level IN VARCHAR2)
220: RETURN pos_supp_uda_obj_tbl IS
221: x_pos_supplier_uda pos_supp_uda_obj_tbl := pos_supp_uda_obj_tbl();
222: x_return_status VARCHAR2(1);
223: x_msg_count NUMBER;
224: x_msg_data VARCHAR2(1000);
225: BEGIN
242: l_data_level_2 IN NUMBER,
243: l_data_level_3 IN NUMBER,
244: l_data_level IN VARCHAR2,
245: l_party_id IN NUMBER,
246: p_pos_supplier_uda_obj IN pos_supp_uda_obj,
247: l_row_identifier IN NUMBER,
248: p_create_update_flag IN VARCHAR2,
249: x_return_status OUT NOCOPY VARCHAR2,
250: x_msg_count OUT NOCOPY NUMBER,
406: END;
407:
408: PROCEDURE process_uda(p_party_id IN NUMBER,
409: p_supp_data_level IN VARCHAR2,
410: p_pos_supplier_uda IN pos_supp_uda_obj_tbl,
411: p_create_update_flag IN VARCHAR2,
412: x_return_status OUT NOCOPY VARCHAR2,
413: x_msg_count OUT NOCOPY NUMBER,
414: x_msg_data OUT NOCOPY VARCHAR2) IS