APPS.XDP_ADAPTER_CORE_DB dependencies on XDP_FE_GENERIC_CONFIG

Line 1204: from XDP_FE_SW_GEN_LOOKUP XSW, XDP_FE_GENERIC_CONFIG XGC

1200: p_GenCountActive OUT NOCOPY NUMBER, p_GenCountFuture OUT NOCOPY NUMBER)
1201: is
1202: cursor c_get_valid_generics (c_fe_id NUMBER, c_AdapterType VARCHAR2) is
1203: select XGC.START_DATE
1204: from XDP_FE_SW_GEN_LOOKUP XSW, XDP_FE_GENERIC_CONFIG XGC
1205: where XGC.FE_ID = c_fe_id and
1206: XSW.ADAPTER_TYPE = c_AdapterType and
1207: XSW.FE_SW_GEN_LOOKUP_ID = XGC.FE_SW_GEN_LOOKUP_ID and
1208: ((XGC.END_DATE is null) or ((XGC.END_DATE is not null) and (XGC.END_DATE > SYSDATE)));

Line 1660: FROM XDP_FE_GENERIC_CONFIG

1656: start_date,
1657: end_date,
1658: sw_start_proc,
1659: sw_exit_proc
1660: FROM XDP_FE_GENERIC_CONFIG
1661: WHERE fe_id = l_fe_id;
1662: CURSOR c_fe_attribute_val(l_fe_config_id number) IS
1663: SELECT
1664: fe_generic_config_id,

Line 1701: select xdp_fe_generic_config_s.nextval into l_new_generic_config_Id from dual;

1697: );
1698: END LOOP;
1699:
1700: FOR l_fe_gen_config in c_fe_generic_config(p_FeID) LOOP
1701: select xdp_fe_generic_config_s.nextval into l_new_generic_config_Id from dual;
1702:
1703: insert into xdp_fe_generic_config (
1704: fe_generic_config_id,
1705: fe_id,

Line 1703: insert into xdp_fe_generic_config (

1699:
1700: FOR l_fe_gen_config in c_fe_generic_config(p_FeID) LOOP
1701: select xdp_fe_generic_config_s.nextval into l_new_generic_config_Id from dual;
1702:
1703: insert into xdp_fe_generic_config (
1704: fe_generic_config_id,
1705: fe_id,
1706: fe_sw_gen_lookup_id,
1707: start_date,