eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CZ_ORAAPPS_INTEGRATE dependencies on CZ_SERVERS

Line 1434: v_fndnam_link_name cz_servers.local_name%type;

1430: --------->>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
1431: ---------- create views
1432:
1433: FUNCTION create_exv_views(slocal_name IN VARCHAR2) RETURN VARCHAR2 AS
1434: v_fndnam_link_name cz_servers.local_name%type;
1435:
1436: v_bom_string varchar2(4000);
1437: v_item_master_string varchar2(4000);
1438: v_items_string varchar2(4000);

Line 1489: FROM cz_servers

1485: BEGIN
1486:
1487: IF (upper(slocal_name) NOT IN ('LOCAL','ERROR')) THEN
1488: SELECT fndnam_link_name INTO v_fndnam_link_name
1489: FROM cz_servers
1490: WHERE local_name = slocal_name;
1491: v_fndnam_link_name := '@'|| v_fndnam_link_name;
1492: ELSE
1493: v_fndnam_link_name := '';

Line 1966: v_import_enabled cz_servers.import_enabled%TYPE;

1962: p_db_link OUT NOCOPY VARCHAR2,
1963: p_do_compile IN VARCHAR2 -- DEFAULT '1'
1964: ) IS
1965: v_code VARCHAR2(1);
1966: v_import_enabled cz_servers.import_enabled%TYPE;
1967: v_local_name cz_servers.local_name%TYPE;
1968: BEGIN
1969: BEGIN
1970: SELECT local_name,fndnam_link_name,import_enabled

Line 1967: v_local_name cz_servers.local_name%TYPE;

1963: p_do_compile IN VARCHAR2 -- DEFAULT '1'
1964: ) IS
1965: v_code VARCHAR2(1);
1966: v_import_enabled cz_servers.import_enabled%TYPE;
1967: v_local_name cz_servers.local_name%TYPE;
1968: BEGIN
1969: BEGIN
1970: SELECT local_name,fndnam_link_name,import_enabled
1971: INTO v_local_name,p_db_link,v_import_enabled FROM CZ_SERVERS

Line 1971: INTO v_local_name,p_db_link,v_import_enabled FROM CZ_SERVERS

1967: v_local_name cz_servers.local_name%TYPE;
1968: BEGIN
1969: BEGIN
1970: SELECT local_name,fndnam_link_name,import_enabled
1971: INTO v_local_name,p_db_link,v_import_enabled FROM CZ_SERVERS
1972: WHERE import_enabled='1';
1973:
1974: ---- check DB Link ----
1975: p_link_status:=isLinkAlive(p_db_link);

Line 2025: v_db_link CZ_SERVERS.fndnam_link_name%TYPE;

2021:
2022: PROCEDURE recreate_exv_views_cp(errbuf IN OUT NOCOPY VARCHAR2,
2023: retcode IN OUT NOCOPY INTEGER) IS
2024: v_views_status VARCHAR2(1);
2025: v_db_link CZ_SERVERS.fndnam_link_name%TYPE;
2026: BEGIN
2027: retcode:=0;
2028: recreate_exv_views(v_views_status,v_db_link, 1);
2029: IF v_views_status=LINK_WORKS THEN

Line 2130: ---------- to insert records into cz_servers

2126: END drop_exv_views;
2127:
2128:
2129: --------->>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
2130: ---------- to insert records into cz_servers
2131:
2132: PROCEDURE populate_cz_server_cp( Errbuf IN OUT NOCOPY VARCHAR2,
2133: Retcode IN OUT NOCOPY PLS_INTEGER,
2134: LOCAL_NAME IN VARCHAR2

Line 2146: v_hostname cz_servers.hostname%TYPE;

2142: ,IMPORT_ENABLED IN VARCHAR2
2143: )
2144: AS
2145:
2146: v_hostname cz_servers.hostname%TYPE;
2147: v_db_listener_port cz_servers.db_listener_port%TYPE;
2148: v_instance_name cz_servers.instance_name%TYPE;
2149: v_local_name cz_servers.local_name%TYPE;
2150: v_fndnam cz_servers.fndnam%TYPE;

Line 2147: v_db_listener_port cz_servers.db_listener_port%TYPE;

2143: )
2144: AS
2145:
2146: v_hostname cz_servers.hostname%TYPE;
2147: v_db_listener_port cz_servers.db_listener_port%TYPE;
2148: v_instance_name cz_servers.instance_name%TYPE;
2149: v_local_name cz_servers.local_name%TYPE;
2150: v_fndnam cz_servers.fndnam%TYPE;
2151: v_global_identity cz_servers.global_identity%TYPE;

Line 2148: v_instance_name cz_servers.instance_name%TYPE;

2144: AS
2145:
2146: v_hostname cz_servers.hostname%TYPE;
2147: v_db_listener_port cz_servers.db_listener_port%TYPE;
2148: v_instance_name cz_servers.instance_name%TYPE;
2149: v_local_name cz_servers.local_name%TYPE;
2150: v_fndnam cz_servers.fndnam%TYPE;
2151: v_global_identity cz_servers.global_identity%TYPE;
2152: v_notes cz_servers.notes%TYPE;

Line 2149: v_local_name cz_servers.local_name%TYPE;

2145:
2146: v_hostname cz_servers.hostname%TYPE;
2147: v_db_listener_port cz_servers.db_listener_port%TYPE;
2148: v_instance_name cz_servers.instance_name%TYPE;
2149: v_local_name cz_servers.local_name%TYPE;
2150: v_fndnam cz_servers.fndnam%TYPE;
2151: v_global_identity cz_servers.global_identity%TYPE;
2152: v_notes cz_servers.notes%TYPE;
2153: v_fndnam_link_name cz_servers.fndnam_link_name%TYPE;

Line 2150: v_fndnam cz_servers.fndnam%TYPE;

2146: v_hostname cz_servers.hostname%TYPE;
2147: v_db_listener_port cz_servers.db_listener_port%TYPE;
2148: v_instance_name cz_servers.instance_name%TYPE;
2149: v_local_name cz_servers.local_name%TYPE;
2150: v_fndnam cz_servers.fndnam%TYPE;
2151: v_global_identity cz_servers.global_identity%TYPE;
2152: v_notes cz_servers.notes%TYPE;
2153: v_fndnam_link_name cz_servers.fndnam_link_name%TYPE;
2154: v_import_enabled cz_servers.import_enabled%TYPE;

Line 2151: v_global_identity cz_servers.global_identity%TYPE;

2147: v_db_listener_port cz_servers.db_listener_port%TYPE;
2148: v_instance_name cz_servers.instance_name%TYPE;
2149: v_local_name cz_servers.local_name%TYPE;
2150: v_fndnam cz_servers.fndnam%TYPE;
2151: v_global_identity cz_servers.global_identity%TYPE;
2152: v_notes cz_servers.notes%TYPE;
2153: v_fndnam_link_name cz_servers.fndnam_link_name%TYPE;
2154: v_import_enabled cz_servers.import_enabled%TYPE;
2155:

Line 2152: v_notes cz_servers.notes%TYPE;

2148: v_instance_name cz_servers.instance_name%TYPE;
2149: v_local_name cz_servers.local_name%TYPE;
2150: v_fndnam cz_servers.fndnam%TYPE;
2151: v_global_identity cz_servers.global_identity%TYPE;
2152: v_notes cz_servers.notes%TYPE;
2153: v_fndnam_link_name cz_servers.fndnam_link_name%TYPE;
2154: v_import_enabled cz_servers.import_enabled%TYPE;
2155:
2156: v_error_status VARCHAR2(4000) := '0';

Line 2153: v_fndnam_link_name cz_servers.fndnam_link_name%TYPE;

2149: v_local_name cz_servers.local_name%TYPE;
2150: v_fndnam cz_servers.fndnam%TYPE;
2151: v_global_identity cz_servers.global_identity%TYPE;
2152: v_notes cz_servers.notes%TYPE;
2153: v_fndnam_link_name cz_servers.fndnam_link_name%TYPE;
2154: v_import_enabled cz_servers.import_enabled%TYPE;
2155:
2156: v_error_status VARCHAR2(4000) := '0';
2157: v_success char(1) := '0';

Line 2154: v_import_enabled cz_servers.import_enabled%TYPE;

2150: v_fndnam cz_servers.fndnam%TYPE;
2151: v_global_identity cz_servers.global_identity%TYPE;
2152: v_notes cz_servers.notes%TYPE;
2153: v_fndnam_link_name cz_servers.fndnam_link_name%TYPE;
2154: v_import_enabled cz_servers.import_enabled%TYPE;
2155:
2156: v_error_status VARCHAR2(4000) := '0';
2157: v_success char(1) := '0';
2158: v_warning char(1) := '1';

Line 2195: FROM cz_servers

2191:
2192: BEGIN
2193: SELECT count(*)
2194: INTO v_server_count
2195: FROM cz_servers
2196: WHERE cz_servers.local_name = v_local_name
2197: OR ( cz_servers.hostname = v_hostname
2198: AND cz_servers.instance_name = v_instance_name
2199: AND cz_servers.db_listener_port = v_db_listener_port) ;

Line 2196: WHERE cz_servers.local_name = v_local_name

2192: BEGIN
2193: SELECT count(*)
2194: INTO v_server_count
2195: FROM cz_servers
2196: WHERE cz_servers.local_name = v_local_name
2197: OR ( cz_servers.hostname = v_hostname
2198: AND cz_servers.instance_name = v_instance_name
2199: AND cz_servers.db_listener_port = v_db_listener_port) ;
2200: EXCEPTION

Line 2197: OR ( cz_servers.hostname = v_hostname

2193: SELECT count(*)
2194: INTO v_server_count
2195: FROM cz_servers
2196: WHERE cz_servers.local_name = v_local_name
2197: OR ( cz_servers.hostname = v_hostname
2198: AND cz_servers.instance_name = v_instance_name
2199: AND cz_servers.db_listener_port = v_db_listener_port) ;
2200: EXCEPTION
2201: WHEN OTHERS THEN

Line 2198: AND cz_servers.instance_name = v_instance_name

2194: INTO v_server_count
2195: FROM cz_servers
2196: WHERE cz_servers.local_name = v_local_name
2197: OR ( cz_servers.hostname = v_hostname
2198: AND cz_servers.instance_name = v_instance_name
2199: AND cz_servers.db_listener_port = v_db_listener_port) ;
2200: EXCEPTION
2201: WHEN OTHERS THEN
2202: v_server_count := 0;

Line 2199: AND cz_servers.db_listener_port = v_db_listener_port) ;

2195: FROM cz_servers
2196: WHERE cz_servers.local_name = v_local_name
2197: OR ( cz_servers.hostname = v_hostname
2198: AND cz_servers.instance_name = v_instance_name
2199: AND cz_servers.db_listener_port = v_db_listener_port) ;
2200: EXCEPTION
2201: WHEN OTHERS THEN
2202: v_server_count := 0;
2203: END;

Line 2213: SELECT count(*) INTO v_import_count FROM cz_servers

2209: INTO v_import_enabled
2210: FROM dual;
2211:
2212: IF (v_import_enabled = '1') THEN
2213: SELECT count(*) INTO v_import_count FROM cz_servers
2214: WHERE import_enabled = '1';
2215: IF (V_IMPORT_count > 0) THEN
2216: Errbuf := cz_utils.get_text('CZ_IMP_SERVER_EXISTS_DEF');
2217: log_report(Errbuf);

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 2252: INSERT INTO CZ_SERVERS (SERVER_LOCAL_ID,LOCAL_NAME, HOSTNAME, DB_LISTENER_PORT,

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,
2253: INSTANCE_NAME, FNDNAM, GLOBAL_IDENTITY, NOTES,
2254: FNDNAM_LINK_NAME, IMPORT_ENABLED)
2255: VALUES (v_server_id,LOCAL_NAME, HOSTNAME, DB_LISTENER_PORT,
2256: INSTANCE_NAME, FNDNAM, V_GLOBAL_IDENTITY, NOTES,

Line 2279: ----------proc for altering records into cz_servers

2275:
2276: END populate_cz_server_cp;
2277:
2278: ---------->>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
2279: ----------proc for altering records into cz_servers
2280:
2281: PROCEDURE alter_cz_server_cp( Errbuf IN OUT NOCOPY VARCHAR2,
2282: Retcode IN OUT NOCOPY PLS_INTEGER,
2283: LOCAL_NAME IN VARCHAR2,

Line 2295: v_hostname cz_servers.hostname%TYPE;

2291: IMPORT_ENABLED IN VARCHAR2
2292: )
2293: AS
2294: v_error_status VARCHAR2(4000) := '0';
2295: v_hostname cz_servers.hostname%TYPE;
2296: v_db_listener_port cz_servers.db_listener_port%TYPE;
2297: v_instance_name cz_servers.instance_name%TYPE;
2298: v_local_name cz_servers.local_name%TYPE;
2299: v_fndnam cz_servers.fndnam%TYPE;

Line 2296: v_db_listener_port cz_servers.db_listener_port%TYPE;

2292: )
2293: AS
2294: v_error_status VARCHAR2(4000) := '0';
2295: v_hostname cz_servers.hostname%TYPE;
2296: v_db_listener_port cz_servers.db_listener_port%TYPE;
2297: v_instance_name cz_servers.instance_name%TYPE;
2298: v_local_name cz_servers.local_name%TYPE;
2299: v_fndnam cz_servers.fndnam%TYPE;
2300: v_global_identity cz_servers.global_identity%TYPE;

Line 2297: v_instance_name cz_servers.instance_name%TYPE;

2293: AS
2294: v_error_status VARCHAR2(4000) := '0';
2295: v_hostname cz_servers.hostname%TYPE;
2296: v_db_listener_port cz_servers.db_listener_port%TYPE;
2297: v_instance_name cz_servers.instance_name%TYPE;
2298: v_local_name cz_servers.local_name%TYPE;
2299: v_fndnam cz_servers.fndnam%TYPE;
2300: v_global_identity cz_servers.global_identity%TYPE;
2301: v_notes cz_servers.notes%TYPE;

Line 2298: v_local_name cz_servers.local_name%TYPE;

2294: v_error_status VARCHAR2(4000) := '0';
2295: v_hostname cz_servers.hostname%TYPE;
2296: v_db_listener_port cz_servers.db_listener_port%TYPE;
2297: v_instance_name cz_servers.instance_name%TYPE;
2298: v_local_name cz_servers.local_name%TYPE;
2299: v_fndnam cz_servers.fndnam%TYPE;
2300: v_global_identity cz_servers.global_identity%TYPE;
2301: v_notes cz_servers.notes%TYPE;
2302: v_fndnam_link_name cz_servers.fndnam_link_name%TYPE;

Line 2299: v_fndnam cz_servers.fndnam%TYPE;

2295: v_hostname cz_servers.hostname%TYPE;
2296: v_db_listener_port cz_servers.db_listener_port%TYPE;
2297: v_instance_name cz_servers.instance_name%TYPE;
2298: v_local_name cz_servers.local_name%TYPE;
2299: v_fndnam cz_servers.fndnam%TYPE;
2300: v_global_identity cz_servers.global_identity%TYPE;
2301: v_notes cz_servers.notes%TYPE;
2302: v_fndnam_link_name cz_servers.fndnam_link_name%TYPE;
2303: v_import_enabled cz_servers.import_enabled%TYPE;

Line 2300: v_global_identity cz_servers.global_identity%TYPE;

2296: v_db_listener_port cz_servers.db_listener_port%TYPE;
2297: v_instance_name cz_servers.instance_name%TYPE;
2298: v_local_name cz_servers.local_name%TYPE;
2299: v_fndnam cz_servers.fndnam%TYPE;
2300: v_global_identity cz_servers.global_identity%TYPE;
2301: v_notes cz_servers.notes%TYPE;
2302: v_fndnam_link_name cz_servers.fndnam_link_name%TYPE;
2303: v_import_enabled cz_servers.import_enabled%TYPE;
2304:

Line 2301: v_notes cz_servers.notes%TYPE;

2297: v_instance_name cz_servers.instance_name%TYPE;
2298: v_local_name cz_servers.local_name%TYPE;
2299: v_fndnam cz_servers.fndnam%TYPE;
2300: v_global_identity cz_servers.global_identity%TYPE;
2301: v_notes cz_servers.notes%TYPE;
2302: v_fndnam_link_name cz_servers.fndnam_link_name%TYPE;
2303: v_import_enabled cz_servers.import_enabled%TYPE;
2304:
2305: v_server_count NUMBER := 0;

Line 2302: v_fndnam_link_name cz_servers.fndnam_link_name%TYPE;

2298: v_local_name cz_servers.local_name%TYPE;
2299: v_fndnam cz_servers.fndnam%TYPE;
2300: v_global_identity cz_servers.global_identity%TYPE;
2301: v_notes cz_servers.notes%TYPE;
2302: v_fndnam_link_name cz_servers.fndnam_link_name%TYPE;
2303: v_import_enabled cz_servers.import_enabled%TYPE;
2304:
2305: v_server_count NUMBER := 0;
2306: v_server_id NUMBER ;

Line 2303: v_import_enabled cz_servers.import_enabled%TYPE;

2299: v_fndnam cz_servers.fndnam%TYPE;
2300: v_global_identity cz_servers.global_identity%TYPE;
2301: v_notes cz_servers.notes%TYPE;
2302: v_fndnam_link_name cz_servers.fndnam_link_name%TYPE;
2303: v_import_enabled cz_servers.import_enabled%TYPE;
2304:
2305: v_server_count NUMBER := 0;
2306: v_server_id NUMBER ;
2307: v_import_count NUMBER := 0;

Line 2316: v_db_link CZ_SERVERS.fndnam_link_name%TYPE;

2312: v_errorString VARCHAR2(1024) :='ALTER_SERVER_CP: ';
2313: v_createstring varchar2(4000);
2314:
2315: v_views_status VARCHAR2(1);
2316: v_db_link CZ_SERVERS.fndnam_link_name%TYPE;
2317:
2318: l_hostname cz_servers.hostname%TYPE;
2319: l_db_listener_port cz_servers.db_listener_port%TYPE;
2320: l_instance_name cz_servers.instance_name%TYPE;

Line 2318: l_hostname cz_servers.hostname%TYPE;

2314:
2315: v_views_status VARCHAR2(1);
2316: v_db_link CZ_SERVERS.fndnam_link_name%TYPE;
2317:
2318: l_hostname cz_servers.hostname%TYPE;
2319: l_db_listener_port cz_servers.db_listener_port%TYPE;
2320: l_instance_name cz_servers.instance_name%TYPE;
2321: l_fndnam cz_servers.fndnam%TYPE;
2322: l_global_identity cz_servers.global_identity%TYPE;

Line 2319: l_db_listener_port cz_servers.db_listener_port%TYPE;

2315: v_views_status VARCHAR2(1);
2316: v_db_link CZ_SERVERS.fndnam_link_name%TYPE;
2317:
2318: l_hostname cz_servers.hostname%TYPE;
2319: l_db_listener_port cz_servers.db_listener_port%TYPE;
2320: l_instance_name cz_servers.instance_name%TYPE;
2321: l_fndnam cz_servers.fndnam%TYPE;
2322: l_global_identity cz_servers.global_identity%TYPE;
2323: l_notes cz_servers.notes%TYPE;

Line 2320: l_instance_name cz_servers.instance_name%TYPE;

2316: v_db_link CZ_SERVERS.fndnam_link_name%TYPE;
2317:
2318: l_hostname cz_servers.hostname%TYPE;
2319: l_db_listener_port cz_servers.db_listener_port%TYPE;
2320: l_instance_name cz_servers.instance_name%TYPE;
2321: l_fndnam cz_servers.fndnam%TYPE;
2322: l_global_identity cz_servers.global_identity%TYPE;
2323: l_notes cz_servers.notes%TYPE;
2324: l_fndnam_link_name cz_servers.fndnam_link_name%TYPE;

Line 2321: l_fndnam cz_servers.fndnam%TYPE;

2317:
2318: l_hostname cz_servers.hostname%TYPE;
2319: l_db_listener_port cz_servers.db_listener_port%TYPE;
2320: l_instance_name cz_servers.instance_name%TYPE;
2321: l_fndnam cz_servers.fndnam%TYPE;
2322: l_global_identity cz_servers.global_identity%TYPE;
2323: l_notes cz_servers.notes%TYPE;
2324: l_fndnam_link_name cz_servers.fndnam_link_name%TYPE;
2325: l_import_enabled cz_servers.import_enabled%TYPE;

Line 2322: l_global_identity cz_servers.global_identity%TYPE;

2318: l_hostname cz_servers.hostname%TYPE;
2319: l_db_listener_port cz_servers.db_listener_port%TYPE;
2320: l_instance_name cz_servers.instance_name%TYPE;
2321: l_fndnam cz_servers.fndnam%TYPE;
2322: l_global_identity cz_servers.global_identity%TYPE;
2323: l_notes cz_servers.notes%TYPE;
2324: l_fndnam_link_name cz_servers.fndnam_link_name%TYPE;
2325: l_import_enabled cz_servers.import_enabled%TYPE;
2326: matching_local_name cz_servers.local_name%TYPE;

Line 2323: l_notes cz_servers.notes%TYPE;

2319: l_db_listener_port cz_servers.db_listener_port%TYPE;
2320: l_instance_name cz_servers.instance_name%TYPE;
2321: l_fndnam cz_servers.fndnam%TYPE;
2322: l_global_identity cz_servers.global_identity%TYPE;
2323: l_notes cz_servers.notes%TYPE;
2324: l_fndnam_link_name cz_servers.fndnam_link_name%TYPE;
2325: l_import_enabled cz_servers.import_enabled%TYPE;
2326: matching_local_name cz_servers.local_name%TYPE;
2327:

Line 2324: l_fndnam_link_name cz_servers.fndnam_link_name%TYPE;

2320: l_instance_name cz_servers.instance_name%TYPE;
2321: l_fndnam cz_servers.fndnam%TYPE;
2322: l_global_identity cz_servers.global_identity%TYPE;
2323: l_notes cz_servers.notes%TYPE;
2324: l_fndnam_link_name cz_servers.fndnam_link_name%TYPE;
2325: l_import_enabled cz_servers.import_enabled%TYPE;
2326: matching_local_name cz_servers.local_name%TYPE;
2327:
2328: BEGIN

Line 2325: l_import_enabled cz_servers.import_enabled%TYPE;

2321: l_fndnam cz_servers.fndnam%TYPE;
2322: l_global_identity cz_servers.global_identity%TYPE;
2323: l_notes cz_servers.notes%TYPE;
2324: l_fndnam_link_name cz_servers.fndnam_link_name%TYPE;
2325: l_import_enabled cz_servers.import_enabled%TYPE;
2326: matching_local_name cz_servers.local_name%TYPE;
2327:
2328: BEGIN
2329:

Line 2326: matching_local_name cz_servers.local_name%TYPE;

2322: l_global_identity cz_servers.global_identity%TYPE;
2323: l_notes cz_servers.notes%TYPE;
2324: l_fndnam_link_name cz_servers.fndnam_link_name%TYPE;
2325: l_import_enabled cz_servers.import_enabled%TYPE;
2326: matching_local_name cz_servers.local_name%TYPE;
2327:
2328: BEGIN
2329:
2330: v_hostname := LTRIM(RTRIM(HOSTNAME)) ;

Line 2347: FROM cz_servers

2343: SELECT SERVER_LOCAL_ID,hostname,db_listener_port,instance_name,
2344: fndnam,global_identity,notes,upper(fndnam_link_name),import_enabled
2345: INTO v_server_id,l_hostname,l_db_listener_port,l_instance_name,
2346: l_fndnam,l_global_identity,l_notes,l_fndnam_link_name,l_import_enabled
2347: FROM cz_servers
2348: WHERE cz_servers.local_name = v_local_name;
2349:
2350: BEGIN
2351: BEGIN

Line 2348: WHERE cz_servers.local_name = v_local_name;

2344: fndnam,global_identity,notes,upper(fndnam_link_name),import_enabled
2345: INTO v_server_id,l_hostname,l_db_listener_port,l_instance_name,
2346: l_fndnam,l_global_identity,l_notes,l_fndnam_link_name,l_import_enabled
2347: FROM cz_servers
2348: WHERE cz_servers.local_name = v_local_name;
2349:
2350: BEGIN
2351: BEGIN
2352: SELECT decode(import_enabled,'Y','1','N','0','0')

Line 2357: FROM cz_servers

2353: INTO v_import_enabled
2354: FROM dual;
2355:
2356: SELECT local_name into matching_local_name
2357: FROM cz_servers
2358: WHERE hostname = v_hostname
2359: AND instance_name = v_instance_name
2360: AND db_listener_port = v_db_listener_port
2361: AND fndnam = v_fndnam

Line 2388: SELECT count(*) INTO v_import_count FROM cz_servers

2384: END IF;
2385:
2386: IF (v_import_enabled = '1') THEN
2387: BEGIN
2388: SELECT count(*) INTO v_import_count FROM cz_servers
2389: WHERE import_enabled = '1'
2390: AND local_name <> v_local_name;
2391: IF (V_IMPORT_count > 0) THEN
2392: -- another server has import enabled, only one is allowed

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 2532: PROCEDURE show_cz_servers_cp(Errbuf OUT NOCOPY VARCHAR2,

2528:
2529: /*>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
2530: <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<*/
2531: ------------------------------------------------------------------------------
2532: PROCEDURE show_cz_servers_cp(Errbuf OUT NOCOPY VARCHAR2,
2533: Retcode OUT NOCOPY NUMBER)
2534: AS
2535:
2536: CURSOR C_GETSERVERS IS

Line 2539: FROM CZ_SERVERS

2535:
2536: CURSOR C_GETSERVERS IS
2537: SELECT LOCAL_NAME, HOSTNAME, DB_LISTENER_PORT, INSTANCE_NAME,
2538: SERVER_DB_VERSION, FNDNAM, GLOBAL_IDENTITY, NOTES,FNDNAM_LINK_NAME, Decode(IMPORT_ENABLED, '1', 'Y', '0','N',IMPORT_ENABLED)
2539: FROM CZ_SERVERS
2540: WHERE SERVER_LOCAL_ID >= 0;
2541:
2542: lLocalName CZ_SERVERS.LOCAL_NAME%TYPE;
2543: lHostName CZ_SERVERS.HOSTNAME%TYPE;

Line 2542: lLocalName CZ_SERVERS.LOCAL_NAME%TYPE;

2538: SERVER_DB_VERSION, FNDNAM, GLOBAL_IDENTITY, NOTES,FNDNAM_LINK_NAME, Decode(IMPORT_ENABLED, '1', 'Y', '0','N',IMPORT_ENABLED)
2539: FROM CZ_SERVERS
2540: WHERE SERVER_LOCAL_ID >= 0;
2541:
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;

Line 2543: lHostName CZ_SERVERS.HOSTNAME%TYPE;

2539: FROM CZ_SERVERS
2540: WHERE SERVER_LOCAL_ID >= 0;
2541:
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;

Line 2544: lDbListenerPort CZ_SERVERS.DB_LISTENER_PORT%TYPE;

2540: WHERE SERVER_LOCAL_ID >= 0;
2541:
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;

Line 2545: lInstanceName CZ_SERVERS.INSTANCE_NAME%TYPE;

2541:
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;

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 2547: lFndNam CZ_SERVERS.FNDNAM%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;
2551: lImportEnabled CZ_SERVERS.IMPORT_ENABLED%TYPE;

Line 2548: lGlobalIdentity CZ_SERVERS.GLOBAL_IDENTITY%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;
2551: lImportEnabled CZ_SERVERS.IMPORT_ENABLED%TYPE;
2552:

Line 2549: lNotes CZ_SERVERS.NOTES%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;
2551: lImportEnabled CZ_SERVERS.IMPORT_ENABLED%TYPE;
2552:
2553: v_errorString VARCHAR2(1024) :='SHOW_SERVERS_CP: ';

Line 2550: lFndNamLinkName CZ_SERVERS.FNDNAM_LINK_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;
2551: lImportEnabled CZ_SERVERS.IMPORT_ENABLED%TYPE;
2552:
2553: v_errorString VARCHAR2(1024) :='SHOW_SERVERS_CP: ';
2554:

Line 2551: lImportEnabled CZ_SERVERS.IMPORT_ENABLED%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;
2551: lImportEnabled CZ_SERVERS.IMPORT_ENABLED%TYPE;
2552:
2553: v_errorString VARCHAR2(1024) :='SHOW_SERVERS_CP: ';
2554:
2555: BEGIN

Line 2586: END show_cz_servers_cp;

2582: WHEN OTHERS THEN
2583: Errbuf:= cz_utils.get_text('CZ_SHOW_SERVERS_ERR','SQLERRM',Sqlerrm);
2584: log_report(v_errorString || errbuf);
2585: retcode := 2;
2586: END show_cz_servers_cp;
2587:
2588: ------------------------------------------------------------------------------
2589: FUNCTION create_remote_hgrid_view(p_server_id IN NUMBER, p_fndnam_link_name IN VARCHAR2)
2590: RETURN VARCHAR2 IS

Line 2614: v_hostname cz_servers.hostname%TYPE;

2610: LOCAL_NAME IN VARCHAR2,
2611: PASSWORD IN VARCHAR2)
2612: AS
2613:
2614: v_hostname cz_servers.hostname%TYPE;
2615: v_instance_name cz_servers.instance_name%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;

Line 2615: v_instance_name cz_servers.instance_name%TYPE;

2611: PASSWORD IN VARCHAR2)
2612: AS
2613:
2614: v_hostname cz_servers.hostname%TYPE;
2615: v_instance_name cz_servers.instance_name%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;

Line 2616: v_db_listener_port cz_servers.db_listener_port%TYPE;

2612: AS
2613:
2614: v_hostname cz_servers.hostname%TYPE;
2615: v_instance_name cz_servers.instance_name%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;

Line 2617: v_fndnam cz_servers.fndnam%TYPE;

2613:
2614: v_hostname cz_servers.hostname%TYPE;
2615: v_instance_name cz_servers.instance_name%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;

Line 2618: v_fndnam_link_name cz_servers.fndnam_link_name%TYPE;

2614: v_hostname cz_servers.hostname%TYPE;
2615: v_instance_name cz_servers.instance_name%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;

Line 2619: v_local_name cz_servers.local_name%TYPE;

2615: v_instance_name cz_servers.instance_name%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;

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 2621: v_import_enabled cz_servers.import_enabled%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;
2625: v_dummy 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 2654: FROM cz_servers

2650: v_fndnam,
2651: v_fndnam_link_name,
2652: v_import_enabled,
2653: v_server_id
2654: FROM cz_servers
2655: WHERE cz_servers.local_name = v_local_name;
2656:
2657: IF v_fndnam_link_name IS NOT NULL THEN
2658: BEGIN

Line 2655: WHERE cz_servers.local_name = v_local_name;

2651: v_fndnam_link_name,
2652: v_import_enabled,
2653: v_server_id
2654: FROM cz_servers
2655: WHERE cz_servers.local_name = v_local_name;
2656:
2657: IF v_fndnam_link_name IS NOT NULL THEN
2658: BEGIN
2659:

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

Line 2738: WHERE cz_servers.local_name = v_local_name ;

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
2741: WHEN OTHERS THEN
2742: errbuf := cz_utils.get_text('CZ_DB_VERSION_UPDATE_FAILURE', 'SQLERRM', Sqlerrm);

Line 3059: 'CZ_ORAAPPS_INTEGRATE.SHOW_CZ_SERVERS_CP',

3055: register_spx_process('View Servers',
3056: 'CZSHOWSERVERS',
3057: application_name,
3058: 'Show Remote Servers',
3059: 'CZ_ORAAPPS_INTEGRATE.SHOW_CZ_SERVERS_CP',
3060: request_group,
3061: cz_schema);
3062: EXCEPTION
3063: WHEN OTHERS THEN

Line 3087: v_db_link cz_servers.fndnam_link_name%TYPE;

3083: lCopy_Child_Models PLS_INTEGER;
3084:
3085: v_link_status VARCHAR2(1);
3086: v_code VARCHAR2(1);
3087: v_db_link cz_servers.fndnam_link_name%TYPE;
3088: v_local_name cz_servers.local_name%TYPE;
3089: v_import_enabled cz_servers.import_enabled%TYPE;
3090: v_ret BOOLEAN := false;
3091:

Line 3088: v_local_name cz_servers.local_name%TYPE;

3084:
3085: v_link_status VARCHAR2(1);
3086: v_code VARCHAR2(1);
3087: v_db_link cz_servers.fndnam_link_name%TYPE;
3088: v_local_name cz_servers.local_name%TYPE;
3089: v_import_enabled cz_servers.import_enabled%TYPE;
3090: v_ret BOOLEAN := false;
3091:
3092: BEGIN

Line 3089: v_import_enabled cz_servers.import_enabled%TYPE;

3085: v_link_status VARCHAR2(1);
3086: v_code VARCHAR2(1);
3087: v_db_link cz_servers.fndnam_link_name%TYPE;
3088: v_local_name cz_servers.local_name%TYPE;
3089: v_import_enabled cz_servers.import_enabled%TYPE;
3090: v_ret BOOLEAN := false;
3091:
3092: BEGIN
3093: retcode:=0;

Line 3114: INTO v_local_name,v_db_link,v_import_enabled FROM CZ_SERVERS

3110: END;
3111:
3112: BEGIN
3113: SELECT local_name,fndnam_link_name,import_enabled
3114: INTO v_local_name,v_db_link,v_import_enabled FROM CZ_SERVERS
3115: WHERE import_enabled='1';
3116: EXCEPTION
3117: WHEN TOO_MANY_ROWS THEN
3118: RAISE CZ_ADMIN.IMP_TOO_MANY_SERVERS;

Line 3214: v_db_link cz_servers.fndnam_link_name%TYPE;

3210: retcode OUT NOCOPY NUMBER ) IS
3211: v_link_status VARCHAR2(1);
3212: v_code VARCHAR2(1);
3213: v_ret BOOLEAN:=FALSE;
3214: v_db_link cz_servers.fndnam_link_name%TYPE;
3215: v_local_name cz_servers.local_name%TYPE;
3216: v_import_enabled cz_servers.import_enabled%TYPE;
3217: BEGIN
3218: BEGIN

Line 3215: v_local_name cz_servers.local_name%TYPE;

3211: v_link_status VARCHAR2(1);
3212: v_code VARCHAR2(1);
3213: v_ret BOOLEAN:=FALSE;
3214: v_db_link cz_servers.fndnam_link_name%TYPE;
3215: v_local_name cz_servers.local_name%TYPE;
3216: v_import_enabled cz_servers.import_enabled%TYPE;
3217: BEGIN
3218: BEGIN
3219: SELECT local_name,fndnam_link_name,import_enabled

Line 3216: v_import_enabled cz_servers.import_enabled%TYPE;

3212: v_code VARCHAR2(1);
3213: v_ret BOOLEAN:=FALSE;
3214: v_db_link cz_servers.fndnam_link_name%TYPE;
3215: v_local_name cz_servers.local_name%TYPE;
3216: v_import_enabled cz_servers.import_enabled%TYPE;
3217: BEGIN
3218: BEGIN
3219: SELECT local_name,fndnam_link_name,import_enabled
3220: INTO v_local_name,v_db_link,v_import_enabled FROM CZ_SERVERS

Line 3220: INTO v_local_name,v_db_link,v_import_enabled FROM CZ_SERVERS

3216: v_import_enabled cz_servers.import_enabled%TYPE;
3217: BEGIN
3218: BEGIN
3219: SELECT local_name,fndnam_link_name,import_enabled
3220: INTO v_local_name,v_db_link,v_import_enabled FROM CZ_SERVERS
3221: WHERE import_enabled='1';
3222: EXCEPTION
3223: WHEN TOO_MANY_ROWS THEN
3224: RAISE CZ_ADMIN.IMP_TOO_MANY_SERVERS;

Line 3286: v_db_link cz_servers.fndnam_link_name%TYPE;

3282: COPY_CHILD_MODELS IN VARCHAR2 DEFAULT '0') IS
3283: v_link_status VARCHAR2(1);
3284: v_code VARCHAR2(1);
3285: v_ret BOOLEAN:=FALSE;
3286: v_db_link cz_servers.fndnam_link_name%TYPE;
3287: v_local_name cz_servers.local_name%TYPE;
3288: v_import_enabled cz_servers.import_enabled%TYPE;
3289: BEGIN
3290: BEGIN

Line 3287: v_local_name cz_servers.local_name%TYPE;

3283: v_link_status VARCHAR2(1);
3284: v_code VARCHAR2(1);
3285: v_ret BOOLEAN:=FALSE;
3286: v_db_link cz_servers.fndnam_link_name%TYPE;
3287: v_local_name cz_servers.local_name%TYPE;
3288: v_import_enabled cz_servers.import_enabled%TYPE;
3289: BEGIN
3290: BEGIN
3291: SELECT local_name,fndnam_link_name,import_enabled

Line 3288: v_import_enabled cz_servers.import_enabled%TYPE;

3284: v_code VARCHAR2(1);
3285: v_ret BOOLEAN:=FALSE;
3286: v_db_link cz_servers.fndnam_link_name%TYPE;
3287: v_local_name cz_servers.local_name%TYPE;
3288: v_import_enabled cz_servers.import_enabled%TYPE;
3289: BEGIN
3290: BEGIN
3291: SELECT local_name,fndnam_link_name,import_enabled
3292: INTO v_local_name,v_db_link,v_import_enabled FROM CZ_SERVERS

Line 3292: INTO v_local_name,v_db_link,v_import_enabled FROM CZ_SERVERS

3288: v_import_enabled cz_servers.import_enabled%TYPE;
3289: BEGIN
3290: BEGIN
3291: SELECT local_name,fndnam_link_name,import_enabled
3292: INTO v_local_name,v_db_link,v_import_enabled FROM CZ_SERVERS
3293: WHERE import_enabled='1';
3294: EXCEPTION
3295: WHEN TOO_MANY_ROWS THEN
3296: RAISE CZ_ADMIN.IMP_TOO_MANY_SERVERS;

Line 3364: v_db_link cz_servers.fndnam_link_name%TYPE;

3360: COPY_CHILD_MODELS IN VARCHAR2 DEFAULT '0') IS
3361: v_link_status VARCHAR2(1);
3362: v_code VARCHAR2(1);
3363: v_ret BOOLEAN:=FALSE;
3364: v_db_link cz_servers.fndnam_link_name%TYPE;
3365: v_local_name cz_servers.local_name%TYPE;
3366: v_import_enabled cz_servers.import_enabled%TYPE;
3367: BEGIN
3368: BEGIN

Line 3365: v_local_name cz_servers.local_name%TYPE;

3361: v_link_status VARCHAR2(1);
3362: v_code VARCHAR2(1);
3363: v_ret BOOLEAN:=FALSE;
3364: v_db_link cz_servers.fndnam_link_name%TYPE;
3365: v_local_name cz_servers.local_name%TYPE;
3366: v_import_enabled cz_servers.import_enabled%TYPE;
3367: BEGIN
3368: BEGIN
3369: SELECT local_name,fndnam_link_name,import_enabled

Line 3366: v_import_enabled cz_servers.import_enabled%TYPE;

3362: v_code VARCHAR2(1);
3363: v_ret BOOLEAN:=FALSE;
3364: v_db_link cz_servers.fndnam_link_name%TYPE;
3365: v_local_name cz_servers.local_name%TYPE;
3366: v_import_enabled cz_servers.import_enabled%TYPE;
3367: BEGIN
3368: BEGIN
3369: SELECT local_name,fndnam_link_name,import_enabled
3370: INTO v_local_name,v_db_link,v_import_enabled FROM CZ_SERVERS

Line 3370: INTO v_local_name,v_db_link,v_import_enabled FROM CZ_SERVERS

3366: v_import_enabled cz_servers.import_enabled%TYPE;
3367: BEGIN
3368: BEGIN
3369: SELECT local_name,fndnam_link_name,import_enabled
3370: INTO v_local_name,v_db_link,v_import_enabled FROM CZ_SERVERS
3371: WHERE import_enabled='1';
3372: EXCEPTION
3373: WHEN TOO_MANY_ROWS THEN
3374: RAISE CZ_ADMIN.IMP_TOO_MANY_SERVERS;

Line 3477: v_TARGET_INSTANCE CZ_SERVERS.INSTANCE_NAME%TYPE;

3473: PROCEDURE sync_all_models_cp
3474: (errbuf OUT NOCOPY VARCHAR2,
3475: retcode OUT NOCOPY NUMBER) IS
3476: v_ret BOOLEAN;
3477: v_TARGET_INSTANCE CZ_SERVERS.INSTANCE_NAME%TYPE;
3478: BEGIN
3479: SELECT LOCAL_NAME
3480: INTO v_TARGET_INSTANCE
3481: FROM CZ_SERVERS

Line 3481: FROM CZ_SERVERS

3477: v_TARGET_INSTANCE CZ_SERVERS.INSTANCE_NAME%TYPE;
3478: BEGIN
3479: SELECT LOCAL_NAME
3480: INTO v_TARGET_INSTANCE
3481: FROM CZ_SERVERS
3482: WHERE import_enabled='1';
3483:
3484: EXECUTE IMMEDIATE
3485: 'BEGIN CZ_BOM_SYNCH.synchronize_all_models_cp(CZ_ORAAPPS_INTEGRATE.mERRBUF,CZ_ORAAPPS_INTEGRATE.mRETCODE,'||