eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.XDP_ADAPTER_CORE_DB dependencies on XDP_ADAPTER_REG

Line 57: insert into xdp_adapter_reg (

53: is
54: begin
55:
56:
57: insert into xdp_adapter_reg (
58: channel_name,
59: fe_id,
60: adapter_status,
61: process_id,

Line 274: from xdp_adapter_reg

270: is
271:
272: cursor c_GetAdapter is
273: select fe_id, process_id, service_instance_id
274: from xdp_adapter_reg
275: where channel_name = p_ChannelName;
276:
277: l_Found varchar2(1) := 'N';
278: begin

Line 331: xdp_adapter_reg xag

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;
335:

Line 477: from xdp_adapter_reg where channel_name = p_ChannelName;

473: l_Status := XDP_ADAPTER.pv_statusDeactivatedSystem;
474:
475: if (p_AdapterDispName is null) then
476: select adapter_display_name into l_AdapterDisplayName
477: from xdp_adapter_reg where channel_name = p_ChannelName;
478: else
479: l_AdapterDisplayName := p_AdapterDispName;
480: end if;
481:

Line 489: update xdp_adapter_reg

485: END IF;
486:
487: -- status_active_time is updated anytime status is updated
488:
489: update xdp_adapter_reg
490: set adapter_status = nvl(l_Status, adapter_status),
491: status_active_time = decode(l_Status,
492: null, status_active_time,
493: sysdate),

Line 559: UPDATE xdp_adapter_reg

555: Procedure Update_Adapter_Active_Time(p_ChannelName IN VARCHAR2)
556: IS
557:
558: BEGIN
559: UPDATE xdp_adapter_reg
560: SET status_active_time = sysdate,
561: last_update_date = sysdate,
562: last_updated_by = fnd_global.user_id,
563: last_update_login = fnd_global.login_id

Line 576: FROM xdp_adapter_reg a,

572:
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

Line 585: FROM xdp_adapter_reg a,

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

Line 653: FROM xdp_adapter_reg a, xdp_adapter_types_b b

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'))

Line 664: FROM xdp_adapter_reg a, xdp_adapter_types_b b

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'))

Line 698: FROM xdp_adapter_job_queue xaj, xdp_adapter_reg xar, xdp_adapter_types_b xat

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';

Line 716: from xdp_adapter_reg xag

712: Function GetCurrentAdapterStatus(p_ChannelName in varchar2) return varchar2
713: is
714: cursor c_GetAdapterStatus is
715: select xag.adapter_status
716: from xdp_adapter_reg xag
717: where channel_name = p_ChannelName;
718:
719: l_CurrentAdapterStatus varchar2(40);
720: l_exists varchar2(1) := 'N';

Line 779: select node into l_InstanceName from xdp_adapter_reg where channel_name = l_ChannelName;

775: ELSE
776: l_ChannelName := p_ChannelName;
777: END IF;
778:
779: select node into l_InstanceName from xdp_adapter_reg where channel_name = l_ChannelName;
780: --Adapter is running on different instance than this session
781: if l_InstanceName is not null and l_InstanceName <> pv_InstanceName then
782: l_LockFlag := ReleaseAdapterLock(p_ChannelName => p_ChannelName);
783: l_LockFlag := 'N';

Line 809: update xdp_adapter_reg set node = pv_InstanceName where channel_name = l_ChannelName;

805: ELSE
806: l_ChannelName := p_ChannelName;
807: END IF;
808:
809: update xdp_adapter_reg set node = pv_InstanceName where channel_name = l_ChannelName;
810: commit;
811: end if;
812:
813: return l_LockFlag;

Line 842: from xdp_adapter_reg

838: l_CODFlag varchar2(1) := 'N';
839: begin
840:
841: select NVL(CONNECT_ON_DEMAND_FLAG, 'N') into l_CODFlag
842: from xdp_adapter_reg
843: where CHANNEL_NAME = p_ChannelName;
844:
845: return (l_CODFlag);
846:

Line 859: ( select JOB_ID from xdp_adapter_job_queue a, xdp_adapter_reg b

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);
862: exception
863: when no_data_found then

Line 1008: from XDP_ADAPTER_REG

1004: l_MaxCount number := 0;
1005: begin
1006: select count(*)
1007: into l_CurrentCount
1008: from XDP_ADAPTER_REG
1009: where FE_ID = p_fe_id and
1010: ADAPTER_STATUS not in (XDP_ADAPTER.pv_statusStopped,
1011: XDP_ADAPTER.pv_statusStoppedError,
1012: XDP_ADAPTER.pv_statusTerminated,

Line 1072: -- Delete the Adapter from the XDP_ADAPTER_REG table

1068: for v_AdapterReq in c_GetAdapterAdminReqs loop
1069: RemoveAdapterAdminReq (p_RequestID => v_AdapterReq.request_id);
1070: END LOOP;
1071:
1072: -- Delete the Adapter from the XDP_ADAPTER_REG table
1073: --
1074: DELETE FROM xdp_adapter_reg WHERE channel_name = p_channel_name;
1075:
1076: END Delete_Adapter;

Line 1074: DELETE FROM xdp_adapter_reg WHERE channel_name = p_channel_name;

1070: END LOOP;
1071:
1072: -- Delete the Adapter from the XDP_ADAPTER_REG table
1073: --
1074: DELETE FROM xdp_adapter_reg WHERE channel_name = p_channel_name;
1075:
1076: END Delete_Adapter;
1077:
1078: --

Line 1086: from xdp_adapter_reg

1082: IS
1083:
1084: cursor c_GetAdapters is
1085: select channel_name
1086: from xdp_adapter_reg
1087: where fe_id = p_fe_id;
1088:
1089: BEGIN
1090: -- Delete all adapters belonging to the FE, if present

Line 1120: xdp_adapter_reg xag

1116: xag.cmd_line_args,
1117: xag.log_level,
1118: xag.log_file_name
1119: from
1120: xdp_adapter_reg xag
1121: where xag.channel_name = p_ChannelName;
1122:
1123: l_AdapterName varchar2(40);
1124: l_AdapterStatus varchar2(40);

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 1281: FROM xdp_adapter_reg xad, xdp_adapter_types_b t

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)

Line 1332: from XDP_ADAPTER_REG

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
1334: and adapter_status not in (XDP_ADAPTER.pv_statusStopped,
1335: XDP_ADAPTER.pv_statusStoppedError,
1336: XDP_ADAPTER.pv_statusTerminated,

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 1400: from xdp_adapter_reg a, xdp_adapter_types_b b

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

Line 1500: from xdp_adapter_reg a

1496: is
1497: l_StartupMode varchar2(30);
1498: begin
1499: select a.startup_mode into l_StartupMode
1500: from xdp_adapter_reg a
1501: where a.CHANNEL_NAME = p_ChannelName;
1502:
1503: if (upper(l_StartupMode) IN (XDP_ADAPTER.pv_startAutomatic, XDP_ADAPTER.pv_startOnDemand)) then
1504: return TRUE;

Line 1534: FROM xdp_adapter_reg ar, xdp_adapter_types_b atb

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);