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.FND_SVC_COMPONENT dependencies on FND_SVC_COMPONENTS

Line 89: l_component_name fnd_svc_components.component_name%TYPE;

85: l_event_params fnd_svc_comp_requests.event_params%TYPE;
86: l_event_frequency fnd_svc_comp_requests.event_frequency%TYPE;
87: l_requested_by_user fnd_svc_comp_requests.requested_by_user%TYPE;
88:
89: l_component_name fnd_svc_components.component_name%TYPE;
90: l_component_type fnd_svc_components.component_type%TYPE;
91: l_component_status fnd_svc_components.component_status%TYPE;
92: l_container_type fnd_svc_components.container_type%TYPE;
93: l_container_name fnd_svc_components.standalone_container_name%TYPE;

Line 90: l_component_type fnd_svc_components.component_type%TYPE;

86: l_event_frequency fnd_svc_comp_requests.event_frequency%TYPE;
87: l_requested_by_user fnd_svc_comp_requests.requested_by_user%TYPE;
88:
89: l_component_name fnd_svc_components.component_name%TYPE;
90: l_component_type fnd_svc_components.component_type%TYPE;
91: l_component_status fnd_svc_components.component_status%TYPE;
92: l_container_type fnd_svc_components.container_type%TYPE;
93: l_container_name fnd_svc_components.standalone_container_name%TYPE;
94:

Line 91: l_component_status fnd_svc_components.component_status%TYPE;

87: l_requested_by_user fnd_svc_comp_requests.requested_by_user%TYPE;
88:
89: l_component_name fnd_svc_components.component_name%TYPE;
90: l_component_type fnd_svc_components.component_type%TYPE;
91: l_component_status fnd_svc_components.component_status%TYPE;
92: l_container_type fnd_svc_components.container_type%TYPE;
93: l_container_name fnd_svc_components.standalone_container_name%TYPE;
94:
95: l_request_history_id fnd_svc_comp_requests_h.request_history_id%TYPE;

Line 92: l_container_type fnd_svc_components.container_type%TYPE;

88:
89: l_component_name fnd_svc_components.component_name%TYPE;
90: l_component_type fnd_svc_components.component_type%TYPE;
91: l_component_status fnd_svc_components.component_status%TYPE;
92: l_container_type fnd_svc_components.container_type%TYPE;
93: l_container_name fnd_svc_components.standalone_container_name%TYPE;
94:
95: l_request_history_id fnd_svc_comp_requests_h.request_history_id%TYPE;
96: l_rowid VARCHAR2(64);

Line 93: l_container_name fnd_svc_components.standalone_container_name%TYPE;

89: l_component_name fnd_svc_components.component_name%TYPE;
90: l_component_type fnd_svc_components.component_type%TYPE;
91: l_component_status fnd_svc_components.component_status%TYPE;
92: l_container_type fnd_svc_components.container_type%TYPE;
93: l_container_name fnd_svc_components.standalone_container_name%TYPE;
94:
95: l_request_history_id fnd_svc_comp_requests_h.request_history_id%TYPE;
96: l_rowid VARCHAR2(64);
97: l_Status varchar2(30) := FND_SVC_COMPONENT.pv_adminStatusCompleted;

Line 117: FROM fnd_svc_comp_requests a, fnd_svc_components b

113: SELECT a.component_id, event_name, event_params, event_frequency, requested_by_user, component_name,
114: component_status, component_type, container_type, standalone_container_name
115: INTO l_component_id, l_event_name, l_event_params, l_event_frequency, l_requested_by_user,
116: l_component_name, l_component_status, l_component_type, l_container_type, l_container_name
117: FROM fnd_svc_comp_requests a, fnd_svc_components b
118: WHERE component_request_id = p_component_request_id and
119: a.component_id = b.component_id;
120:
121: IF l_container_type = pv_Container_Type_GSM THEN

Line 124: FROM fnd_svc_components_v

120:
121: IF l_container_type = pv_Container_Type_GSM THEN
122: SELECT concurrent_queue_name
123: INTO l_container_name
124: FROM fnd_svc_components_v
125: WHERE component_id = l_component_id;
126: END IF;
127:
128: EXCEPTION

Line 270: FROM fnd_svc_components c

266:
267: CURSOR c_Components
268: IS
269: SELECT c.component_status
270: FROM fnd_svc_components c
271: WHERE c.component_type = NVL(p_component_type, c.component_type);
272:
273: BEGIN
274: --

Line 327: l_customization_level fnd_svc_components.customization_level%TYPE;

323:
324: l_rowid VARCHAR2(64);
325: l_component_parameter_id fnd_svc_comp_param_vals.component_parameter_id%TYPE;
326:
327: l_customization_level fnd_svc_components.customization_level%TYPE;
328: l_created_by NUMBER;
329: l_last_updated_by NUMBER;
330: l_last_update_login NUMBER;
331:

Line 352: FROM fnd_svc_components

348: -- Retrieve common data from component
349: --
350: SELECT customization_level, created_by, last_updated_by, last_update_login
351: INTO l_customization_level, l_created_by, l_last_updated_by, l_last_update_login
352: FROM fnd_svc_components
353: WHERE component_id = p_component_id;
354:
355: --
356: -- Insert parameter value

Line 531: l_CurrentStatus fnd_svc_components.component_status%TYPE;

527:
528:
529: Function Get_Current_Status(p_Component_Id in NUMBER) return varchar2
530: is
531: l_CurrentStatus fnd_svc_components.component_status%TYPE;
532: begin
533: select component_status into l_CurrentStatus
534: from fnd_svc_components where component_id = p_Component_Id;
535:

Line 534: from fnd_svc_components where component_id = p_Component_Id;

530: is
531: l_CurrentStatus fnd_svc_components.component_status%TYPE;
532: begin
533: select component_status into l_CurrentStatus
534: from fnd_svc_components where component_id = p_Component_Id;
535:
536: return l_CurrentStatus;
537:
538: EXCEPTION

Line 553: l_CurrentStatus fnd_svc_components.component_status%TYPE;

549: p_errbuf OUT NOCOPY VARCHAR2)
550: is
551:
552: l_isValid boolean := false;
553: l_CurrentStatus fnd_svc_components.component_status%TYPE;
554:
555: begin
556:
557: p_retcode := 0;

Line 680: l_Standalone_Container_Name fnd_svc_components.standalone_container_name%TYPE;

676: p_Container_Type out nocopy varchar2,
677: p_Container_Name out nocopy varchar2)
678: is
679: l_Concurrent_Queue_Name fnd_concurrent_queues.concurrent_queue_name%TYPE;
680: l_Standalone_Container_Name fnd_svc_components.standalone_container_name%TYPE;
681: begin
682: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
683: WF_LOG_PKG.STRING (WF_LOG_PKG.LEVEL_PROCEDURE,
684: 'wf.plsql.FND_SVC_COMPONENT.GET_CONTAINER_INFO.begin',

Line 690: from fnd_svc_components_v where component_id = p_Component_Id;

686: end if;
687:
688: select container_type, concurrent_queue_name, standalone_container_name
689: into p_Container_Type, l_Concurrent_Queue_Name, l_Standalone_Container_Name
690: from fnd_svc_components_v where component_id = p_Component_Id;
691:
692: if (p_Container_Type = FND_SVC_COMPONENT.pv_Container_Type_GSM) then
693: p_Container_Name := l_Concurrent_Queue_Name;
694: else

Line 707: -- the FND_SVC_COMPONENTS table and to raise a System Alert if necessary.

703:
704: --
705: -- Update_Status
706: -- Procedure to update the status of the given Service Component in
707: -- the FND_SVC_COMPONENTS table and to raise a System Alert if necessary.
708: -- If the component staus is either STOPPED_ERROR or DEACTIVATED_SYSTEM
709: -- then a System Alert is raised with the pre-defined message.
710: -- For more information, refer Bug 3786007.
711: --

Line 725: l_component_name fnd_svc_components.component_name%TYPE;

721: p_Status_Info IN VARCHAR2,
722: p_Last_Updated_By IN NUMBER,
723: p_Last_Update_Login IN NUMBER)
724: is
725: l_component_name fnd_svc_components.component_name%TYPE;
726:
727: begin
728: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
729: WF_LOG_PKG.STRING (WF_LOG_PKG.LEVEL_PROCEDURE,

Line 735: UPDATE FND_SVC_COMPONENTS

731: 'p_Component_Id: '||p_Component_Id
732: ||' p_Status: '||p_Status);
733: end if;
734:
735: UPDATE FND_SVC_COMPONENTS
736: SET component_status = p_Status,
737: component_status_info = decode(p_Status_Info, null, component_status_info,
738: 'NULL', null, substrb(p_Status_Info,1,1996)),
739: last_update_date = sysdate,

Line 760: FROM fnd_svc_components

756: end if;
757:
758: SELECT TRIM(component_name)
759: INTO l_component_name
760: FROM fnd_svc_components
761: WHERE component_id = p_Component_Id;
762:
763: WF_LOG_PKG.SET_TOKEN('COMPONENT_NAME', l_component_name);
764: WF_LOG_PKG.SET_TOKEN('ERROR_CONTEXT', nvl(p_Status_Info,'Not provided.'));

Line 787: l_Container_Type fnd_svc_components.container_type%TYPE;

783: (p_Component_Name IN VARCHAR2)
784: RETURN VARCHAR2
785: is
786: l_Component_Id fnd_svc_comp_requests.component_id%TYPE;
787: l_Container_Type fnd_svc_components.container_type%TYPE;
788: l_Container_Name fnd_svc_components.standalone_container_name%TYPE;
789: l_Current_Status fnd_svc_components.component_status%TYPE;
790:
791: begin

Line 788: l_Container_Name fnd_svc_components.standalone_container_name%TYPE;

784: RETURN VARCHAR2
785: is
786: l_Component_Id fnd_svc_comp_requests.component_id%TYPE;
787: l_Container_Type fnd_svc_components.container_type%TYPE;
788: l_Container_Name fnd_svc_components.standalone_container_name%TYPE;
789: l_Current_Status fnd_svc_components.component_status%TYPE;
790:
791: begin
792: -- Get the Component Id

Line 789: l_Current_Status fnd_svc_components.component_status%TYPE;

785: is
786: l_Component_Id fnd_svc_comp_requests.component_id%TYPE;
787: l_Container_Type fnd_svc_components.container_type%TYPE;
788: l_Container_Name fnd_svc_components.standalone_container_name%TYPE;
789: l_Current_Status fnd_svc_components.component_status%TYPE;
790:
791: begin
792: -- Get the Component Id
793: SELECT component_id

Line 795: FROM fnd_svc_components

791: begin
792: -- Get the Component Id
793: SELECT component_id
794: INTO l_Component_Id
795: FROM fnd_svc_components
796: WHERE component_name = p_component_Name;
797:
798: -- Get Container Type and Name
799: Get_Container_Info(p_Component_Id => l_Component_Id,

Line 859: l_Container_Type fnd_svc_components.container_type%TYPE;

855: p_retcode OUT NOCOPY NUMBER,
856: p_errbuf OUT NOCOPY VARCHAR2)
857: is
858:
859: l_Container_Type fnd_svc_components.container_type%TYPE;
860: l_Container_Name fnd_svc_components.standalone_container_name%TYPE;
861: l_CPID number;
862: l_Container_Status fnd_svc_components.component_status%TYPE;
863:

Line 860: l_Container_Name fnd_svc_components.standalone_container_name%TYPE;

856: p_errbuf OUT NOCOPY VARCHAR2)
857: is
858:
859: l_Container_Type fnd_svc_components.container_type%TYPE;
860: l_Container_Name fnd_svc_components.standalone_container_name%TYPE;
861: l_CPID number;
862: l_Container_Status fnd_svc_components.component_status%TYPE;
863:
864: begin

Line 862: l_Container_Status fnd_svc_components.component_status%TYPE;

858:
859: l_Container_Type fnd_svc_components.container_type%TYPE;
860: l_Container_Name fnd_svc_components.standalone_container_name%TYPE;
861: l_CPID number;
862: l_Container_Status fnd_svc_components.component_status%TYPE;
863:
864: begin
865: p_retcode := 0;
866:

Line 939: l_Container_Type fnd_svc_components.container_type%TYPE;

935: p_retcode OUT NOCOPY NUMBER,
936: p_errbuf OUT NOCOPY VARCHAR2)
937: is
938:
939: l_Container_Type fnd_svc_components.container_type%TYPE;
940: l_Container_Name fnd_svc_components.standalone_container_name%TYPE;
941: l_CPID number;
942: l_Container_Status fnd_svc_components.component_status%TYPE;
943:

Line 940: l_Container_Name fnd_svc_components.standalone_container_name%TYPE;

936: p_errbuf OUT NOCOPY VARCHAR2)
937: is
938:
939: l_Container_Type fnd_svc_components.container_type%TYPE;
940: l_Container_Name fnd_svc_components.standalone_container_name%TYPE;
941: l_CPID number;
942: l_Container_Status fnd_svc_components.component_status%TYPE;
943:
944: begin

Line 942: l_Container_Status fnd_svc_components.component_status%TYPE;

938:
939: l_Container_Type fnd_svc_components.container_type%TYPE;
940: l_Container_Name fnd_svc_components.standalone_container_name%TYPE;
941: l_CPID number;
942: l_Container_Status fnd_svc_components.component_status%TYPE;
943:
944: begin
945: p_retcode := 0;
946:

Line 1031: l_Container_Type fnd_svc_components.container_type%TYPE;

1027: p_retcode OUT NOCOPY NUMBER,
1028: p_errbuf OUT NOCOPY VARCHAR2)
1029: is
1030:
1031: l_Container_Type fnd_svc_components.container_type%TYPE;
1032: l_Container_Name fnd_svc_components.standalone_container_name%TYPE;
1033: l_CPID number;
1034: l_Container_Status fnd_svc_components.component_status%TYPE;
1035:

Line 1032: l_Container_Name fnd_svc_components.standalone_container_name%TYPE;

1028: p_errbuf OUT NOCOPY VARCHAR2)
1029: is
1030:
1031: l_Container_Type fnd_svc_components.container_type%TYPE;
1032: l_Container_Name fnd_svc_components.standalone_container_name%TYPE;
1033: l_CPID number;
1034: l_Container_Status fnd_svc_components.component_status%TYPE;
1035:
1036: begin

Line 1034: l_Container_Status fnd_svc_components.component_status%TYPE;

1030:
1031: l_Container_Type fnd_svc_components.container_type%TYPE;
1032: l_Container_Name fnd_svc_components.standalone_container_name%TYPE;
1033: l_CPID number;
1034: l_Container_Status fnd_svc_components.component_status%TYPE;
1035:
1036: begin
1037: p_retcode := 0;
1038:

Line 1108: l_Container_Type fnd_svc_components.container_type%TYPE;

1104: p_retcode OUT NOCOPY NUMBER,
1105: p_errbuf OUT NOCOPY VARCHAR2)
1106: is
1107:
1108: l_Container_Type fnd_svc_components.container_type%TYPE;
1109: l_Container_Name fnd_svc_components.standalone_container_name%TYPE;
1110: l_CPID number;
1111: l_Container_Status fnd_svc_components.component_status%TYPE;
1112:

Line 1109: l_Container_Name fnd_svc_components.standalone_container_name%TYPE;

1105: p_errbuf OUT NOCOPY VARCHAR2)
1106: is
1107:
1108: l_Container_Type fnd_svc_components.container_type%TYPE;
1109: l_Container_Name fnd_svc_components.standalone_container_name%TYPE;
1110: l_CPID number;
1111: l_Container_Status fnd_svc_components.component_status%TYPE;
1112:
1113: begin

Line 1111: l_Container_Status fnd_svc_components.component_status%TYPE;

1107:
1108: l_Container_Type fnd_svc_components.container_type%TYPE;
1109: l_Container_Name fnd_svc_components.standalone_container_name%TYPE;
1110: l_CPID number;
1111: l_Container_Status fnd_svc_components.component_status%TYPE;
1112:
1113: begin
1114: p_retcode := 0;
1115:

Line 1187: l_Container_Type fnd_svc_components.container_type%TYPE;

1183: p_retcode OUT NOCOPY NUMBER,
1184: p_errbuf OUT NOCOPY VARCHAR2)
1185: is
1186:
1187: l_Container_Type fnd_svc_components.container_type%TYPE;
1188: l_Container_Name fnd_svc_components.standalone_container_name%TYPE;
1189: l_CPID number;
1190: l_Container_Status fnd_svc_components.component_status%TYPE;
1191:

Line 1188: l_Container_Name fnd_svc_components.standalone_container_name%TYPE;

1184: p_errbuf OUT NOCOPY VARCHAR2)
1185: is
1186:
1187: l_Container_Type fnd_svc_components.container_type%TYPE;
1188: l_Container_Name fnd_svc_components.standalone_container_name%TYPE;
1189: l_CPID number;
1190: l_Container_Status fnd_svc_components.component_status%TYPE;
1191:
1192: begin

Line 1190: l_Container_Status fnd_svc_components.component_status%TYPE;

1186:
1187: l_Container_Type fnd_svc_components.container_type%TYPE;
1188: l_Container_Name fnd_svc_components.standalone_container_name%TYPE;
1189: l_CPID number;
1190: l_Container_Status fnd_svc_components.component_status%TYPE;
1191:
1192: begin
1193: p_retcode := 0;
1194:

Line 1266: l_Container_Type fnd_svc_components.container_type%TYPE;

1262: p_retcode OUT NOCOPY NUMBER,
1263: p_errbuf OUT NOCOPY VARCHAR2)
1264: is
1265:
1266: l_Container_Type fnd_svc_components.container_type%TYPE;
1267: l_Container_Name fnd_svc_components.standalone_container_name%TYPE;
1268: l_CPID number;
1269: l_Container_Status fnd_svc_components.component_status%TYPE;
1270:

Line 1267: l_Container_Name fnd_svc_components.standalone_container_name%TYPE;

1263: p_errbuf OUT NOCOPY VARCHAR2)
1264: is
1265:
1266: l_Container_Type fnd_svc_components.container_type%TYPE;
1267: l_Container_Name fnd_svc_components.standalone_container_name%TYPE;
1268: l_CPID number;
1269: l_Container_Status fnd_svc_components.component_status%TYPE;
1270:
1271: begin

Line 1269: l_Container_Status fnd_svc_components.component_status%TYPE;

1265:
1266: l_Container_Type fnd_svc_components.container_type%TYPE;
1267: l_Container_Name fnd_svc_components.standalone_container_name%TYPE;
1268: l_CPID number;
1269: l_Container_Status fnd_svc_components.component_status%TYPE;
1270:
1271: begin
1272: p_retcode := 0;
1273:

Line 1365: from FND_SVC_COMPONENTS

1361: is
1362: PRAGMA AUTONOMOUS_TRANSACTION;
1363: cursor c_Get_Running_Components_Conc (ConcQId number, ApplId number) is
1364: select component_id
1365: from FND_SVC_COMPONENTS
1366: where component_status not in (FND_SVC_COMPONENT.pv_Status_Stopped,
1367: FND_SVC_COMPONENT.pv_Status_Stopped_Error,
1368: FND_SVC_COMPONENT.pv_Status_Not_Configured,
1369: FND_SVC_COMPONENT.pv_Status_Deactivated_User,

Line 1377: from FND_SVC_COMPONENTS

1373: and application_id = ApplId;
1374:
1375: cursor c_Get_Running_Components_Std (StdContainerName varchar2) is
1376: select component_id
1377: from FND_SVC_COMPONENTS
1378: where component_status not in (FND_SVC_COMPONENT.pv_Status_Stopped,
1379: FND_SVC_COMPONENT.pv_Status_Stopped_Error,
1380: FND_SVC_COMPONENT.pv_Status_Not_Configured,
1381: FND_SVC_COMPONENT.pv_Status_Deactivated_User,

Line 1410: update FND_SVC_COMPONENTS

1406: p_Status_Info => 'Status has been reset because the Service Component did not stop gracefully.'); -- TODO MLS??
1407:
1408: END LOOP;
1409:
1410: update FND_SVC_COMPONENTS
1411: set component_status = FND_SVC_COMPONENT.pv_Status_Stopped_Error where
1412: component_status = FND_SVC_COMPONENT.pv_Status_Deactivated_System and
1413: concurrent_queue_id = l_concurrent_queue_id and
1414: application_id = l_appl_id and

Line 1426: update FND_SVC_COMPONENTS

1422: p_Status => FND_SVC_COMPONENT.pv_Status_Stopped_Error,
1423: p_Status_Info => 'Status has been reset because the Service Component did not stop gracefully.'); -- TODO MLS??
1424: END LOOP;
1425:
1426: update FND_SVC_COMPONENTS
1427: set component_status = FND_SVC_COMPONENT.pv_Status_Stopped_Error where
1428: component_status = FND_SVC_COMPONENT.pv_Status_Deactivated_System and
1429: standalone_container_name = p_container_name and
1430: container_type = pv_Container_Type_Servlet;

Line 1472: l_Container_Status fnd_svc_components.component_status%TYPE;

1468: p_errbuf OUT NOCOPY VARCHAR2)
1469: is
1470:
1471: l_CPID number;
1472: l_Container_Status fnd_svc_components.component_status%TYPE;
1473:
1474: begin
1475: p_retcode := 0;
1476:

Line 1532: l_Container_Status fnd_svc_components.component_status%TYPE;

1528: , p_container_name IN VARCHAR2)
1529: IS
1530:
1531: l_CPID number;
1532: l_Container_Status fnd_svc_components.component_status%TYPE;
1533:
1534: begin
1535:
1536: Get_Container_Status (p_container_type => p_container_Type

Line 1563: from FND_SVC_COMPONENTS

1559:
1560: cursor c_Get_Distinct_Containers is
1561:
1562: select distinct standalone_container_name container_name, container_type
1563: from FND_SVC_COMPONENTS
1564: where container_type = pv_Container_Type_Servlet and standalone_container_name is not null
1565:
1566: union
1567:

Line 1569: from FND_SVC_COMPONENTS_V

1565:
1566: union
1567:
1568: select distinct concurrent_queue_name container_name, container_type
1569: from FND_SVC_COMPONENTS_V
1570: where container_type = pv_Container_Type_GSM and concurrent_queue_name is not null;
1571:
1572: begin
1573: