APPS.CZ_ORAAPPS_INTEGRATE dependencies on CZ_SERVERS_S

Line 2248: SELECT cz_servers_s.NEXTVAL

2244: END;
2245: END IF;
2246:
2247: BEGIN
2248: SELECT cz_servers_s.NEXTVAL
2249: INTO v_server_id
2250: FROM dual;
2251: FND_FILE.PUT_LINE(FND_FILE.LOG,'Inserting ' || v_server_id);
2252: INSERT INTO CZ_SERVERS (SERVER_LOCAL_ID,LOCAL_NAME, HOSTNAME, DB_LISTENER_PORT,

Line 2471: UPDATE CZ_SERVERS SET

2467: return;
2468: END;
2469:
2470: BEGIN
2471: UPDATE CZ_SERVERS SET
2472: LOCAL_NAME = v_local_name,
2473: HOSTNAME = v_hostname,
2474: DB_LISTENER_PORT = v_db_listener_port,
2475: INSTANCE_NAME = v_instance_name,

Line 2481: WHERE cz_servers.server_local_id = v_server_id ;

2477: GLOBAL_IDENTITY = v_global_identity ,
2478: NOTES = v_notes ,
2479: FNDNAM_LINK_NAME = v_fndnam_link_name ,
2480: IMPORT_ENABLED = v_import_enabled
2481: WHERE cz_servers.server_local_id = v_server_id ;
2482: EXCEPTION
2483: WHEN OTHERS THEN
2484: Retcode := '2';
2485: errbuf := cz_utils.get_text('CZ_MOD_SERVER_ERR','SQLERRM',Sqlerrm);

Line 2546: lServerDbVersion CZ_SERVERS.SERVER_DB_VERSION%TYPE;

2542: lLocalName CZ_SERVERS.LOCAL_NAME%TYPE;
2543: lHostName CZ_SERVERS.HOSTNAME%TYPE;
2544: lDbListenerPort CZ_SERVERS.DB_LISTENER_PORT%TYPE;
2545: lInstanceName CZ_SERVERS.INSTANCE_NAME%TYPE;
2546: lServerDbVersion CZ_SERVERS.SERVER_DB_VERSION%TYPE;
2547: lFndNam CZ_SERVERS.FNDNAM%TYPE;
2548: lGlobalIdentity CZ_SERVERS.GLOBAL_IDENTITY%TYPE;
2549: lNotes CZ_SERVERS.NOTES%TYPE;
2550: lFndNamLinkName CZ_SERVERS.FNDNAM_LINK_NAME%TYPE;

Line 2620: v_server_db_version cz_servers.server_db_version%TYPE;

2616: v_db_listener_port cz_servers.db_listener_port%TYPE;
2617: v_fndnam cz_servers.fndnam%TYPE;
2618: v_fndnam_link_name cz_servers.fndnam_link_name%TYPE;
2619: v_local_name cz_servers.local_name%TYPE;
2620: v_server_db_version cz_servers.server_db_version%TYPE;
2621: v_import_enabled cz_servers.import_enabled%TYPE;
2622: v_server_id cz_servers.server_local_id%TYPE;
2623: v_cursor NUMBER;
2624: v_NumRows NUMBER;

Line 2622: v_server_id cz_servers.server_local_id%TYPE;

2618: v_fndnam_link_name cz_servers.fndnam_link_name%TYPE;
2619: v_local_name cz_servers.local_name%TYPE;
2620: v_server_db_version cz_servers.server_db_version%TYPE;
2621: v_import_enabled cz_servers.import_enabled%TYPE;
2622: v_server_id cz_servers.server_local_id%TYPE;
2623: v_cursor NUMBER;
2624: v_NumRows NUMBER;
2625: v_dummy NUMBER;
2626: xerror char(1);

Line 2736: UPDATE CZ_SERVERS SET

2732: END;
2733:
2734:
2735: BEGIN
2736: UPDATE CZ_SERVERS SET
2737: SERVER_DB_VERSION = v_server_db_version
2738: WHERE cz_servers.local_name = v_local_name ;
2739: COMMIT;
2740: EXCEPTION