1 PACKAGE AMS_access_denorm_PVT AUTHID CURRENT_USER AS
2 /* $Header: amsvdens.pls 115.7 2003/02/12 11:36:44 sunkumar ship $ */
3
4
5 PROCEDURE insert_resource( p_resource_id IN NUMBER
6 , p_object_type IN VARCHAR2
7 , p_object_id IN NUMBER
8 , p_edit_metrics IN VARCHAR2
9 , x_return_status OUT NOCOPY VARCHAR2
10 , x_msg_count OUT NOCOPY NUMBER
11 , x_msg_data OUT NOCOPY VARCHAR2
12 );
13
14 PROCEDURE update_resource( p_resource_id IN NUMBER
15 , p_object_type IN VARCHAR2
16 , p_object_id IN NUMBER
17 , p_edit_metrics IN VARCHAR2
18 , x_return_status OUT NOCOPY VARCHAR2
19 , x_msg_count OUT NOCOPY NUMBER
20 , x_msg_data OUT NOCOPY VARCHAR2
21 );
22
23
24 PROCEDURE delete_resource( p_resource_id IN NUMBER
25 , p_object_type IN VARCHAR2
26 , p_object_id IN NUMBER
27 , p_edit_metrics IN VARCHAR2
28 , x_return_status OUT NOCOPY VARCHAR2
29 , x_msg_count OUT NOCOPY NUMBER
30 , x_msg_data OUT NOCOPY VARCHAR2
31 );
32
33 /* This procedure inserts a resource for a given object into ams_act_access_denorm
34 evaluating edit_metrics. If a resource that is being inserted already exists, it
35 checks for the edit metrics. If the existing value is 'N' and the incoming parameter
36 is 'Y' it updates the row */
37
38 PROCEDURE insert_resource( p_resource_id IN NUMBER
39 , p_object_type IN VARCHAR2
40 , p_object_id IN NUMBER
41 , p_edit_metrics IN VARCHAR2
42 , x_return_status OUT NOCOPY VARCHAR2
43 );
44
45 /* This procedure updates a resource for a given object in ams_act_access_denorm
46 evaluating edit_metrics. If incoming edit metrics is N and the existing value
47 is 'Y', it checks to see if the resource is part of any other group with 'Y' access
48 if it finds a matching 'Y' row, this procedure will not do any thing other wise it
49 updates the resource */
50
51 PROCEDURE update_resource( p_resource_id IN NUMBER
52 , p_object_type IN VARCHAR2
53 , p_object_id IN NUMBER
54 , p_edit_metrics IN VARCHAR2
55 , x_return_status OUT NOCOPY VARCHAR2
56 );
57 /* This procedure deletes a resource from the denorm, before deleting it will check
58 if this resource exists as part of any other group than the one that is being deleted
59 if assumes that delete from ams_act_access already happened*/
60
61 PROCEDURE delete_resource( p_resource_id IN NUMBER
62 , p_object_type IN VARCHAR2
63 , p_object_id IN NUMBER
64 , p_edit_metrics IN VARCHAR2
65 , x_return_status OUT NOCOPY VARCHAR2
66 );
67 /* This procedure inserts a resource for a given object into ams_act_access_denorm
68 evaluating edit_metrics. If a resource that is being inserted already exists, it
69 checks for the edit metrics. If the existing value is 'N' and the incoming parameter
70 is 'Y' it updates the row */
71
72 PROCEDURE insert_resource( p_resource_id IN NUMBER
73 , p_object_type IN VARCHAR2
74 , p_object_id IN NUMBER
75 , p_edit_metrics IN VARCHAR2
76 );
77 /* This procedure updates a resource for a given object in ams_act_access_denorm
78 evaluating edit_metrics. If incoming edit metrics is N and the existing value
79 is 'Y', it checks to see if the resource is part of any other group with 'Y' access
80 if it finds a matching 'Y' row, this procedure will not do any thing other wise it
81 updates the resource */
82
83 PROCEDURE update_resource( p_resource_id IN NUMBER
84 , p_object_type IN VARCHAR2
85 , p_object_id IN NUMBER
86 , p_edit_metrics IN VARCHAR2
87 );
88 /* This procedure deletes a resource from the denorm, before deleting it will check
89 if this resource exists as part of any other group than the one that is being deleted
90 if assumes that delete from ams_act_access already happened*/
91
92 PROCEDURE delete_resource( p_resource_id IN NUMBER
93 , p_object_type IN VARCHAR2
94 , p_object_id IN NUMBER
95 , p_edit_metrics IN VARCHAR2
96 );
97 /* This procedure inserts group information ( all the resources in the group and its children)
98 into the denorm table. It evaluates to see if the resource is part of another group with
99 a different edit metrics and inserts/updates accordingly */
100 PROCEDURE insert_group( p_group_id IN NUMBER
101 , p_object_type IN VARCHAR2
102 , p_object_id IN NUMBER
103 , p_edit_metrics IN VARCHAR2
104 );
105 /* deletes resources present in the group and its children groups in the denorm table*/
106 PROCEDURE delete_group( p_group_id IN NUMBER
107 , p_object_type IN VARCHAR2
108 , p_object_id IN NUMBER
109 , p_edit_metrics IN VARCHAR2
110 );
111
112 PROCEDURE update_group( p_group_id IN NUMBER
113 , p_object_type IN VARCHAR2
114 , p_object_id IN NUMBER
115 , p_edit_metrics IN VARCHAR2
116 );
117 /* This procedure will be used as a concurrent program. This program will refresh the entries
118 in the denorm table for the object in context */
119 PROCEDURE ams_object_denorm ( errbuf OUT NOCOPY VARCHAR2
120 , retcode OUT NOCOPY VARCHAR2
121 , p_object_id IN NUMBER
122 , p_object_type IN VARCHAR2
123 );
124 /* This procedure will be used as a concurrent program. This program will refresh the entries
125 in the denorm table for all of the objects since the last run or complete refresh*/
126 AMS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
127 AMS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
128 AMS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
129
130 PROCEDURE ams_access_denorm ( errbuf OUT NOCOPY VARCHAR2
131 , retcode OUT NOCOPY VARCHAR2
132 , p_full_mode IN VARCHAR2 := Fnd_Api.G_FALSE
133 );
134
135
136 /* This procedure will be used as a concurrent program. This program will refresh the entries
137 in the denorm table for all of the changes to groups done through resource manager*/
138 PROCEDURE jtf_access_denorm( errbuf OUT NOCOPY VARCHAR2
139 , retcode OUT NOCOPY VARCHAR2
140 );
141
142 END ams_access_denorm_pvt;