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;