DBA Data[Home] [Help]

APPS.CZ_LC_MGR dependencies on CZ_DB_SETTINGS

Line 6: SELECT TO_NUMBER(VALUE) INTO BATCH_size FROM CZ_DB_SETTINGS

2: /* $Header: czlcmgrb.pls 120.2 2011/04/19 18:38:53 smanna ship $ */
3:
4: PROCEDURE get_BATCH_size IS
5: BEGIN
6: SELECT TO_NUMBER(VALUE) INTO BATCH_size FROM CZ_DB_SETTINGS
7: WHERE UPPER(SETTING_ID)='BATCHSIZE';
8: EXCEPTION
9: WHEN NO_DATA_FOUND THEN
10: BATCH_size:=5000;