DBA Data[Home] [Help]

PACKAGE: APPS.PQH_COPY_ENTITY_TXNS_API

Source


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