[Home] [Help]
1523: last_updated_by, last_update_date, last_update_login,
1524: node_mode, server_id, server_address, description,
1525: host, domain,support_db, virtual_ip)
1526: select
1527: fnd_nodes_s.nextval, name,
1528: forms_tier, cp_tier, web_tier, admin_tier,
1529: platform_id, 1, SYSDATE,
1530: 1, SYSDATE, 0,
1531: 'O', p_server_id, p_address, p_description,
1539: * Apps system, but for different tiers. Essentially,
1540: * we're performing an 'OR' of the flags in the table
1541: * and those passed into the procedure.
1542: */
1543: update fnd_nodes set
1544: description = p_description,
1545: support_forms = decode(forms_tier, 'Y', 'Y', support_forms),
1546: support_cp = decode(cp_tier, 'Y', 'Y', support_cp),
1547: support_web = decode(web_tier, 'Y', 'Y', support_web),
1552: domain = p_domain,
1553: support_db = decode(db_tier,'Y','Y',support_db)
1554: where upper(node_name) = upper(name);
1555:
1556: -- If server_id is not null, update fnd_nodes.server_id.
1557: -- fnd_nodes.server_id can only be null if the application server node has been
1558: -- removed.
1559: if (p_server_id is not null) then
1560: update fnd_nodes
1553: support_db = decode(db_tier,'Y','Y',support_db)
1554: where upper(node_name) = upper(name);
1555:
1556: -- If server_id is not null, update fnd_nodes.server_id.
1557: -- fnd_nodes.server_id can only be null if the application server node has been
1558: -- removed.
1559: if (p_server_id is not null) then
1560: update fnd_nodes
1561: set server_id = p_server_id
1561: set server_id = p_server_id
1562: where upper(node_name) = upper(name);
1563: end if;
1564:
1565: -- If server_address is not null, update fnd_nodes.server_address.
1566: if (p_address is not null) then
1567: update fnd_nodes
1568: set server_address = p_address
1569: where upper(node_name) = upper(name);