PACKAGE: APPS.BSC_UPDATE_LOCK

Source

1 PACKAGE BSC_UPDATE_LOCK AS
2 /* $Header: BSCDLCKS.pls 120.0 2005/06/01 16:22:00 appldev noship $ */
3 
4 
5 FUNCTION Lock_AW_Indicator_Cubes(
6     x_indicator IN NUMBER
7 ) RETURN BOOLEAN;
8 
9 FUNCTION Lock_Calendar (
10     x_calendar_id IN NUMBER
11 ) RETURN BOOLEAN;
12 
13 FUNCTION Lock_Calendar_Change (
14     x_calendar_id IN NUMBER
15 ) RETURN BOOLEAN;
16 
17 FUNCTION Lock_Color_Indicator(
18     x_indicator IN NUMBER
19 ) RETURN BOOLEAN;
20 
21 FUNCTION Lock_Color_Indicators(
22     x_indicators IN BSC_UPDATE_UTIL.t_array_of_number,
23     x_num_indicators IN NUMBER
24 ) RETURN BOOLEAN;
25 
26 FUNCTION Lock_DBI_Dimension(
27     x_dim_short_name IN VARCHAR2
28 ) RETURN BOOLEAN;
29 
30 FUNCTION Lock_Import_Dbi_Plans RETURN BOOLEAN;
31 
32 FUNCTION Lock_Import_ITable(
33     x_input_table IN VARCHAR2
34 ) RETURN BOOLEAN;
35 
36 FUNCTION Lock_Incremental_Indicators RETURN BOOLEAN;
37 
38 FUNCTION Lock_Indicators (
39     x_input_tables IN BSC_UPDATE_UTIL.t_array_of_varchar2,
40     x_num_input_tables IN NUMBER
41 ) RETURN BOOLEAN;
42 
43 FUNCTION Lock_Indicators_by_Calendar (
44     x_calendars IN BSC_UPDATE_UTIL.t_array_of_number,
45     x_num_calendars IN NUMBER
46 ) RETURN BOOLEAN;
47 
48 FUNCTION Lock_Indicators_To_Delete (
49     x_indicators IN BSC_UPDATE_UTIL.t_array_of_number,
50     x_num_indicators IN NUMBER
51 ) RETURN BOOLEAN;
52 
53 FUNCTION Lock_Load_Dimension_Table (
54     x_dim_table IN VARCHAR2,
55     x_input_table IN VARCHAR2
56 ) RETURN BOOLEAN;
57 
58 FUNCTION Lock_Period_Indicator(
59     x_indicator IN NUMBER
60 ) RETURN BOOLEAN;
61 
62 FUNCTION Lock_Period_Indicators(
63     x_indicators IN BSC_UPDATE_UTIL.t_array_of_number,
64     x_num_indicators IN NUMBER
65 ) RETURN BOOLEAN;
66 
67 FUNCTION Lock_Period_Indicators(
68     x_table_name IN VARCHAR2
69 ) RETURN BOOLEAN;
70 
71 FUNCTION Lock_Prototype_Indicator(
72     x_indicator IN NUMBER
73 ) RETURN BOOLEAN;
74 
75 FUNCTION Lock_Prototype_Indicators(
76     x_calendar_id IN NUMBER
77 ) RETURN BOOLEAN;
78 
79 FUNCTION Lock_Prototype_Indicators
80 RETURN BOOLEAN;
81 
82 FUNCTION Lock_Refresh_AW_Indicator(
83     x_indicator IN NUMBER
84 ) RETURN BOOLEAN;
85 
86 FUNCTION Lock_Refresh_AW_Table(
87     x_summary_table IN VARCHAR2
88 ) RETURN BOOLEAN;
89 
90 FUNCTION Lock_Refresh_MV(
91     x_summary_table IN VARCHAR2
92 ) RETURN BOOLEAN;
93 
94 FUNCTION Lock_Refresh_Sum_Table(
95     x_summary_table IN VARCHAR2
96 ) RETURN BOOLEAN;
97 
98 FUNCTION Lock_Update_Base_Table(
99     x_input_table IN VARCHAR2,
100     x_base_table IN VARCHAR2
101 ) RETURN BOOLEAN;
102 
103 FUNCTION Lock_Update_Date RETURN BOOLEAN;
104 
105 FUNCTION Lock_Table(
106     x_table IN VARCHAR2
107 ) RETURN BOOLEAN;
108 
109 FUNCTION Lock_Tables(
110     x_tables IN BSC_UPDATE_UTIL.t_array_of_varchar2,
111     x_num_tables IN NUMBER
112 ) RETURN BOOLEAN;
113 
114 FUNCTION Lock_Temp_Tables(
115     x_type IN VARCHAR2
116 ) RETURN BOOLEAN;
117 
118 /*===========================================================================+
119 |
120 |   Name:          Request_Lock
121 |
122 |   Description:   This function locks all the given objects. It waits
123 |                  all the time necessary to get all the locks.
124 |
125 +============================================================================*/
126 FUNCTION Request_Lock (
127     x_object_keys IN BSC_UPDATE_UTIL.t_array_of_varchar2,
128     x_object_types IN BSC_UPDATE_UTIL.t_array_of_varchar2,
129     x_lock_types IN BSC_UPDATE_UTIL.t_array_of_varchar2,
130     x_cascade_levels IN BSC_UPDATE_UTIL.t_array_of_number,
131     x_num_objects IN NUMBER
132 ) RETURN BOOLEAN;
133 
134 END BSC_UPDATE_LOCK;