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_PSS_DEL dependencies on PER_PSS_SHD

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

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

Line 70: per_pss_shd.constraint_error

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

Line 108: Procedure pre_delete(p_rec in per_pss_shd.g_rec_type) is

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

Line 150: Procedure post_delete(p_rec in per_pss_shd.g_rec_type) is

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

Line 162: => per_pss_shd.g_old_rec.object_version_number,

158: per_pss_rkd.after_delete
159: (p_salary_survey_id
160: => p_rec.salary_survey_id,
161: p_object_version_number_o
162: => per_pss_shd.g_old_rec.object_version_number,
163: p_survey_name_o
164: => per_pss_shd.g_old_rec.survey_name,
165: p_survey_company_code_o
166: => p_rec.survey_company_code,

Line 164: => per_pss_shd.g_old_rec.survey_name,

160: => p_rec.salary_survey_id,
161: p_object_version_number_o
162: => per_pss_shd.g_old_rec.object_version_number,
163: p_survey_name_o
164: => per_pss_shd.g_old_rec.survey_name,
165: p_survey_company_code_o
166: => p_rec.survey_company_code,
167: p_identifier_o
168: => p_rec.identifier,

Line 170: --ras => per_pss_shd.g_old_rec.currency_code,

166: => p_rec.survey_company_code,
167: p_identifier_o
168: => p_rec.identifier,
169: --ras p_currency_code_o
170: --ras => per_pss_shd.g_old_rec.currency_code,
171: p_survey_type_code_o
172: => per_pss_shd.g_old_rec.survey_type_code,
173: p_base_region_o
174: => per_pss_shd.g_old_rec.base_region,

Line 172: => per_pss_shd.g_old_rec.survey_type_code,

168: => p_rec.identifier,
169: --ras p_currency_code_o
170: --ras => per_pss_shd.g_old_rec.currency_code,
171: p_survey_type_code_o
172: => per_pss_shd.g_old_rec.survey_type_code,
173: p_base_region_o
174: => per_pss_shd.g_old_rec.base_region,
175: p_attribute_category_o
176: => per_pss_shd.g_old_rec.attribute_category,

Line 174: => per_pss_shd.g_old_rec.base_region,

170: --ras => per_pss_shd.g_old_rec.currency_code,
171: p_survey_type_code_o
172: => per_pss_shd.g_old_rec.survey_type_code,
173: p_base_region_o
174: => per_pss_shd.g_old_rec.base_region,
175: p_attribute_category_o
176: => per_pss_shd.g_old_rec.attribute_category,
177: p_attribute1_o
178: => per_pss_shd.g_old_rec.attribute1,

Line 176: => per_pss_shd.g_old_rec.attribute_category,

172: => per_pss_shd.g_old_rec.survey_type_code,
173: p_base_region_o
174: => per_pss_shd.g_old_rec.base_region,
175: p_attribute_category_o
176: => per_pss_shd.g_old_rec.attribute_category,
177: p_attribute1_o
178: => per_pss_shd.g_old_rec.attribute1,
179: p_attribute2_o
180: => per_pss_shd.g_old_rec.attribute2,

Line 178: => per_pss_shd.g_old_rec.attribute1,

174: => per_pss_shd.g_old_rec.base_region,
175: p_attribute_category_o
176: => per_pss_shd.g_old_rec.attribute_category,
177: p_attribute1_o
178: => per_pss_shd.g_old_rec.attribute1,
179: p_attribute2_o
180: => per_pss_shd.g_old_rec.attribute2,
181: p_attribute3_o
182: => per_pss_shd.g_old_rec.attribute3,

Line 180: => per_pss_shd.g_old_rec.attribute2,

176: => per_pss_shd.g_old_rec.attribute_category,
177: p_attribute1_o
178: => per_pss_shd.g_old_rec.attribute1,
179: p_attribute2_o
180: => per_pss_shd.g_old_rec.attribute2,
181: p_attribute3_o
182: => per_pss_shd.g_old_rec.attribute3,
183: p_attribute4_o
184: => per_pss_shd.g_old_rec.attribute4,

Line 182: => per_pss_shd.g_old_rec.attribute3,

178: => per_pss_shd.g_old_rec.attribute1,
179: p_attribute2_o
180: => per_pss_shd.g_old_rec.attribute2,
181: p_attribute3_o
182: => per_pss_shd.g_old_rec.attribute3,
183: p_attribute4_o
184: => per_pss_shd.g_old_rec.attribute4,
185: p_attribute5_o
186: => per_pss_shd.g_old_rec.attribute5,

Line 184: => per_pss_shd.g_old_rec.attribute4,

180: => per_pss_shd.g_old_rec.attribute2,
181: p_attribute3_o
182: => per_pss_shd.g_old_rec.attribute3,
183: p_attribute4_o
184: => per_pss_shd.g_old_rec.attribute4,
185: p_attribute5_o
186: => per_pss_shd.g_old_rec.attribute5,
187: p_attribute6_o
188: => per_pss_shd.g_old_rec.attribute6,

Line 186: => per_pss_shd.g_old_rec.attribute5,

182: => per_pss_shd.g_old_rec.attribute3,
183: p_attribute4_o
184: => per_pss_shd.g_old_rec.attribute4,
185: p_attribute5_o
186: => per_pss_shd.g_old_rec.attribute5,
187: p_attribute6_o
188: => per_pss_shd.g_old_rec.attribute6,
189: p_attribute7_o
190: => per_pss_shd.g_old_rec.attribute7,

Line 188: => per_pss_shd.g_old_rec.attribute6,

184: => per_pss_shd.g_old_rec.attribute4,
185: p_attribute5_o
186: => per_pss_shd.g_old_rec.attribute5,
187: p_attribute6_o
188: => per_pss_shd.g_old_rec.attribute6,
189: p_attribute7_o
190: => per_pss_shd.g_old_rec.attribute7,
191: p_attribute8_o
192: => per_pss_shd.g_old_rec.attribute8,

Line 190: => per_pss_shd.g_old_rec.attribute7,

186: => per_pss_shd.g_old_rec.attribute5,
187: p_attribute6_o
188: => per_pss_shd.g_old_rec.attribute6,
189: p_attribute7_o
190: => per_pss_shd.g_old_rec.attribute7,
191: p_attribute8_o
192: => per_pss_shd.g_old_rec.attribute8,
193: p_attribute9_o
194: => per_pss_shd.g_old_rec.attribute9,

Line 192: => per_pss_shd.g_old_rec.attribute8,

188: => per_pss_shd.g_old_rec.attribute6,
189: p_attribute7_o
190: => per_pss_shd.g_old_rec.attribute7,
191: p_attribute8_o
192: => per_pss_shd.g_old_rec.attribute8,
193: p_attribute9_o
194: => per_pss_shd.g_old_rec.attribute9,
195: p_attribute10_o
196: => per_pss_shd.g_old_rec.attribute10,

Line 194: => per_pss_shd.g_old_rec.attribute9,

190: => per_pss_shd.g_old_rec.attribute7,
191: p_attribute8_o
192: => per_pss_shd.g_old_rec.attribute8,
193: p_attribute9_o
194: => per_pss_shd.g_old_rec.attribute9,
195: p_attribute10_o
196: => per_pss_shd.g_old_rec.attribute10,
197: p_attribute11_o
198: => per_pss_shd.g_old_rec.attribute11,

Line 196: => per_pss_shd.g_old_rec.attribute10,

192: => per_pss_shd.g_old_rec.attribute8,
193: p_attribute9_o
194: => per_pss_shd.g_old_rec.attribute9,
195: p_attribute10_o
196: => per_pss_shd.g_old_rec.attribute10,
197: p_attribute11_o
198: => per_pss_shd.g_old_rec.attribute11,
199: p_attribute12_o
200: => per_pss_shd.g_old_rec.attribute12,

Line 198: => per_pss_shd.g_old_rec.attribute11,

194: => per_pss_shd.g_old_rec.attribute9,
195: p_attribute10_o
196: => per_pss_shd.g_old_rec.attribute10,
197: p_attribute11_o
198: => per_pss_shd.g_old_rec.attribute11,
199: p_attribute12_o
200: => per_pss_shd.g_old_rec.attribute12,
201: p_attribute13_o
202: => per_pss_shd.g_old_rec.attribute13,

Line 200: => per_pss_shd.g_old_rec.attribute12,

196: => per_pss_shd.g_old_rec.attribute10,
197: p_attribute11_o
198: => per_pss_shd.g_old_rec.attribute11,
199: p_attribute12_o
200: => per_pss_shd.g_old_rec.attribute12,
201: p_attribute13_o
202: => per_pss_shd.g_old_rec.attribute13,
203: p_attribute14_o
204: => per_pss_shd.g_old_rec.attribute14,

Line 202: => per_pss_shd.g_old_rec.attribute13,

198: => per_pss_shd.g_old_rec.attribute11,
199: p_attribute12_o
200: => per_pss_shd.g_old_rec.attribute12,
201: p_attribute13_o
202: => per_pss_shd.g_old_rec.attribute13,
203: p_attribute14_o
204: => per_pss_shd.g_old_rec.attribute14,
205: p_attribute15_o
206: => per_pss_shd.g_old_rec.attribute15,

Line 204: => per_pss_shd.g_old_rec.attribute14,

200: => per_pss_shd.g_old_rec.attribute12,
201: p_attribute13_o
202: => per_pss_shd.g_old_rec.attribute13,
203: p_attribute14_o
204: => per_pss_shd.g_old_rec.attribute14,
205: p_attribute15_o
206: => per_pss_shd.g_old_rec.attribute15,
207: p_attribute16_o
208: => per_pss_shd.g_old_rec.attribute16,

Line 206: => per_pss_shd.g_old_rec.attribute15,

202: => per_pss_shd.g_old_rec.attribute13,
203: p_attribute14_o
204: => per_pss_shd.g_old_rec.attribute14,
205: p_attribute15_o
206: => per_pss_shd.g_old_rec.attribute15,
207: p_attribute16_o
208: => per_pss_shd.g_old_rec.attribute16,
209: p_attribute17_o
210: => per_pss_shd.g_old_rec.attribute17,

Line 208: => per_pss_shd.g_old_rec.attribute16,

204: => per_pss_shd.g_old_rec.attribute14,
205: p_attribute15_o
206: => per_pss_shd.g_old_rec.attribute15,
207: p_attribute16_o
208: => per_pss_shd.g_old_rec.attribute16,
209: p_attribute17_o
210: => per_pss_shd.g_old_rec.attribute17,
211: p_attribute18_o
212: => per_pss_shd.g_old_rec.attribute18,

Line 210: => per_pss_shd.g_old_rec.attribute17,

206: => per_pss_shd.g_old_rec.attribute15,
207: p_attribute16_o
208: => per_pss_shd.g_old_rec.attribute16,
209: p_attribute17_o
210: => per_pss_shd.g_old_rec.attribute17,
211: p_attribute18_o
212: => per_pss_shd.g_old_rec.attribute18,
213: p_attribute19_o
214: => per_pss_shd.g_old_rec.attribute19,

Line 212: => per_pss_shd.g_old_rec.attribute18,

208: => per_pss_shd.g_old_rec.attribute16,
209: p_attribute17_o
210: => per_pss_shd.g_old_rec.attribute17,
211: p_attribute18_o
212: => per_pss_shd.g_old_rec.attribute18,
213: p_attribute19_o
214: => per_pss_shd.g_old_rec.attribute19,
215: p_attribute20_o
216: => per_pss_shd.g_old_rec.attribute20

Line 214: => per_pss_shd.g_old_rec.attribute19,

210: => per_pss_shd.g_old_rec.attribute17,
211: p_attribute18_o
212: => per_pss_shd.g_old_rec.attribute18,
213: p_attribute19_o
214: => per_pss_shd.g_old_rec.attribute19,
215: p_attribute20_o
216: => per_pss_shd.g_old_rec.attribute20
217: );
218:

Line 216: => per_pss_shd.g_old_rec.attribute20

212: => per_pss_shd.g_old_rec.attribute18,
213: p_attribute19_o
214: => per_pss_shd.g_old_rec.attribute19,
215: p_attribute20_o
216: => per_pss_shd.g_old_rec.attribute20
217: );
218:
219: exception
220: when hr_api.cannot_find_prog_unit then

Line 236: p_rec in per_pss_shd.g_rec_type

232: -- |---------------------------------< del >----------------------------------|
233: -- ----------------------------------------------------------------------------
234: Procedure del
235: (
236: p_rec in per_pss_shd.g_rec_type
237: ) is
238: --
239: l_proc varchar2(72) := g_package||'del';
240: --

Line 246: per_pss_shd.lck

242: hr_utility.set_location('Entering:'||l_proc, 5);
243: --
244: -- We must lock the row which we need to delete.
245: --
246: per_pss_shd.lck
247: (
248: p_rec.salary_survey_id,
249: p_rec.object_version_number
250: );

Line 278: l_rec per_pss_shd.g_rec_type;

274: p_salary_survey_id in number,
275: p_object_version_number in number
276: ) is
277: --
278: l_rec per_pss_shd.g_rec_type;
279: l_proc varchar2(72) := g_package||'del';
280: --
281: Begin
282: hr_utility.set_location('Entering:'||l_proc, 5);