APPS.FND_CONCURRENT dependencies on FND_NODES

Line 1515: from fnd_nodes

1511: * Create node. If it already exists,then we'll Update instead
1512: */
1513: select count(*)
1514: into kount
1515: from fnd_nodes
1516: where upper(node_name) = upper(name);
1517:
1518: if (kount = 0) then
1519: insert into fnd_nodes

Line 1519: insert into fnd_nodes

1515: from fnd_nodes
1516: where upper(node_name) = upper(name);
1517:
1518: if (kount = 0) then
1519: insert into fnd_nodes
1520: (node_id, node_name,
1521: support_forms, support_cp, support_web, support_admin,
1522: platform_code, created_by, creation_date,
1523: last_updated_by, last_update_date, last_update_login,

Line 1527: fnd_nodes_s.nextval, name,

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,

Line 1543: update fnd_nodes set

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),

Line 1556: -- If server_id is not null, update fnd_nodes.server_id.

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

Line 1557: -- fnd_nodes.server_id can only be null if the application server node has been

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

Line 1560: update fnd_nodes

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
1562: where upper(node_name) = upper(name);
1563: end if;
1564:

Line 1565: -- If server_address is not null, update fnd_nodes.server_address.

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);

Line 1567: update fnd_nodes

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);
1570: end if;
1571:

Line 1574: update fnd_nodes

1570: end if;
1571:
1572: -- if p_virtual_ip is not null update the fnd_node.virtual_ip
1573: if (p_virtual_ip is not null) then
1574: update fnd_nodes
1575: set virtual_ip = p_virtual_ip
1576: where upper(node_name) = upper(name);
1577: end if;
1578: end if;