DBA Data[Home] [Help]

APPS.FND_OAM_COLLECTION dependencies on FND_OAM_FNDNODES_VL

Line 1088: from FND_OAM_FNDNODES_VL

1084: pragma AUTONOMOUS_TRANSACTION;
1085: cursor nodes_c is
1086: select upper(node_name) node_name, status, support_cp, support_forms,
1087: support_web, support_admin
1088: from FND_OAM_FNDNODES_VL
1089: where node_mode = 'O'
1090: and (nvl(support_cp, 'N') = 'Y' or
1091: nvl(support_forms, 'N') = 'Y' or
1092: nvl(support_web, 'N') = 'Y' or

Line 1162: select upper(node_name) node_name,upper(webhost) webhost from FND_OAM_FNDNODES_VL

1158: --rjaiswal bug#4917109
1159: -- For virtual host we have the entry of main host in this column 'webhost'
1160: -- So this column can be used to compare the gv$instance host_name value
1161: -- instead of comparing it with node_name.Added webhost column
1162: select upper(node_name) node_name,upper(webhost) webhost from FND_OAM_FNDNODES_VL
1163: where node_mode = 'O'
1164: and (nvl(support_cp, 'N') = 'Y' or
1165: nvl(support_forms, 'N') = 'Y' or
1166: nvl(support_web, 'N') = 'Y' or

Line 1222: -- no match found in FND_OAM_FNDNODES_VL, so we will create

1218: end;
1219: end loop;
1220:
1221: if (v_db_node_registered = false) then
1222: -- no match found in FND_OAM_FNDNODES_VL, so we will create
1223: -- a new entry for this host (if one does not
1224: -- already exist) with status as unknown for now.
1225: -- This is temporary bug fix for 2952829.
1226: declare