APPS.FND_SVC_COMPONENT dependencies on FND_SVC_COMP_REQUESTS_H

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