1 package body HR_DOCUMENT_TYPES_BK2 as
2 /* $Header: hrdtyapi.pkb 120.0 2005/05/30 23:53:41 generated noship $ */
3 -- Code generated by the Oracle HRMS API Hook Pre-processor
4 -- Created on 2009/03/30 04:46:04 (YYYY/MM/DD HH24:MI:SS)
5 procedure UPDATE_DOCUMENT_TYPE_A
6 (P_DOCUMENT_TYPE_ID in NUMBER
7 ,P_EFFECTIVE_DATE in DATE
8 ,P_DOCUMENT_TYPE in VARCHAR2
9 ,P_LANGUAGE_CODE in VARCHAR2
10 ,P_DESCRIPTION in VARCHAR2
11 ,P_CATEGORY_CODE in VARCHAR2
12 ,P_ACTIVE_INACTIVE_FLAG in VARCHAR2
13 ,P_MULTIPLE_OCCURENCES_FLAG in VARCHAR2
14 ,P_AUTHORIZATION_REQUIRED in VARCHAR2
15 ,P_SUB_CATEGORY_CODE in VARCHAR2
16 ,P_LEGISLATION_CODE in VARCHAR2
17 ,P_WARNING_PERIOD in NUMBER
18 ,P_REQUEST_ID in NUMBER
19 ,P_PROGRAM_APPLICATION_ID in NUMBER
20 ,P_PROGRAM_ID in NUMBER
21 ,P_PROGRAM_UPDATE_DATE in DATE
22 ,P_OBJECT_VERSION_NUMBER in NUMBER
23 )is
24 l_commit_unit_number number;
25 l_legislation_code varchar2(30);
26 begin
27 hr_utility.set_location('Entering: HR_DOCUMENT_TYPES_BK2.UPDATE_DOCUMENT_TYPE_A', 10);
28 l_commit_unit_number := hr_api.return_commit_unit;
29 if hr_api.call_app_hooks then
30 hr_document_types_be2.UPDATE_DOCUMENT_TYPE_A
31 (P_DOCUMENT_TYPE_ID => P_DOCUMENT_TYPE_ID
32 ,P_EFFECTIVE_DATE => P_EFFECTIVE_DATE
33 ,P_DOCUMENT_TYPE => P_DOCUMENT_TYPE
34 ,P_LANGUAGE_CODE => P_LANGUAGE_CODE
35 ,P_DESCRIPTION => P_DESCRIPTION
36 ,P_CATEGORY_CODE => P_CATEGORY_CODE
37 ,P_ACTIVE_INACTIVE_FLAG => P_ACTIVE_INACTIVE_FLAG
38 ,P_MULTIPLE_OCCURENCES_FLAG => P_MULTIPLE_OCCURENCES_FLAG
39 ,P_AUTHORIZATION_REQUIRED => P_AUTHORIZATION_REQUIRED
40 ,P_SUB_CATEGORY_CODE => P_SUB_CATEGORY_CODE
41 ,P_LEGISLATION_CODE => P_LEGISLATION_CODE
42 ,P_WARNING_PERIOD => P_WARNING_PERIOD
43 ,P_REQUEST_ID => P_REQUEST_ID
44 ,P_PROGRAM_APPLICATION_ID => P_PROGRAM_APPLICATION_ID
45 ,P_PROGRAM_ID => P_PROGRAM_ID
46 ,P_PROGRAM_UPDATE_DATE => P_PROGRAM_UPDATE_DATE
47 ,P_OBJECT_VERSION_NUMBER => P_OBJECT_VERSION_NUMBER
48 );
49 end if;
50 hr_multi_message.end_validation_set;
51 hr_api.validate_commit_unit(l_commit_unit_number, 'UPDATE_DOCUMENT_TYPE', 'AP');
52 hr_utility.set_location(' Leaving: HR_DOCUMENT_TYPES_BK2.UPDATE_DOCUMENT_TYPE_A', 20);
53 end UPDATE_DOCUMENT_TYPE_A;
54 procedure UPDATE_DOCUMENT_TYPE_B
55 (P_DOCUMENT_TYPE_ID in NUMBER
56 ,P_EFFECTIVE_DATE in DATE
57 ,P_DOCUMENT_TYPE in VARCHAR2
58 ,P_LANGUAGE_CODE in VARCHAR2
59 ,P_DESCRIPTION in VARCHAR2
60 ,P_CATEGORY_CODE in VARCHAR2
61 ,P_ACTIVE_INACTIVE_FLAG in VARCHAR2
62 ,P_MULTIPLE_OCCURENCES_FLAG in VARCHAR2
63 ,P_AUTHORIZATION_REQUIRED in VARCHAR2
64 ,P_SUB_CATEGORY_CODE in VARCHAR2
65 ,P_LEGISLATION_CODE in VARCHAR2
66 ,P_WARNING_PERIOD in NUMBER
67 ,P_REQUEST_ID in NUMBER
68 ,P_PROGRAM_APPLICATION_ID in NUMBER
69 ,P_PROGRAM_ID in NUMBER
70 ,P_PROGRAM_UPDATE_DATE in DATE
71 ,P_OBJECT_VERSION_NUMBER in NUMBER
72 )is
73 begin
74 hr_utility.set_location('Entering: HR_DOCUMENT_TYPES_BK2.UPDATE_DOCUMENT_TYPE_B', 10);
75 hr_utility.set_location(' Leaving: HR_DOCUMENT_TYPES_BK2.UPDATE_DOCUMENT_TYPE_B', 20);
76 end UPDATE_DOCUMENT_TYPE_B;
77 end HR_DOCUMENT_TYPES_BK2;
[Home] [Help]