[Home] [Help]
PACKAGE: APPS.PQH_SPECIAL_ATTRIBUTES_API
Source
1 Package pqh_special_attributes_api as
2 /* $Header: pqsatapi.pkh 120.0 2005/05/29 02:40:59 appldev noship $ */
3 --
4 -- ----------------------------------------------------------------------------
5 -- |------------------------< create_special_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_txn_category_attribute_id Yes number Descriptive Flexfield
18 -- p_attribute_type_cd No varchar2 Descriptive Flexfield
19 -- p_key_attribute_type No varchar2 Descriptive Flexfield
20 -- p_enable_flag Yes varchar2
21 -- p_flex_code No varchar2
22 -- p_ddf_column_name No varchar2
23 -- p_ddf_value_column_name No varchar2
24 -- p_context Yes varchar2
25 -- p_effective_date Yes date Session Date.
26 --
27 -- Post Success:
28 --
29 -- Out Parameters:
30 -- Name Type Description
31 -- p_special_attribute_id Yes number Descriptive Flexfield
32 -- p_object_version_number Yes number OVN of record
33 --
34 -- Post Failure:
35 --
36 -- Access Status:
37 -- Public.
38 --
39 -- {End Of Comments}
40 --
41 procedure create_special_attribute
42 (
43 p_validate in boolean default false
44 ,p_special_attribute_id out nocopy number
45 ,p_txn_category_attribute_id in number default null
46 ,p_attribute_type_cd in varchar2 default null
47 ,p_key_attribute_type in varchar2 default null
48 ,p_enable_flag in varchar2 default null
49 ,p_flex_code in varchar2 default null
50 ,p_object_version_number out nocopy number
51 ,p_ddf_column_name in varchar2 default null
52 ,p_ddf_value_column_name in varchar2 default null
53 ,p_context in varchar2 default null
54 ,p_effective_date in date
55 );
56 -- ----------------------------------------------------------------------------
57 -- |------------------------< update_special_attribute >------------------------|
58 -- ----------------------------------------------------------------------------
59 -- {Start Of Comments}
60 --
61 -- Description:
62 --
63 -- Prerequisites:
64 --
65 --
66 -- In Parameters:
67 -- Name Reqd Type Description
68 -- p_validate Yes boolean Commit or Rollback.
69 -- p_special_attribute_id Yes number Descriptive Flexfield
70 -- p_txn_category_attribute_id Yes number Descriptive Flexfield
71 -- p_attribute_type_cd No varchar2 Descriptive Flexfield
72 -- p_key_attribute_type No varchar2 Descriptive Flexfield
73 -- p_enable_flag Yes varchar2
74 -- p_flex_code No varchar2
75 -- p_ddf_column_name No varchar2
76 -- p_ddf_value_column_name No varchar2
77 -- p_context Yes varchar2
78 -- p_effective_date Yes date Session Date.
79 --
80 -- Post Success:
81 --
82 -- Name Type Description
83 -- p_object_version_number Yes number OVN of record
84 --
85 -- Post Failure:
86 --
87 -- Access Status:
88 -- Public.
89 --
90 -- {End Of Comments}
91 --
92 procedure update_special_attribute
93 (
94 p_validate in boolean default false
95 ,p_special_attribute_id in number
96 ,p_txn_category_attribute_id in number default hr_api.g_number
97 ,p_attribute_type_cd in varchar2 default hr_api.g_varchar2
98 ,p_key_attribute_type in varchar2 default hr_api.g_varchar2
99 ,p_enable_flag in varchar2 default hr_api.g_varchar2
100 ,p_flex_code in varchar2 default hr_api.g_varchar2
101 ,p_object_version_number in out nocopy number
102 ,p_ddf_column_name in varchar2 default hr_api.g_varchar2
103 ,p_ddf_value_column_name in varchar2 default hr_api.g_varchar2
104 ,p_context in varchar2 default hr_api.g_varchar2
105 ,p_effective_date in date
106 );
107 --
108 -- ----------------------------------------------------------------------------
109 -- |------------------------< delete_special_attribute >------------------------|
110 -- ----------------------------------------------------------------------------
111 -- {Start Of Comments}
112 --
113 -- Description:
114 --
115 -- Prerequisites:
116 --
117 --
118 -- In Parameters:
119 -- Name Reqd Type Description
120 -- p_validate Yes boolean Commit or Rollback.
121 -- p_special_attribute_id Yes number Descriptive Flexfield
122 -- p_effective_date Yes date Session Date.
123 --
124 -- Post Success:
125 --
126 -- Name Type Description
127 -- p_object_version_number Yes number OVN of record
128 --
129 -- Post Failure:
130 --
131 -- Access Status:
132 -- Public.
133 --
134 -- {End Of Comments}
135 --
136 procedure delete_special_attribute
137 (
138 p_validate in boolean default false
139 ,p_special_attribute_id in number
140 ,p_object_version_number in number
141 ,p_effective_date in date
142 );
143 --
144
145 --
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161 end pqh_special_attributes_api;