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_COMP_REQUESTS

Line 49: l_job_id fnd_svc_comp_requests.job_id%TYPE;

45:
46: PROCEDURE Delete_Request
47: ( p_component_request_id IN NUMBER)
48: AS
49: l_job_id fnd_svc_comp_requests.job_id%TYPE;
50:
51: BEGIN
52:
53: --

Line 60: FROM fnd_svc_comp_requests

56: --
57:
58: SELECT job_id
59: INTO l_job_id
60: FROM fnd_svc_comp_requests
61: WHERE component_request_id = p_component_request_id;
62:
63: --
64: -- Delete DBMS_JOB

Line 72: FND_SVC_COMP_REQUESTS_PKG.DELETE_ROW(

68:
69: --
70: -- Delete the request
71: --
72: FND_SVC_COMP_REQUESTS_PKG.DELETE_ROW(
73: x_component_request_id => p_component_request_id);
74:
75: END Delete_Request;
76:

Line 82: l_component_id fnd_svc_comp_requests.component_id%TYPE;

78: PROCEDURE Execute_Request
79: ( p_component_request_id IN NUMBER)
80: AS
81:
82: l_component_id fnd_svc_comp_requests.component_id%TYPE;
83: l_event_name fnd_svc_comp_requests.event_name%TYPE;
84: l_job_id fnd_svc_comp_requests.job_id%TYPE;
85: l_event_params fnd_svc_comp_requests.event_params%TYPE;
86: l_event_frequency fnd_svc_comp_requests.event_frequency%TYPE;

Line 83: l_event_name fnd_svc_comp_requests.event_name%TYPE;

79: ( p_component_request_id IN NUMBER)
80: AS
81:
82: l_component_id fnd_svc_comp_requests.component_id%TYPE;
83: l_event_name fnd_svc_comp_requests.event_name%TYPE;
84: l_job_id fnd_svc_comp_requests.job_id%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;

Line 84: l_job_id fnd_svc_comp_requests.job_id%TYPE;

80: AS
81:
82: l_component_id fnd_svc_comp_requests.component_id%TYPE;
83: l_event_name fnd_svc_comp_requests.event_name%TYPE;
84: l_job_id fnd_svc_comp_requests.job_id%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:

Line 85: l_event_params fnd_svc_comp_requests.event_params%TYPE;

81:
82: l_component_id fnd_svc_comp_requests.component_id%TYPE;
83: l_event_name fnd_svc_comp_requests.event_name%TYPE;
84: l_job_id fnd_svc_comp_requests.job_id%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;

Line 86: l_event_frequency fnd_svc_comp_requests.event_frequency%TYPE;

82: l_component_id fnd_svc_comp_requests.component_id%TYPE;
83: l_event_name fnd_svc_comp_requests.event_name%TYPE;
84: l_job_id fnd_svc_comp_requests.job_id%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;

Line 87: l_requested_by_user fnd_svc_comp_requests.requested_by_user%TYPE;

83: l_event_name fnd_svc_comp_requests.event_name%TYPE;
84: l_job_id fnd_svc_comp_requests.job_id%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;

Line 95: l_request_history_id fnd_svc_comp_requests_h.request_history_id%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;
98:
99: l_ErrorMsg VARCHAR2 (4000);

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 223: SELECT fnd_svc_comp_requests_h_s.nextval INTO l_request_history_id FROM dual;

219: 'wf.plsql.FND_SVC_COMPONENT.EXECUTE_REQUEST.request_audit',
220: 'Request audited with status: '||l_Status);
221: end if;
222:
223: SELECT fnd_svc_comp_requests_h_s.nextval INTO l_request_history_id FROM dual;
224:
225: FND_SVC_COMP_REQUESTS_H_PKG.Insert_Row
226: ( x_rowid => l_rowid
227: , x_request_history_id => l_request_history_id

Line 225: FND_SVC_COMP_REQUESTS_H_PKG.Insert_Row

221: end if;
222:
223: SELECT fnd_svc_comp_requests_h_s.nextval INTO l_request_history_id FROM dual;
224:
225: FND_SVC_COMP_REQUESTS_H_PKG.Insert_Row
226: ( x_rowid => l_rowid
227: , x_request_history_id => l_request_history_id
228: , x_component_id => l_component_id
229: , x_event_name => l_event_name

Line 248: -- Can come here only because of some SQL error in FND_SVC_COMP_REQUESTS_H_PKG.Insert_Row

244: commit;
245:
246: EXCEPTION
247: WHEN OTHERS THEN
248: -- Can come here only because of some SQL error in FND_SVC_COMP_REQUESTS_H_PKG.Insert_Row
249: -- Still we need to commit;
250: if (wf_log_pkg.level_error >= fnd_log.g_current_runtime_level) then
251: wf_log_pkg.STRING (wf_log_pkg.LEVEL_ERROR,
252: 'wf.plsql.FND_SVC_COMPONENT.EXECUTE_REQUEST.error',

Line 786: l_Component_Id fnd_svc_comp_requests.component_id%TYPE;

782: FUNCTION Get_Component_Status
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: