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;
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
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