eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OTA_TMT_BUS1 dependencies on OTA_TP_MEASUREMENT_TYPES

Line 17: ,p_tp_measurement_code in ota_tp_measurement_types.tp_measurement_code%TYPE

13: -- ----------------------------------------------------------------------------
14: --
15: Procedure chk_tp_measurement_code
16: (p_effective_date in date
17: ,p_tp_measurement_code in ota_tp_measurement_types.tp_measurement_code%TYPE
18: ,p_business_group_id in ota_tp_measurement_types.business_group_id%TYPE
19: ) is
20: --
21: l_exists varchar2(1);

Line 18: ,p_business_group_id in ota_tp_measurement_types.business_group_id%TYPE

14: --
15: Procedure chk_tp_measurement_code
16: (p_effective_date in date
17: ,p_tp_measurement_code in ota_tp_measurement_types.tp_measurement_code%TYPE
18: ,p_business_group_id in ota_tp_measurement_types.business_group_id%TYPE
19: ) is
20: --
21: l_exists varchar2(1);
22: l_proc varchar2(72) := g_package||'chk_tp_measurement_code';

Line 26: from OTA_TP_MEASUREMENT_TYPES

22: l_proc varchar2(72) := g_package||'chk_tp_measurement_code';
23: --
24: cursor csr_tp_measurement_code is
25: select null
26: from OTA_TP_MEASUREMENT_TYPES
27: where tp_measurement_code = p_tp_measurement_code
28: and business_group_id = p_business_group_id;
29: Begin
30: --

Line 86: (p_tp_measurement_code in ota_tp_measurement_types.tp_measurement_code%TYPE

82: -- ----------------------------------------------------------------------------
83: -- |---------------------------------------------|
84: -- ----------------------------------------------------------------------------
85: Procedure chk_del_tp_measurement_code
86: (p_tp_measurement_code in ota_tp_measurement_types.tp_measurement_code%TYPE
87: ,p_tp_measurement_type_id in ota_tp_measurement_types.tp_measurement_type_id%TYPE
88: ,p_business_group_id in ota_tp_measurement_types.business_group_id%TYPE
89: ) is
90: --

Line 87: ,p_tp_measurement_type_id in ota_tp_measurement_types.tp_measurement_type_id%TYPE

83: -- |---------------------------------------------|
84: -- ----------------------------------------------------------------------------
85: Procedure chk_del_tp_measurement_code
86: (p_tp_measurement_code in ota_tp_measurement_types.tp_measurement_code%TYPE
87: ,p_tp_measurement_type_id in ota_tp_measurement_types.tp_measurement_type_id%TYPE
88: ,p_business_group_id in ota_tp_measurement_types.business_group_id%TYPE
89: ) is
90: --
91: l_exists varchar2(1);

Line 88: ,p_business_group_id in ota_tp_measurement_types.business_group_id%TYPE

84: -- ----------------------------------------------------------------------------
85: Procedure chk_del_tp_measurement_code
86: (p_tp_measurement_code in ota_tp_measurement_types.tp_measurement_code%TYPE
87: ,p_tp_measurement_type_id in ota_tp_measurement_types.tp_measurement_type_id%TYPE
88: ,p_business_group_id in ota_tp_measurement_types.business_group_id%TYPE
89: ) is
90: --
91: l_exists varchar2(1);
92: l_proc varchar2(72) := g_package||'chk_del_tp_measurement_code';

Line 153: ,p_unit in ota_tp_measurement_types.unit%TYPE

149: -- |----------------------------------------------------------------|
150: -- ----------------------------------------------------------------------------
151: Procedure chk_unit
152: (p_effective_date in date
153: ,p_unit in ota_tp_measurement_types.unit%TYPE
154: ,p_business_group_id in ota_tp_measurement_types.business_group_id%TYPE
155: ,p_object_version_number in ota_tp_measurement_types.object_version_number%TYPE
156: ,p_tp_measurement_type_id in ota_tp_measurement_types.tp_measurement_type_id%TYPE
157: ) is

Line 154: ,p_business_group_id in ota_tp_measurement_types.business_group_id%TYPE

150: -- ----------------------------------------------------------------------------
151: Procedure chk_unit
152: (p_effective_date in date
153: ,p_unit in ota_tp_measurement_types.unit%TYPE
154: ,p_business_group_id in ota_tp_measurement_types.business_group_id%TYPE
155: ,p_object_version_number in ota_tp_measurement_types.object_version_number%TYPE
156: ,p_tp_measurement_type_id in ota_tp_measurement_types.tp_measurement_type_id%TYPE
157: ) is
158: --

Line 155: ,p_object_version_number in ota_tp_measurement_types.object_version_number%TYPE

151: Procedure chk_unit
152: (p_effective_date in date
153: ,p_unit in ota_tp_measurement_types.unit%TYPE
154: ,p_business_group_id in ota_tp_measurement_types.business_group_id%TYPE
155: ,p_object_version_number in ota_tp_measurement_types.object_version_number%TYPE
156: ,p_tp_measurement_type_id in ota_tp_measurement_types.tp_measurement_type_id%TYPE
157: ) is
158: --
159: l_exists varchar2(1);

Line 156: ,p_tp_measurement_type_id in ota_tp_measurement_types.tp_measurement_type_id%TYPE

152: (p_effective_date in date
153: ,p_unit in ota_tp_measurement_types.unit%TYPE
154: ,p_business_group_id in ota_tp_measurement_types.business_group_id%TYPE
155: ,p_object_version_number in ota_tp_measurement_types.object_version_number%TYPE
156: ,p_tp_measurement_type_id in ota_tp_measurement_types.tp_measurement_type_id%TYPE
157: ) is
158: --
159: l_exists varchar2(1);
160: l_proc varchar2(72) := g_package||'chk_unit';

Line 252: ,p_business_group_id in ota_tp_measurement_types.business_group_id%TYPE

248: -- |---------------------------------------------------------|
249: -- ----------------------------------------------------------------------------
250: Procedure chk_budget_level
251: (p_effective_date in date
252: ,p_business_group_id in ota_tp_measurement_types.business_group_id%TYPE
253: ,p_budget_level in ota_tp_measurement_types.budget_level%TYPE
254: ,p_tp_measurement_code in ota_tp_measurement_types.tp_measurement_code%TYPE
255: ,p_object_version_number in ota_tp_measurement_types.object_version_number%TYPE
256: ,p_tp_measurement_type_id in ota_tp_measurement_types.tp_measurement_type_id%TYPE

Line 253: ,p_budget_level in ota_tp_measurement_types.budget_level%TYPE

249: -- ----------------------------------------------------------------------------
250: Procedure chk_budget_level
251: (p_effective_date in date
252: ,p_business_group_id in ota_tp_measurement_types.business_group_id%TYPE
253: ,p_budget_level in ota_tp_measurement_types.budget_level%TYPE
254: ,p_tp_measurement_code in ota_tp_measurement_types.tp_measurement_code%TYPE
255: ,p_object_version_number in ota_tp_measurement_types.object_version_number%TYPE
256: ,p_tp_measurement_type_id in ota_tp_measurement_types.tp_measurement_type_id%TYPE
257: ) is

Line 254: ,p_tp_measurement_code in ota_tp_measurement_types.tp_measurement_code%TYPE

250: Procedure chk_budget_level
251: (p_effective_date in date
252: ,p_business_group_id in ota_tp_measurement_types.business_group_id%TYPE
253: ,p_budget_level in ota_tp_measurement_types.budget_level%TYPE
254: ,p_tp_measurement_code in ota_tp_measurement_types.tp_measurement_code%TYPE
255: ,p_object_version_number in ota_tp_measurement_types.object_version_number%TYPE
256: ,p_tp_measurement_type_id in ota_tp_measurement_types.tp_measurement_type_id%TYPE
257: ) is
258: --

Line 255: ,p_object_version_number in ota_tp_measurement_types.object_version_number%TYPE

251: (p_effective_date in date
252: ,p_business_group_id in ota_tp_measurement_types.business_group_id%TYPE
253: ,p_budget_level in ota_tp_measurement_types.budget_level%TYPE
254: ,p_tp_measurement_code in ota_tp_measurement_types.tp_measurement_code%TYPE
255: ,p_object_version_number in ota_tp_measurement_types.object_version_number%TYPE
256: ,p_tp_measurement_type_id in ota_tp_measurement_types.tp_measurement_type_id%TYPE
257: ) is
258: --
259: l_exists varchar2(1);

Line 256: ,p_tp_measurement_type_id in ota_tp_measurement_types.tp_measurement_type_id%TYPE

252: ,p_business_group_id in ota_tp_measurement_types.business_group_id%TYPE
253: ,p_budget_level in ota_tp_measurement_types.budget_level%TYPE
254: ,p_tp_measurement_code in ota_tp_measurement_types.tp_measurement_code%TYPE
255: ,p_object_version_number in ota_tp_measurement_types.object_version_number%TYPE
256: ,p_tp_measurement_type_id in ota_tp_measurement_types.tp_measurement_type_id%TYPE
257: ) is
258: --
259: l_exists varchar2(1);
260: l_proc varchar2(72) := g_package||'chk_budget_level';

Line 359: (p_budget_level in ota_tp_measurement_types.budget_level%TYPE

355: -- ----------------------------------------------------------------------------
356: -- |----------------------------------------------|
357: -- ----------------------------------------------------------------------------
358: Procedure chk_budget_cost_combination
359: (p_budget_level in ota_tp_measurement_types.budget_level%TYPE
360: ,p_cost_level in ota_tp_measurement_types.cost_level%TYPE
361: ,p_object_version_number in ota_tp_measurement_types.object_version_number%TYPE
362: ,p_tp_measurement_type_id in ota_tp_measurement_types.tp_measurement_type_id%TYPE
363: ) is

Line 360: ,p_cost_level in ota_tp_measurement_types.cost_level%TYPE

356: -- |----------------------------------------------|
357: -- ----------------------------------------------------------------------------
358: Procedure chk_budget_cost_combination
359: (p_budget_level in ota_tp_measurement_types.budget_level%TYPE
360: ,p_cost_level in ota_tp_measurement_types.cost_level%TYPE
361: ,p_object_version_number in ota_tp_measurement_types.object_version_number%TYPE
362: ,p_tp_measurement_type_id in ota_tp_measurement_types.tp_measurement_type_id%TYPE
363: ) is
364: --

Line 361: ,p_object_version_number in ota_tp_measurement_types.object_version_number%TYPE

357: -- ----------------------------------------------------------------------------
358: Procedure chk_budget_cost_combination
359: (p_budget_level in ota_tp_measurement_types.budget_level%TYPE
360: ,p_cost_level in ota_tp_measurement_types.cost_level%TYPE
361: ,p_object_version_number in ota_tp_measurement_types.object_version_number%TYPE
362: ,p_tp_measurement_type_id in ota_tp_measurement_types.tp_measurement_type_id%TYPE
363: ) is
364: --
365: l_exists varchar2(1);

Line 362: ,p_tp_measurement_type_id in ota_tp_measurement_types.tp_measurement_type_id%TYPE

358: Procedure chk_budget_cost_combination
359: (p_budget_level in ota_tp_measurement_types.budget_level%TYPE
360: ,p_cost_level in ota_tp_measurement_types.cost_level%TYPE
361: ,p_object_version_number in ota_tp_measurement_types.object_version_number%TYPE
362: ,p_tp_measurement_type_id in ota_tp_measurement_types.tp_measurement_type_id%TYPE
363: ) is
364: --
365: l_exists varchar2(1);
366: l_proc varchar2(72) := g_package||'chk_budget_cost_combination';

Line 425: ,p_business_group_id in ota_tp_measurement_types.business_group_id%TYPE

421: -- |-----------------------------------------------------------|
422: -- ----------------------------------------------------------------------------
423: Procedure chk_cost_level
424: (p_effective_date in date
425: ,p_business_group_id in ota_tp_measurement_types.business_group_id%TYPE
426: ,p_cost_level in ota_tp_measurement_types.cost_level%TYPE
427: ,p_object_version_number in ota_tp_measurement_types.object_version_number%TYPE
428: ,p_tp_measurement_type_id in ota_tp_measurement_types.tp_measurement_type_id%TYPE
429: ) is

Line 426: ,p_cost_level in ota_tp_measurement_types.cost_level%TYPE

422: -- ----------------------------------------------------------------------------
423: Procedure chk_cost_level
424: (p_effective_date in date
425: ,p_business_group_id in ota_tp_measurement_types.business_group_id%TYPE
426: ,p_cost_level in ota_tp_measurement_types.cost_level%TYPE
427: ,p_object_version_number in ota_tp_measurement_types.object_version_number%TYPE
428: ,p_tp_measurement_type_id in ota_tp_measurement_types.tp_measurement_type_id%TYPE
429: ) is
430: --

Line 427: ,p_object_version_number in ota_tp_measurement_types.object_version_number%TYPE

423: Procedure chk_cost_level
424: (p_effective_date in date
425: ,p_business_group_id in ota_tp_measurement_types.business_group_id%TYPE
426: ,p_cost_level in ota_tp_measurement_types.cost_level%TYPE
427: ,p_object_version_number in ota_tp_measurement_types.object_version_number%TYPE
428: ,p_tp_measurement_type_id in ota_tp_measurement_types.tp_measurement_type_id%TYPE
429: ) is
430: --
431: l_exists varchar2(1);

Line 428: ,p_tp_measurement_type_id in ota_tp_measurement_types.tp_measurement_type_id%TYPE

424: (p_effective_date in date
425: ,p_business_group_id in ota_tp_measurement_types.business_group_id%TYPE
426: ,p_cost_level in ota_tp_measurement_types.cost_level%TYPE
427: ,p_object_version_number in ota_tp_measurement_types.object_version_number%TYPE
428: ,p_tp_measurement_type_id in ota_tp_measurement_types.tp_measurement_type_id%TYPE
429: ) is
430: --
431: l_exists varchar2(1);
432: l_proc varchar2(72) := g_package||'chk_cost_level';

Line 520: ,p_business_group_id in ota_tp_measurement_types.business_group_id%TYPE

516: -- |----------------------------------------------|
517: -- ----------------------------------------------------------------------------
518: Procedure chk_many_budget_values_flag
519: (p_effective_date in date
520: ,p_business_group_id in ota_tp_measurement_types.business_group_id%TYPE
521: ,p_many_budget_values_flag in ota_tp_measurement_types.many_budget_values_flag%TYPE
522: ,p_tp_measurement_code in ota_tp_measurement_types.tp_measurement_code%TYPE
523: ,p_object_version_number in ota_tp_measurement_types.object_version_number%TYPE
524: ,p_tp_measurement_type_id in ota_tp_measurement_types.tp_measurement_type_id%TYPE

Line 521: ,p_many_budget_values_flag in ota_tp_measurement_types.many_budget_values_flag%TYPE

517: -- ----------------------------------------------------------------------------
518: Procedure chk_many_budget_values_flag
519: (p_effective_date in date
520: ,p_business_group_id in ota_tp_measurement_types.business_group_id%TYPE
521: ,p_many_budget_values_flag in ota_tp_measurement_types.many_budget_values_flag%TYPE
522: ,p_tp_measurement_code in ota_tp_measurement_types.tp_measurement_code%TYPE
523: ,p_object_version_number in ota_tp_measurement_types.object_version_number%TYPE
524: ,p_tp_measurement_type_id in ota_tp_measurement_types.tp_measurement_type_id%TYPE
525: ) is

Line 522: ,p_tp_measurement_code in ota_tp_measurement_types.tp_measurement_code%TYPE

518: Procedure chk_many_budget_values_flag
519: (p_effective_date in date
520: ,p_business_group_id in ota_tp_measurement_types.business_group_id%TYPE
521: ,p_many_budget_values_flag in ota_tp_measurement_types.many_budget_values_flag%TYPE
522: ,p_tp_measurement_code in ota_tp_measurement_types.tp_measurement_code%TYPE
523: ,p_object_version_number in ota_tp_measurement_types.object_version_number%TYPE
524: ,p_tp_measurement_type_id in ota_tp_measurement_types.tp_measurement_type_id%TYPE
525: ) is
526: --

Line 523: ,p_object_version_number in ota_tp_measurement_types.object_version_number%TYPE

519: (p_effective_date in date
520: ,p_business_group_id in ota_tp_measurement_types.business_group_id%TYPE
521: ,p_many_budget_values_flag in ota_tp_measurement_types.many_budget_values_flag%TYPE
522: ,p_tp_measurement_code in ota_tp_measurement_types.tp_measurement_code%TYPE
523: ,p_object_version_number in ota_tp_measurement_types.object_version_number%TYPE
524: ,p_tp_measurement_type_id in ota_tp_measurement_types.tp_measurement_type_id%TYPE
525: ) is
526: --
527: l_exists varchar2(1);

Line 524: ,p_tp_measurement_type_id in ota_tp_measurement_types.tp_measurement_type_id%TYPE

520: ,p_business_group_id in ota_tp_measurement_types.business_group_id%TYPE
521: ,p_many_budget_values_flag in ota_tp_measurement_types.many_budget_values_flag%TYPE
522: ,p_tp_measurement_code in ota_tp_measurement_types.tp_measurement_code%TYPE
523: ,p_object_version_number in ota_tp_measurement_types.object_version_number%TYPE
524: ,p_tp_measurement_type_id in ota_tp_measurement_types.tp_measurement_type_id%TYPE
525: ) is
526: --
527: l_exists varchar2(1);
528: l_proc varchar2(72) := g_package||'chk_many_budget_values_flag';

Line 631: (p_item_type_usage_id in ota_tp_measurement_types.item_type_usage_id%TYPE

627: -- ----------------------------------------------------------------------------
628: -- |--------------------------------------------------|
629: -- ----------------------------------------------------------------------------
630: Procedure chk_item_type_usage_id
631: (p_item_type_usage_id in ota_tp_measurement_types.item_type_usage_id%TYPE
632: ,p_business_group_id in ota_tp_measurement_types.business_group_id%TYPE
633: ,p_object_version_number in ota_tp_measurement_types.object_version_number%TYPE
634: ,p_tp_measurement_type_id in ota_tp_measurement_types.tp_measurement_type_id%TYPE
635: ) is

Line 632: ,p_business_group_id in ota_tp_measurement_types.business_group_id%TYPE

628: -- |--------------------------------------------------|
629: -- ----------------------------------------------------------------------------
630: Procedure chk_item_type_usage_id
631: (p_item_type_usage_id in ota_tp_measurement_types.item_type_usage_id%TYPE
632: ,p_business_group_id in ota_tp_measurement_types.business_group_id%TYPE
633: ,p_object_version_number in ota_tp_measurement_types.object_version_number%TYPE
634: ,p_tp_measurement_type_id in ota_tp_measurement_types.tp_measurement_type_id%TYPE
635: ) is
636: --

Line 633: ,p_object_version_number in ota_tp_measurement_types.object_version_number%TYPE

629: -- ----------------------------------------------------------------------------
630: Procedure chk_item_type_usage_id
631: (p_item_type_usage_id in ota_tp_measurement_types.item_type_usage_id%TYPE
632: ,p_business_group_id in ota_tp_measurement_types.business_group_id%TYPE
633: ,p_object_version_number in ota_tp_measurement_types.object_version_number%TYPE
634: ,p_tp_measurement_type_id in ota_tp_measurement_types.tp_measurement_type_id%TYPE
635: ) is
636: --
637: l_exists varchar2(1);

Line 634: ,p_tp_measurement_type_id in ota_tp_measurement_types.tp_measurement_type_id%TYPE

630: Procedure chk_item_type_usage_id
631: (p_item_type_usage_id in ota_tp_measurement_types.item_type_usage_id%TYPE
632: ,p_business_group_id in ota_tp_measurement_types.business_group_id%TYPE
633: ,p_object_version_number in ota_tp_measurement_types.object_version_number%TYPE
634: ,p_tp_measurement_type_id in ota_tp_measurement_types.tp_measurement_type_id%TYPE
635: ) is
636: --
637: l_exists varchar2(1);
638: l_proc varchar2(72) := g_package||'chk_item_type_usage_id';

Line 695: (p_tp_measurement_type_id in ota_tp_measurement_types.tp_measurement_type_id%TYPE

691: -- ----------------------------------------------------------------------------
692: -- |------------------------------------------|
693: -- ----------------------------------------------------------------------------
694: Procedure chk_del_tp_measurement_type_id
695: (p_tp_measurement_type_id in ota_tp_measurement_types.tp_measurement_type_id%TYPE
696: ) is
697: --
698: l_exists varchar2(1);
699: l_proc varchar2(72) := g_package||'chk_del_tp_measurement_type_id';

Line 736: ,p_tp_measurement_code in ota_tp_measurement_types.tp_measurement_code%TYPE

732: -- |---------------------------------------------------|
733: -- ----------------------------------------------------------------------------
734: Procedure chk_legislative_setup(
735: p_legislation_code in per_business_groups.legislation_code%TYPE
736: ,p_tp_measurement_code in ota_tp_measurement_types.tp_measurement_code%TYPE
737: ,p_unit in ota_tp_measurement_types.unit%TYPE
738: ,p_budget_level in ota_tp_measurement_types.budget_level%TYPE
739: ,p_cost_level in ota_tp_measurement_types.cost_level%TYPE
740: ,p_many_budget_values_flag in ota_tp_measurement_types.many_budget_values_flag%TYPE

Line 737: ,p_unit in ota_tp_measurement_types.unit%TYPE

733: -- ----------------------------------------------------------------------------
734: Procedure chk_legislative_setup(
735: p_legislation_code in per_business_groups.legislation_code%TYPE
736: ,p_tp_measurement_code in ota_tp_measurement_types.tp_measurement_code%TYPE
737: ,p_unit in ota_tp_measurement_types.unit%TYPE
738: ,p_budget_level in ota_tp_measurement_types.budget_level%TYPE
739: ,p_cost_level in ota_tp_measurement_types.cost_level%TYPE
740: ,p_many_budget_values_flag in ota_tp_measurement_types.many_budget_values_flag%TYPE
741: ,p_object_version_number in ota_tp_measurement_types.object_version_number%TYPE

Line 738: ,p_budget_level in ota_tp_measurement_types.budget_level%TYPE

734: Procedure chk_legislative_setup(
735: p_legislation_code in per_business_groups.legislation_code%TYPE
736: ,p_tp_measurement_code in ota_tp_measurement_types.tp_measurement_code%TYPE
737: ,p_unit in ota_tp_measurement_types.unit%TYPE
738: ,p_budget_level in ota_tp_measurement_types.budget_level%TYPE
739: ,p_cost_level in ota_tp_measurement_types.cost_level%TYPE
740: ,p_many_budget_values_flag in ota_tp_measurement_types.many_budget_values_flag%TYPE
741: ,p_object_version_number in ota_tp_measurement_types.object_version_number%TYPE
742: ,p_tp_measurement_type_id in ota_tp_measurement_types.tp_measurement_type_id%TYPE

Line 739: ,p_cost_level in ota_tp_measurement_types.cost_level%TYPE

735: p_legislation_code in per_business_groups.legislation_code%TYPE
736: ,p_tp_measurement_code in ota_tp_measurement_types.tp_measurement_code%TYPE
737: ,p_unit in ota_tp_measurement_types.unit%TYPE
738: ,p_budget_level in ota_tp_measurement_types.budget_level%TYPE
739: ,p_cost_level in ota_tp_measurement_types.cost_level%TYPE
740: ,p_many_budget_values_flag in ota_tp_measurement_types.many_budget_values_flag%TYPE
741: ,p_object_version_number in ota_tp_measurement_types.object_version_number%TYPE
742: ,p_tp_measurement_type_id in ota_tp_measurement_types.tp_measurement_type_id%TYPE
743: ) is

Line 740: ,p_many_budget_values_flag in ota_tp_measurement_types.many_budget_values_flag%TYPE

736: ,p_tp_measurement_code in ota_tp_measurement_types.tp_measurement_code%TYPE
737: ,p_unit in ota_tp_measurement_types.unit%TYPE
738: ,p_budget_level in ota_tp_measurement_types.budget_level%TYPE
739: ,p_cost_level in ota_tp_measurement_types.cost_level%TYPE
740: ,p_many_budget_values_flag in ota_tp_measurement_types.many_budget_values_flag%TYPE
741: ,p_object_version_number in ota_tp_measurement_types.object_version_number%TYPE
742: ,p_tp_measurement_type_id in ota_tp_measurement_types.tp_measurement_type_id%TYPE
743: ) is
744: --

Line 741: ,p_object_version_number in ota_tp_measurement_types.object_version_number%TYPE

737: ,p_unit in ota_tp_measurement_types.unit%TYPE
738: ,p_budget_level in ota_tp_measurement_types.budget_level%TYPE
739: ,p_cost_level in ota_tp_measurement_types.cost_level%TYPE
740: ,p_many_budget_values_flag in ota_tp_measurement_types.many_budget_values_flag%TYPE
741: ,p_object_version_number in ota_tp_measurement_types.object_version_number%TYPE
742: ,p_tp_measurement_type_id in ota_tp_measurement_types.tp_measurement_type_id%TYPE
743: ) is
744: --
745: l_exists varchar2(1);

Line 742: ,p_tp_measurement_type_id in ota_tp_measurement_types.tp_measurement_type_id%TYPE

738: ,p_budget_level in ota_tp_measurement_types.budget_level%TYPE
739: ,p_cost_level in ota_tp_measurement_types.cost_level%TYPE
740: ,p_many_budget_values_flag in ota_tp_measurement_types.many_budget_values_flag%TYPE
741: ,p_object_version_number in ota_tp_measurement_types.object_version_number%TYPE
742: ,p_tp_measurement_type_id in ota_tp_measurement_types.tp_measurement_type_id%TYPE
743: ) is
744: --
745: l_exists varchar2(1);
746: l_proc varchar2(72) := g_package||'chk_legislative_setup';