DBA Data[Home] [Help]

PACKAGE: APPS.PQH_PTX_INFO_TYPES_API

Source


1 Package pqh_ptx_info_types_api as
2 /* $Header: pqptiapi.pkh 120.0 2005/05/29 02:21:21 appldev noship $ */
3 --
4 -- ----------------------------------------------------------------------------
5 -- |------------------------< create_ptx_info_type >------------------------|
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_active_inactive_flag         Yes  varchar2
18 --   p_description                  No   varchar2
19 --   p_multiple_occurences_flag     Yes  varchar2
20 --   p_legislation_code             No   varchar2
21 --   p_effective_date           Yes  date      Session Date.
22 --
23 -- Post Success:
24 --
25 -- Out Parameters:
26 --   Name                                Type     Description
27 --   p_information_type             Yes  varchar2  PK of record
28 --   p_object_version_number        Yes  number    OVN of record
29 --
30 -- Post Failure:
31 --
32 -- Access Status:
33 --   Public.
34 --
35 -- {End Of Comments}
36 --
37 procedure create_ptx_info_type
38 (
39    p_validate                       in boolean    default false
40   ,p_information_type               out nocopy varchar2
41   ,p_active_inactive_flag           in  varchar2  default null
42   ,p_description                    in  varchar2  default null
43   ,p_multiple_occurences_flag       in  varchar2  default null
44   ,p_legislation_code               in  varchar2  default null
45   ,p_object_version_number          out nocopy number
46   ,p_effective_date            in  date
47  );
48 -- ----------------------------------------------------------------------------
49 -- |------------------------< update_ptx_info_type >------------------------|
50 -- ----------------------------------------------------------------------------
51 -- {Start Of Comments}
52 --
53 -- Description:
54 --
55 -- Prerequisites:
56 --
57 --
58 -- In Parameters:
59 --   Name                           Reqd Type     Description
60 --   p_validate                     Yes  boolean  Commit or Rollback.
61 --   p_information_type             Yes  varchar2  PK of record
62 --   p_active_inactive_flag         Yes  varchar2
63 --   p_description                  No   varchar2
64 --   p_multiple_occurences_flag     Yes  varchar2
65 --   p_legislation_code             No   varchar2
66 --   p_effective_date          Yes  date       Session Date.
67 --
68 -- Post Success:
69 --
70 --   Name                           Type     Description
71 --   p_object_version_number        Yes  number    OVN of record
72 --
73 -- Post Failure:
74 --
75 -- Access Status:
76 --   Public.
77 --
78 -- {End Of Comments}
79 --
80 procedure update_ptx_info_type
81   (
82    p_validate                       in boolean    default false
83   ,p_information_type               in  varchar2
84   ,p_active_inactive_flag           in  varchar2  default hr_api.g_varchar2
85   ,p_description                    in  varchar2  default hr_api.g_varchar2
86   ,p_multiple_occurences_flag       in  varchar2  default hr_api.g_varchar2
87   ,p_legislation_code               in  varchar2  default hr_api.g_varchar2
88   ,p_object_version_number          in out nocopy number
89   ,p_effective_date            in  date
90   );
91 --
92 -- ----------------------------------------------------------------------------
93 -- |------------------------< delete_ptx_info_type >------------------------|
94 -- ----------------------------------------------------------------------------
95 -- {Start Of Comments}
96 --
97 -- Description:
98 --
99 -- Prerequisites:
100 --
101 --
102 -- In Parameters:
103 --   Name                           Reqd Type     Description
104 --   p_validate                     Yes  boolean  Commit or Rollback.
105 --   p_information_type             Yes  varchar2  PK of record
106 --   p_effective_date          Yes  date     Session Date.
107 --
108 -- Post Success:
109 --
110 --   Name                           Type     Description
111 --   p_object_version_number        Yes  number    OVN of record
112 --
113 -- Post Failure:
114 --
115 -- Access Status:
116 --   Public.
117 --
118 -- {End Of Comments}
119 --
120 procedure delete_ptx_info_type
121   (
122    p_validate                       in boolean        default false
123   ,p_information_type               in  varchar2
124   ,p_object_version_number          in out nocopy number
125   ,p_effective_date            in date
126   );
127 --
128 --
129 end pqh_ptx_info_types_api;