5: -- -----------------------------------------------------------------------
6: -- -----------------------------------------------------------------------
7:
8: procedure LOCK_ROW (
9: p_measure_id IN pji_mt_measures_b.measure_id%TYPE,
10: p_OBJECT_VERSION_NUMBER IN pji_mt_measures_b.OBJECT_VERSION_NUMBER%TYPE
11: );
12:
13:
6: -- -----------------------------------------------------------------------
7:
8: procedure LOCK_ROW (
9: p_measure_id IN pji_mt_measures_b.measure_id%TYPE,
10: p_OBJECT_VERSION_NUMBER IN pji_mt_measures_b.OBJECT_VERSION_NUMBER%TYPE
11: );
12:
13:
14: -- -----------------------------------------------------------------------
13:
14: -- -----------------------------------------------------------------------
15:
16: procedure DELETE_ROW (
17: p_measure_id IN pji_mt_measures_b.measure_id%TYPE
18: );
19:
20:
21: -- -----------------------------------------------------------------------
23: procedure INSERT_ROW (
24:
25: X_rowid IN OUT NOCOPY rowid,
26:
27: X_measure_id IN pji_mt_measures_b.measure_id%type,
28:
29: X_measure_set_code IN pji_mt_measures_b.measure_set_code%type,
30: X_measure_code IN pji_mt_measures_b.measure_code%type,
31: X_xtd_type IN pji_mt_measures_b.xtd_type%type,
25: X_rowid IN OUT NOCOPY rowid,
26:
27: X_measure_id IN pji_mt_measures_b.measure_id%type,
28:
29: X_measure_set_code IN pji_mt_measures_b.measure_set_code%type,
30: X_measure_code IN pji_mt_measures_b.measure_code%type,
31: X_xtd_type IN pji_mt_measures_b.xtd_type%type,
32: X_pl_sql_api IN pji_mt_measures_b.pl_sql_api%type,
33: X_object_version_number IN pji_mt_measures_b.object_version_number%type,
26:
27: X_measure_id IN pji_mt_measures_b.measure_id%type,
28:
29: X_measure_set_code IN pji_mt_measures_b.measure_set_code%type,
30: X_measure_code IN pji_mt_measures_b.measure_code%type,
31: X_xtd_type IN pji_mt_measures_b.xtd_type%type,
32: X_pl_sql_api IN pji_mt_measures_b.pl_sql_api%type,
33: X_object_version_number IN pji_mt_measures_b.object_version_number%type,
34:
27: X_measure_id IN pji_mt_measures_b.measure_id%type,
28:
29: X_measure_set_code IN pji_mt_measures_b.measure_set_code%type,
30: X_measure_code IN pji_mt_measures_b.measure_code%type,
31: X_xtd_type IN pji_mt_measures_b.xtd_type%type,
32: X_pl_sql_api IN pji_mt_measures_b.pl_sql_api%type,
33: X_object_version_number IN pji_mt_measures_b.object_version_number%type,
34:
35: X_name IN pji_mt_measures_tl.name%type,
28:
29: X_measure_set_code IN pji_mt_measures_b.measure_set_code%type,
30: X_measure_code IN pji_mt_measures_b.measure_code%type,
31: X_xtd_type IN pji_mt_measures_b.xtd_type%type,
32: X_pl_sql_api IN pji_mt_measures_b.pl_sql_api%type,
33: X_object_version_number IN pji_mt_measures_b.object_version_number%type,
34:
35: X_name IN pji_mt_measures_tl.name%type,
36: X_description IN pji_mt_measures_tl.description%type,
29: X_measure_set_code IN pji_mt_measures_b.measure_set_code%type,
30: X_measure_code IN pji_mt_measures_b.measure_code%type,
31: X_xtd_type IN pji_mt_measures_b.xtd_type%type,
32: X_pl_sql_api IN pji_mt_measures_b.pl_sql_api%type,
33: X_object_version_number IN pji_mt_measures_b.object_version_number%type,
34:
35: X_name IN pji_mt_measures_tl.name%type,
36: X_description IN pji_mt_measures_tl.description%type,
37:
34:
35: X_name IN pji_mt_measures_tl.name%type,
36: X_description IN pji_mt_measures_tl.description%type,
37:
38: X_last_update_date IN pji_mt_measures_b.last_update_date%Type,
39: X_last_updated_by IN pji_mt_measures_b.last_updated_by%Type,
40: X_creation_date IN pji_mt_measures_b.creation_date%Type,
41: X_created_by IN pji_mt_measures_b.created_by%Type,
42: X_last_update_login IN pji_mt_measures_b.last_update_login%Type,
35: X_name IN pji_mt_measures_tl.name%type,
36: X_description IN pji_mt_measures_tl.description%type,
37:
38: X_last_update_date IN pji_mt_measures_b.last_update_date%Type,
39: X_last_updated_by IN pji_mt_measures_b.last_updated_by%Type,
40: X_creation_date IN pji_mt_measures_b.creation_date%Type,
41: X_created_by IN pji_mt_measures_b.created_by%Type,
42: X_last_update_login IN pji_mt_measures_b.last_update_login%Type,
43:
36: X_description IN pji_mt_measures_tl.description%type,
37:
38: X_last_update_date IN pji_mt_measures_b.last_update_date%Type,
39: X_last_updated_by IN pji_mt_measures_b.last_updated_by%Type,
40: X_creation_date IN pji_mt_measures_b.creation_date%Type,
41: X_created_by IN pji_mt_measures_b.created_by%Type,
42: X_last_update_login IN pji_mt_measures_b.last_update_login%Type,
43:
44: X_return_status OUT NOCOPY VARCHAR2,
37:
38: X_last_update_date IN pji_mt_measures_b.last_update_date%Type,
39: X_last_updated_by IN pji_mt_measures_b.last_updated_by%Type,
40: X_creation_date IN pji_mt_measures_b.creation_date%Type,
41: X_created_by IN pji_mt_measures_b.created_by%Type,
42: X_last_update_login IN pji_mt_measures_b.last_update_login%Type,
43:
44: X_return_status OUT NOCOPY VARCHAR2,
45: X_msg_data OUT NOCOPY VARCHAR2,
38: X_last_update_date IN pji_mt_measures_b.last_update_date%Type,
39: X_last_updated_by IN pji_mt_measures_b.last_updated_by%Type,
40: X_creation_date IN pji_mt_measures_b.creation_date%Type,
41: X_created_by IN pji_mt_measures_b.created_by%Type,
42: X_last_update_login IN pji_mt_measures_b.last_update_login%Type,
43:
44: X_return_status OUT NOCOPY VARCHAR2,
45: X_msg_data OUT NOCOPY VARCHAR2,
46: X_msg_count OUT NOCOPY NUMBER
50: -- -----------------------------------------------------------------------
51:
52: procedure UPDATE_ROW (
53:
54: X_measure_id IN pji_mt_measures_b.measure_id%type,
55:
56: X_measure_set_code IN pji_mt_measures_b.measure_set_code%type,
57: X_measure_code IN pji_mt_measures_b.measure_code%type,
58: X_xtd_type IN pji_mt_measures_b.xtd_type%type,
52: procedure UPDATE_ROW (
53:
54: X_measure_id IN pji_mt_measures_b.measure_id%type,
55:
56: X_measure_set_code IN pji_mt_measures_b.measure_set_code%type,
57: X_measure_code IN pji_mt_measures_b.measure_code%type,
58: X_xtd_type IN pji_mt_measures_b.xtd_type%type,
59: X_pl_sql_api IN pji_mt_measures_b.pl_sql_api%type,
60: X_object_version_number IN pji_mt_measures_b.object_version_number%type,
53:
54: X_measure_id IN pji_mt_measures_b.measure_id%type,
55:
56: X_measure_set_code IN pji_mt_measures_b.measure_set_code%type,
57: X_measure_code IN pji_mt_measures_b.measure_code%type,
58: X_xtd_type IN pji_mt_measures_b.xtd_type%type,
59: X_pl_sql_api IN pji_mt_measures_b.pl_sql_api%type,
60: X_object_version_number IN pji_mt_measures_b.object_version_number%type,
61:
54: X_measure_id IN pji_mt_measures_b.measure_id%type,
55:
56: X_measure_set_code IN pji_mt_measures_b.measure_set_code%type,
57: X_measure_code IN pji_mt_measures_b.measure_code%type,
58: X_xtd_type IN pji_mt_measures_b.xtd_type%type,
59: X_pl_sql_api IN pji_mt_measures_b.pl_sql_api%type,
60: X_object_version_number IN pji_mt_measures_b.object_version_number%type,
61:
62: X_name IN pji_mt_measures_tl.name%type,
55:
56: X_measure_set_code IN pji_mt_measures_b.measure_set_code%type,
57: X_measure_code IN pji_mt_measures_b.measure_code%type,
58: X_xtd_type IN pji_mt_measures_b.xtd_type%type,
59: X_pl_sql_api IN pji_mt_measures_b.pl_sql_api%type,
60: X_object_version_number IN pji_mt_measures_b.object_version_number%type,
61:
62: X_name IN pji_mt_measures_tl.name%type,
63: X_description IN pji_mt_measures_tl.description%type,
56: X_measure_set_code IN pji_mt_measures_b.measure_set_code%type,
57: X_measure_code IN pji_mt_measures_b.measure_code%type,
58: X_xtd_type IN pji_mt_measures_b.xtd_type%type,
59: X_pl_sql_api IN pji_mt_measures_b.pl_sql_api%type,
60: X_object_version_number IN pji_mt_measures_b.object_version_number%type,
61:
62: X_name IN pji_mt_measures_tl.name%type,
63: X_description IN pji_mt_measures_tl.description%type,
64:
61:
62: X_name IN pji_mt_measures_tl.name%type,
63: X_description IN pji_mt_measures_tl.description%type,
64:
65: X_last_update_date IN pji_mt_measures_b.last_update_date%Type,
66: X_last_updated_by IN pji_mt_measures_b.last_updated_by%Type,
67: X_last_update_login IN pji_mt_measures_b.last_update_login%Type,
68: X_return_status OUT NOCOPY VARCHAR2,
69: X_msg_data OUT NOCOPY VARCHAR2,
62: X_name IN pji_mt_measures_tl.name%type,
63: X_description IN pji_mt_measures_tl.description%type,
64:
65: X_last_update_date IN pji_mt_measures_b.last_update_date%Type,
66: X_last_updated_by IN pji_mt_measures_b.last_updated_by%Type,
67: X_last_update_login IN pji_mt_measures_b.last_update_login%Type,
68: X_return_status OUT NOCOPY VARCHAR2,
69: X_msg_data OUT NOCOPY VARCHAR2,
70: X_msg_count OUT NOCOPY NUMBER
63: X_description IN pji_mt_measures_tl.description%type,
64:
65: X_last_update_date IN pji_mt_measures_b.last_update_date%Type,
66: X_last_updated_by IN pji_mt_measures_b.last_updated_by%Type,
67: X_last_update_login IN pji_mt_measures_b.last_update_login%Type,
68: X_return_status OUT NOCOPY VARCHAR2,
69: X_msg_data OUT NOCOPY VARCHAR2,
70: X_msg_count OUT NOCOPY NUMBER
71: );
74: -- -----------------------------------------------------------------------
75:
76: procedure LOAD_ROW (
77:
78: X_measure_id IN pji_mt_measures_b.measure_id%type,
79: X_measure_set_code IN pji_mt_measures_b.measure_set_code%type,
80: X_measure_code IN pji_mt_measures_b.measure_code%type,
81: X_xtd_type IN pji_mt_measures_b.xtd_type%type,
82: X_pl_sql_api IN pji_mt_measures_b.pl_sql_api%type,
75:
76: procedure LOAD_ROW (
77:
78: X_measure_id IN pji_mt_measures_b.measure_id%type,
79: X_measure_set_code IN pji_mt_measures_b.measure_set_code%type,
80: X_measure_code IN pji_mt_measures_b.measure_code%type,
81: X_xtd_type IN pji_mt_measures_b.xtd_type%type,
82: X_pl_sql_api IN pji_mt_measures_b.pl_sql_api%type,
83: X_object_version_number IN pji_mt_measures_b.object_version_number%type,
76: procedure LOAD_ROW (
77:
78: X_measure_id IN pji_mt_measures_b.measure_id%type,
79: X_measure_set_code IN pji_mt_measures_b.measure_set_code%type,
80: X_measure_code IN pji_mt_measures_b.measure_code%type,
81: X_xtd_type IN pji_mt_measures_b.xtd_type%type,
82: X_pl_sql_api IN pji_mt_measures_b.pl_sql_api%type,
83: X_object_version_number IN pji_mt_measures_b.object_version_number%type,
84:
77:
78: X_measure_id IN pji_mt_measures_b.measure_id%type,
79: X_measure_set_code IN pji_mt_measures_b.measure_set_code%type,
80: X_measure_code IN pji_mt_measures_b.measure_code%type,
81: X_xtd_type IN pji_mt_measures_b.xtd_type%type,
82: X_pl_sql_api IN pji_mt_measures_b.pl_sql_api%type,
83: X_object_version_number IN pji_mt_measures_b.object_version_number%type,
84:
85: X_name IN pji_mt_measures_tl.name%type,
78: X_measure_id IN pji_mt_measures_b.measure_id%type,
79: X_measure_set_code IN pji_mt_measures_b.measure_set_code%type,
80: X_measure_code IN pji_mt_measures_b.measure_code%type,
81: X_xtd_type IN pji_mt_measures_b.xtd_type%type,
82: X_pl_sql_api IN pji_mt_measures_b.pl_sql_api%type,
83: X_object_version_number IN pji_mt_measures_b.object_version_number%type,
84:
85: X_name IN pji_mt_measures_tl.name%type,
86: X_description IN pji_mt_measures_tl.description%type,
79: X_measure_set_code IN pji_mt_measures_b.measure_set_code%type,
80: X_measure_code IN pji_mt_measures_b.measure_code%type,
81: X_xtd_type IN pji_mt_measures_b.xtd_type%type,
82: X_pl_sql_api IN pji_mt_measures_b.pl_sql_api%type,
83: X_object_version_number IN pji_mt_measures_b.object_version_number%type,
84:
85: X_name IN pji_mt_measures_tl.name%type,
86: X_description IN pji_mt_measures_tl.description%type,
87:
97: -- -----------------------------------------------------------------------
98:
99: procedure TRANSLATE_ROW (
100:
101: X_measure_id IN pji_mt_measures_b.measure_id%type,
102:
103: X_name IN pji_mt_measures_tl.name%type,
104: X_description IN pji_mt_measures_tl.description%type,
105: