[Home] [Help]
198: PROCEDURE get_bo_and_insert(p_party_id IN pos_tbl_number,
199: p_report_id IN NUMBER ) IS
200: l_user_id NUMBER := fnd_global.user_id;
201: l_last_update_login NUMBER := fnd_global.login_id;
202: l_pos_supplier_bo pos_supplier_bo;
203: x_return_status VARCHAR2(1000);
204: x_msg_count NUMBER:=0;
205: x_msg_data VARCHAR2(1000);
206:
208:
209: FOR i IN p_party_id.first .. p_party_id.last LOOP
210:
211: -- Procedure to get the XML content based on Party ID
212: pos_supplier_bo_pkg.pos_get_supplier_bo(NULL,
213: NULL,
214: p_party_id(i),
215: NULL,
216: NULL,
213: NULL,
214: p_party_id(i),
215: NULL,
216: NULL,
217: l_pos_supplier_bo,
218: x_return_status,
219: x_msg_count,
220: x_msg_data);
221:
230: last_update_login)
231: VALUES
232: (p_report_id,
233: p_party_id(i),
234: xmltype(l_pos_supplier_bo),
235: l_user_id,
236: SYSDATE,
237: l_user_id,
238: SYSDATE,