[Home] [Help]
115: p_JobID OUT NOCOPY number)
116: is
117:
118: begin
119: select XDP_ADAPTER_ADMIN_REQS_S.NEXTVAL into p_RequestID from dual;
120:
121: XDP_CRON_UTIL.SubmitAdapterAdminJob(p_request => p_RequestID,
122: p_RunDate => SubmitAdapterAdminReq.p_RequestDate,
123: p_RunFreq => SubmitAdapterAdminReq.p_Freq,
853: begin
854:
855: begin
856: select 'Y' into l_check
857: from dual
858: where exists
859: ( select JOB_ID from xdp_adapter_job_queue a, xdp_adapter_reg b
860: where b.channel_name = p_ChannelName
861: and b.fe_id = a.fe_id);
1325: lv_exists varchar2(1) := 'N';
1326:
1327: CURSOR c_IsAdapterRunning is
1328: select 'Y' yahoo
1329: from dual
1330: where exists(
1331: select 1
1332: from XDP_ADAPTER_REG
1333: where fe_id = p_fe_id
1362: lv_exists varchar2(1) := 'N';
1363:
1364: CURSOR c_IsAdapterRunning is
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
1583: SavePoint CopyFETATTR;
1584:
1585: FOR l_at_attr in c_adapter_type_attribute LOOP
1586:
1587: select XDP.XDP_FE_ATTRIBUTE_DEF_S.nextval into l_fe_attribute_id from dual;
1588:
1589: XDP_FE_ATTRIBUTE_DEF_PKG.INSERT_ROW(
1590: l_rowid,
1591: l_fe_attribute_id,
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,
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,