APPS.CZ_MODELOPERATIONS_PUB dependencies on CZ_SERVERS

Line 682: l_db_link CZ_SERVERS.fndnam_link_name%TYPE;

678: x_status OUT NOCOPY NUMBER) IS -- sselahi: removed x_run_info_id
679: l_api_name CONSTANT VARCHAR2(30) := 'import_single_bill';
680: l_api_version CONSTANT NUMBER := 1.0;
681: l_error BOOLEAN := FALSE;
682: l_db_link CZ_SERVERS.fndnam_link_name%TYPE;
683: --10011026
684: l_local_name CZ_SERVERS.local_name%TYPE;
685: l_Exist VARCHAR2(1):= 'N';
686: l_err VARCHAR2(1);

Line 684: l_local_name CZ_SERVERS.local_name%TYPE;

680: l_api_version CONSTANT NUMBER := 1.0;
681: l_error BOOLEAN := FALSE;
682: l_db_link CZ_SERVERS.fndnam_link_name%TYPE;
683: --10011026
684: l_local_name CZ_SERVERS.local_name%TYPE;
685: l_Exist VARCHAR2(1):= 'N';
686: l_err VARCHAR2(1);
687: l_errbuf VARCHAR2(2000);
688: l_retcode NUMBER;

Line 713: FROM cz_servers

709:
710: BEGIN
711: SELECT fndnam_link_name,local_name --10011026
712: INTO l_db_link, l_local_name
713: FROM cz_servers
714: WHERE import_enabled = '1';
715: EXCEPTION
716: WHEN TOO_MANY_ROWS THEN
717: RAISE TOO_MANY_IMP_SERVERS;

Line 852: l_db_link CZ_SERVERS.fndnam_link_name%TYPE;

848: l_api_name CONSTANT VARCHAR2(30) := 'refresh_single_model';
849: l_api_version CONSTANT NUMBER := 1.0;
850: l_errbuf VARCHAR2(2000);
851: l_found NUMBER;
852: l_db_link CZ_SERVERS.fndnam_link_name%TYPE;
853: l_Exist VARCHAR2(1):= 'N';
854: l_err VARCHAR2(1);
855: l_user_id NUMBER;
856: TOO_MANY_IMP_SERVERS EXCEPTION;

Line 901: FROM cz_servers

897: -- check the imp server
898: BEGIN
899: SELECT fndnam_link_name
900: INTO l_db_link
901: FROM cz_servers
902: WHERE import_enabled = '1';
903: EXCEPTION
904: WHEN TOO_MANY_ROWS THEN
905: RAISE TOO_MANY_IMP_SERVERS;