DBA Data[Home] [Help]

APPS.PJI_MT_MEASURES_PKG dependencies on PJI_MT_MEASURES_B

Line 9: p_measure_id IN pji_mt_measures_b.measure_id%TYPE,

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:

Line 10: p_OBJECT_VERSION_NUMBER IN pji_mt_measures_b.OBJECT_VERSION_NUMBER%TYPE

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: -- -----------------------------------------------------------------------

Line 17: p_measure_id IN pji_mt_measures_b.measure_id%TYPE

13:
14: -- -----------------------------------------------------------------------
15:
16: procedure DELETE_ROW (
17: p_measure_id IN pji_mt_measures_b.measure_id%TYPE
18: );
19:
20:
21: -- -----------------------------------------------------------------------

Line 27: X_measure_id IN pji_mt_measures_b.measure_id%type,

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,

Line 29: X_measure_set_code IN pji_mt_measures_b.measure_set_code%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,

Line 30: X_measure_code IN pji_mt_measures_b.measure_code%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:

Line 31: X_xtd_type IN pji_mt_measures_b.xtd_type%type,

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,

Line 32: X_pl_sql_api IN pji_mt_measures_b.pl_sql_api%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,

Line 33: X_object_version_number IN pji_mt_measures_b.object_version_number%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:

Line 38: X_last_update_date IN pji_mt_measures_b.last_update_date%Type,

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,

Line 39: X_last_updated_by IN pji_mt_measures_b.last_updated_by%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:

Line 40: X_creation_date IN pji_mt_measures_b.creation_date%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:
44: X_return_status OUT NOCOPY VARCHAR2,

Line 41: X_created_by IN pji_mt_measures_b.created_by%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,
45: X_msg_data OUT NOCOPY VARCHAR2,

Line 42: X_last_update_login IN pji_mt_measures_b.last_update_login%Type,

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

Line 54: X_measure_id IN pji_mt_measures_b.measure_id%type,

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,

Line 56: X_measure_set_code IN pji_mt_measures_b.measure_set_code%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,

Line 57: X_measure_code IN pji_mt_measures_b.measure_code%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:

Line 58: X_xtd_type IN pji_mt_measures_b.xtd_type%type,

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,

Line 59: X_pl_sql_api IN pji_mt_measures_b.pl_sql_api%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,

Line 60: X_object_version_number IN pji_mt_measures_b.object_version_number%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:

Line 65: X_last_update_date IN pji_mt_measures_b.last_update_date%Type,

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,

Line 66: X_last_updated_by IN pji_mt_measures_b.last_updated_by%Type,

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

Line 67: X_last_update_login IN pji_mt_measures_b.last_update_login%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
71: );

Line 78: X_measure_id IN pji_mt_measures_b.measure_id%type,

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,

Line 79: X_measure_set_code IN pji_mt_measures_b.measure_set_code%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,

Line 80: X_measure_code IN pji_mt_measures_b.measure_code%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:

Line 81: X_xtd_type IN pji_mt_measures_b.xtd_type%type,

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,

Line 82: X_pl_sql_api IN pji_mt_measures_b.pl_sql_api%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,

Line 83: X_object_version_number IN pji_mt_measures_b.object_version_number%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:

Line 101: X_measure_id IN pji_mt_measures_b.measure_id%type,

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: