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.OKE_K_USER_ATTRIBUTES_PUB dependencies on OKE_API

Line 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 (
8: k_user_attribute_id oke_k_user_attributes.k_user_attribute_id%TYPE
9: := oke_api.g_miss_num,

Line 9: := oke_api.g_miss_num,

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
13: := oke_api.g_miss_num,

Line 11: := oke_api.g_miss_date,

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
15: := oke_api.g_miss_date,

Line 13: := oke_api.g_miss_num,

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
17: := oke_api.g_miss_num,

Line 15: := oke_api.g_miss_date,

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
19: := oke_api.g_miss_num,

Line 17: := oke_api.g_miss_num,

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
21: := oke_api.g_miss_num,

Line 19: := oke_api.g_miss_num,

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
23: := oke_api.g_miss_num,

Line 21: := oke_api.g_miss_num,

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
25: := oke_api.g_miss_num,

Line 23: := oke_api.g_miss_num,

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
27: := oke_api.g_miss_char,

Line 25: := oke_api.g_miss_num,

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
29: := oke_api.g_miss_char,

Line 27: := oke_api.g_miss_char,

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
31: := oke_api.g_miss_char,

Line 29: := oke_api.g_miss_char,

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
33: := oke_api.g_miss_char,

Line 31: := oke_api.g_miss_char,

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
35: := oke_api.g_miss_char,

Line 33: := oke_api.g_miss_char,

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
37: := oke_api.g_miss_char,

Line 35: := oke_api.g_miss_char,

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
39: := oke_api.g_miss_char,

Line 37: := oke_api.g_miss_char,

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
41: := oke_api.g_miss_char,

Line 39: := oke_api.g_miss_char,

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
43: := oke_api.g_miss_char,

Line 41: := oke_api.g_miss_char,

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
45: := oke_api.g_miss_char,

Line 43: := oke_api.g_miss_char,

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
47: := oke_api.g_miss_char,

Line 45: := oke_api.g_miss_char,

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
49: := oke_api.g_miss_char,

Line 47: := oke_api.g_miss_char,

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
51: := oke_api.g_miss_char,

Line 49: := oke_api.g_miss_char,

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
53: := oke_api.g_miss_char,

Line 51: := oke_api.g_miss_char,

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
55: := oke_api.g_miss_char,

Line 53: := oke_api.g_miss_char,

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
57: := oke_api.g_miss_char,

Line 55: := oke_api.g_miss_char,

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
59: := oke_api.g_miss_char,

Line 57: := oke_api.g_miss_char,

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
61: := oke_api.g_miss_char,

Line 59: := oke_api.g_miss_char,

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
63: := oke_api.g_miss_char,

Line 61: := oke_api.g_miss_char,

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
65: := oke_api.g_miss_char,

Line 63: := oke_api.g_miss_char,

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
67: := oke_api.g_miss_char,

Line 65: := oke_api.g_miss_char,

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
69: := oke_api.g_miss_char,

Line 67: := oke_api.g_miss_char,

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
71: := oke_api.g_miss_char,

Line 69: := oke_api.g_miss_char,

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
73: := oke_api.g_miss_char,

Line 71: := oke_api.g_miss_char,

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
75: := oke_api.g_miss_char,

Line 73: := oke_api.g_miss_char,

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
77: := oke_api.g_miss_char,

Line 75: := oke_api.g_miss_char,

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
79: := oke_api.g_miss_char,

Line 77: := oke_api.g_miss_char,

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
81: := oke_api.g_miss_char,

Line 79: := oke_api.g_miss_char,

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
83: := oke_api.g_miss_char,

Line 81: := oke_api.g_miss_char,

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
85: := oke_api.g_miss_char,

Line 83: := oke_api.g_miss_char,

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
87: := oke_api.g_miss_char

Line 85: := oke_api.g_miss_char,

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: );
89:

Line 87: := oke_api.g_miss_char

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
91: INDEX BY BINARY_INTEGER;

Line 96: DEFAULT oke_api.g_false,

92:
93: PROCEDURE create_k_user_attributes (
94: p_api_version IN NUMBER,
95: p_init_msg_list IN VARCHAR2
96: DEFAULT oke_api.g_false,
97: p_k_user_attributes_rec IN k_user_attributes_rec_type,
98: x_k_user_attributes_rec OUT NOCOPY k_user_attributes_rec_type,
99: x_return_status OUT NOCOPY VARCHAR2,
100: x_msg_count OUT NOCOPY NUMBER,

Line 107: DEFAULT oke_api.g_false,

103:
104: PROCEDURE update_k_user_attributes (
105: p_api_version IN NUMBER,
106: p_init_msg_list IN VARCHAR2
107: DEFAULT oke_api.g_false,
108: p_k_user_attributes_rec IN k_user_attributes_rec_type,
109: x_k_user_attributes_rec OUT NOCOPY k_user_attributes_rec_type,
110: x_return_status OUT NOCOPY VARCHAR2,
111: x_msg_count OUT NOCOPY NUMBER,