1 PACKAGE CS_SR_SECURITY_GRP AUTHID CURRENT_USER AS
2 /* $Header: csgsecs.pls 115.2 2003/09/25 02:32:27 dejoseph noship $ */
3
4 -- Record structure to hold the values of the SR attributes that are used to
5 -- implement service security
6 -- For release 11.5.10, only SR Type is used.
7 TYPE SR_REC_TYPE IS RECORD (
8 INCIDENT_ID NUMBER,
9 INCIDENT_TYPE_ID NUMBER );
10
11 -- Record structure to hold the values of the id and type of the resource. Resource
12 -- type can be INDIVIDUAL, SUPPLIER, VENDOR, GROUP, TEAM etc.
13 TYPE RESOURCE_VALIDATE_REC_TYPE IS RECORD (
14 RESOURCE_ID NUMBER,
15 RESOURCE_TYPE VARCHAR2(90) );
16
17 -- Table type of resource records. Given a list of resources, the validate_resource
18 -- API will return back a set of resources that satisfy the Service Security policies.
19
20 TYPE RESOURCE_VALIDATE_TBL_TYPE IS TABLE OF RESOURCE_VALIDATE_REC_TYPE;
21
22 -- VALIDATE_USER_RESPONSIBILITY - This API is created for integration with
23 -- OTM. Given a incident_id, the api queries from the incidents secure view.
24 -- The secure view validates if the responsibility performing the update has
25 -- access to the SR or not.
26 -- This will be invoked from - sr_uwq_integ.validate_security
27
28 PROCEDURE VALIDATE_USER_RESPONSIBILITY (
29 p_api_version IN NUMBER,
30 p_init_msg_list IN VARCHAR2,
31 p_commit IN VARCHAR2,
32 p_incident_id IN NUMBER,
33 x_resp_access_status OUT NOCOPY VARCHAR2,
34 x_return_status OUT NOCOPY VARCHAR2,
35 x_msg_count OUT NOCOPY NUMBER,
36 x_msg_data OUT NOCOPY VARCHAR2 );
37
38 -- VALIDATE_RESOURCE - This API is created for integration with JTA assignment
39 -- manager. Given a service request id and type, and a list of resources, this API
40 -- returns back a list of resources (from the given list) who have access to
41 -- the Service Request.
42
43 PROCEDURE Validate_Resource (
44 p_api_version IN NUMBER,
45 p_init_msg_list IN VARCHAR2,
46 p_commit IN VARCHAR2,
47 p_sr_rec IN SR_REC_TYPE,
48 px_resource_tbl IN OUT NOCOPY RESOURCE_VALIDATE_TBL_TYPE,
49 x_return_status OUT NOCOPY VARCHAR2,
50 x_msg_count OUT NOCOPY NUMBER,
51 x_msg_data OUT NOCOPY VARCHAR2 );
52
53 END CS_SR_SECURITY_GRP;