DBA Data[Home] [Help]

PACKAGE: APPS.OTA_OCL_API

Source


1 Package OTA_OCL_API as
2 /* $Header: otoclapi.pkh 120.1 2007/02/07 09:16:52 niarora noship $ */
3 --
4 -- ----------------------------------------------------------------------------
5 -- |--------------------------< <create_competence_language> >-----------------|
6 -- ----------------------------------------------------------------------------
7 -- {Start Of Comments}
8 --
9 -- Description:
10 --
11 --
12 -- Prerequisites:
13 --
14 --
15 -- In Parameters:
16 --   Name                           Reqd Type     Description
17 --
18 --
19 -- Post Success:
20 --
21 --
22 --   Name                           Type     Description
23 --
24 -- Post Failure:
25 --
26 --
27 -- Access Status:
28 --   Public.
29 --
30 -- {End Of Comments}
31 --
32 procedure create_competence_language
33   (p_validate                      in     boolean  default false
34   ,p_effective_date                in     date
35   ,p_competence_language_id            out nocopy number
36   ,p_competence_id                 in     number
37   ,p_language_code                   in     varchar2
38   ,p_business_group_id             in     number
39   ,p_min_proficiency_level_id      in     number   default null
40   ,p_ocl_information_category      in     varchar2 default null
41   ,p_ocl_information1              in     varchar2 default null
42   ,p_ocl_information2              in     varchar2 default null
43   ,p_ocl_information3              in     varchar2 default null
44   ,p_ocl_information4              in     varchar2 default null
45   ,p_ocl_information5              in     varchar2 default null
46   ,p_ocl_information6              in     varchar2 default null
47   ,p_ocl_information7              in     varchar2 default null
48   ,p_ocl_information8              in     varchar2 default null
49   ,p_ocl_information9              in     varchar2 default null
50   ,p_ocl_information10             in     varchar2 default null
51   ,p_ocl_information11             in     varchar2 default null
52   ,p_ocl_information12             in     varchar2 default null
53   ,p_ocl_information13             in     varchar2 default null
54   ,p_ocl_information14             in     varchar2 default null
55   ,p_ocl_information15             in     varchar2 default null
56   ,p_ocl_information16             in     varchar2 default null
57   ,p_ocl_information17             in     varchar2 default null
58   ,p_ocl_information18             in     varchar2 default null
59   ,p_ocl_information19             in     varchar2 default null
60   ,p_ocl_information20             in     varchar2 default null
61   ,p_object_version_number             out nocopy number
62   ,p_some_warning                     out nocopy boolean
63   );
64 --
65 
66 -- ----------------------------------------------------------------------------
67 -- |--------------------------< <update_competence_language> >-----------------|
68 -- ----------------------------------------------------------------------------
69 -- {Start Of Comments}
70 --
71 -- Description:
72 --
73 --
74 -- Prerequisites:
75 --
76 --
77 -- In Parameters:
78 --   Name                           Reqd Type     Description
79 --
80 --
81 -- Post Success:
82 --
83 --
84 --   Name                           Type     Description
85 --
86 -- Post Failure:
87 --
88 --
89 -- Access Status:
90 --   Public.
91 --
92 -- {End Of Comments}
93 --
94 procedure update_competence_language
95   (p_validate                      in     boolean  default false
96   ,p_effective_date                in     date
97   ,p_competence_language_id        in	number
98   ,p_competence_id                 in     number
99   ,p_language_code                   in    varchar2
100   ,p_business_group_id             in     number
101   ,p_min_proficiency_level_id      in     number   default null
102   ,p_ocl_information_category      in     varchar2 default null
103   ,p_ocl_information1              in     varchar2 default null
104   ,p_ocl_information2              in     varchar2 default null
105   ,p_ocl_information3              in     varchar2 default null
106   ,p_ocl_information4              in     varchar2 default null
107   ,p_ocl_information5              in     varchar2 default null
108   ,p_ocl_information6              in     varchar2 default null
109   ,p_ocl_information7              in     varchar2 default null
110   ,p_ocl_information8              in     varchar2 default null
111   ,p_ocl_information9              in     varchar2 default null
112   ,p_ocl_information10             in     varchar2 default null
113   ,p_ocl_information11             in     varchar2 default null
114   ,p_ocl_information12             in     varchar2 default null
115   ,p_ocl_information13             in     varchar2 default null
116   ,p_ocl_information14             in     varchar2 default null
117   ,p_ocl_information15             in     varchar2 default null
118   ,p_ocl_information16             in     varchar2 default null
119   ,p_ocl_information17             in     varchar2 default null
120   ,p_ocl_information18             in     varchar2 default null
121   ,p_ocl_information19             in     varchar2 default null
122   ,p_ocl_information20             in     varchar2 default null
123   ,p_object_version_number         in  out nocopy number
124   ,p_some_warning                     out nocopy boolean
125   );
126 --
127 end OTA_OCL_API ;