1 package BSC_MULTI_USER_PVT as
2 /* $Header: BSCVMUFS.pls 120.0 2005/05/31 18:58:58 appldev noship $*/
3
4 procedure Apply_Multi_User_Env(
5 p_obj_type IN varchar2
6 ,p_obj_id IN number := 0
7 ,p_obj_id2 IN number := 0
8 ,p_obj_id3 IN number := 0
9 ,p_obj_location IN varchar2 := 'DUMMY'
10 ,p_obj_action IN varchar2
11 ,p_time_stamp IN varchar2
12 ,x_return_status OUT NOCOPY varchar2
13 ,x_msg_count OUT NOCOPY number
14 ,x_msg_data OUT NOCOPY varchar2
15 );
16
17 procedure Have_Time_Stamps_Changed(
18 p_obj_type IN varchar2
19 ,p_obj_id IN number
20 ,p_time_stamp IN date
21 ,x_return_status OUT NOCOPY varchar2
22 ,x_msg_count OUT NOCOPY number
23 ,x_msg_data OUT NOCOPY varchar2
24 );
25
26 procedure Check_Tab_Time_Stamp(
27 p_obj_id IN number
28 ,p_time_stamp IN date
29 ,x_return_status OUT NOCOPY varchar2
30 ,x_msg_count OUT NOCOPY number
31 ,x_msg_data OUT NOCOPY varchar2
32 );
33
34 procedure Check_Kpi_Time_Stamp(
35 p_obj_id IN number
36 ,p_time_stamp IN date
37 ,x_return_status OUT NOCOPY varchar2
38 ,x_msg_count OUT NOCOPY number
39 ,x_msg_data OUT NOCOPY varchar2
40 );
41
42 procedure Check_System_Change(
43 p_property_code IN varchar2
44 ,p_time_stamp IN date
45 ,x_return_status OUT NOCOPY varchar2
46 ,x_msg_count OUT NOCOPY number
47 ,x_msg_data OUT NOCOPY varchar2
48 );
49
50 procedure Tab_Details_Lock(
51 p_obj_id IN number
52 ,x_return_status OUT NOCOPY varchar2
53 ,x_msg_count OUT NOCOPY number
54 ,x_msg_data OUT NOCOPY varchar2
55 );
56
57 procedure Tab_Delete_Lock(
58 p_obj_id IN number
59 ,x_return_status OUT NOCOPY varchar2
60 ,x_msg_count OUT NOCOPY number
61 ,x_msg_data OUT NOCOPY varchar2
62 );
63
64 procedure Tab_Select_Items_Lock(
65 p_obj_id IN number
66 ,x_return_status OUT NOCOPY varchar2
67 ,x_msg_count OUT NOCOPY number
68 ,x_msg_data OUT NOCOPY varchar2
69 );
70
71 procedure Kpi_Lock(
72 p_obj_id number
73 ,x_return_status OUT NOCOPY varchar2
74 ,x_msg_count OUT NOCOPY number
75 ,x_msg_data OUT NOCOPY varchar2
76 );
77
78 procedure Option_Lock(
79 p_obj_id IN number
80 ,p_obj_id2 IN number
81 ,p_obj_id3 IN number
82 ,x_return_status OUT NOCOPY varchar2
83 ,x_msg_count OUT NOCOPY number
84 ,x_msg_data OUT NOCOPY varchar2
85 );
86
87 procedure Dim_Level_Lock(
88 p_obj_id IN number
89 ,p_obj_shortName IN varchar2
90 ,x_return_status OUT NOCOPY varchar2
91 ,x_msg_count OUT NOCOPY number
92 ,x_msg_data OUT NOCOPY varchar2
93 );
94
95
96 end BSC_MULTI_USER_PVT;