DBA Data[Home] [Help]

APPS.CZ_IMP_SINGLE dependencies on CZ_SERVERS

Line 3094: SELECT server_local_id FROM CZ_SERVERS

3090: v_enabled VARCHAR2(1) := '1';
3091: v_local VARCHAR2(8) := 'LOCAL';
3092:
3093: CURSOR check_remote_import IS
3094: SELECT server_local_id FROM CZ_SERVERS
3095: WHERE local_name = v_local
3096: AND import_enabled = v_enabled;
3097:
3098: l_server_id CZ_SERVERS.server_local_id%type;

Line 3098: l_server_id CZ_SERVERS.server_local_id%type;

3094: SELECT server_local_id FROM CZ_SERVERS
3095: WHERE local_name = v_local
3096: AND import_enabled = v_enabled;
3097:
3098: l_server_id CZ_SERVERS.server_local_id%type;
3099: x_get_remote_import_f BOOLEAN := false;
3100: xError boolean := false;
3101: d_str VARCHAR2(2000);
3102:

Line 3441: server_id cz_servers.server_local_id%TYPE;

3437: nRunExploder PLS_INTEGER;
3438: cFound CHAR(1);
3439: dDateFormat VARCHAR2(40);
3440: sVersion CZ_DB_SETTINGS.VALUE%TYPE;
3441: server_id cz_servers.server_local_id%TYPE;
3442: nModelId NUMBER;
3443: topModelId NUMBER;
3444: genStatisticsBom PLS_INTEGER;
3445: genStatisticsCz PLS_INTEGER;

Line 3519: FROM cz_servers

3515: DBMS_APPLICATION_INFO.SET_MODULE('CZIMPORT','');
3516:
3517: BEGIN
3518: SELECT server_local_id INTO server_id
3519: FROM cz_servers
3520: WHERE import_enabled = v_enabled;
3521: EXCEPTION
3522: WHEN TOO_MANY_ROWS THEN
3523: xERROR:=cz_utils.log_report(CZ_UTILS.GET_TEXT('CZ_IMP_TOO_MANY_SERVERS'),1,'CZ_IMP_ALL.ImportSingleBill',11276);