DBA Data[Home] [Help]

APPS.PER_PYP_DEL dependencies on PER_PYP_SHD

Line 51: Procedure delete_dml(p_rec in per_pyp_shd.g_rec_type) is

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

Line 58: per_pyp_shd.g_api_dml := true; -- Set the api dml status

54: --
55: Begin
56: hr_utility.set_location('Entering:'||l_proc, 5);
57: --
58: per_pyp_shd.g_api_dml := true; -- Set the api dml status
59: --
60: -- Delete the per_pay_proposals row.
61: --
62: delete from per_pay_proposals

Line 65: per_pyp_shd.g_api_dml := false; -- Unset the api dml status

61: --
62: delete from per_pay_proposals
63: where pay_proposal_id = p_rec.pay_proposal_id;
64: --
65: per_pyp_shd.g_api_dml := false; -- Unset the api dml status
66: --
67: hr_utility.set_location(' Leaving:'||l_proc, 10);
68: --
69: Exception

Line 72: per_pyp_shd.g_api_dml := false; -- Unset the api dml status

68: --
69: Exception
70: When hr_api.child_integrity_violated then
71: -- Child integrity has been violated
72: per_pyp_shd.g_api_dml := false; -- Unset the api dml status
73: per_pyp_shd.constraint_error
74: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
75: When Others Then
76: per_pyp_shd.g_api_dml := false; -- Unset the api dml status

Line 73: per_pyp_shd.constraint_error

69: Exception
70: When hr_api.child_integrity_violated then
71: -- Child integrity has been violated
72: per_pyp_shd.g_api_dml := false; -- Unset the api dml status
73: per_pyp_shd.constraint_error
74: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
75: When Others Then
76: per_pyp_shd.g_api_dml := false; -- Unset the api dml status
77: Raise;

Line 76: per_pyp_shd.g_api_dml := false; -- Unset the api dml status

72: per_pyp_shd.g_api_dml := false; -- Unset the api dml status
73: per_pyp_shd.constraint_error
74: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
75: When Others Then
76: per_pyp_shd.g_api_dml := false; -- Unset the api dml status
77: Raise;
78: End delete_dml;
79: --
80: -- ----------------------------------------------------------------------------

Line 112: Procedure pre_delete(p_rec in per_pyp_shd.g_rec_type) is

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

Line 154: Procedure post_delete(p_rec in per_pyp_shd.g_rec_type) is

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

Line 168: p_assignment_id_o => per_pyp_shd.g_old_rec.assignment_id,

164: --
165: per_pyp_rkd.after_delete
166: (
167: p_pay_proposal_id => p_rec.pay_proposal_id,
168: p_assignment_id_o => per_pyp_shd.g_old_rec.assignment_id,
169: p_business_group_id_o => per_pyp_shd.g_old_rec.business_group_id,
170: p_change_date_o => per_pyp_shd.g_old_rec.change_date,
171: p_comments_o => per_pyp_shd.g_old_rec.comments,
172: p_next_sal_review_date_o => per_pyp_shd.g_old_rec.next_sal_review_date,

Line 169: p_business_group_id_o => per_pyp_shd.g_old_rec.business_group_id,

165: per_pyp_rkd.after_delete
166: (
167: p_pay_proposal_id => p_rec.pay_proposal_id,
168: p_assignment_id_o => per_pyp_shd.g_old_rec.assignment_id,
169: p_business_group_id_o => per_pyp_shd.g_old_rec.business_group_id,
170: p_change_date_o => per_pyp_shd.g_old_rec.change_date,
171: p_comments_o => per_pyp_shd.g_old_rec.comments,
172: p_next_sal_review_date_o => per_pyp_shd.g_old_rec.next_sal_review_date,
173: p_proposal_reason_o => per_pyp_shd.g_old_rec.proposal_reason,

Line 170: p_change_date_o => per_pyp_shd.g_old_rec.change_date,

166: (
167: p_pay_proposal_id => p_rec.pay_proposal_id,
168: p_assignment_id_o => per_pyp_shd.g_old_rec.assignment_id,
169: p_business_group_id_o => per_pyp_shd.g_old_rec.business_group_id,
170: p_change_date_o => per_pyp_shd.g_old_rec.change_date,
171: p_comments_o => per_pyp_shd.g_old_rec.comments,
172: p_next_sal_review_date_o => per_pyp_shd.g_old_rec.next_sal_review_date,
173: p_proposal_reason_o => per_pyp_shd.g_old_rec.proposal_reason,
174: p_proposed_salary_n_o => per_pyp_shd.g_old_rec.proposed_salary_n,

Line 171: p_comments_o => per_pyp_shd.g_old_rec.comments,

167: p_pay_proposal_id => p_rec.pay_proposal_id,
168: p_assignment_id_o => per_pyp_shd.g_old_rec.assignment_id,
169: p_business_group_id_o => per_pyp_shd.g_old_rec.business_group_id,
170: p_change_date_o => per_pyp_shd.g_old_rec.change_date,
171: p_comments_o => per_pyp_shd.g_old_rec.comments,
172: p_next_sal_review_date_o => per_pyp_shd.g_old_rec.next_sal_review_date,
173: p_proposal_reason_o => per_pyp_shd.g_old_rec.proposal_reason,
174: p_proposed_salary_n_o => per_pyp_shd.g_old_rec.proposed_salary_n,
175: p_forced_ranking_o => per_pyp_shd.g_old_rec.forced_ranking,

Line 172: p_next_sal_review_date_o => per_pyp_shd.g_old_rec.next_sal_review_date,

168: p_assignment_id_o => per_pyp_shd.g_old_rec.assignment_id,
169: p_business_group_id_o => per_pyp_shd.g_old_rec.business_group_id,
170: p_change_date_o => per_pyp_shd.g_old_rec.change_date,
171: p_comments_o => per_pyp_shd.g_old_rec.comments,
172: p_next_sal_review_date_o => per_pyp_shd.g_old_rec.next_sal_review_date,
173: p_proposal_reason_o => per_pyp_shd.g_old_rec.proposal_reason,
174: p_proposed_salary_n_o => per_pyp_shd.g_old_rec.proposed_salary_n,
175: p_forced_ranking_o => per_pyp_shd.g_old_rec.forced_ranking,
176: p_date_to_o => per_pyp_shd.g_old_rec.date_to,

Line 173: p_proposal_reason_o => per_pyp_shd.g_old_rec.proposal_reason,

169: p_business_group_id_o => per_pyp_shd.g_old_rec.business_group_id,
170: p_change_date_o => per_pyp_shd.g_old_rec.change_date,
171: p_comments_o => per_pyp_shd.g_old_rec.comments,
172: p_next_sal_review_date_o => per_pyp_shd.g_old_rec.next_sal_review_date,
173: p_proposal_reason_o => per_pyp_shd.g_old_rec.proposal_reason,
174: p_proposed_salary_n_o => per_pyp_shd.g_old_rec.proposed_salary_n,
175: p_forced_ranking_o => per_pyp_shd.g_old_rec.forced_ranking,
176: p_date_to_o => per_pyp_shd.g_old_rec.date_to,
177: p_performance_review_id_o => per_pyp_shd.g_old_rec.performance_review_id,

Line 174: p_proposed_salary_n_o => per_pyp_shd.g_old_rec.proposed_salary_n,

170: p_change_date_o => per_pyp_shd.g_old_rec.change_date,
171: p_comments_o => per_pyp_shd.g_old_rec.comments,
172: p_next_sal_review_date_o => per_pyp_shd.g_old_rec.next_sal_review_date,
173: p_proposal_reason_o => per_pyp_shd.g_old_rec.proposal_reason,
174: p_proposed_salary_n_o => per_pyp_shd.g_old_rec.proposed_salary_n,
175: p_forced_ranking_o => per_pyp_shd.g_old_rec.forced_ranking,
176: p_date_to_o => per_pyp_shd.g_old_rec.date_to,
177: p_performance_review_id_o => per_pyp_shd.g_old_rec.performance_review_id,
178: p_attribute_category_o => per_pyp_shd.g_old_rec.attribute_category,

Line 175: p_forced_ranking_o => per_pyp_shd.g_old_rec.forced_ranking,

171: p_comments_o => per_pyp_shd.g_old_rec.comments,
172: p_next_sal_review_date_o => per_pyp_shd.g_old_rec.next_sal_review_date,
173: p_proposal_reason_o => per_pyp_shd.g_old_rec.proposal_reason,
174: p_proposed_salary_n_o => per_pyp_shd.g_old_rec.proposed_salary_n,
175: p_forced_ranking_o => per_pyp_shd.g_old_rec.forced_ranking,
176: p_date_to_o => per_pyp_shd.g_old_rec.date_to,
177: p_performance_review_id_o => per_pyp_shd.g_old_rec.performance_review_id,
178: p_attribute_category_o => per_pyp_shd.g_old_rec.attribute_category,
179: p_attribute1_o => per_pyp_shd.g_old_rec.attribute1,

Line 176: p_date_to_o => per_pyp_shd.g_old_rec.date_to,

172: p_next_sal_review_date_o => per_pyp_shd.g_old_rec.next_sal_review_date,
173: p_proposal_reason_o => per_pyp_shd.g_old_rec.proposal_reason,
174: p_proposed_salary_n_o => per_pyp_shd.g_old_rec.proposed_salary_n,
175: p_forced_ranking_o => per_pyp_shd.g_old_rec.forced_ranking,
176: p_date_to_o => per_pyp_shd.g_old_rec.date_to,
177: p_performance_review_id_o => per_pyp_shd.g_old_rec.performance_review_id,
178: p_attribute_category_o => per_pyp_shd.g_old_rec.attribute_category,
179: p_attribute1_o => per_pyp_shd.g_old_rec.attribute1,
180: p_attribute2_o => per_pyp_shd.g_old_rec.attribute2,

Line 177: p_performance_review_id_o => per_pyp_shd.g_old_rec.performance_review_id,

173: p_proposal_reason_o => per_pyp_shd.g_old_rec.proposal_reason,
174: p_proposed_salary_n_o => per_pyp_shd.g_old_rec.proposed_salary_n,
175: p_forced_ranking_o => per_pyp_shd.g_old_rec.forced_ranking,
176: p_date_to_o => per_pyp_shd.g_old_rec.date_to,
177: p_performance_review_id_o => per_pyp_shd.g_old_rec.performance_review_id,
178: p_attribute_category_o => per_pyp_shd.g_old_rec.attribute_category,
179: p_attribute1_o => per_pyp_shd.g_old_rec.attribute1,
180: p_attribute2_o => per_pyp_shd.g_old_rec.attribute2,
181: p_attribute3_o => per_pyp_shd.g_old_rec.attribute3,

Line 178: p_attribute_category_o => per_pyp_shd.g_old_rec.attribute_category,

174: p_proposed_salary_n_o => per_pyp_shd.g_old_rec.proposed_salary_n,
175: p_forced_ranking_o => per_pyp_shd.g_old_rec.forced_ranking,
176: p_date_to_o => per_pyp_shd.g_old_rec.date_to,
177: p_performance_review_id_o => per_pyp_shd.g_old_rec.performance_review_id,
178: p_attribute_category_o => per_pyp_shd.g_old_rec.attribute_category,
179: p_attribute1_o => per_pyp_shd.g_old_rec.attribute1,
180: p_attribute2_o => per_pyp_shd.g_old_rec.attribute2,
181: p_attribute3_o => per_pyp_shd.g_old_rec.attribute3,
182: p_attribute4_o => per_pyp_shd.g_old_rec.attribute4,

Line 179: p_attribute1_o => per_pyp_shd.g_old_rec.attribute1,

175: p_forced_ranking_o => per_pyp_shd.g_old_rec.forced_ranking,
176: p_date_to_o => per_pyp_shd.g_old_rec.date_to,
177: p_performance_review_id_o => per_pyp_shd.g_old_rec.performance_review_id,
178: p_attribute_category_o => per_pyp_shd.g_old_rec.attribute_category,
179: p_attribute1_o => per_pyp_shd.g_old_rec.attribute1,
180: p_attribute2_o => per_pyp_shd.g_old_rec.attribute2,
181: p_attribute3_o => per_pyp_shd.g_old_rec.attribute3,
182: p_attribute4_o => per_pyp_shd.g_old_rec.attribute4,
183: p_attribute5_o => per_pyp_shd.g_old_rec.attribute5,

Line 180: p_attribute2_o => per_pyp_shd.g_old_rec.attribute2,

176: p_date_to_o => per_pyp_shd.g_old_rec.date_to,
177: p_performance_review_id_o => per_pyp_shd.g_old_rec.performance_review_id,
178: p_attribute_category_o => per_pyp_shd.g_old_rec.attribute_category,
179: p_attribute1_o => per_pyp_shd.g_old_rec.attribute1,
180: p_attribute2_o => per_pyp_shd.g_old_rec.attribute2,
181: p_attribute3_o => per_pyp_shd.g_old_rec.attribute3,
182: p_attribute4_o => per_pyp_shd.g_old_rec.attribute4,
183: p_attribute5_o => per_pyp_shd.g_old_rec.attribute5,
184: p_attribute6_o => per_pyp_shd.g_old_rec.attribute6,

Line 181: p_attribute3_o => per_pyp_shd.g_old_rec.attribute3,

177: p_performance_review_id_o => per_pyp_shd.g_old_rec.performance_review_id,
178: p_attribute_category_o => per_pyp_shd.g_old_rec.attribute_category,
179: p_attribute1_o => per_pyp_shd.g_old_rec.attribute1,
180: p_attribute2_o => per_pyp_shd.g_old_rec.attribute2,
181: p_attribute3_o => per_pyp_shd.g_old_rec.attribute3,
182: p_attribute4_o => per_pyp_shd.g_old_rec.attribute4,
183: p_attribute5_o => per_pyp_shd.g_old_rec.attribute5,
184: p_attribute6_o => per_pyp_shd.g_old_rec.attribute6,
185: p_attribute7_o => per_pyp_shd.g_old_rec.attribute7,

Line 182: p_attribute4_o => per_pyp_shd.g_old_rec.attribute4,

178: p_attribute_category_o => per_pyp_shd.g_old_rec.attribute_category,
179: p_attribute1_o => per_pyp_shd.g_old_rec.attribute1,
180: p_attribute2_o => per_pyp_shd.g_old_rec.attribute2,
181: p_attribute3_o => per_pyp_shd.g_old_rec.attribute3,
182: p_attribute4_o => per_pyp_shd.g_old_rec.attribute4,
183: p_attribute5_o => per_pyp_shd.g_old_rec.attribute5,
184: p_attribute6_o => per_pyp_shd.g_old_rec.attribute6,
185: p_attribute7_o => per_pyp_shd.g_old_rec.attribute7,
186: p_attribute8_o => per_pyp_shd.g_old_rec.attribute8,

Line 183: p_attribute5_o => per_pyp_shd.g_old_rec.attribute5,

179: p_attribute1_o => per_pyp_shd.g_old_rec.attribute1,
180: p_attribute2_o => per_pyp_shd.g_old_rec.attribute2,
181: p_attribute3_o => per_pyp_shd.g_old_rec.attribute3,
182: p_attribute4_o => per_pyp_shd.g_old_rec.attribute4,
183: p_attribute5_o => per_pyp_shd.g_old_rec.attribute5,
184: p_attribute6_o => per_pyp_shd.g_old_rec.attribute6,
185: p_attribute7_o => per_pyp_shd.g_old_rec.attribute7,
186: p_attribute8_o => per_pyp_shd.g_old_rec.attribute8,
187: p_attribute9_o => per_pyp_shd.g_old_rec.attribute9,

Line 184: p_attribute6_o => per_pyp_shd.g_old_rec.attribute6,

180: p_attribute2_o => per_pyp_shd.g_old_rec.attribute2,
181: p_attribute3_o => per_pyp_shd.g_old_rec.attribute3,
182: p_attribute4_o => per_pyp_shd.g_old_rec.attribute4,
183: p_attribute5_o => per_pyp_shd.g_old_rec.attribute5,
184: p_attribute6_o => per_pyp_shd.g_old_rec.attribute6,
185: p_attribute7_o => per_pyp_shd.g_old_rec.attribute7,
186: p_attribute8_o => per_pyp_shd.g_old_rec.attribute8,
187: p_attribute9_o => per_pyp_shd.g_old_rec.attribute9,
188: p_attribute10_o => per_pyp_shd.g_old_rec.attribute10,

Line 185: p_attribute7_o => per_pyp_shd.g_old_rec.attribute7,

181: p_attribute3_o => per_pyp_shd.g_old_rec.attribute3,
182: p_attribute4_o => per_pyp_shd.g_old_rec.attribute4,
183: p_attribute5_o => per_pyp_shd.g_old_rec.attribute5,
184: p_attribute6_o => per_pyp_shd.g_old_rec.attribute6,
185: p_attribute7_o => per_pyp_shd.g_old_rec.attribute7,
186: p_attribute8_o => per_pyp_shd.g_old_rec.attribute8,
187: p_attribute9_o => per_pyp_shd.g_old_rec.attribute9,
188: p_attribute10_o => per_pyp_shd.g_old_rec.attribute10,
189: p_attribute11_o => per_pyp_shd.g_old_rec.attribute11,

Line 186: p_attribute8_o => per_pyp_shd.g_old_rec.attribute8,

182: p_attribute4_o => per_pyp_shd.g_old_rec.attribute4,
183: p_attribute5_o => per_pyp_shd.g_old_rec.attribute5,
184: p_attribute6_o => per_pyp_shd.g_old_rec.attribute6,
185: p_attribute7_o => per_pyp_shd.g_old_rec.attribute7,
186: p_attribute8_o => per_pyp_shd.g_old_rec.attribute8,
187: p_attribute9_o => per_pyp_shd.g_old_rec.attribute9,
188: p_attribute10_o => per_pyp_shd.g_old_rec.attribute10,
189: p_attribute11_o => per_pyp_shd.g_old_rec.attribute11,
190: p_attribute12_o => per_pyp_shd.g_old_rec.attribute12,

Line 187: p_attribute9_o => per_pyp_shd.g_old_rec.attribute9,

183: p_attribute5_o => per_pyp_shd.g_old_rec.attribute5,
184: p_attribute6_o => per_pyp_shd.g_old_rec.attribute6,
185: p_attribute7_o => per_pyp_shd.g_old_rec.attribute7,
186: p_attribute8_o => per_pyp_shd.g_old_rec.attribute8,
187: p_attribute9_o => per_pyp_shd.g_old_rec.attribute9,
188: p_attribute10_o => per_pyp_shd.g_old_rec.attribute10,
189: p_attribute11_o => per_pyp_shd.g_old_rec.attribute11,
190: p_attribute12_o => per_pyp_shd.g_old_rec.attribute12,
191: p_attribute13_o => per_pyp_shd.g_old_rec.attribute13,

Line 188: p_attribute10_o => per_pyp_shd.g_old_rec.attribute10,

184: p_attribute6_o => per_pyp_shd.g_old_rec.attribute6,
185: p_attribute7_o => per_pyp_shd.g_old_rec.attribute7,
186: p_attribute8_o => per_pyp_shd.g_old_rec.attribute8,
187: p_attribute9_o => per_pyp_shd.g_old_rec.attribute9,
188: p_attribute10_o => per_pyp_shd.g_old_rec.attribute10,
189: p_attribute11_o => per_pyp_shd.g_old_rec.attribute11,
190: p_attribute12_o => per_pyp_shd.g_old_rec.attribute12,
191: p_attribute13_o => per_pyp_shd.g_old_rec.attribute13,
192: p_attribute14_o => per_pyp_shd.g_old_rec.attribute14,

Line 189: p_attribute11_o => per_pyp_shd.g_old_rec.attribute11,

185: p_attribute7_o => per_pyp_shd.g_old_rec.attribute7,
186: p_attribute8_o => per_pyp_shd.g_old_rec.attribute8,
187: p_attribute9_o => per_pyp_shd.g_old_rec.attribute9,
188: p_attribute10_o => per_pyp_shd.g_old_rec.attribute10,
189: p_attribute11_o => per_pyp_shd.g_old_rec.attribute11,
190: p_attribute12_o => per_pyp_shd.g_old_rec.attribute12,
191: p_attribute13_o => per_pyp_shd.g_old_rec.attribute13,
192: p_attribute14_o => per_pyp_shd.g_old_rec.attribute14,
193: p_attribute15_o => per_pyp_shd.g_old_rec.attribute15,

Line 190: p_attribute12_o => per_pyp_shd.g_old_rec.attribute12,

186: p_attribute8_o => per_pyp_shd.g_old_rec.attribute8,
187: p_attribute9_o => per_pyp_shd.g_old_rec.attribute9,
188: p_attribute10_o => per_pyp_shd.g_old_rec.attribute10,
189: p_attribute11_o => per_pyp_shd.g_old_rec.attribute11,
190: p_attribute12_o => per_pyp_shd.g_old_rec.attribute12,
191: p_attribute13_o => per_pyp_shd.g_old_rec.attribute13,
192: p_attribute14_o => per_pyp_shd.g_old_rec.attribute14,
193: p_attribute15_o => per_pyp_shd.g_old_rec.attribute15,
194: p_attribute16_o => per_pyp_shd.g_old_rec.attribute16,

Line 191: p_attribute13_o => per_pyp_shd.g_old_rec.attribute13,

187: p_attribute9_o => per_pyp_shd.g_old_rec.attribute9,
188: p_attribute10_o => per_pyp_shd.g_old_rec.attribute10,
189: p_attribute11_o => per_pyp_shd.g_old_rec.attribute11,
190: p_attribute12_o => per_pyp_shd.g_old_rec.attribute12,
191: p_attribute13_o => per_pyp_shd.g_old_rec.attribute13,
192: p_attribute14_o => per_pyp_shd.g_old_rec.attribute14,
193: p_attribute15_o => per_pyp_shd.g_old_rec.attribute15,
194: p_attribute16_o => per_pyp_shd.g_old_rec.attribute16,
195: p_attribute17_o => per_pyp_shd.g_old_rec.attribute17,

Line 192: p_attribute14_o => per_pyp_shd.g_old_rec.attribute14,

188: p_attribute10_o => per_pyp_shd.g_old_rec.attribute10,
189: p_attribute11_o => per_pyp_shd.g_old_rec.attribute11,
190: p_attribute12_o => per_pyp_shd.g_old_rec.attribute12,
191: p_attribute13_o => per_pyp_shd.g_old_rec.attribute13,
192: p_attribute14_o => per_pyp_shd.g_old_rec.attribute14,
193: p_attribute15_o => per_pyp_shd.g_old_rec.attribute15,
194: p_attribute16_o => per_pyp_shd.g_old_rec.attribute16,
195: p_attribute17_o => per_pyp_shd.g_old_rec.attribute17,
196: p_attribute18_o => per_pyp_shd.g_old_rec.attribute18,

Line 193: p_attribute15_o => per_pyp_shd.g_old_rec.attribute15,

189: p_attribute11_o => per_pyp_shd.g_old_rec.attribute11,
190: p_attribute12_o => per_pyp_shd.g_old_rec.attribute12,
191: p_attribute13_o => per_pyp_shd.g_old_rec.attribute13,
192: p_attribute14_o => per_pyp_shd.g_old_rec.attribute14,
193: p_attribute15_o => per_pyp_shd.g_old_rec.attribute15,
194: p_attribute16_o => per_pyp_shd.g_old_rec.attribute16,
195: p_attribute17_o => per_pyp_shd.g_old_rec.attribute17,
196: p_attribute18_o => per_pyp_shd.g_old_rec.attribute18,
197: p_attribute19_o => per_pyp_shd.g_old_rec.attribute19,

Line 194: p_attribute16_o => per_pyp_shd.g_old_rec.attribute16,

190: p_attribute12_o => per_pyp_shd.g_old_rec.attribute12,
191: p_attribute13_o => per_pyp_shd.g_old_rec.attribute13,
192: p_attribute14_o => per_pyp_shd.g_old_rec.attribute14,
193: p_attribute15_o => per_pyp_shd.g_old_rec.attribute15,
194: p_attribute16_o => per_pyp_shd.g_old_rec.attribute16,
195: p_attribute17_o => per_pyp_shd.g_old_rec.attribute17,
196: p_attribute18_o => per_pyp_shd.g_old_rec.attribute18,
197: p_attribute19_o => per_pyp_shd.g_old_rec.attribute19,
198: p_attribute20_o => per_pyp_shd.g_old_rec.attribute20,

Line 195: p_attribute17_o => per_pyp_shd.g_old_rec.attribute17,

191: p_attribute13_o => per_pyp_shd.g_old_rec.attribute13,
192: p_attribute14_o => per_pyp_shd.g_old_rec.attribute14,
193: p_attribute15_o => per_pyp_shd.g_old_rec.attribute15,
194: p_attribute16_o => per_pyp_shd.g_old_rec.attribute16,
195: p_attribute17_o => per_pyp_shd.g_old_rec.attribute17,
196: p_attribute18_o => per_pyp_shd.g_old_rec.attribute18,
197: p_attribute19_o => per_pyp_shd.g_old_rec.attribute19,
198: p_attribute20_o => per_pyp_shd.g_old_rec.attribute20,
199: p_object_version_number_o => per_pyp_shd.g_old_rec.object_version_number,

Line 196: p_attribute18_o => per_pyp_shd.g_old_rec.attribute18,

192: p_attribute14_o => per_pyp_shd.g_old_rec.attribute14,
193: p_attribute15_o => per_pyp_shd.g_old_rec.attribute15,
194: p_attribute16_o => per_pyp_shd.g_old_rec.attribute16,
195: p_attribute17_o => per_pyp_shd.g_old_rec.attribute17,
196: p_attribute18_o => per_pyp_shd.g_old_rec.attribute18,
197: p_attribute19_o => per_pyp_shd.g_old_rec.attribute19,
198: p_attribute20_o => per_pyp_shd.g_old_rec.attribute20,
199: p_object_version_number_o => per_pyp_shd.g_old_rec.object_version_number,
200: p_multiple_components_o => per_pyp_shd.g_old_rec.multiple_components,

Line 197: p_attribute19_o => per_pyp_shd.g_old_rec.attribute19,

193: p_attribute15_o => per_pyp_shd.g_old_rec.attribute15,
194: p_attribute16_o => per_pyp_shd.g_old_rec.attribute16,
195: p_attribute17_o => per_pyp_shd.g_old_rec.attribute17,
196: p_attribute18_o => per_pyp_shd.g_old_rec.attribute18,
197: p_attribute19_o => per_pyp_shd.g_old_rec.attribute19,
198: p_attribute20_o => per_pyp_shd.g_old_rec.attribute20,
199: p_object_version_number_o => per_pyp_shd.g_old_rec.object_version_number,
200: p_multiple_components_o => per_pyp_shd.g_old_rec.multiple_components,
201: p_approved_o => per_pyp_shd.g_old_rec.approved

Line 198: p_attribute20_o => per_pyp_shd.g_old_rec.attribute20,

194: p_attribute16_o => per_pyp_shd.g_old_rec.attribute16,
195: p_attribute17_o => per_pyp_shd.g_old_rec.attribute17,
196: p_attribute18_o => per_pyp_shd.g_old_rec.attribute18,
197: p_attribute19_o => per_pyp_shd.g_old_rec.attribute19,
198: p_attribute20_o => per_pyp_shd.g_old_rec.attribute20,
199: p_object_version_number_o => per_pyp_shd.g_old_rec.object_version_number,
200: p_multiple_components_o => per_pyp_shd.g_old_rec.multiple_components,
201: p_approved_o => per_pyp_shd.g_old_rec.approved
202: );

Line 199: p_object_version_number_o => per_pyp_shd.g_old_rec.object_version_number,

195: p_attribute17_o => per_pyp_shd.g_old_rec.attribute17,
196: p_attribute18_o => per_pyp_shd.g_old_rec.attribute18,
197: p_attribute19_o => per_pyp_shd.g_old_rec.attribute19,
198: p_attribute20_o => per_pyp_shd.g_old_rec.attribute20,
199: p_object_version_number_o => per_pyp_shd.g_old_rec.object_version_number,
200: p_multiple_components_o => per_pyp_shd.g_old_rec.multiple_components,
201: p_approved_o => per_pyp_shd.g_old_rec.approved
202: );
203: --

Line 200: p_multiple_components_o => per_pyp_shd.g_old_rec.multiple_components,

196: p_attribute18_o => per_pyp_shd.g_old_rec.attribute18,
197: p_attribute19_o => per_pyp_shd.g_old_rec.attribute19,
198: p_attribute20_o => per_pyp_shd.g_old_rec.attribute20,
199: p_object_version_number_o => per_pyp_shd.g_old_rec.object_version_number,
200: p_multiple_components_o => per_pyp_shd.g_old_rec.multiple_components,
201: p_approved_o => per_pyp_shd.g_old_rec.approved
202: );
203: --
204: exception

Line 201: p_approved_o => per_pyp_shd.g_old_rec.approved

197: p_attribute19_o => per_pyp_shd.g_old_rec.attribute19,
198: p_attribute20_o => per_pyp_shd.g_old_rec.attribute20,
199: p_object_version_number_o => per_pyp_shd.g_old_rec.object_version_number,
200: p_multiple_components_o => per_pyp_shd.g_old_rec.multiple_components,
201: p_approved_o => per_pyp_shd.g_old_rec.approved
202: );
203: --
204: exception
205: when hr_api.cannot_find_prog_unit then

Line 220: p_rec in per_pyp_shd.g_rec_type,

216: -- |---------------------------------< del >----------------------------------|
217: -- ----------------------------------------------------------------------------
218: Procedure del
219: (
220: p_rec in per_pyp_shd.g_rec_type,
221: p_validate in boolean,
222: p_salary_warning out nocopy boolean
223: ) is
224: --

Line 241: per_pyp_shd.lck

237: End If;
238: --
239: -- We must lock the row which we need to delete.
240: --
241: per_pyp_shd.lck
242: (
243: p_rec.pay_proposal_id,
244: p_rec.object_version_number
245: );

Line 294: l_rec per_pyp_shd.g_rec_type;

290: p_salary_warning out nocopy boolean
291:
292: ) is
293: --
294: l_rec per_pyp_shd.g_rec_type;
295: l_proc varchar2(72) := g_package||'del';
296: --
297: Begin
298: hr_utility.set_location('Entering:'||l_proc, 5);