[Home] [Help]
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
334: and xag.adapter_type = xat.adapter_type;
573:
574: CURSOR c_GetASyncAdapterStatus IS
575: SELECT a.adapter_status
576: FROM xdp_adapter_reg a,
577: xdp_adapter_types_b b
578: WHERE a.adapter_type = b.adapter_type AND
579: a.fe_id = p_fe_id AND
580: (b.application_mode = 'QUEUE' OR
581: (b.application_mode = 'NONE' AND b.inbound_required_flag = 'Y'));
582:
583: CURSOR c_GetSyncAdapterStatus IS
584: SELECT a.adapter_status
585: FROM xdp_adapter_reg a,
586: xdp_adapter_types_b b
587: WHERE a.adapter_type = b.adapter_type AND
588: a.fe_id = p_fe_id AND
589: NOT(b.application_mode = 'QUEUE' OR
590: (b.application_mode = 'NONE' AND b.inbound_required_flag = 'Y'));
649: IF p_mode = 'ASYNC' THEN
650:
651: SELECT count(*)
652: INTO l_adapter_status_cnt
653: FROM xdp_adapter_reg a, xdp_adapter_types_b b
654: WHERE a.adapter_type = b.adapter_type
655: AND a.fe_id = p_fe_id
656: AND (b.application_mode = 'QUEUE' OR
657: (b.application_mode = 'NONE' AND b.inbound_required_flag = 'Y'))
660: ELSE
661:
662: SELECT count(*)
663: INTO l_adapter_status_cnt
664: FROM xdp_adapter_reg a, xdp_adapter_types_b b
665: WHERE a.adapter_type = b.adapter_type
666: AND a.fe_id = p_fe_id
667: AND NOT(b.application_mode = 'QUEUE' OR
668: (b.application_mode = 'NONE' AND b.inbound_required_flag = 'Y'))
694: else
695:
696: SELECT COUNT(DISTINCT xaj.job_id) num_of_jobs
697: INTO l_num_of_job_cnt
698: FROM xdp_adapter_job_queue xaj, xdp_adapter_reg xar, xdp_adapter_types_b xat
699: WHERE xaj.fe_id = xar.fe_id
700: AND xar.adapter_type = xat.adapter_type
701: AND xaj.fe_id = p_fe_id
702: AND xat.application_mode <> 'QUEUE';
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'
1277: l_adapter_name varchar2(80) := NULL;
1278:
1279: cursor c_getadapter(FEID number) is
1280: SELECT xad.adapter_name
1281: FROM xdp_adapter_reg xad, xdp_adapter_types_b t
1282: WHERE xad.adapter_type = t.adapter_type
1283: AND FE_ID = FEID
1284: AND application_mode='QUEUE'
1285: AND xad.adapter_status not in (XDP_ADAPTER.pv_statusNotAvailable)
1396: is
1397: l_ClassName varchar2(240);
1398: begin
1399: select b.adapter_class into l_ClassName
1400: from xdp_adapter_reg a, xdp_adapter_types_b b
1401: where a.CHANNEL_NAME = p_ChannelName and
1402: a.adapter_type = b.adapter_type;
1403:
1404: if (upper(l_ClassName) = 'NONE') then
1530: Function checkLockRequired( p_Channelname in varchar2) return boolean IS
1531:
1532: cursor getApplMode IS
1533: SELECT atb.application_mode
1534: FROM xdp_adapter_reg ar, xdp_adapter_types_b atb
1535: WHERE ar.channel_name = p_Channelname
1536: AND ar.adapter_type = atb.adapter_type;
1537:
1538: lv_appl_mode VARCHAR2(40);
1571: select FE_ATTRIBUTE_NAME from xdp_fe_attribute_def_vl
1572: where fe_sw_gen_lookup_id = p_fe_sw_gen_lookup_id);
1573:
1574: cursor c_adapter_types is
1575: SELECT BASE_ADAPTER_TYPE FROM XDP_ADAPTER_TYPES_B
1576: WHERE ADAPTER_TYPE = p_adapter_type;
1577:
1578: l_rowid ROWID;
1579: l_base_type XDP_ADAPTER_TYPES_B.ADAPTER_TYPE%TYPE;
1575: SELECT BASE_ADAPTER_TYPE FROM XDP_ADAPTER_TYPES_B
1576: WHERE ADAPTER_TYPE = p_adapter_type;
1577:
1578: l_rowid ROWID;
1579: l_base_type XDP_ADAPTER_TYPES_B.ADAPTER_TYPE%TYPE;
1580: l_fe_attribute_id number;
1581: BEGIN
1582: x_retcode := 0;
1583: SavePoint CopyFETATTR;