APPS.XDP_ADAPTER_CORE_DB dependencies on XDP_FES

Line 329: from xdp_fes xfe,

325: xag.cmd_line_args sub_cmd_args,
326: xag.log_level,
327: xag.log_file_name,
328: xag.service_instance_id
329: from xdp_fes xfe,
330: xdp_adapter_types_b xat,
331: xdp_adapter_reg xag
332: where xag.channel_name = p_ChannelName
333: and xag.fe_id = xfe.fe_id

Line 979: from xdp_fes

975: Function Get_Fe_Id_For_name (p_FeName in varchar2) return number
976: is
977: cursor c_GetFEiD is
978: select fe_id
979: from xdp_fes
980: where UPPER(fulfillment_element_name) = UPPER(p_FeName);
981:
982: l_FEId number := -1;
983:

Line 1021: from XDP_FES

1017: XDP_ADAPTER.pv_statusDeactivatedSystem);
1018:
1019: select MAX_CONNECTION
1020: into l_MaxCount
1021: from XDP_FES
1022: where FE_ID = p_fe_id;
1023:
1024: if l_CurrentCount < l_maxCount then
1025: return TRUE;

Line 1237: FROM xdp_adapter_reg xad, xdp_adapter_types_b t,xdp_fes XFE

1233: --
1234:
1235: cursor c_getadapter IS
1236: SELECT xad.adapter_name
1237: FROM xdp_adapter_reg xad, xdp_adapter_types_b t,xdp_fes XFE
1238: WHERE XAD.fe_id = XFE.fe_id
1239: AND XFE.fulfillment_element_name = p_fe_name
1240: AND xad.adapter_type = t.adapter_type
1241: AND application_mode='QUEUE'

Line 1369: from XDP_ADAPTER_REG arn, XDP_FES fet

1365: select 'Y' yahoo
1366: from dual
1367: where exists(
1368: select 1
1369: from XDP_ADAPTER_REG arn, XDP_FES fet
1370: where arn.fe_id = fet.fe_id
1371: and fet.fetype_id = p_fetype_id
1372: and arn.adapter_status not in (XDP_ADAPTER.pv_statusStopped,
1373: XDP_ADAPTER.pv_statusStoppedError,

Line 1650: from xdp_fes_vl

1646: geo_area_id,
1647: role_name,
1648: network_unit_id,
1649: description
1650: from xdp_fes_vl
1651: where fe_id = p_FeID;
1652: CURSOR c_fe_generic_config(l_fe_id number) IS
1653: SELECT
1654: fe_generic_config_id,

Line 1674: select XDP.xdp_fes_s.nextval into l_new_feId from dual;

1670: WHERE fe_generic_config_id = l_fe_config_id;
1671: BEGIN
1672: x_retcode := 0;
1673: SavePoint CopyFE;
1674: select XDP.xdp_fes_s.nextval into l_new_feId from dual;
1675:
1676: for l_FeRecord in aFe loop
1677: XDP_FES_PKG.INSERT_ROW(
1678: l_rowid,

Line 1677: XDP_FES_PKG.INSERT_ROW(

1673: SavePoint CopyFE;
1674: select XDP.xdp_fes_s.nextval into l_new_feId from dual;
1675:
1676: for l_FeRecord in aFe loop
1677: XDP_FES_PKG.INSERT_ROW(
1678: l_rowid,
1679: l_new_feId,
1680: l_FeRecord.fetype_id,
1681: p_FeName,