DBA Data[Home] [Help]

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: l_Exist VARCHAR2(1):= 'N';
684: l_err VARCHAR2(1);
685: l_errbuf VARCHAR2(2000);
686: l_retcode NUMBER;

Line 711: FROM cz_servers

707:
708: BEGIN
709: SELECT fndnam_link_name
710: INTO l_db_link
711: FROM cz_servers
712: WHERE import_enabled = '1';
713: EXCEPTION
714: WHEN TOO_MANY_ROWS THEN
715: RAISE TOO_MANY_IMP_SERVERS;

Line 848: l_db_link CZ_SERVERS.fndnam_link_name%TYPE;

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

Line 897: FROM cz_servers

893: -- check the imp server
894: BEGIN
895: SELECT fndnam_link_name
896: INTO l_db_link
897: FROM cz_servers
898: WHERE import_enabled = '1';
899: EXCEPTION
900: WHEN TOO_MANY_ROWS THEN
901: RAISE TOO_MANY_IMP_SERVERS;