35: -- {End Of Comments}
36: -- ----------------------------------------------------------------------------
37: Procedure chk_tp_measurement_code
38: (p_effective_date in date
39: ,p_tp_measurement_code in ota_tp_measurement_types.tp_measurement_code%TYPE
40: ,p_business_group_id in ota_tp_measurement_types.business_group_id%TYPE
41: );
42: -- ----------------------------------------------------------------------------
43: -- |----------------------
36: -- ----------------------------------------------------------------------------
37: Procedure chk_tp_measurement_code
38: (p_effective_date in date
39: ,p_tp_measurement_code in ota_tp_measurement_types.tp_measurement_code%TYPE
40: ,p_business_group_id in ota_tp_measurement_types.business_group_id%TYPE
41: );
42: -- ----------------------------------------------------------------------------
43: -- |----------------------
44: -- ----------------------------------------------------------------------------
71: --
72: -- {End Of Comments}
73: -- ----------------------------------------------------------------------------
74: Procedure chk_del_tp_measurement_code
75: (p_tp_measurement_code in ota_tp_measurement_types.tp_measurement_code%TYPE
76: ,p_tp_measurement_type_id in ota_tp_measurement_types.tp_measurement_type_id%TYPE
77: ,p_business_group_id in ota_tp_measurement_types.business_group_id%TYPE
78: );
79: -- ----------------------------------------------------------------------------
72: -- {End Of Comments}
73: -- ----------------------------------------------------------------------------
74: Procedure chk_del_tp_measurement_code
75: (p_tp_measurement_code in ota_tp_measurement_types.tp_measurement_code%TYPE
76: ,p_tp_measurement_type_id in ota_tp_measurement_types.tp_measurement_type_id%TYPE
77: ,p_business_group_id in ota_tp_measurement_types.business_group_id%TYPE
78: );
79: -- ----------------------------------------------------------------------------
80: -- |--------------------------------
73: -- ----------------------------------------------------------------------------
74: Procedure chk_del_tp_measurement_code
75: (p_tp_measurement_code in ota_tp_measurement_types.tp_measurement_code%TYPE
76: ,p_tp_measurement_type_id in ota_tp_measurement_types.tp_measurement_type_id%TYPE
77: ,p_business_group_id in ota_tp_measurement_types.business_group_id%TYPE
78: );
79: -- ----------------------------------------------------------------------------
80: -- |--------------------------------
81: -- ----------------------------------------------------------------------------
109: -- {End Of Comments}
110: -- ----------------------------------------------------------------------------
111: Procedure chk_unit
112: (p_effective_date in date
113: ,p_unit in ota_tp_measurement_types.unit%TYPE
114: ,p_business_group_id in ota_tp_measurement_types.business_group_id%TYPE
115: ,p_object_version_number in ota_tp_measurement_types.object_version_number%TYPE
116: ,p_tp_measurement_type_id in ota_tp_measurement_types.tp_measurement_type_id%TYPE
117: );
110: -- ----------------------------------------------------------------------------
111: Procedure chk_unit
112: (p_effective_date in date
113: ,p_unit in ota_tp_measurement_types.unit%TYPE
114: ,p_business_group_id in ota_tp_measurement_types.business_group_id%TYPE
115: ,p_object_version_number in ota_tp_measurement_types.object_version_number%TYPE
116: ,p_tp_measurement_type_id in ota_tp_measurement_types.tp_measurement_type_id%TYPE
117: );
118: -- ----------------------------------------------------------------------------
111: Procedure chk_unit
112: (p_effective_date in date
113: ,p_unit in ota_tp_measurement_types.unit%TYPE
114: ,p_business_group_id in ota_tp_measurement_types.business_group_id%TYPE
115: ,p_object_version_number in ota_tp_measurement_types.object_version_number%TYPE
116: ,p_tp_measurement_type_id in ota_tp_measurement_types.tp_measurement_type_id%TYPE
117: );
118: -- ----------------------------------------------------------------------------
119: -- |--------------------------------
112: (p_effective_date in date
113: ,p_unit in ota_tp_measurement_types.unit%TYPE
114: ,p_business_group_id in ota_tp_measurement_types.business_group_id%TYPE
115: ,p_object_version_number in ota_tp_measurement_types.object_version_number%TYPE
116: ,p_tp_measurement_type_id in ota_tp_measurement_types.tp_measurement_type_id%TYPE
117: );
118: -- ----------------------------------------------------------------------------
119: -- |--------------------------------
120: -- ----------------------------------------------------------------------------
150: -- {End Of Comments}
151: -- ----------------------------------------------------------------------------
152: Procedure chk_budget_level
153: (p_effective_date in date
154: ,p_business_group_id in ota_tp_measurement_types.business_group_id%TYPE
155: ,p_budget_level in ota_tp_measurement_types.budget_level%TYPE
156: ,p_tp_measurement_code in ota_tp_measurement_types.tp_measurement_code%TYPE
157: ,p_object_version_number in ota_tp_measurement_types.object_version_number%TYPE
158: ,p_tp_measurement_type_id in ota_tp_measurement_types.tp_measurement_type_id%TYPE
151: -- ----------------------------------------------------------------------------
152: Procedure chk_budget_level
153: (p_effective_date in date
154: ,p_business_group_id in ota_tp_measurement_types.business_group_id%TYPE
155: ,p_budget_level in ota_tp_measurement_types.budget_level%TYPE
156: ,p_tp_measurement_code in ota_tp_measurement_types.tp_measurement_code%TYPE
157: ,p_object_version_number in ota_tp_measurement_types.object_version_number%TYPE
158: ,p_tp_measurement_type_id in ota_tp_measurement_types.tp_measurement_type_id%TYPE
159: );
152: Procedure chk_budget_level
153: (p_effective_date in date
154: ,p_business_group_id in ota_tp_measurement_types.business_group_id%TYPE
155: ,p_budget_level in ota_tp_measurement_types.budget_level%TYPE
156: ,p_tp_measurement_code in ota_tp_measurement_types.tp_measurement_code%TYPE
157: ,p_object_version_number in ota_tp_measurement_types.object_version_number%TYPE
158: ,p_tp_measurement_type_id in ota_tp_measurement_types.tp_measurement_type_id%TYPE
159: );
160: -- ----------------------------------------------------------------------------
153: (p_effective_date in date
154: ,p_business_group_id in ota_tp_measurement_types.business_group_id%TYPE
155: ,p_budget_level in ota_tp_measurement_types.budget_level%TYPE
156: ,p_tp_measurement_code in ota_tp_measurement_types.tp_measurement_code%TYPE
157: ,p_object_version_number in ota_tp_measurement_types.object_version_number%TYPE
158: ,p_tp_measurement_type_id in ota_tp_measurement_types.tp_measurement_type_id%TYPE
159: );
160: -- ----------------------------------------------------------------------------
161: -- |--------------------------------
154: ,p_business_group_id in ota_tp_measurement_types.business_group_id%TYPE
155: ,p_budget_level in ota_tp_measurement_types.budget_level%TYPE
156: ,p_tp_measurement_code in ota_tp_measurement_types.tp_measurement_code%TYPE
157: ,p_object_version_number in ota_tp_measurement_types.object_version_number%TYPE
158: ,p_tp_measurement_type_id in ota_tp_measurement_types.tp_measurement_type_id%TYPE
159: );
160: -- ----------------------------------------------------------------------------
161: -- |--------------------------------
162: -- ----------------------------------------------------------------------------
188: --
189: -- {End Of Comments}
190: -- ----------------------------------------------------------------------------
191: Procedure chk_budget_cost_combination
192: (p_budget_level in ota_tp_measurement_types.budget_level%TYPE
193: ,p_cost_level in ota_tp_measurement_types.cost_level%TYPE
194: ,p_object_version_number in ota_tp_measurement_types.object_version_number%TYPE
195: ,p_tp_measurement_type_id in ota_tp_measurement_types.tp_measurement_type_id%TYPE
196: );
189: -- {End Of Comments}
190: -- ----------------------------------------------------------------------------
191: Procedure chk_budget_cost_combination
192: (p_budget_level in ota_tp_measurement_types.budget_level%TYPE
193: ,p_cost_level in ota_tp_measurement_types.cost_level%TYPE
194: ,p_object_version_number in ota_tp_measurement_types.object_version_number%TYPE
195: ,p_tp_measurement_type_id in ota_tp_measurement_types.tp_measurement_type_id%TYPE
196: );
197: -- ----------------------------------------------------------------------------
190: -- ----------------------------------------------------------------------------
191: Procedure chk_budget_cost_combination
192: (p_budget_level in ota_tp_measurement_types.budget_level%TYPE
193: ,p_cost_level in ota_tp_measurement_types.cost_level%TYPE
194: ,p_object_version_number in ota_tp_measurement_types.object_version_number%TYPE
195: ,p_tp_measurement_type_id in ota_tp_measurement_types.tp_measurement_type_id%TYPE
196: );
197: -- ----------------------------------------------------------------------------
198: -- |--------------------------------
191: Procedure chk_budget_cost_combination
192: (p_budget_level in ota_tp_measurement_types.budget_level%TYPE
193: ,p_cost_level in ota_tp_measurement_types.cost_level%TYPE
194: ,p_object_version_number in ota_tp_measurement_types.object_version_number%TYPE
195: ,p_tp_measurement_type_id in ota_tp_measurement_types.tp_measurement_type_id%TYPE
196: );
197: -- ----------------------------------------------------------------------------
198: -- |--------------------------------
199: -- ----------------------------------------------------------------------------
228: -- {End Of Comments}
229: -- ----------------------------------------------------------------------------
230: Procedure chk_cost_level
231: (p_effective_date in date
232: ,p_business_group_id in ota_tp_measurement_types.business_group_id%TYPE
233: ,p_cost_level in ota_tp_measurement_types.cost_level%TYPE
234: ,p_object_version_number in ota_tp_measurement_types.object_version_number%TYPE
235: ,p_tp_measurement_type_id in ota_tp_measurement_types.tp_measurement_type_id%TYPE
236: );
229: -- ----------------------------------------------------------------------------
230: Procedure chk_cost_level
231: (p_effective_date in date
232: ,p_business_group_id in ota_tp_measurement_types.business_group_id%TYPE
233: ,p_cost_level in ota_tp_measurement_types.cost_level%TYPE
234: ,p_object_version_number in ota_tp_measurement_types.object_version_number%TYPE
235: ,p_tp_measurement_type_id in ota_tp_measurement_types.tp_measurement_type_id%TYPE
236: );
237: -- ----------------------------------------------------------------------------
230: Procedure chk_cost_level
231: (p_effective_date in date
232: ,p_business_group_id in ota_tp_measurement_types.business_group_id%TYPE
233: ,p_cost_level in ota_tp_measurement_types.cost_level%TYPE
234: ,p_object_version_number in ota_tp_measurement_types.object_version_number%TYPE
235: ,p_tp_measurement_type_id in ota_tp_measurement_types.tp_measurement_type_id%TYPE
236: );
237: -- ----------------------------------------------------------------------------
238: -- |-----------------------
231: (p_effective_date in date
232: ,p_business_group_id in ota_tp_measurement_types.business_group_id%TYPE
233: ,p_cost_level in ota_tp_measurement_types.cost_level%TYPE
234: ,p_object_version_number in ota_tp_measurement_types.object_version_number%TYPE
235: ,p_tp_measurement_type_id in ota_tp_measurement_types.tp_measurement_type_id%TYPE
236: );
237: -- ----------------------------------------------------------------------------
238: -- |-----------------------
239: -- ----------------------------------------------------------------------------
268: -- {End Of Comments}
269: -- ----------------------------------------------------------------------------
270: Procedure chk_many_budget_values_flag
271: (p_effective_date in date
272: ,p_business_group_id in ota_tp_measurement_types.business_group_id%TYPE
273: ,p_many_budget_values_flag in ota_tp_measurement_types.many_budget_values_flag%TYPE
274: ,p_tp_measurement_code in ota_tp_measurement_types.tp_measurement_code%TYPE
275: ,p_object_version_number in ota_tp_measurement_types.object_version_number%TYPE
276: ,p_tp_measurement_type_id in ota_tp_measurement_types.tp_measurement_type_id%TYPE
269: -- ----------------------------------------------------------------------------
270: Procedure chk_many_budget_values_flag
271: (p_effective_date in date
272: ,p_business_group_id in ota_tp_measurement_types.business_group_id%TYPE
273: ,p_many_budget_values_flag in ota_tp_measurement_types.many_budget_values_flag%TYPE
274: ,p_tp_measurement_code in ota_tp_measurement_types.tp_measurement_code%TYPE
275: ,p_object_version_number in ota_tp_measurement_types.object_version_number%TYPE
276: ,p_tp_measurement_type_id in ota_tp_measurement_types.tp_measurement_type_id%TYPE
277: );
270: Procedure chk_many_budget_values_flag
271: (p_effective_date in date
272: ,p_business_group_id in ota_tp_measurement_types.business_group_id%TYPE
273: ,p_many_budget_values_flag in ota_tp_measurement_types.many_budget_values_flag%TYPE
274: ,p_tp_measurement_code in ota_tp_measurement_types.tp_measurement_code%TYPE
275: ,p_object_version_number in ota_tp_measurement_types.object_version_number%TYPE
276: ,p_tp_measurement_type_id in ota_tp_measurement_types.tp_measurement_type_id%TYPE
277: );
278: -- ----------------------------------------------------------------------------
271: (p_effective_date in date
272: ,p_business_group_id in ota_tp_measurement_types.business_group_id%TYPE
273: ,p_many_budget_values_flag in ota_tp_measurement_types.many_budget_values_flag%TYPE
274: ,p_tp_measurement_code in ota_tp_measurement_types.tp_measurement_code%TYPE
275: ,p_object_version_number in ota_tp_measurement_types.object_version_number%TYPE
276: ,p_tp_measurement_type_id in ota_tp_measurement_types.tp_measurement_type_id%TYPE
277: );
278: -- ----------------------------------------------------------------------------
279: -- |-----------------------
272: ,p_business_group_id in ota_tp_measurement_types.business_group_id%TYPE
273: ,p_many_budget_values_flag in ota_tp_measurement_types.many_budget_values_flag%TYPE
274: ,p_tp_measurement_code in ota_tp_measurement_types.tp_measurement_code%TYPE
275: ,p_object_version_number in ota_tp_measurement_types.object_version_number%TYPE
276: ,p_tp_measurement_type_id in ota_tp_measurement_types.tp_measurement_type_id%TYPE
277: );
278: -- ----------------------------------------------------------------------------
279: -- |-----------------------
280: -- ----------------------------------------------------------------------------
306: --
307: -- {End Of Comments}
308: -- ----------------------------------------------------------------------------
309: Procedure chk_item_type_usage_id
310: (p_item_type_usage_id in ota_tp_measurement_types.item_type_usage_id%TYPE
311: ,p_business_group_id in ota_tp_measurement_types.business_group_id%TYPE
312: ,p_object_version_number in ota_tp_measurement_types.object_version_number%TYPE
313: ,p_tp_measurement_type_id in ota_tp_measurement_types.tp_measurement_type_id%TYPE
314: );
307: -- {End Of Comments}
308: -- ----------------------------------------------------------------------------
309: Procedure chk_item_type_usage_id
310: (p_item_type_usage_id in ota_tp_measurement_types.item_type_usage_id%TYPE
311: ,p_business_group_id in ota_tp_measurement_types.business_group_id%TYPE
312: ,p_object_version_number in ota_tp_measurement_types.object_version_number%TYPE
313: ,p_tp_measurement_type_id in ota_tp_measurement_types.tp_measurement_type_id%TYPE
314: );
315: -- ----------------------------------------------------------------------------
308: -- ----------------------------------------------------------------------------
309: Procedure chk_item_type_usage_id
310: (p_item_type_usage_id in ota_tp_measurement_types.item_type_usage_id%TYPE
311: ,p_business_group_id in ota_tp_measurement_types.business_group_id%TYPE
312: ,p_object_version_number in ota_tp_measurement_types.object_version_number%TYPE
313: ,p_tp_measurement_type_id in ota_tp_measurement_types.tp_measurement_type_id%TYPE
314: );
315: -- ----------------------------------------------------------------------------
316: -- |----------------------
309: Procedure chk_item_type_usage_id
310: (p_item_type_usage_id in ota_tp_measurement_types.item_type_usage_id%TYPE
311: ,p_business_group_id in ota_tp_measurement_types.business_group_id%TYPE
312: ,p_object_version_number in ota_tp_measurement_types.object_version_number%TYPE
313: ,p_tp_measurement_type_id in ota_tp_measurement_types.tp_measurement_type_id%TYPE
314: );
315: -- ----------------------------------------------------------------------------
316: -- |----------------------
317: -- ----------------------------------------------------------------------------
342: --
343: -- {End Of Comments}
344: -- ----------------------------------------------------------------------------
345: Procedure chk_del_tp_measurement_type_id
346: (p_tp_measurement_type_id in ota_tp_measurement_types.tp_measurement_type_id%TYPE
347: );
348: -- ----------------------------------------------------------------------------
349: -- |----------------------
350: -- ----------------------------------------------------------------------------
377: -- {End Of Comments}
378: -- ----------------------------------------------------------------------------
379: Procedure chk_legislative_setup(
380: p_legislation_code in per_business_groups.legislation_code%TYPE
381: ,p_tp_measurement_code in ota_tp_measurement_types.tp_measurement_code%TYPE
382: ,p_unit in ota_tp_measurement_types.unit%TYPE
383: ,p_budget_level in ota_tp_measurement_types.budget_level%TYPE
384: ,p_cost_level in ota_tp_measurement_types.cost_level%TYPE
385: ,p_many_budget_values_flag in ota_tp_measurement_types.many_budget_values_flag%TYPE
378: -- ----------------------------------------------------------------------------
379: Procedure chk_legislative_setup(
380: p_legislation_code in per_business_groups.legislation_code%TYPE
381: ,p_tp_measurement_code in ota_tp_measurement_types.tp_measurement_code%TYPE
382: ,p_unit in ota_tp_measurement_types.unit%TYPE
383: ,p_budget_level in ota_tp_measurement_types.budget_level%TYPE
384: ,p_cost_level in ota_tp_measurement_types.cost_level%TYPE
385: ,p_many_budget_values_flag in ota_tp_measurement_types.many_budget_values_flag%TYPE
386: ,p_object_version_number in ota_tp_measurement_types.object_version_number%TYPE
379: Procedure chk_legislative_setup(
380: p_legislation_code in per_business_groups.legislation_code%TYPE
381: ,p_tp_measurement_code in ota_tp_measurement_types.tp_measurement_code%TYPE
382: ,p_unit in ota_tp_measurement_types.unit%TYPE
383: ,p_budget_level in ota_tp_measurement_types.budget_level%TYPE
384: ,p_cost_level in ota_tp_measurement_types.cost_level%TYPE
385: ,p_many_budget_values_flag in ota_tp_measurement_types.many_budget_values_flag%TYPE
386: ,p_object_version_number in ota_tp_measurement_types.object_version_number%TYPE
387: ,p_tp_measurement_type_id in ota_tp_measurement_types.tp_measurement_type_id%TYPE
380: p_legislation_code in per_business_groups.legislation_code%TYPE
381: ,p_tp_measurement_code in ota_tp_measurement_types.tp_measurement_code%TYPE
382: ,p_unit in ota_tp_measurement_types.unit%TYPE
383: ,p_budget_level in ota_tp_measurement_types.budget_level%TYPE
384: ,p_cost_level in ota_tp_measurement_types.cost_level%TYPE
385: ,p_many_budget_values_flag in ota_tp_measurement_types.many_budget_values_flag%TYPE
386: ,p_object_version_number in ota_tp_measurement_types.object_version_number%TYPE
387: ,p_tp_measurement_type_id in ota_tp_measurement_types.tp_measurement_type_id%TYPE
388: );
381: ,p_tp_measurement_code in ota_tp_measurement_types.tp_measurement_code%TYPE
382: ,p_unit in ota_tp_measurement_types.unit%TYPE
383: ,p_budget_level in ota_tp_measurement_types.budget_level%TYPE
384: ,p_cost_level in ota_tp_measurement_types.cost_level%TYPE
385: ,p_many_budget_values_flag in ota_tp_measurement_types.many_budget_values_flag%TYPE
386: ,p_object_version_number in ota_tp_measurement_types.object_version_number%TYPE
387: ,p_tp_measurement_type_id in ota_tp_measurement_types.tp_measurement_type_id%TYPE
388: );
389: end ota_tmt_bus1;
382: ,p_unit in ota_tp_measurement_types.unit%TYPE
383: ,p_budget_level in ota_tp_measurement_types.budget_level%TYPE
384: ,p_cost_level in ota_tp_measurement_types.cost_level%TYPE
385: ,p_many_budget_values_flag in ota_tp_measurement_types.many_budget_values_flag%TYPE
386: ,p_object_version_number in ota_tp_measurement_types.object_version_number%TYPE
387: ,p_tp_measurement_type_id in ota_tp_measurement_types.tp_measurement_type_id%TYPE
388: );
389: end ota_tmt_bus1;
383: ,p_budget_level in ota_tp_measurement_types.budget_level%TYPE
384: ,p_cost_level in ota_tp_measurement_types.cost_level%TYPE
385: ,p_many_budget_values_flag in ota_tp_measurement_types.many_budget_values_flag%TYPE
386: ,p_object_version_number in ota_tp_measurement_types.object_version_number%TYPE
387: ,p_tp_measurement_type_id in ota_tp_measurement_types.tp_measurement_type_id%TYPE
388: );
389: end ota_tmt_bus1;