[Home] [Help]
PACKAGE: APPS.OKE_K_USER_ATTRIBUTES_PUB
Source
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,
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
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,
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
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,
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
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,
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
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,
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
91 INDEX BY BINARY_INTEGER;
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,
101 x_msg_data OUT NOCOPY VARCHAR2
102 );
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,
112 x_msg_data OUT NOCOPY VARCHAR2
113 );
114
115 END oke_k_user_attributes_pub;