1 PACKAGE OE_SECURITY_PVT AUTHID CURRENT_USER AS
2 /* $Header: OEXVSECS.pls 120.0 2005/06/01 02:21:04 appldev noship $ */
3
4 -- Start of Comments
5 -- API name
6 -- Type PRIVATE
7 -- Function
8 --
9 -- Pre-reqs
10 --
11 -- Parameters
12 --
13 -- Version Current version = 1.0
14 -- Initial version = 1.0
15 --
16 -- Notes
17 --
18 -- End of Comments
19
20 G_PKG_NAME VARCHAR2(30) := '';
21
22 -- Security Record Type
23 /* Record G_SECURITY_REC_TYPE
24 */
25 TYPE G_SECURITY_REC_TYPE IS RECORD
26 (
27 User_id Number := null
28 ,application_id Number := 300
29 ,responsibility_id Number := NULL
30 ,WF_Item_Type Varchar2(30) := 'OEOL'
31 ,WF_Item_Key Varchar2(100) := null
32 ,Attribute_Group Varchar2(30) := null
33 ,Attribute_Code Varchar2(30) := null
34 ,Operation_code Varchar2(30) := null
35 ,constraint_id Number := null
36 -- constraint id of the processing constraints which prevent the
37 -- operation from being performed
38 ,constraint_type Varchar2(30) := null
39 -- 'BLOCK' -- Operation not allowed
40 -- 'REQUIRE_REASON'changes require to specify reason
41 -- 'REQUIRE_HISTORY' changes require a history to be recorded
42 -- null if no constraints exists
43 , resolving_activity_item_type Varchar2(30) := null
44 , resolving_activity_name Varchar2(30) := null
45 , resolving_responsibility_id Number := null
46 , err_code Varchar2(240) := null
47 );
48 /* Procedure ChkProcConstraints
49 ** Usage Check if any processing constraints exists for a given Object
50 ** / Attribute. Returns FND_API.G_TUE if the current operation is
51 ** allowed and does not have any processing constrints. Returns
52 ** FND_API.G_FALSE if the operation is not allowed. The column
53 ** p_sec_req.constraint_id holds the constrint_id of the constraint
54 ** preventing the operation and p_sec_req.constraint_type is set
55 ** to null if no constraints exists, Object for processing constraints
56 ** and User if the current user / responsibility does not have
57 ** authority to perform the operation
58 ** Parameters
59 ** IN OUT NOCOPY p_sec_req
60 ** OUT NOCOPY p_result FND_API.G_TRUE if no processing constraints
61
62 ** FND_API.G_FALSE if processing constrints exit
63 ** OUT NOCOPY p_sec_req.security_result OBJECT for processing constrints
64
65 ** USER if the user does not have authoriy to perform
66 ** Operation
67 */
68 Procedure ChkProcConstraints(
69 x_sec_req IN OUT NOCOPY /* file.sql.39 change */ OE_SECURITY_PVT.G_SECURITY_REC_TYPE
70 ,x_return_status OUT NOCOPY Varchar2
71
72 ,x_result OUT NOCOPY Varchar2
73
74 ,x_msg_data OUT NOCOPY Varchar2
75
76 ,x_msg_count OUT NOCOPY Number
77
78 );
79
80 END;