eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PER_CAG_DEL dependencies on PER_CAG_SHD

Line 53: Procedure delete_dml(p_rec in per_cag_shd.g_rec_type) is

49: -- Internal Row Handler Use Only.
50: --
51: -- {End Of Comments}
52: -- ----------------------------------------------------------------------------
53: Procedure delete_dml(p_rec in per_cag_shd.g_rec_type) is
54: --
55: l_proc varchar2(72) := g_package||'delete_dml';
56: --
57: Begin

Line 72: per_cag_shd.constraint_error

68: --
69: Exception
70: When hr_api.child_integrity_violated then
71: -- Child integrity has been violated
72: per_cag_shd.constraint_error
73: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
74: When Others Then
75: Raise;
76: End delete_dml;

Line 110: Procedure pre_delete(p_rec in per_cag_shd.g_rec_type) is

106: -- Internal Row Handler Use Only.
107: --
108: -- {End Of Comments}
109: -- ----------------------------------------------------------------------------
110: Procedure pre_delete(p_rec in per_cag_shd.g_rec_type) is
111: --
112: l_proc varchar2(72) := g_package||'pre_delete';
113: --
114: Begin

Line 152: Procedure post_delete(p_rec in per_cag_shd.g_rec_type) is

148: -- Internal table Handler Use Only.
149: --
150: -- {End Of Comments}
151: -- ----------------------------------------------------------------------------
152: Procedure post_delete(p_rec in per_cag_shd.g_rec_type) is
153: --
154: l_proc varchar2(72) := g_package||'post_delete';
155: --
156: Begin

Line 167: p_business_group_id =>per_cag_shd.g_old_rec.business_group_id,

163: begin
164: --
165: per_cag_rkd.after_delete
166: ( p_collective_agreement_id =>p_rec.collective_agreement_id,
167: p_business_group_id =>per_cag_shd.g_old_rec.business_group_id,
168: p_object_version_number =>per_cag_shd.g_old_rec.object_version_number,
169: p_name =>per_cag_shd.g_old_rec.name,
170: p_status =>per_cag_shd.g_old_rec.status,
171: p_cag_number =>per_cag_shd.g_old_rec.cag_number,

Line 168: p_object_version_number =>per_cag_shd.g_old_rec.object_version_number,

164: --
165: per_cag_rkd.after_delete
166: ( p_collective_agreement_id =>p_rec.collective_agreement_id,
167: p_business_group_id =>per_cag_shd.g_old_rec.business_group_id,
168: p_object_version_number =>per_cag_shd.g_old_rec.object_version_number,
169: p_name =>per_cag_shd.g_old_rec.name,
170: p_status =>per_cag_shd.g_old_rec.status,
171: p_cag_number =>per_cag_shd.g_old_rec.cag_number,
172: p_description =>per_cag_shd.g_old_rec.description,

Line 169: p_name =>per_cag_shd.g_old_rec.name,

165: per_cag_rkd.after_delete
166: ( p_collective_agreement_id =>p_rec.collective_agreement_id,
167: p_business_group_id =>per_cag_shd.g_old_rec.business_group_id,
168: p_object_version_number =>per_cag_shd.g_old_rec.object_version_number,
169: p_name =>per_cag_shd.g_old_rec.name,
170: p_status =>per_cag_shd.g_old_rec.status,
171: p_cag_number =>per_cag_shd.g_old_rec.cag_number,
172: p_description =>per_cag_shd.g_old_rec.description,
173: p_start_date =>per_cag_shd.g_old_rec.start_date,

Line 170: p_status =>per_cag_shd.g_old_rec.status,

166: ( p_collective_agreement_id =>p_rec.collective_agreement_id,
167: p_business_group_id =>per_cag_shd.g_old_rec.business_group_id,
168: p_object_version_number =>per_cag_shd.g_old_rec.object_version_number,
169: p_name =>per_cag_shd.g_old_rec.name,
170: p_status =>per_cag_shd.g_old_rec.status,
171: p_cag_number =>per_cag_shd.g_old_rec.cag_number,
172: p_description =>per_cag_shd.g_old_rec.description,
173: p_start_date =>per_cag_shd.g_old_rec.start_date,
174: p_end_date =>per_cag_shd.g_old_rec.end_date,

Line 171: p_cag_number =>per_cag_shd.g_old_rec.cag_number,

167: p_business_group_id =>per_cag_shd.g_old_rec.business_group_id,
168: p_object_version_number =>per_cag_shd.g_old_rec.object_version_number,
169: p_name =>per_cag_shd.g_old_rec.name,
170: p_status =>per_cag_shd.g_old_rec.status,
171: p_cag_number =>per_cag_shd.g_old_rec.cag_number,
172: p_description =>per_cag_shd.g_old_rec.description,
173: p_start_date =>per_cag_shd.g_old_rec.start_date,
174: p_end_date =>per_cag_shd.g_old_rec.end_date,
175: p_employer_organization_id =>per_cag_shd.g_old_rec.employer_organization_id,

Line 172: p_description =>per_cag_shd.g_old_rec.description,

168: p_object_version_number =>per_cag_shd.g_old_rec.object_version_number,
169: p_name =>per_cag_shd.g_old_rec.name,
170: p_status =>per_cag_shd.g_old_rec.status,
171: p_cag_number =>per_cag_shd.g_old_rec.cag_number,
172: p_description =>per_cag_shd.g_old_rec.description,
173: p_start_date =>per_cag_shd.g_old_rec.start_date,
174: p_end_date =>per_cag_shd.g_old_rec.end_date,
175: p_employer_organization_id =>per_cag_shd.g_old_rec.employer_organization_id,
176: p_employer_signatory =>per_cag_shd.g_old_rec.employer_signatory,

Line 173: p_start_date =>per_cag_shd.g_old_rec.start_date,

169: p_name =>per_cag_shd.g_old_rec.name,
170: p_status =>per_cag_shd.g_old_rec.status,
171: p_cag_number =>per_cag_shd.g_old_rec.cag_number,
172: p_description =>per_cag_shd.g_old_rec.description,
173: p_start_date =>per_cag_shd.g_old_rec.start_date,
174: p_end_date =>per_cag_shd.g_old_rec.end_date,
175: p_employer_organization_id =>per_cag_shd.g_old_rec.employer_organization_id,
176: p_employer_signatory =>per_cag_shd.g_old_rec.employer_signatory,
177: p_bargaining_organization_id =>per_cag_shd.g_old_rec.bargaining_organization_id,

Line 174: p_end_date =>per_cag_shd.g_old_rec.end_date,

170: p_status =>per_cag_shd.g_old_rec.status,
171: p_cag_number =>per_cag_shd.g_old_rec.cag_number,
172: p_description =>per_cag_shd.g_old_rec.description,
173: p_start_date =>per_cag_shd.g_old_rec.start_date,
174: p_end_date =>per_cag_shd.g_old_rec.end_date,
175: p_employer_organization_id =>per_cag_shd.g_old_rec.employer_organization_id,
176: p_employer_signatory =>per_cag_shd.g_old_rec.employer_signatory,
177: p_bargaining_organization_id =>per_cag_shd.g_old_rec.bargaining_organization_id,
178: p_bargaining_unit_signatory =>per_cag_shd.g_old_rec.bargaining_unit_signatory,

Line 175: p_employer_organization_id =>per_cag_shd.g_old_rec.employer_organization_id,

171: p_cag_number =>per_cag_shd.g_old_rec.cag_number,
172: p_description =>per_cag_shd.g_old_rec.description,
173: p_start_date =>per_cag_shd.g_old_rec.start_date,
174: p_end_date =>per_cag_shd.g_old_rec.end_date,
175: p_employer_organization_id =>per_cag_shd.g_old_rec.employer_organization_id,
176: p_employer_signatory =>per_cag_shd.g_old_rec.employer_signatory,
177: p_bargaining_organization_id =>per_cag_shd.g_old_rec.bargaining_organization_id,
178: p_bargaining_unit_signatory =>per_cag_shd.g_old_rec.bargaining_unit_signatory,
179: p_jurisdiction =>per_cag_shd.g_old_rec.jurisdiction,

Line 176: p_employer_signatory =>per_cag_shd.g_old_rec.employer_signatory,

172: p_description =>per_cag_shd.g_old_rec.description,
173: p_start_date =>per_cag_shd.g_old_rec.start_date,
174: p_end_date =>per_cag_shd.g_old_rec.end_date,
175: p_employer_organization_id =>per_cag_shd.g_old_rec.employer_organization_id,
176: p_employer_signatory =>per_cag_shd.g_old_rec.employer_signatory,
177: p_bargaining_organization_id =>per_cag_shd.g_old_rec.bargaining_organization_id,
178: p_bargaining_unit_signatory =>per_cag_shd.g_old_rec.bargaining_unit_signatory,
179: p_jurisdiction =>per_cag_shd.g_old_rec.jurisdiction,
180: p_authorizing_body =>per_cag_shd.g_old_rec.authorizing_body,

Line 177: p_bargaining_organization_id =>per_cag_shd.g_old_rec.bargaining_organization_id,

173: p_start_date =>per_cag_shd.g_old_rec.start_date,
174: p_end_date =>per_cag_shd.g_old_rec.end_date,
175: p_employer_organization_id =>per_cag_shd.g_old_rec.employer_organization_id,
176: p_employer_signatory =>per_cag_shd.g_old_rec.employer_signatory,
177: p_bargaining_organization_id =>per_cag_shd.g_old_rec.bargaining_organization_id,
178: p_bargaining_unit_signatory =>per_cag_shd.g_old_rec.bargaining_unit_signatory,
179: p_jurisdiction =>per_cag_shd.g_old_rec.jurisdiction,
180: p_authorizing_body =>per_cag_shd.g_old_rec.authorizing_body,
181: p_authorized_date =>per_cag_shd.g_old_rec.authorized_date,

Line 178: p_bargaining_unit_signatory =>per_cag_shd.g_old_rec.bargaining_unit_signatory,

174: p_end_date =>per_cag_shd.g_old_rec.end_date,
175: p_employer_organization_id =>per_cag_shd.g_old_rec.employer_organization_id,
176: p_employer_signatory =>per_cag_shd.g_old_rec.employer_signatory,
177: p_bargaining_organization_id =>per_cag_shd.g_old_rec.bargaining_organization_id,
178: p_bargaining_unit_signatory =>per_cag_shd.g_old_rec.bargaining_unit_signatory,
179: p_jurisdiction =>per_cag_shd.g_old_rec.jurisdiction,
180: p_authorizing_body =>per_cag_shd.g_old_rec.authorizing_body,
181: p_authorized_date =>per_cag_shd.g_old_rec.authorized_date,
182: p_cag_information_category =>per_cag_shd.g_old_rec.cag_information_category,

Line 179: p_jurisdiction =>per_cag_shd.g_old_rec.jurisdiction,

175: p_employer_organization_id =>per_cag_shd.g_old_rec.employer_organization_id,
176: p_employer_signatory =>per_cag_shd.g_old_rec.employer_signatory,
177: p_bargaining_organization_id =>per_cag_shd.g_old_rec.bargaining_organization_id,
178: p_bargaining_unit_signatory =>per_cag_shd.g_old_rec.bargaining_unit_signatory,
179: p_jurisdiction =>per_cag_shd.g_old_rec.jurisdiction,
180: p_authorizing_body =>per_cag_shd.g_old_rec.authorizing_body,
181: p_authorized_date =>per_cag_shd.g_old_rec.authorized_date,
182: p_cag_information_category =>per_cag_shd.g_old_rec.cag_information_category,
183: p_cag_information1 =>per_cag_shd.g_old_rec.cag_information1,

Line 180: p_authorizing_body =>per_cag_shd.g_old_rec.authorizing_body,

176: p_employer_signatory =>per_cag_shd.g_old_rec.employer_signatory,
177: p_bargaining_organization_id =>per_cag_shd.g_old_rec.bargaining_organization_id,
178: p_bargaining_unit_signatory =>per_cag_shd.g_old_rec.bargaining_unit_signatory,
179: p_jurisdiction =>per_cag_shd.g_old_rec.jurisdiction,
180: p_authorizing_body =>per_cag_shd.g_old_rec.authorizing_body,
181: p_authorized_date =>per_cag_shd.g_old_rec.authorized_date,
182: p_cag_information_category =>per_cag_shd.g_old_rec.cag_information_category,
183: p_cag_information1 =>per_cag_shd.g_old_rec.cag_information1,
184: p_cag_information2 =>per_cag_shd.g_old_rec.cag_information2,

Line 181: p_authorized_date =>per_cag_shd.g_old_rec.authorized_date,

177: p_bargaining_organization_id =>per_cag_shd.g_old_rec.bargaining_organization_id,
178: p_bargaining_unit_signatory =>per_cag_shd.g_old_rec.bargaining_unit_signatory,
179: p_jurisdiction =>per_cag_shd.g_old_rec.jurisdiction,
180: p_authorizing_body =>per_cag_shd.g_old_rec.authorizing_body,
181: p_authorized_date =>per_cag_shd.g_old_rec.authorized_date,
182: p_cag_information_category =>per_cag_shd.g_old_rec.cag_information_category,
183: p_cag_information1 =>per_cag_shd.g_old_rec.cag_information1,
184: p_cag_information2 =>per_cag_shd.g_old_rec.cag_information2,
185: p_cag_information3 =>per_cag_shd.g_old_rec.cag_information3,

Line 182: p_cag_information_category =>per_cag_shd.g_old_rec.cag_information_category,

178: p_bargaining_unit_signatory =>per_cag_shd.g_old_rec.bargaining_unit_signatory,
179: p_jurisdiction =>per_cag_shd.g_old_rec.jurisdiction,
180: p_authorizing_body =>per_cag_shd.g_old_rec.authorizing_body,
181: p_authorized_date =>per_cag_shd.g_old_rec.authorized_date,
182: p_cag_information_category =>per_cag_shd.g_old_rec.cag_information_category,
183: p_cag_information1 =>per_cag_shd.g_old_rec.cag_information1,
184: p_cag_information2 =>per_cag_shd.g_old_rec.cag_information2,
185: p_cag_information3 =>per_cag_shd.g_old_rec.cag_information3,
186: p_cag_information4 =>per_cag_shd.g_old_rec.cag_information4,

Line 183: p_cag_information1 =>per_cag_shd.g_old_rec.cag_information1,

179: p_jurisdiction =>per_cag_shd.g_old_rec.jurisdiction,
180: p_authorizing_body =>per_cag_shd.g_old_rec.authorizing_body,
181: p_authorized_date =>per_cag_shd.g_old_rec.authorized_date,
182: p_cag_information_category =>per_cag_shd.g_old_rec.cag_information_category,
183: p_cag_information1 =>per_cag_shd.g_old_rec.cag_information1,
184: p_cag_information2 =>per_cag_shd.g_old_rec.cag_information2,
185: p_cag_information3 =>per_cag_shd.g_old_rec.cag_information3,
186: p_cag_information4 =>per_cag_shd.g_old_rec.cag_information4,
187: p_cag_information5 =>per_cag_shd.g_old_rec.cag_information5,

Line 184: p_cag_information2 =>per_cag_shd.g_old_rec.cag_information2,

180: p_authorizing_body =>per_cag_shd.g_old_rec.authorizing_body,
181: p_authorized_date =>per_cag_shd.g_old_rec.authorized_date,
182: p_cag_information_category =>per_cag_shd.g_old_rec.cag_information_category,
183: p_cag_information1 =>per_cag_shd.g_old_rec.cag_information1,
184: p_cag_information2 =>per_cag_shd.g_old_rec.cag_information2,
185: p_cag_information3 =>per_cag_shd.g_old_rec.cag_information3,
186: p_cag_information4 =>per_cag_shd.g_old_rec.cag_information4,
187: p_cag_information5 =>per_cag_shd.g_old_rec.cag_information5,
188: p_cag_information6 =>per_cag_shd.g_old_rec.cag_information6,

Line 185: p_cag_information3 =>per_cag_shd.g_old_rec.cag_information3,

181: p_authorized_date =>per_cag_shd.g_old_rec.authorized_date,
182: p_cag_information_category =>per_cag_shd.g_old_rec.cag_information_category,
183: p_cag_information1 =>per_cag_shd.g_old_rec.cag_information1,
184: p_cag_information2 =>per_cag_shd.g_old_rec.cag_information2,
185: p_cag_information3 =>per_cag_shd.g_old_rec.cag_information3,
186: p_cag_information4 =>per_cag_shd.g_old_rec.cag_information4,
187: p_cag_information5 =>per_cag_shd.g_old_rec.cag_information5,
188: p_cag_information6 =>per_cag_shd.g_old_rec.cag_information6,
189: p_cag_information7 =>per_cag_shd.g_old_rec.cag_information7,

Line 186: p_cag_information4 =>per_cag_shd.g_old_rec.cag_information4,

182: p_cag_information_category =>per_cag_shd.g_old_rec.cag_information_category,
183: p_cag_information1 =>per_cag_shd.g_old_rec.cag_information1,
184: p_cag_information2 =>per_cag_shd.g_old_rec.cag_information2,
185: p_cag_information3 =>per_cag_shd.g_old_rec.cag_information3,
186: p_cag_information4 =>per_cag_shd.g_old_rec.cag_information4,
187: p_cag_information5 =>per_cag_shd.g_old_rec.cag_information5,
188: p_cag_information6 =>per_cag_shd.g_old_rec.cag_information6,
189: p_cag_information7 =>per_cag_shd.g_old_rec.cag_information7,
190: p_cag_information8 =>per_cag_shd.g_old_rec.cag_information8,

Line 187: p_cag_information5 =>per_cag_shd.g_old_rec.cag_information5,

183: p_cag_information1 =>per_cag_shd.g_old_rec.cag_information1,
184: p_cag_information2 =>per_cag_shd.g_old_rec.cag_information2,
185: p_cag_information3 =>per_cag_shd.g_old_rec.cag_information3,
186: p_cag_information4 =>per_cag_shd.g_old_rec.cag_information4,
187: p_cag_information5 =>per_cag_shd.g_old_rec.cag_information5,
188: p_cag_information6 =>per_cag_shd.g_old_rec.cag_information6,
189: p_cag_information7 =>per_cag_shd.g_old_rec.cag_information7,
190: p_cag_information8 =>per_cag_shd.g_old_rec.cag_information8,
191: p_cag_information9 =>per_cag_shd.g_old_rec.cag_information9,

Line 188: p_cag_information6 =>per_cag_shd.g_old_rec.cag_information6,

184: p_cag_information2 =>per_cag_shd.g_old_rec.cag_information2,
185: p_cag_information3 =>per_cag_shd.g_old_rec.cag_information3,
186: p_cag_information4 =>per_cag_shd.g_old_rec.cag_information4,
187: p_cag_information5 =>per_cag_shd.g_old_rec.cag_information5,
188: p_cag_information6 =>per_cag_shd.g_old_rec.cag_information6,
189: p_cag_information7 =>per_cag_shd.g_old_rec.cag_information7,
190: p_cag_information8 =>per_cag_shd.g_old_rec.cag_information8,
191: p_cag_information9 =>per_cag_shd.g_old_rec.cag_information9,
192: p_cag_information10 =>per_cag_shd.g_old_rec.cag_information10,

Line 189: p_cag_information7 =>per_cag_shd.g_old_rec.cag_information7,

185: p_cag_information3 =>per_cag_shd.g_old_rec.cag_information3,
186: p_cag_information4 =>per_cag_shd.g_old_rec.cag_information4,
187: p_cag_information5 =>per_cag_shd.g_old_rec.cag_information5,
188: p_cag_information6 =>per_cag_shd.g_old_rec.cag_information6,
189: p_cag_information7 =>per_cag_shd.g_old_rec.cag_information7,
190: p_cag_information8 =>per_cag_shd.g_old_rec.cag_information8,
191: p_cag_information9 =>per_cag_shd.g_old_rec.cag_information9,
192: p_cag_information10 =>per_cag_shd.g_old_rec.cag_information10,
193: p_cag_information11 =>per_cag_shd.g_old_rec.cag_information11,

Line 190: p_cag_information8 =>per_cag_shd.g_old_rec.cag_information8,

186: p_cag_information4 =>per_cag_shd.g_old_rec.cag_information4,
187: p_cag_information5 =>per_cag_shd.g_old_rec.cag_information5,
188: p_cag_information6 =>per_cag_shd.g_old_rec.cag_information6,
189: p_cag_information7 =>per_cag_shd.g_old_rec.cag_information7,
190: p_cag_information8 =>per_cag_shd.g_old_rec.cag_information8,
191: p_cag_information9 =>per_cag_shd.g_old_rec.cag_information9,
192: p_cag_information10 =>per_cag_shd.g_old_rec.cag_information10,
193: p_cag_information11 =>per_cag_shd.g_old_rec.cag_information11,
194: p_cag_information12 =>per_cag_shd.g_old_rec.cag_information12,

Line 191: p_cag_information9 =>per_cag_shd.g_old_rec.cag_information9,

187: p_cag_information5 =>per_cag_shd.g_old_rec.cag_information5,
188: p_cag_information6 =>per_cag_shd.g_old_rec.cag_information6,
189: p_cag_information7 =>per_cag_shd.g_old_rec.cag_information7,
190: p_cag_information8 =>per_cag_shd.g_old_rec.cag_information8,
191: p_cag_information9 =>per_cag_shd.g_old_rec.cag_information9,
192: p_cag_information10 =>per_cag_shd.g_old_rec.cag_information10,
193: p_cag_information11 =>per_cag_shd.g_old_rec.cag_information11,
194: p_cag_information12 =>per_cag_shd.g_old_rec.cag_information12,
195: p_cag_information13 =>per_cag_shd.g_old_rec.cag_information13,

Line 192: p_cag_information10 =>per_cag_shd.g_old_rec.cag_information10,

188: p_cag_information6 =>per_cag_shd.g_old_rec.cag_information6,
189: p_cag_information7 =>per_cag_shd.g_old_rec.cag_information7,
190: p_cag_information8 =>per_cag_shd.g_old_rec.cag_information8,
191: p_cag_information9 =>per_cag_shd.g_old_rec.cag_information9,
192: p_cag_information10 =>per_cag_shd.g_old_rec.cag_information10,
193: p_cag_information11 =>per_cag_shd.g_old_rec.cag_information11,
194: p_cag_information12 =>per_cag_shd.g_old_rec.cag_information12,
195: p_cag_information13 =>per_cag_shd.g_old_rec.cag_information13,
196: p_cag_information14 =>per_cag_shd.g_old_rec.cag_information14,

Line 193: p_cag_information11 =>per_cag_shd.g_old_rec.cag_information11,

189: p_cag_information7 =>per_cag_shd.g_old_rec.cag_information7,
190: p_cag_information8 =>per_cag_shd.g_old_rec.cag_information8,
191: p_cag_information9 =>per_cag_shd.g_old_rec.cag_information9,
192: p_cag_information10 =>per_cag_shd.g_old_rec.cag_information10,
193: p_cag_information11 =>per_cag_shd.g_old_rec.cag_information11,
194: p_cag_information12 =>per_cag_shd.g_old_rec.cag_information12,
195: p_cag_information13 =>per_cag_shd.g_old_rec.cag_information13,
196: p_cag_information14 =>per_cag_shd.g_old_rec.cag_information14,
197: p_cag_information15 =>per_cag_shd.g_old_rec.cag_information15,

Line 194: p_cag_information12 =>per_cag_shd.g_old_rec.cag_information12,

190: p_cag_information8 =>per_cag_shd.g_old_rec.cag_information8,
191: p_cag_information9 =>per_cag_shd.g_old_rec.cag_information9,
192: p_cag_information10 =>per_cag_shd.g_old_rec.cag_information10,
193: p_cag_information11 =>per_cag_shd.g_old_rec.cag_information11,
194: p_cag_information12 =>per_cag_shd.g_old_rec.cag_information12,
195: p_cag_information13 =>per_cag_shd.g_old_rec.cag_information13,
196: p_cag_information14 =>per_cag_shd.g_old_rec.cag_information14,
197: p_cag_information15 =>per_cag_shd.g_old_rec.cag_information15,
198: p_cag_information16 =>per_cag_shd.g_old_rec.cag_information16,

Line 195: p_cag_information13 =>per_cag_shd.g_old_rec.cag_information13,

191: p_cag_information9 =>per_cag_shd.g_old_rec.cag_information9,
192: p_cag_information10 =>per_cag_shd.g_old_rec.cag_information10,
193: p_cag_information11 =>per_cag_shd.g_old_rec.cag_information11,
194: p_cag_information12 =>per_cag_shd.g_old_rec.cag_information12,
195: p_cag_information13 =>per_cag_shd.g_old_rec.cag_information13,
196: p_cag_information14 =>per_cag_shd.g_old_rec.cag_information14,
197: p_cag_information15 =>per_cag_shd.g_old_rec.cag_information15,
198: p_cag_information16 =>per_cag_shd.g_old_rec.cag_information16,
199: p_cag_information17 =>per_cag_shd.g_old_rec.cag_information17,

Line 196: p_cag_information14 =>per_cag_shd.g_old_rec.cag_information14,

192: p_cag_information10 =>per_cag_shd.g_old_rec.cag_information10,
193: p_cag_information11 =>per_cag_shd.g_old_rec.cag_information11,
194: p_cag_information12 =>per_cag_shd.g_old_rec.cag_information12,
195: p_cag_information13 =>per_cag_shd.g_old_rec.cag_information13,
196: p_cag_information14 =>per_cag_shd.g_old_rec.cag_information14,
197: p_cag_information15 =>per_cag_shd.g_old_rec.cag_information15,
198: p_cag_information16 =>per_cag_shd.g_old_rec.cag_information16,
199: p_cag_information17 =>per_cag_shd.g_old_rec.cag_information17,
200: p_cag_information18 =>per_cag_shd.g_old_rec.cag_information18,

Line 197: p_cag_information15 =>per_cag_shd.g_old_rec.cag_information15,

193: p_cag_information11 =>per_cag_shd.g_old_rec.cag_information11,
194: p_cag_information12 =>per_cag_shd.g_old_rec.cag_information12,
195: p_cag_information13 =>per_cag_shd.g_old_rec.cag_information13,
196: p_cag_information14 =>per_cag_shd.g_old_rec.cag_information14,
197: p_cag_information15 =>per_cag_shd.g_old_rec.cag_information15,
198: p_cag_information16 =>per_cag_shd.g_old_rec.cag_information16,
199: p_cag_information17 =>per_cag_shd.g_old_rec.cag_information17,
200: p_cag_information18 =>per_cag_shd.g_old_rec.cag_information18,
201: p_cag_information19 =>per_cag_shd.g_old_rec.cag_information19,

Line 198: p_cag_information16 =>per_cag_shd.g_old_rec.cag_information16,

194: p_cag_information12 =>per_cag_shd.g_old_rec.cag_information12,
195: p_cag_information13 =>per_cag_shd.g_old_rec.cag_information13,
196: p_cag_information14 =>per_cag_shd.g_old_rec.cag_information14,
197: p_cag_information15 =>per_cag_shd.g_old_rec.cag_information15,
198: p_cag_information16 =>per_cag_shd.g_old_rec.cag_information16,
199: p_cag_information17 =>per_cag_shd.g_old_rec.cag_information17,
200: p_cag_information18 =>per_cag_shd.g_old_rec.cag_information18,
201: p_cag_information19 =>per_cag_shd.g_old_rec.cag_information19,
202: p_cag_information20 =>per_cag_shd.g_old_rec.cag_information20,

Line 199: p_cag_information17 =>per_cag_shd.g_old_rec.cag_information17,

195: p_cag_information13 =>per_cag_shd.g_old_rec.cag_information13,
196: p_cag_information14 =>per_cag_shd.g_old_rec.cag_information14,
197: p_cag_information15 =>per_cag_shd.g_old_rec.cag_information15,
198: p_cag_information16 =>per_cag_shd.g_old_rec.cag_information16,
199: p_cag_information17 =>per_cag_shd.g_old_rec.cag_information17,
200: p_cag_information18 =>per_cag_shd.g_old_rec.cag_information18,
201: p_cag_information19 =>per_cag_shd.g_old_rec.cag_information19,
202: p_cag_information20 =>per_cag_shd.g_old_rec.cag_information20,
203: p_attribute_category =>per_cag_shd.g_old_rec.attribute_category,

Line 200: p_cag_information18 =>per_cag_shd.g_old_rec.cag_information18,

196: p_cag_information14 =>per_cag_shd.g_old_rec.cag_information14,
197: p_cag_information15 =>per_cag_shd.g_old_rec.cag_information15,
198: p_cag_information16 =>per_cag_shd.g_old_rec.cag_information16,
199: p_cag_information17 =>per_cag_shd.g_old_rec.cag_information17,
200: p_cag_information18 =>per_cag_shd.g_old_rec.cag_information18,
201: p_cag_information19 =>per_cag_shd.g_old_rec.cag_information19,
202: p_cag_information20 =>per_cag_shd.g_old_rec.cag_information20,
203: p_attribute_category =>per_cag_shd.g_old_rec.attribute_category,
204: p_attribute1 =>per_cag_shd.g_old_rec.attribute1,

Line 201: p_cag_information19 =>per_cag_shd.g_old_rec.cag_information19,

197: p_cag_information15 =>per_cag_shd.g_old_rec.cag_information15,
198: p_cag_information16 =>per_cag_shd.g_old_rec.cag_information16,
199: p_cag_information17 =>per_cag_shd.g_old_rec.cag_information17,
200: p_cag_information18 =>per_cag_shd.g_old_rec.cag_information18,
201: p_cag_information19 =>per_cag_shd.g_old_rec.cag_information19,
202: p_cag_information20 =>per_cag_shd.g_old_rec.cag_information20,
203: p_attribute_category =>per_cag_shd.g_old_rec.attribute_category,
204: p_attribute1 =>per_cag_shd.g_old_rec.attribute1,
205: p_attribute2 =>per_cag_shd.g_old_rec.attribute2,

Line 202: p_cag_information20 =>per_cag_shd.g_old_rec.cag_information20,

198: p_cag_information16 =>per_cag_shd.g_old_rec.cag_information16,
199: p_cag_information17 =>per_cag_shd.g_old_rec.cag_information17,
200: p_cag_information18 =>per_cag_shd.g_old_rec.cag_information18,
201: p_cag_information19 =>per_cag_shd.g_old_rec.cag_information19,
202: p_cag_information20 =>per_cag_shd.g_old_rec.cag_information20,
203: p_attribute_category =>per_cag_shd.g_old_rec.attribute_category,
204: p_attribute1 =>per_cag_shd.g_old_rec.attribute1,
205: p_attribute2 =>per_cag_shd.g_old_rec.attribute2,
206: p_attribute3 =>per_cag_shd.g_old_rec.attribute3,

Line 203: p_attribute_category =>per_cag_shd.g_old_rec.attribute_category,

199: p_cag_information17 =>per_cag_shd.g_old_rec.cag_information17,
200: p_cag_information18 =>per_cag_shd.g_old_rec.cag_information18,
201: p_cag_information19 =>per_cag_shd.g_old_rec.cag_information19,
202: p_cag_information20 =>per_cag_shd.g_old_rec.cag_information20,
203: p_attribute_category =>per_cag_shd.g_old_rec.attribute_category,
204: p_attribute1 =>per_cag_shd.g_old_rec.attribute1,
205: p_attribute2 =>per_cag_shd.g_old_rec.attribute2,
206: p_attribute3 =>per_cag_shd.g_old_rec.attribute3,
207: p_attribute4 =>per_cag_shd.g_old_rec.attribute4,

Line 204: p_attribute1 =>per_cag_shd.g_old_rec.attribute1,

200: p_cag_information18 =>per_cag_shd.g_old_rec.cag_information18,
201: p_cag_information19 =>per_cag_shd.g_old_rec.cag_information19,
202: p_cag_information20 =>per_cag_shd.g_old_rec.cag_information20,
203: p_attribute_category =>per_cag_shd.g_old_rec.attribute_category,
204: p_attribute1 =>per_cag_shd.g_old_rec.attribute1,
205: p_attribute2 =>per_cag_shd.g_old_rec.attribute2,
206: p_attribute3 =>per_cag_shd.g_old_rec.attribute3,
207: p_attribute4 =>per_cag_shd.g_old_rec.attribute4,
208: p_attribute5 =>per_cag_shd.g_old_rec.attribute5,

Line 205: p_attribute2 =>per_cag_shd.g_old_rec.attribute2,

201: p_cag_information19 =>per_cag_shd.g_old_rec.cag_information19,
202: p_cag_information20 =>per_cag_shd.g_old_rec.cag_information20,
203: p_attribute_category =>per_cag_shd.g_old_rec.attribute_category,
204: p_attribute1 =>per_cag_shd.g_old_rec.attribute1,
205: p_attribute2 =>per_cag_shd.g_old_rec.attribute2,
206: p_attribute3 =>per_cag_shd.g_old_rec.attribute3,
207: p_attribute4 =>per_cag_shd.g_old_rec.attribute4,
208: p_attribute5 =>per_cag_shd.g_old_rec.attribute5,
209: p_attribute6 =>per_cag_shd.g_old_rec.attribute6,

Line 206: p_attribute3 =>per_cag_shd.g_old_rec.attribute3,

202: p_cag_information20 =>per_cag_shd.g_old_rec.cag_information20,
203: p_attribute_category =>per_cag_shd.g_old_rec.attribute_category,
204: p_attribute1 =>per_cag_shd.g_old_rec.attribute1,
205: p_attribute2 =>per_cag_shd.g_old_rec.attribute2,
206: p_attribute3 =>per_cag_shd.g_old_rec.attribute3,
207: p_attribute4 =>per_cag_shd.g_old_rec.attribute4,
208: p_attribute5 =>per_cag_shd.g_old_rec.attribute5,
209: p_attribute6 =>per_cag_shd.g_old_rec.attribute6,
210: p_attribute7 =>per_cag_shd.g_old_rec.attribute7,

Line 207: p_attribute4 =>per_cag_shd.g_old_rec.attribute4,

203: p_attribute_category =>per_cag_shd.g_old_rec.attribute_category,
204: p_attribute1 =>per_cag_shd.g_old_rec.attribute1,
205: p_attribute2 =>per_cag_shd.g_old_rec.attribute2,
206: p_attribute3 =>per_cag_shd.g_old_rec.attribute3,
207: p_attribute4 =>per_cag_shd.g_old_rec.attribute4,
208: p_attribute5 =>per_cag_shd.g_old_rec.attribute5,
209: p_attribute6 =>per_cag_shd.g_old_rec.attribute6,
210: p_attribute7 =>per_cag_shd.g_old_rec.attribute7,
211: p_attribute8 =>per_cag_shd.g_old_rec.attribute8,

Line 208: p_attribute5 =>per_cag_shd.g_old_rec.attribute5,

204: p_attribute1 =>per_cag_shd.g_old_rec.attribute1,
205: p_attribute2 =>per_cag_shd.g_old_rec.attribute2,
206: p_attribute3 =>per_cag_shd.g_old_rec.attribute3,
207: p_attribute4 =>per_cag_shd.g_old_rec.attribute4,
208: p_attribute5 =>per_cag_shd.g_old_rec.attribute5,
209: p_attribute6 =>per_cag_shd.g_old_rec.attribute6,
210: p_attribute7 =>per_cag_shd.g_old_rec.attribute7,
211: p_attribute8 =>per_cag_shd.g_old_rec.attribute8,
212: p_attribute9 =>per_cag_shd.g_old_rec.attribute9,

Line 209: p_attribute6 =>per_cag_shd.g_old_rec.attribute6,

205: p_attribute2 =>per_cag_shd.g_old_rec.attribute2,
206: p_attribute3 =>per_cag_shd.g_old_rec.attribute3,
207: p_attribute4 =>per_cag_shd.g_old_rec.attribute4,
208: p_attribute5 =>per_cag_shd.g_old_rec.attribute5,
209: p_attribute6 =>per_cag_shd.g_old_rec.attribute6,
210: p_attribute7 =>per_cag_shd.g_old_rec.attribute7,
211: p_attribute8 =>per_cag_shd.g_old_rec.attribute8,
212: p_attribute9 =>per_cag_shd.g_old_rec.attribute9,
213: p_attribute10 =>per_cag_shd.g_old_rec.attribute10,

Line 210: p_attribute7 =>per_cag_shd.g_old_rec.attribute7,

206: p_attribute3 =>per_cag_shd.g_old_rec.attribute3,
207: p_attribute4 =>per_cag_shd.g_old_rec.attribute4,
208: p_attribute5 =>per_cag_shd.g_old_rec.attribute5,
209: p_attribute6 =>per_cag_shd.g_old_rec.attribute6,
210: p_attribute7 =>per_cag_shd.g_old_rec.attribute7,
211: p_attribute8 =>per_cag_shd.g_old_rec.attribute8,
212: p_attribute9 =>per_cag_shd.g_old_rec.attribute9,
213: p_attribute10 =>per_cag_shd.g_old_rec.attribute10,
214: p_attribute11 =>per_cag_shd.g_old_rec.attribute11,

Line 211: p_attribute8 =>per_cag_shd.g_old_rec.attribute8,

207: p_attribute4 =>per_cag_shd.g_old_rec.attribute4,
208: p_attribute5 =>per_cag_shd.g_old_rec.attribute5,
209: p_attribute6 =>per_cag_shd.g_old_rec.attribute6,
210: p_attribute7 =>per_cag_shd.g_old_rec.attribute7,
211: p_attribute8 =>per_cag_shd.g_old_rec.attribute8,
212: p_attribute9 =>per_cag_shd.g_old_rec.attribute9,
213: p_attribute10 =>per_cag_shd.g_old_rec.attribute10,
214: p_attribute11 =>per_cag_shd.g_old_rec.attribute11,
215: p_attribute12 =>per_cag_shd.g_old_rec.attribute12,

Line 212: p_attribute9 =>per_cag_shd.g_old_rec.attribute9,

208: p_attribute5 =>per_cag_shd.g_old_rec.attribute5,
209: p_attribute6 =>per_cag_shd.g_old_rec.attribute6,
210: p_attribute7 =>per_cag_shd.g_old_rec.attribute7,
211: p_attribute8 =>per_cag_shd.g_old_rec.attribute8,
212: p_attribute9 =>per_cag_shd.g_old_rec.attribute9,
213: p_attribute10 =>per_cag_shd.g_old_rec.attribute10,
214: p_attribute11 =>per_cag_shd.g_old_rec.attribute11,
215: p_attribute12 =>per_cag_shd.g_old_rec.attribute12,
216: p_attribute13 =>per_cag_shd.g_old_rec.attribute13,

Line 213: p_attribute10 =>per_cag_shd.g_old_rec.attribute10,

209: p_attribute6 =>per_cag_shd.g_old_rec.attribute6,
210: p_attribute7 =>per_cag_shd.g_old_rec.attribute7,
211: p_attribute8 =>per_cag_shd.g_old_rec.attribute8,
212: p_attribute9 =>per_cag_shd.g_old_rec.attribute9,
213: p_attribute10 =>per_cag_shd.g_old_rec.attribute10,
214: p_attribute11 =>per_cag_shd.g_old_rec.attribute11,
215: p_attribute12 =>per_cag_shd.g_old_rec.attribute12,
216: p_attribute13 =>per_cag_shd.g_old_rec.attribute13,
217: p_attribute14 =>per_cag_shd.g_old_rec.attribute14,

Line 214: p_attribute11 =>per_cag_shd.g_old_rec.attribute11,

210: p_attribute7 =>per_cag_shd.g_old_rec.attribute7,
211: p_attribute8 =>per_cag_shd.g_old_rec.attribute8,
212: p_attribute9 =>per_cag_shd.g_old_rec.attribute9,
213: p_attribute10 =>per_cag_shd.g_old_rec.attribute10,
214: p_attribute11 =>per_cag_shd.g_old_rec.attribute11,
215: p_attribute12 =>per_cag_shd.g_old_rec.attribute12,
216: p_attribute13 =>per_cag_shd.g_old_rec.attribute13,
217: p_attribute14 =>per_cag_shd.g_old_rec.attribute14,
218: p_attribute15 =>per_cag_shd.g_old_rec.attribute15,

Line 215: p_attribute12 =>per_cag_shd.g_old_rec.attribute12,

211: p_attribute8 =>per_cag_shd.g_old_rec.attribute8,
212: p_attribute9 =>per_cag_shd.g_old_rec.attribute9,
213: p_attribute10 =>per_cag_shd.g_old_rec.attribute10,
214: p_attribute11 =>per_cag_shd.g_old_rec.attribute11,
215: p_attribute12 =>per_cag_shd.g_old_rec.attribute12,
216: p_attribute13 =>per_cag_shd.g_old_rec.attribute13,
217: p_attribute14 =>per_cag_shd.g_old_rec.attribute14,
218: p_attribute15 =>per_cag_shd.g_old_rec.attribute15,
219: p_attribute16 =>per_cag_shd.g_old_rec.attribute16,

Line 216: p_attribute13 =>per_cag_shd.g_old_rec.attribute13,

212: p_attribute9 =>per_cag_shd.g_old_rec.attribute9,
213: p_attribute10 =>per_cag_shd.g_old_rec.attribute10,
214: p_attribute11 =>per_cag_shd.g_old_rec.attribute11,
215: p_attribute12 =>per_cag_shd.g_old_rec.attribute12,
216: p_attribute13 =>per_cag_shd.g_old_rec.attribute13,
217: p_attribute14 =>per_cag_shd.g_old_rec.attribute14,
218: p_attribute15 =>per_cag_shd.g_old_rec.attribute15,
219: p_attribute16 =>per_cag_shd.g_old_rec.attribute16,
220: p_attribute17 =>per_cag_shd.g_old_rec.attribute17,

Line 217: p_attribute14 =>per_cag_shd.g_old_rec.attribute14,

213: p_attribute10 =>per_cag_shd.g_old_rec.attribute10,
214: p_attribute11 =>per_cag_shd.g_old_rec.attribute11,
215: p_attribute12 =>per_cag_shd.g_old_rec.attribute12,
216: p_attribute13 =>per_cag_shd.g_old_rec.attribute13,
217: p_attribute14 =>per_cag_shd.g_old_rec.attribute14,
218: p_attribute15 =>per_cag_shd.g_old_rec.attribute15,
219: p_attribute16 =>per_cag_shd.g_old_rec.attribute16,
220: p_attribute17 =>per_cag_shd.g_old_rec.attribute17,
221: p_attribute18 =>per_cag_shd.g_old_rec.attribute18,

Line 218: p_attribute15 =>per_cag_shd.g_old_rec.attribute15,

214: p_attribute11 =>per_cag_shd.g_old_rec.attribute11,
215: p_attribute12 =>per_cag_shd.g_old_rec.attribute12,
216: p_attribute13 =>per_cag_shd.g_old_rec.attribute13,
217: p_attribute14 =>per_cag_shd.g_old_rec.attribute14,
218: p_attribute15 =>per_cag_shd.g_old_rec.attribute15,
219: p_attribute16 =>per_cag_shd.g_old_rec.attribute16,
220: p_attribute17 =>per_cag_shd.g_old_rec.attribute17,
221: p_attribute18 =>per_cag_shd.g_old_rec.attribute18,
222: p_attribute19 =>per_cag_shd.g_old_rec.attribute19,

Line 219: p_attribute16 =>per_cag_shd.g_old_rec.attribute16,

215: p_attribute12 =>per_cag_shd.g_old_rec.attribute12,
216: p_attribute13 =>per_cag_shd.g_old_rec.attribute13,
217: p_attribute14 =>per_cag_shd.g_old_rec.attribute14,
218: p_attribute15 =>per_cag_shd.g_old_rec.attribute15,
219: p_attribute16 =>per_cag_shd.g_old_rec.attribute16,
220: p_attribute17 =>per_cag_shd.g_old_rec.attribute17,
221: p_attribute18 =>per_cag_shd.g_old_rec.attribute18,
222: p_attribute19 =>per_cag_shd.g_old_rec.attribute19,
223: p_attribute20 =>per_cag_shd.g_old_rec.attribute20

Line 220: p_attribute17 =>per_cag_shd.g_old_rec.attribute17,

216: p_attribute13 =>per_cag_shd.g_old_rec.attribute13,
217: p_attribute14 =>per_cag_shd.g_old_rec.attribute14,
218: p_attribute15 =>per_cag_shd.g_old_rec.attribute15,
219: p_attribute16 =>per_cag_shd.g_old_rec.attribute16,
220: p_attribute17 =>per_cag_shd.g_old_rec.attribute17,
221: p_attribute18 =>per_cag_shd.g_old_rec.attribute18,
222: p_attribute19 =>per_cag_shd.g_old_rec.attribute19,
223: p_attribute20 =>per_cag_shd.g_old_rec.attribute20
224: );

Line 221: p_attribute18 =>per_cag_shd.g_old_rec.attribute18,

217: p_attribute14 =>per_cag_shd.g_old_rec.attribute14,
218: p_attribute15 =>per_cag_shd.g_old_rec.attribute15,
219: p_attribute16 =>per_cag_shd.g_old_rec.attribute16,
220: p_attribute17 =>per_cag_shd.g_old_rec.attribute17,
221: p_attribute18 =>per_cag_shd.g_old_rec.attribute18,
222: p_attribute19 =>per_cag_shd.g_old_rec.attribute19,
223: p_attribute20 =>per_cag_shd.g_old_rec.attribute20
224: );
225: --

Line 222: p_attribute19 =>per_cag_shd.g_old_rec.attribute19,

218: p_attribute15 =>per_cag_shd.g_old_rec.attribute15,
219: p_attribute16 =>per_cag_shd.g_old_rec.attribute16,
220: p_attribute17 =>per_cag_shd.g_old_rec.attribute17,
221: p_attribute18 =>per_cag_shd.g_old_rec.attribute18,
222: p_attribute19 =>per_cag_shd.g_old_rec.attribute19,
223: p_attribute20 =>per_cag_shd.g_old_rec.attribute20
224: );
225: --
226: exception

Line 223: p_attribute20 =>per_cag_shd.g_old_rec.attribute20

219: p_attribute16 =>per_cag_shd.g_old_rec.attribute16,
220: p_attribute17 =>per_cag_shd.g_old_rec.attribute17,
221: p_attribute18 =>per_cag_shd.g_old_rec.attribute18,
222: p_attribute19 =>per_cag_shd.g_old_rec.attribute19,
223: p_attribute20 =>per_cag_shd.g_old_rec.attribute20
224: );
225: --
226: exception
227: --

Line 247: p_rec in per_cag_shd.g_rec_type

243: -- |---------------------------------< del >----------------------------------|
244: -- ----------------------------------------------------------------------------
245: Procedure del
246: (
247: p_rec in per_cag_shd.g_rec_type
248: ) is
249: --
250: l_proc varchar2(72) := g_package||'del';
251: --

Line 257: per_cag_shd.lck

253: hr_utility.set_location('Entering:'||l_proc, 5);
254: --
255: -- We must lock the row which we need to delete.
256: --
257: per_cag_shd.lck
258: (
259: p_rec.collective_agreement_id,
260: p_rec.object_version_number
261: );

Line 289: l_rec per_cag_shd.g_rec_type;

285: p_collective_agreement_id in number,
286: p_object_version_number in number
287: ) is
288: --
289: l_rec per_cag_shd.g_rec_type;
290: l_proc varchar2(72) := g_package||'del';
291: --
292: Begin
293: hr_utility.set_location('Entering:'||l_proc, 5);