APPS.CZ_IMP_SINGLE dependencies on CZ_SERVERS

Line 3168: SELECT server_local_id FROM CZ_SERVERS

3164: v_enabled VARCHAR2(1) := '1';
3165: v_local VARCHAR2(8) := 'LOCAL';
3166:
3167: CURSOR check_remote_import IS
3168: SELECT server_local_id FROM CZ_SERVERS
3169: WHERE local_name = v_local
3170: AND import_enabled = v_enabled;
3171:
3172: l_server_id CZ_SERVERS.server_local_id%type;

Line 3172: l_server_id CZ_SERVERS.server_local_id%type;

3168: SELECT server_local_id FROM CZ_SERVERS
3169: WHERE local_name = v_local
3170: AND import_enabled = v_enabled;
3171:
3172: l_server_id CZ_SERVERS.server_local_id%type;
3173: x_get_remote_import_f BOOLEAN := false;
3174: xError boolean := false;
3175: d_str VARCHAR2(2000);
3176:

Line 3748: server_id cz_servers.server_local_id%TYPE;

3744: nRunExploder PLS_INTEGER;
3745: cFound CHAR(1);
3746: dDateFormat VARCHAR2(40);
3747: sVersion CZ_DB_SETTINGS.VALUE%TYPE;
3748: server_id cz_servers.server_local_id%TYPE;
3749: nModelId NUMBER;
3750: topModelId NUMBER;
3751: genStatisticsBom PLS_INTEGER;
3752: genStatisticsCz PLS_INTEGER;

Line 3832: FROM cz_servers

3828: DBMS_APPLICATION_INFO.SET_MODULE('CZIMPORT','');
3829:
3830: BEGIN
3831: SELECT server_local_id INTO server_id
3832: FROM cz_servers
3833: WHERE import_enabled = v_enabled;
3834: EXCEPTION
3835: WHEN TOO_MANY_ROWS THEN
3836: xERROR:=cz_utils.log_report(CZ_UTILS.GET_TEXT('CZ_IMP_TOO_MANY_SERVERS'),1,'CZ_IMP_ALL.ImportSingleBill',11276);