[Home] [Help]
30: * the database will remain unchanged. If false and all validation checks pass,
31: * then the database will be modified.
32: * @param p_language_code Specifies to which language the translation
33: * values apply. You can set to the base or any installed language. The default
34: * value of hr_api.userenv_lang is equivalent to the RDBMS userenv('LANG')
35: * function value.
36: * @param p_description Description of the docuement type being created.
37: * @param p_document_type Document Type.
38: * @param p_effective_date Reference date for validating lookup values are
73: -- {End Of Comments}
74: --
75: procedure create_document_type(
76: p_validate in boolean default false
77: ,p_language_code IN VARCHAR2 DEFAULT hr_api.userenv_lang
78: ,p_description in varchar2 default null
79: ,p_document_type in varchar2
80: ,p_effective_date in date default sysdate
81: ,p_category_code in varchar2
120: * are applicable during the start to end active date range. This date does
121: * not determine when the changes take effect.
122: * @param p_language_code Specifies to which language the translation
123: * values apply. You can set to the base or any installed language. The default
124: * value of hr_api.userenv_lang is equivalent to the RDBMS userenv('LANG')
125: * function value.
126: * @param p_description Description of the Document Type
127: * @param p_document_type Defines the Basic Document Type
128: * @param p_document_type_id This uniquely identifies the Document Type.
162: --
163: procedure update_document_type(
164: p_validate in boolean default false
165: ,p_effective_date in date default sysdate
166: ,p_language_code IN VARCHAR2 DEFAULT hr_api.userenv_lang
167: ,p_description in varchar2 default hr_api.g_varchar2
168: ,p_document_type in varchar2
169: ,p_document_type_id in number
170: ,p_object_version_number in out nocopy number
163: procedure update_document_type(
164: p_validate in boolean default false
165: ,p_effective_date in date default sysdate
166: ,p_language_code IN VARCHAR2 DEFAULT hr_api.userenv_lang
167: ,p_description in varchar2 default hr_api.g_varchar2
168: ,p_document_type in varchar2
169: ,p_document_type_id in number
170: ,p_object_version_number in out nocopy number
171: ,p_category_code in varchar2
170: ,p_object_version_number in out nocopy number
171: ,p_category_code in varchar2
172: ,p_active_inactive_flag in varchar2
173: ,p_multiple_occurences_flag in varchar2
174: ,p_legislation_code in varchar2 default hr_api.g_varchar2
175: ,p_authorization_required in varchar2
176: ,p_sub_category_code in varchar2 default hr_api.g_varchar2
177: ,p_warning_period in number default hr_api.g_number
178: ,p_request_id in number default hr_api.g_number
172: ,p_active_inactive_flag in varchar2
173: ,p_multiple_occurences_flag in varchar2
174: ,p_legislation_code in varchar2 default hr_api.g_varchar2
175: ,p_authorization_required in varchar2
176: ,p_sub_category_code in varchar2 default hr_api.g_varchar2
177: ,p_warning_period in number default hr_api.g_number
178: ,p_request_id in number default hr_api.g_number
179: ,p_program_application_id in number default hr_api.g_number
180: ,p_program_id in number default hr_api.g_number
173: ,p_multiple_occurences_flag in varchar2
174: ,p_legislation_code in varchar2 default hr_api.g_varchar2
175: ,p_authorization_required in varchar2
176: ,p_sub_category_code in varchar2 default hr_api.g_varchar2
177: ,p_warning_period in number default hr_api.g_number
178: ,p_request_id in number default hr_api.g_number
179: ,p_program_application_id in number default hr_api.g_number
180: ,p_program_id in number default hr_api.g_number
181: ,p_program_update_date in date default hr_api.g_date
174: ,p_legislation_code in varchar2 default hr_api.g_varchar2
175: ,p_authorization_required in varchar2
176: ,p_sub_category_code in varchar2 default hr_api.g_varchar2
177: ,p_warning_period in number default hr_api.g_number
178: ,p_request_id in number default hr_api.g_number
179: ,p_program_application_id in number default hr_api.g_number
180: ,p_program_id in number default hr_api.g_number
181: ,p_program_update_date in date default hr_api.g_date
182: );
175: ,p_authorization_required in varchar2
176: ,p_sub_category_code in varchar2 default hr_api.g_varchar2
177: ,p_warning_period in number default hr_api.g_number
178: ,p_request_id in number default hr_api.g_number
179: ,p_program_application_id in number default hr_api.g_number
180: ,p_program_id in number default hr_api.g_number
181: ,p_program_update_date in date default hr_api.g_date
182: );
183: --
176: ,p_sub_category_code in varchar2 default hr_api.g_varchar2
177: ,p_warning_period in number default hr_api.g_number
178: ,p_request_id in number default hr_api.g_number
179: ,p_program_application_id in number default hr_api.g_number
180: ,p_program_id in number default hr_api.g_number
181: ,p_program_update_date in date default hr_api.g_date
182: );
183: --
184: -- ----------------------------------------------------------------------------
177: ,p_warning_period in number default hr_api.g_number
178: ,p_request_id in number default hr_api.g_number
179: ,p_program_application_id in number default hr_api.g_number
180: ,p_program_id in number default hr_api.g_number
181: ,p_program_update_date in date default hr_api.g_date
182: );
183: --
184: -- ----------------------------------------------------------------------------
185: -- |-------------------------< delete_document_type >---------------------|