DBA Data[Home] [Help]

APPS.IEB_SYNC_SERVER dependencies on IEB_SVC_CATS_S1

Line 328: select IEB_SVC_CATS_S1.NEXTVAL into l_wbsc_id from sys.dual;

324: begin
325: x_return_status := fnd_api.g_ret_sts_success;
326:
327: for c1_rec in c1 loop
328: select IEB_SVC_CATS_S1.NEXTVAL into l_wbsc_id from sys.dual;
329: if c1_rec.depth = 0 then
330: l_parent_id := NULL;
331: l_parent_id_ib := l_wbsc_id;
332: l_parent_id_ob := l_wbsc_id;

Line 513: select IEB_SVC_CATS_S1.NEXTVAL into l_wbsc_id from sys.dual;

509: -- commit;
510:
511: if (sql%notfound) then
512:
513: select IEB_SVC_CATS_S1.NEXTVAL into l_wbsc_id from sys.dual;
514: if c1_rec2.depth = 0 then
515: l_parent_id := NULL;
516: l_root_id_ib := l_wbsc_id;
517: l_root_id_ob := l_wbsc_id;