APPS.FND_APP_SYSTEM dependencies on FND_NODES

Line 1364: from fnd_nodes

1360: -- Copied from AFCPUTLB.pls - 115.56
1361:
1362: select count(*)
1363: into kount
1364: from fnd_nodes
1365: where upper(node_name) = upper(name);
1366:
1367: if (kount = 0) then
1368: execute immediate

Line 1369: 'insert into fnd_nodes ' ||

1365: where upper(node_name) = upper(name);
1366:
1367: if (kount = 0) then
1368: execute immediate
1369: 'insert into fnd_nodes ' ||
1370: ' (node_id, node_name,' ||
1371: ' support_forms, support_cp, support_web, support_admin,' || ' platform_code, created_by, creation_date,' ||
1372: ' last_updated_by, last_update_date, last_update_login,' ||
1373: ' node_mode, server_id, server_address, description)' ||

Line 1375: ' fnd_nodes_s.nextval, :v1,' ||

1371: ' support_forms, support_cp, support_web, support_admin,' || ' platform_code, created_by, creation_date,' ||
1372: ' last_updated_by, last_update_date, last_update_login,' ||
1373: ' node_mode, server_id, server_address, description)' ||
1374: ' select ' ||
1375: ' fnd_nodes_s.nextval, :v1,' ||
1376: ' :v2, :v3, :v4, :v5, :v6, 1, SYSDATE, 1, SYSDATE, 0,' ||
1377: ' ''O'', :v7, :v8, :v9 ' ||
1378: ' from dual '
1379: using name, forms_tier, cp_tier, web_tier, admin_tier,

Line 1382: update fnd_nodes

1378: ' from dual '
1379: using name, forms_tier, cp_tier, web_tier, admin_tier,
1380: platform_id, p_server_id, p_address, p_description;
1381: else
1382: update fnd_nodes
1383: set description = p_description,
1384: support_forms = decode(forms_tier, 'Y', 'Y', support_forms),
1385: support_cp = decode(cp_tier, 'Y', 'Y', support_cp),
1386: support_web = decode(web_tier, 'Y', 'Y', support_web),

Line 1393: execute immediate 'update fnd_nodes ' ||

1389: last_update_date = SYSDATE, last_updated_by = 1
1390: where upper(node_name) = upper(name);
1391:
1392: if (p_server_id is not null) then
1393: execute immediate 'update fnd_nodes ' ||
1394: ' set server_id = :v1' ||
1395: ' where upper(node_name) = upper(:v2) '
1396: using p_server_id, name;
1397: end if;

Line 1400: execute immediate 'update fnd_nodes ' ||

1396: using p_server_id, name;
1397: end if;
1398:
1399: if (p_address is not null) then
1400: execute immediate 'update fnd_nodes ' ||
1401: ' set server_address = :v1' ||
1402: ' where upper(node_name) = upper(:v2)'
1403: using p_address,name;
1404: end if;