1 PACKAGE QA_SECURITY_PKG AUTHID CURRENT_USER AS
2 /* $Header: qltsecb.pls 120.1 2006/03/31 05:27:52 saugupta noship $ */
3
4
5 /* Package level variable */
6
7 TYPE ChildPlanArray IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
8
9 pv_group_type CONSTANT varchar2(10) := 'QA';
10
11
12 Procedure Create_Grant(EVENT in varchar2,
13 p_grantee_id in number, p_plan_id in number,
14 p_setup_flag in varchar2, x_setup_guid in out NOCOPY raw,
15 p_enter_flag in varchar2, x_enter_guid in out NOCOPY raw,
16 p_view_flag in varchar2, x_view_guid in out NOCOPY raw,
17 p_update_flag in varchar2, x_update_guid in out NOCOPY raw,
18 p_delete_flag in varchar2, x_delete_guid in out NOCOPY raw);
19
20 Procedure security_predicate( p1_function in varchar2,
21 p1_object_name in varchar2,
22 p1_user_name in varchar2,
23 x1_predicate out NOCOPY varchar2,
24 x1_return_status out NOCOPY varchar2);
25
26 -- Bug2379185. Changed the signature of the function.
27 -- Included p_check_immediate parameter and x_child_plan_ids changed to 'in out' parameter
28 -- rponnusa Thu May 16 19:25:20 PDT 2002
29 Function child_security( p_function_name IN VARCHAR2,
30 p_user IN VARCHAR2,
31 x_child_plan_ids IN OUT NOCOPY VARCHAR2,
32 p_parent_plan_id IN NUMBER,
33 p_check_immediate IN BOOLEAN)
34 RETURN VARCHAR2;
35
36 Procedure Create_Group( p_group_name in varchar2,
37 x1_msg_data out NOCOPY varchar2,
38 x1_return_status out NOCOPY varchar2,
39 x1_party_id out NOCOPY number);
40
41 Procedure Create_Person(p_fname in varchar2,
42 p_lname in varchar2,
43 x1_msg_data out NOCOPY varchar2,
44 x1_return_status out NOCOPY varchar2,
45 x1_party_id out NOCOPY number);
46
47 Procedure Create_Relationship(p_subject_id in number,
48 p_object_id in number,
49 x1_msg_data out NOCOPY varchar2,
50 x1_return_status out NOCOPY varchar2,
51 x1_party_id out NOCOPY number,
52 x1_relationship_id out NOCOPY number);
53
54
55 Procedure Update_Group(p_group_name in varchar2,
56 p_party_id in number,
57 p_date in date,
58 x1_msg_data out NOCOPY varchar2,
59 x1_return_status out NOCOPY varchar2);
60
61 Procedure Update_Person(p_fname in varchar2,
62 p_lname in varchar2,
63 p_party_id in number,
64 p_date in date,
65 x1_msg_data out NOCOPY varchar2,
66 x1_return_status out NOCOPY varchar2);
67
68 Procedure Delete_Relationship(p_relationship_id in number);
69
70 Procedure Update_Relationship(p_relationship_id in number,
71 p_subject_id in number,
72 p_object_id in number,
73 p_party_id in number,
74 p_status in varchar2,
75 p_rel_date in date,
76 p_party_date in date,
77 x1_return_status out NOCOPY varchar2,
78 x1_msg_data out NOCOPY varchar2);
79
80
81 -- anagarwa Tue Aug 3 12:26:09 PDT 2004
82 -- bug 3695361: Slow performance when security is on
83 -- Following procedure takes in used id instead of user name and
84 -- finds user name and then calls original security_predicate
85 PROCEDURE ssqr_security_predicate(p2_function in varchar2,
86 p2_object_name in varchar2,
87 p2_user_id in number,
88 x2_predicate out NOCOPY varchar2,
89 x2_return_status out NOCOPY varchar2) ;
90 END QA_SECURITY_PKG;