APPS.ICX_SEC dependencies on FND_NODES

Line 553: select node_id into l_node_id from fnd_nodes

549:
550: -- Bug 3361985
551: -- where lower(node_name) = l_server_host;
552:
553: select node_id into l_node_id from fnd_nodes
554: where lower(webhost) = l_server_host;
555:
556: else if l_server_host is NULL
557: then

Line 559: select node_id into l_node_id from fnd_nodes

555:
556: else if l_server_host is NULL
557: then
558:
559: select node_id into l_node_id from fnd_nodes
560: where lower(node_name) = l_server_host;
561:
562: else
563:

Line 564: select node_id into l_node_id from fnd_nodes

560: where lower(node_name) = l_server_host;
561:
562: else
563:
564: select node_id into l_node_id from fnd_nodes
565: where server_id = l_server_id;
566: end if;
567: end if;
568:

Line 796: select server_id into l_server_id from fnd_nodes

792:
793: begin
794:
795: begin
796: select server_id into l_server_id from fnd_nodes
797: where server_id = p_server_id;
798: EXCEPTION
799: WHEN no_data_found THEN
800: l_server_id := '-1';

Line 918: select node_id into l_node_id from fnd_nodes

914:
915: -- Bug 3361985
916: -- where lower(node_name) = (l_server_host);
917:
918: select node_id into l_node_id from fnd_nodes
919: where lower(webhost) = l_server_host;
920:
921: else if l_server_host is NULL
922: then

Line 924: select node_id into l_node_id from fnd_nodes

920:
921: else if l_server_host is NULL
922: then
923:
924: select node_id into l_node_id from fnd_nodes
925: where lower(node_name) = (l_server_host);
926:
927:
928: else

Line 930: select node_id into l_node_id from fnd_nodes

926:
927:
928: else
929:
930: select node_id into l_node_id from fnd_nodes
931: where server_id = l_server_id;
932: end if;
933: end if;
934: