1: PACKAGE BODY IEB_SYNC_SERVER AS
2: /* $Header: IEBSVRB.pls 115.28 2004/02/10 19:35:48 gpagadal noship $ */
3:
4: PROCEDURE GET_WB_SERVER_LIST (
5: p_language IN varchar2,
49:
50: BEGIN
51: x_return_status := fnd_api.g_ret_sts_success;
52:
53: IEB_SYNC_SERVER.SYNC_SERVER(p_language, x_return_status);
54:
55:
56: v_cursorID := DBMS_SQL.OPEN_CURSOR;
57:
271: Where WB_server_name = c1_rec.server_name;
272: end if;
273: end if;
274:
275: IEB_SYNC_SERVER.INSERT_SVC_CAT_ENTRIES(p_language, l_wbsvr_id, x_return_status);
276:
277: exit when c1%notfound;
278: commit;
279: end loop;
284: null;
285: end if;
286: commit;
287:
288: IEB_SYNC_SERVER.SYNC_CAT_ENTRIES(p_language, x_return_status);
289:
290: EXCEPTION
291: WHEN fnd_api.g_exc_error THEN
292: x_return_status := fnd_api.g_ret_sts_error;
613:
614:
615: END SYNC_CAT_ENTRIES;
616:
617: END IEB_SYNC_SERVER;