DBA Data[Home] [Help]

APPS.INV_SERIAL_NUMBER_PUB dependencies on MTL_GEN_OBJECT_ID_S

Line 243: SELECT mtl_gen_object_id_s.NEXTVAL

239:
240: RAISE fnd_api.g_exc_unexpected_error;
241: END;
242:
243: SELECT mtl_gen_object_id_s.NEXTVAL
244: INTO x_object_id
245: FROM DUAL;
246:
247: l_userid := fnd_global.user_id;

Line 491: SELECT mtl_gen_object_id_s.NEXTVAL

487: fnd_msg_pub.ADD;
488: RAISE fnd_api.g_exc_error;
489: END;
490:
491: SELECT mtl_gen_object_id_s.NEXTVAL
492: INTO x_object_id
493: FROM DUAL;
494:
495: -- invtrace('next genealogy object id from the sequence mtl_gen_object_id_s is ' || x_object_id);

Line 495: -- invtrace('next genealogy object id from the sequence mtl_gen_object_id_s is ' || x_object_id);

491: SELECT mtl_gen_object_id_s.NEXTVAL
492: INTO x_object_id
493: FROM DUAL;
494:
495: -- invtrace('next genealogy object id from the sequence mtl_gen_object_id_s is ' || x_object_id);
496: l_wms_installed :=
497: wms_install.check_install(
498: x_return_status => l_return_status
499: , x_msg_count => l_msg_count