[Home] [Help]
PACKAGE: APPS.PQH_ATTRIBUTES_API
Source
1 Package pqh_ATTRIBUTES_api AUTHID CURRENT_USER as
2 /* $Header: pqattapi.pkh 120.0 2005/05/29 01:26:40 appldev noship $ */
3 --
4 -- ----------------------------------------------------------------------------
5 -- |------------------------< create_ATTRIBUTE >------------------------|
6 -- ----------------------------------------------------------------------------
7 -- {Start Of Comments}
8 --
9 -- Description:
10 --
11 -- Prerequisites:
12 --
13 --
14 -- In Parameters:
15 -- Name Reqd Type Description
16 -- p_validate Yes boolean Commit or Rollback.
17 -- p_attribute_name Yes varchar2 Descriptive Flexfield
18 -- p_master_attribute_id No number Descriptive Flexfield
19 -- p_master_table_route_id Yes number
20 -- p_column_name Yes varchar2
21 -- p_column_type Yes varchar2
22 -- p_enable_flag No varchar2
23 -- p_width Yes number
24 -- p_effective_date Yes date Session Date.
25 -- p_region_itemname in varchar2
26 -- p_attribute_itemname in varchar2
27 -- p_decode_function_name in varchar2
28 --
29 -- Post Success:
30 --
31 -- Out Parameters:
32 -- Name Type Description
33 -- p_attribute_id Yes number Descriptive Flexfield
34 -- p_object_version_number Yes number OVN of record
35 --
36 -- Post Failure:
37 --
38 -- Access Status:
39 -- Public.
40 --
41 -- {End Of Comments}
42 --
43 procedure create_ATTRIBUTE
44 (
45 p_validate in boolean default false
46 ,p_attribute_id out nocopy number
47 ,p_attribute_name in varchar2 default null
48 ,p_master_attribute_id in number default null
49 ,p_master_table_route_id in number default null
50 ,p_column_name in varchar2 default null
51 ,p_column_type in varchar2 default null
52 ,p_enable_flag in varchar2 default null
53 ,p_width in number default null
54 ,p_object_version_number out nocopy number
55 ,p_effective_date in date
56 ,p_language_code in varchar2 default hr_api.userenv_lang
57 ,p_region_itemname in varchar2 default null
58 ,p_attribute_itemname in varchar2 default null
59 ,p_decode_function_name in varchar2 default null
60 );
61 -- ----------------------------------------------------------------------------
62 -- |------------------------< update_ATTRIBUTE >------------------------|
63 -- ----------------------------------------------------------------------------
64 -- {Start Of Comments}
65 --
66 -- Description:
67 --
68 -- Prerequisites:
69 --
70 --
71 -- In Parameters:
72 -- Name Reqd Type Description
73 -- p_validate Yes boolean Commit or Rollback.
74 -- p_attribute_id Yes number Descriptive Flexfield
75 -- p_attribute_name Yes varchar2 Descriptive Flexfield
76 -- p_master_attribute_id No number Descriptive Flexfield
77 -- p_master_table_route_id Yes number
78 -- p_column_name Yes varchar2
79 -- p_column_type Yes varchar2
80 -- p_enable_flag No varchar2
81 -- p_width Yes number
82 -- p_effective_date Yes date Session Date.
83 -- p_region_itemname in varchar2
84 -- p_attribute_itemname in varchar2
85 -- p_decode_function_name in varchar2
86 --
87 -- Post Success:
88 --
89 -- Name Type Description
90 -- p_object_version_number Yes number OVN of record
91 --
92 -- Post Failure:
93 --
94 -- Access Status:
95 -- Public.
96 --
100 (
97 -- {End Of Comments}
98 --
99 procedure update_ATTRIBUTE
101 p_validate in boolean default false
102 ,p_attribute_id in number
103 ,p_attribute_name in varchar2 default hr_api.g_varchar2
104 ,p_master_attribute_id in number default hr_api.g_number
105 ,p_master_table_route_id in number default hr_api.g_number
106 ,p_column_name in varchar2 default hr_api.g_varchar2
107 ,p_column_type in varchar2 default hr_api.g_varchar2
108 ,p_enable_flag in varchar2 default hr_api.g_varchar2
109 ,p_width in number default hr_api.g_number
110 ,p_object_version_number in out nocopy number
111 ,p_effective_date in date
112 ,p_language_code in varchar2 default hr_api.userenv_lang
113 ,p_region_itemname in varchar2 default hr_api.g_varchar2
114 ,p_attribute_itemname in varchar2 default hr_api.g_varchar2
115 ,p_decode_function_name in varchar2 default hr_api.g_varchar2
116 );
117 --
118 -- ----------------------------------------------------------------------------
119 -- |------------------------< delete_ATTRIBUTE >------------------------|
120 -- ----------------------------------------------------------------------------
121 -- {Start Of Comments}
122 --
123 -- Description:
124 --
125 -- Prerequisites:
126 --
127 --
128 -- In Parameters:
129 -- Name Reqd Type Description
130 -- p_validate Yes boolean Commit or Rollback.
131 -- p_attribute_id Yes number Descriptive Flexfield
132 -- p_effective_date Yes date Session Date.
133 --
134 -- Post Success:
135 --
136 -- Name Type Description
137 -- p_object_version_number Yes number OVN of record
138 --
139 -- Post Failure:
140 --
141 -- Access Status:
142 -- Public.
143 --
144 -- {End Of Comments}
145 --
146 procedure delete_ATTRIBUTE
147 (
148 p_validate in boolean default false
149 ,p_attribute_id in number
150 ,p_object_version_number in number
151 ,p_effective_date in date
152 );
153 --
154 --
155 end pqh_ATTRIBUTES_api;