1: PACKAGE oke_k_user_attributes_pub AUTHID CURRENT_USER AS
2: /* $Header: OKEPUATS.pls 120.0.12020000.2 2013/02/22 06:58:21 ansraj noship $ */
3: g_pkg_name CONSTANT VARCHAR2 (200) := 'OKE_K_USER_ATTRIBUTES_PUB';
4: g_module CONSTANT VARCHAR2 (200) := 'oke.plsql.' || g_pkg_name || '.';
5: g_app_name CONSTANT VARCHAR2 (200) := oke_api.g_app_name;
1: PACKAGE oke_k_user_attributes_pub AUTHID CURRENT_USER AS
2: /* $Header: OKEPUATS.pls 120.0.12020000.2 2013/02/22 06:58:21 ansraj noship $ */
3: g_pkg_name CONSTANT VARCHAR2 (200) := 'OKE_K_USER_ATTRIBUTES_PUB';
4: g_module CONSTANT VARCHAR2 (200) := 'oke.plsql.' || g_pkg_name || '.';
5: g_app_name CONSTANT VARCHAR2 (200) := oke_api.g_app_name;
6:
7: TYPE k_user_attributes_rec_type IS RECORD (
4: g_module CONSTANT VARCHAR2 (200) := 'oke.plsql.' || g_pkg_name || '.';
5: g_app_name CONSTANT VARCHAR2 (200) := oke_api.g_app_name;
6:
7: TYPE k_user_attributes_rec_type IS RECORD (
8: k_user_attribute_id oke_k_user_attributes.k_user_attribute_id%TYPE
9: := oke_api.g_miss_num,
10: creation_date oke_k_user_attributes.creation_date%TYPE
11: := oke_api.g_miss_date,
12: created_by oke_k_user_attributes.created_by%TYPE
6:
7: TYPE k_user_attributes_rec_type IS RECORD (
8: k_user_attribute_id oke_k_user_attributes.k_user_attribute_id%TYPE
9: := oke_api.g_miss_num,
10: creation_date oke_k_user_attributes.creation_date%TYPE
11: := oke_api.g_miss_date,
12: created_by oke_k_user_attributes.created_by%TYPE
13: := oke_api.g_miss_num,
14: last_update_date oke_k_user_attributes.last_update_date%TYPE
8: k_user_attribute_id oke_k_user_attributes.k_user_attribute_id%TYPE
9: := oke_api.g_miss_num,
10: creation_date oke_k_user_attributes.creation_date%TYPE
11: := oke_api.g_miss_date,
12: created_by oke_k_user_attributes.created_by%TYPE
13: := oke_api.g_miss_num,
14: last_update_date oke_k_user_attributes.last_update_date%TYPE
15: := oke_api.g_miss_date,
16: last_updated_by oke_k_user_attributes.last_updated_by%TYPE
10: creation_date oke_k_user_attributes.creation_date%TYPE
11: := oke_api.g_miss_date,
12: created_by oke_k_user_attributes.created_by%TYPE
13: := oke_api.g_miss_num,
14: last_update_date oke_k_user_attributes.last_update_date%TYPE
15: := oke_api.g_miss_date,
16: last_updated_by oke_k_user_attributes.last_updated_by%TYPE
17: := oke_api.g_miss_num,
18: last_update_login oke_k_user_attributes.last_update_login%TYPE
12: created_by oke_k_user_attributes.created_by%TYPE
13: := oke_api.g_miss_num,
14: last_update_date oke_k_user_attributes.last_update_date%TYPE
15: := oke_api.g_miss_date,
16: last_updated_by oke_k_user_attributes.last_updated_by%TYPE
17: := oke_api.g_miss_num,
18: last_update_login oke_k_user_attributes.last_update_login%TYPE
19: := oke_api.g_miss_num,
20: record_version_number oke_k_user_attributes.record_version_number%TYPE
14: last_update_date oke_k_user_attributes.last_update_date%TYPE
15: := oke_api.g_miss_date,
16: last_updated_by oke_k_user_attributes.last_updated_by%TYPE
17: := oke_api.g_miss_num,
18: last_update_login oke_k_user_attributes.last_update_login%TYPE
19: := oke_api.g_miss_num,
20: record_version_number oke_k_user_attributes.record_version_number%TYPE
21: := oke_api.g_miss_num,
22: k_header_id oke_k_user_attributes.k_header_id%TYPE
16: last_updated_by oke_k_user_attributes.last_updated_by%TYPE
17: := oke_api.g_miss_num,
18: last_update_login oke_k_user_attributes.last_update_login%TYPE
19: := oke_api.g_miss_num,
20: record_version_number oke_k_user_attributes.record_version_number%TYPE
21: := oke_api.g_miss_num,
22: k_header_id oke_k_user_attributes.k_header_id%TYPE
23: := oke_api.g_miss_num,
24: k_line_id oke_k_user_attributes.k_line_id%TYPE
18: last_update_login oke_k_user_attributes.last_update_login%TYPE
19: := oke_api.g_miss_num,
20: record_version_number oke_k_user_attributes.record_version_number%TYPE
21: := oke_api.g_miss_num,
22: k_header_id oke_k_user_attributes.k_header_id%TYPE
23: := oke_api.g_miss_num,
24: k_line_id oke_k_user_attributes.k_line_id%TYPE
25: := oke_api.g_miss_num,
26: user_attribute_context oke_k_user_attributes.user_attribute_context%TYPE
20: record_version_number oke_k_user_attributes.record_version_number%TYPE
21: := oke_api.g_miss_num,
22: k_header_id oke_k_user_attributes.k_header_id%TYPE
23: := oke_api.g_miss_num,
24: k_line_id oke_k_user_attributes.k_line_id%TYPE
25: := oke_api.g_miss_num,
26: user_attribute_context oke_k_user_attributes.user_attribute_context%TYPE
27: := oke_api.g_miss_char,
28: user_attribute01 oke_k_user_attributes.user_attribute01%TYPE
22: k_header_id oke_k_user_attributes.k_header_id%TYPE
23: := oke_api.g_miss_num,
24: k_line_id oke_k_user_attributes.k_line_id%TYPE
25: := oke_api.g_miss_num,
26: user_attribute_context oke_k_user_attributes.user_attribute_context%TYPE
27: := oke_api.g_miss_char,
28: user_attribute01 oke_k_user_attributes.user_attribute01%TYPE
29: := oke_api.g_miss_char,
30: user_attribute02 oke_k_user_attributes.user_attribute02%TYPE
24: k_line_id oke_k_user_attributes.k_line_id%TYPE
25: := oke_api.g_miss_num,
26: user_attribute_context oke_k_user_attributes.user_attribute_context%TYPE
27: := oke_api.g_miss_char,
28: user_attribute01 oke_k_user_attributes.user_attribute01%TYPE
29: := oke_api.g_miss_char,
30: user_attribute02 oke_k_user_attributes.user_attribute02%TYPE
31: := oke_api.g_miss_char,
32: user_attribute03 oke_k_user_attributes.user_attribute03%TYPE
26: user_attribute_context oke_k_user_attributes.user_attribute_context%TYPE
27: := oke_api.g_miss_char,
28: user_attribute01 oke_k_user_attributes.user_attribute01%TYPE
29: := oke_api.g_miss_char,
30: user_attribute02 oke_k_user_attributes.user_attribute02%TYPE
31: := oke_api.g_miss_char,
32: user_attribute03 oke_k_user_attributes.user_attribute03%TYPE
33: := oke_api.g_miss_char,
34: user_attribute04 oke_k_user_attributes.user_attribute04%TYPE
28: user_attribute01 oke_k_user_attributes.user_attribute01%TYPE
29: := oke_api.g_miss_char,
30: user_attribute02 oke_k_user_attributes.user_attribute02%TYPE
31: := oke_api.g_miss_char,
32: user_attribute03 oke_k_user_attributes.user_attribute03%TYPE
33: := oke_api.g_miss_char,
34: user_attribute04 oke_k_user_attributes.user_attribute04%TYPE
35: := oke_api.g_miss_char,
36: user_attribute05 oke_k_user_attributes.user_attribute05%TYPE
30: user_attribute02 oke_k_user_attributes.user_attribute02%TYPE
31: := oke_api.g_miss_char,
32: user_attribute03 oke_k_user_attributes.user_attribute03%TYPE
33: := oke_api.g_miss_char,
34: user_attribute04 oke_k_user_attributes.user_attribute04%TYPE
35: := oke_api.g_miss_char,
36: user_attribute05 oke_k_user_attributes.user_attribute05%TYPE
37: := oke_api.g_miss_char,
38: user_attribute06 oke_k_user_attributes.user_attribute06%TYPE
32: user_attribute03 oke_k_user_attributes.user_attribute03%TYPE
33: := oke_api.g_miss_char,
34: user_attribute04 oke_k_user_attributes.user_attribute04%TYPE
35: := oke_api.g_miss_char,
36: user_attribute05 oke_k_user_attributes.user_attribute05%TYPE
37: := oke_api.g_miss_char,
38: user_attribute06 oke_k_user_attributes.user_attribute06%TYPE
39: := oke_api.g_miss_char,
40: user_attribute07 oke_k_user_attributes.user_attribute07%TYPE
34: user_attribute04 oke_k_user_attributes.user_attribute04%TYPE
35: := oke_api.g_miss_char,
36: user_attribute05 oke_k_user_attributes.user_attribute05%TYPE
37: := oke_api.g_miss_char,
38: user_attribute06 oke_k_user_attributes.user_attribute06%TYPE
39: := oke_api.g_miss_char,
40: user_attribute07 oke_k_user_attributes.user_attribute07%TYPE
41: := oke_api.g_miss_char,
42: user_attribute08 oke_k_user_attributes.user_attribute08%TYPE
36: user_attribute05 oke_k_user_attributes.user_attribute05%TYPE
37: := oke_api.g_miss_char,
38: user_attribute06 oke_k_user_attributes.user_attribute06%TYPE
39: := oke_api.g_miss_char,
40: user_attribute07 oke_k_user_attributes.user_attribute07%TYPE
41: := oke_api.g_miss_char,
42: user_attribute08 oke_k_user_attributes.user_attribute08%TYPE
43: := oke_api.g_miss_char,
44: user_attribute09 oke_k_user_attributes.user_attribute09%TYPE
38: user_attribute06 oke_k_user_attributes.user_attribute06%TYPE
39: := oke_api.g_miss_char,
40: user_attribute07 oke_k_user_attributes.user_attribute07%TYPE
41: := oke_api.g_miss_char,
42: user_attribute08 oke_k_user_attributes.user_attribute08%TYPE
43: := oke_api.g_miss_char,
44: user_attribute09 oke_k_user_attributes.user_attribute09%TYPE
45: := oke_api.g_miss_char,
46: user_attribute10 oke_k_user_attributes.user_attribute10%TYPE
40: user_attribute07 oke_k_user_attributes.user_attribute07%TYPE
41: := oke_api.g_miss_char,
42: user_attribute08 oke_k_user_attributes.user_attribute08%TYPE
43: := oke_api.g_miss_char,
44: user_attribute09 oke_k_user_attributes.user_attribute09%TYPE
45: := oke_api.g_miss_char,
46: user_attribute10 oke_k_user_attributes.user_attribute10%TYPE
47: := oke_api.g_miss_char,
48: user_attribute11 oke_k_user_attributes.user_attribute11%TYPE
42: user_attribute08 oke_k_user_attributes.user_attribute08%TYPE
43: := oke_api.g_miss_char,
44: user_attribute09 oke_k_user_attributes.user_attribute09%TYPE
45: := oke_api.g_miss_char,
46: user_attribute10 oke_k_user_attributes.user_attribute10%TYPE
47: := oke_api.g_miss_char,
48: user_attribute11 oke_k_user_attributes.user_attribute11%TYPE
49: := oke_api.g_miss_char,
50: user_attribute12 oke_k_user_attributes.user_attribute12%TYPE
44: user_attribute09 oke_k_user_attributes.user_attribute09%TYPE
45: := oke_api.g_miss_char,
46: user_attribute10 oke_k_user_attributes.user_attribute10%TYPE
47: := oke_api.g_miss_char,
48: user_attribute11 oke_k_user_attributes.user_attribute11%TYPE
49: := oke_api.g_miss_char,
50: user_attribute12 oke_k_user_attributes.user_attribute12%TYPE
51: := oke_api.g_miss_char,
52: user_attribute13 oke_k_user_attributes.user_attribute13%TYPE
46: user_attribute10 oke_k_user_attributes.user_attribute10%TYPE
47: := oke_api.g_miss_char,
48: user_attribute11 oke_k_user_attributes.user_attribute11%TYPE
49: := oke_api.g_miss_char,
50: user_attribute12 oke_k_user_attributes.user_attribute12%TYPE
51: := oke_api.g_miss_char,
52: user_attribute13 oke_k_user_attributes.user_attribute13%TYPE
53: := oke_api.g_miss_char,
54: user_attribute14 oke_k_user_attributes.user_attribute14%TYPE
48: user_attribute11 oke_k_user_attributes.user_attribute11%TYPE
49: := oke_api.g_miss_char,
50: user_attribute12 oke_k_user_attributes.user_attribute12%TYPE
51: := oke_api.g_miss_char,
52: user_attribute13 oke_k_user_attributes.user_attribute13%TYPE
53: := oke_api.g_miss_char,
54: user_attribute14 oke_k_user_attributes.user_attribute14%TYPE
55: := oke_api.g_miss_char,
56: user_attribute15 oke_k_user_attributes.user_attribute15%TYPE
50: user_attribute12 oke_k_user_attributes.user_attribute12%TYPE
51: := oke_api.g_miss_char,
52: user_attribute13 oke_k_user_attributes.user_attribute13%TYPE
53: := oke_api.g_miss_char,
54: user_attribute14 oke_k_user_attributes.user_attribute14%TYPE
55: := oke_api.g_miss_char,
56: user_attribute15 oke_k_user_attributes.user_attribute15%TYPE
57: := oke_api.g_miss_char,
58: user_attribute16 oke_k_user_attributes.user_attribute16%TYPE
52: user_attribute13 oke_k_user_attributes.user_attribute13%TYPE
53: := oke_api.g_miss_char,
54: user_attribute14 oke_k_user_attributes.user_attribute14%TYPE
55: := oke_api.g_miss_char,
56: user_attribute15 oke_k_user_attributes.user_attribute15%TYPE
57: := oke_api.g_miss_char,
58: user_attribute16 oke_k_user_attributes.user_attribute16%TYPE
59: := oke_api.g_miss_char,
60: user_attribute17 oke_k_user_attributes.user_attribute17%TYPE
54: user_attribute14 oke_k_user_attributes.user_attribute14%TYPE
55: := oke_api.g_miss_char,
56: user_attribute15 oke_k_user_attributes.user_attribute15%TYPE
57: := oke_api.g_miss_char,
58: user_attribute16 oke_k_user_attributes.user_attribute16%TYPE
59: := oke_api.g_miss_char,
60: user_attribute17 oke_k_user_attributes.user_attribute17%TYPE
61: := oke_api.g_miss_char,
62: user_attribute18 oke_k_user_attributes.user_attribute18%TYPE
56: user_attribute15 oke_k_user_attributes.user_attribute15%TYPE
57: := oke_api.g_miss_char,
58: user_attribute16 oke_k_user_attributes.user_attribute16%TYPE
59: := oke_api.g_miss_char,
60: user_attribute17 oke_k_user_attributes.user_attribute17%TYPE
61: := oke_api.g_miss_char,
62: user_attribute18 oke_k_user_attributes.user_attribute18%TYPE
63: := oke_api.g_miss_char,
64: user_attribute19 oke_k_user_attributes.user_attribute19%TYPE
58: user_attribute16 oke_k_user_attributes.user_attribute16%TYPE
59: := oke_api.g_miss_char,
60: user_attribute17 oke_k_user_attributes.user_attribute17%TYPE
61: := oke_api.g_miss_char,
62: user_attribute18 oke_k_user_attributes.user_attribute18%TYPE
63: := oke_api.g_miss_char,
64: user_attribute19 oke_k_user_attributes.user_attribute19%TYPE
65: := oke_api.g_miss_char,
66: user_attribute20 oke_k_user_attributes.user_attribute20%TYPE
60: user_attribute17 oke_k_user_attributes.user_attribute17%TYPE
61: := oke_api.g_miss_char,
62: user_attribute18 oke_k_user_attributes.user_attribute18%TYPE
63: := oke_api.g_miss_char,
64: user_attribute19 oke_k_user_attributes.user_attribute19%TYPE
65: := oke_api.g_miss_char,
66: user_attribute20 oke_k_user_attributes.user_attribute20%TYPE
67: := oke_api.g_miss_char,
68: user_attribute21 oke_k_user_attributes.user_attribute21%TYPE
62: user_attribute18 oke_k_user_attributes.user_attribute18%TYPE
63: := oke_api.g_miss_char,
64: user_attribute19 oke_k_user_attributes.user_attribute19%TYPE
65: := oke_api.g_miss_char,
66: user_attribute20 oke_k_user_attributes.user_attribute20%TYPE
67: := oke_api.g_miss_char,
68: user_attribute21 oke_k_user_attributes.user_attribute21%TYPE
69: := oke_api.g_miss_char,
70: user_attribute22 oke_k_user_attributes.user_attribute22%TYPE
64: user_attribute19 oke_k_user_attributes.user_attribute19%TYPE
65: := oke_api.g_miss_char,
66: user_attribute20 oke_k_user_attributes.user_attribute20%TYPE
67: := oke_api.g_miss_char,
68: user_attribute21 oke_k_user_attributes.user_attribute21%TYPE
69: := oke_api.g_miss_char,
70: user_attribute22 oke_k_user_attributes.user_attribute22%TYPE
71: := oke_api.g_miss_char,
72: user_attribute23 oke_k_user_attributes.user_attribute23%TYPE
66: user_attribute20 oke_k_user_attributes.user_attribute20%TYPE
67: := oke_api.g_miss_char,
68: user_attribute21 oke_k_user_attributes.user_attribute21%TYPE
69: := oke_api.g_miss_char,
70: user_attribute22 oke_k_user_attributes.user_attribute22%TYPE
71: := oke_api.g_miss_char,
72: user_attribute23 oke_k_user_attributes.user_attribute23%TYPE
73: := oke_api.g_miss_char,
74: user_attribute24 oke_k_user_attributes.user_attribute24%TYPE
68: user_attribute21 oke_k_user_attributes.user_attribute21%TYPE
69: := oke_api.g_miss_char,
70: user_attribute22 oke_k_user_attributes.user_attribute22%TYPE
71: := oke_api.g_miss_char,
72: user_attribute23 oke_k_user_attributes.user_attribute23%TYPE
73: := oke_api.g_miss_char,
74: user_attribute24 oke_k_user_attributes.user_attribute24%TYPE
75: := oke_api.g_miss_char,
76: user_attribute25 oke_k_user_attributes.user_attribute25%TYPE
70: user_attribute22 oke_k_user_attributes.user_attribute22%TYPE
71: := oke_api.g_miss_char,
72: user_attribute23 oke_k_user_attributes.user_attribute23%TYPE
73: := oke_api.g_miss_char,
74: user_attribute24 oke_k_user_attributes.user_attribute24%TYPE
75: := oke_api.g_miss_char,
76: user_attribute25 oke_k_user_attributes.user_attribute25%TYPE
77: := oke_api.g_miss_char,
78: user_attribute26 oke_k_user_attributes.user_attribute26%TYPE
72: user_attribute23 oke_k_user_attributes.user_attribute23%TYPE
73: := oke_api.g_miss_char,
74: user_attribute24 oke_k_user_attributes.user_attribute24%TYPE
75: := oke_api.g_miss_char,
76: user_attribute25 oke_k_user_attributes.user_attribute25%TYPE
77: := oke_api.g_miss_char,
78: user_attribute26 oke_k_user_attributes.user_attribute26%TYPE
79: := oke_api.g_miss_char,
80: user_attribute27 oke_k_user_attributes.user_attribute27%TYPE
74: user_attribute24 oke_k_user_attributes.user_attribute24%TYPE
75: := oke_api.g_miss_char,
76: user_attribute25 oke_k_user_attributes.user_attribute25%TYPE
77: := oke_api.g_miss_char,
78: user_attribute26 oke_k_user_attributes.user_attribute26%TYPE
79: := oke_api.g_miss_char,
80: user_attribute27 oke_k_user_attributes.user_attribute27%TYPE
81: := oke_api.g_miss_char,
82: user_attribute28 oke_k_user_attributes.user_attribute28%TYPE
76: user_attribute25 oke_k_user_attributes.user_attribute25%TYPE
77: := oke_api.g_miss_char,
78: user_attribute26 oke_k_user_attributes.user_attribute26%TYPE
79: := oke_api.g_miss_char,
80: user_attribute27 oke_k_user_attributes.user_attribute27%TYPE
81: := oke_api.g_miss_char,
82: user_attribute28 oke_k_user_attributes.user_attribute28%TYPE
83: := oke_api.g_miss_char,
84: user_attribute29 oke_k_user_attributes.user_attribute29%TYPE
78: user_attribute26 oke_k_user_attributes.user_attribute26%TYPE
79: := oke_api.g_miss_char,
80: user_attribute27 oke_k_user_attributes.user_attribute27%TYPE
81: := oke_api.g_miss_char,
82: user_attribute28 oke_k_user_attributes.user_attribute28%TYPE
83: := oke_api.g_miss_char,
84: user_attribute29 oke_k_user_attributes.user_attribute29%TYPE
85: := oke_api.g_miss_char,
86: user_attribute30 oke_k_user_attributes.user_attribute30%TYPE
80: user_attribute27 oke_k_user_attributes.user_attribute27%TYPE
81: := oke_api.g_miss_char,
82: user_attribute28 oke_k_user_attributes.user_attribute28%TYPE
83: := oke_api.g_miss_char,
84: user_attribute29 oke_k_user_attributes.user_attribute29%TYPE
85: := oke_api.g_miss_char,
86: user_attribute30 oke_k_user_attributes.user_attribute30%TYPE
87: := oke_api.g_miss_char
88: );
82: user_attribute28 oke_k_user_attributes.user_attribute28%TYPE
83: := oke_api.g_miss_char,
84: user_attribute29 oke_k_user_attributes.user_attribute29%TYPE
85: := oke_api.g_miss_char,
86: user_attribute30 oke_k_user_attributes.user_attribute30%TYPE
87: := oke_api.g_miss_char
88: );
89:
90: TYPE k_user_attributes_tbl_type IS TABLE OF k_user_attributes_rec_type
111: x_msg_count OUT NOCOPY NUMBER,
112: x_msg_data OUT NOCOPY VARCHAR2
113: );
114:
115: END oke_k_user_attributes_pub;