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_ECO_DEL dependencies on PER_ECO_SHD

Line 52: (p_rec in per_eco_shd.g_rec_type

48: --
49: -- {End Of Comments}
50: -- ----------------------------------------------------------------------------
51: Procedure delete_dml
52: (p_rec in per_eco_shd.g_rec_type
53: ) is
54: --
55: l_proc varchar2(72) := g_package||'delete_dml';
56: --

Line 60: per_eco_shd.g_api_dml := true; -- Set the api dml status

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

Line 67: per_eco_shd.g_api_dml := false; -- Unset the api dml status

63: --
64: delete from per_election_constituencys
65: where election_constituency_id = p_rec.election_constituency_id;
66: --
67: per_eco_shd.g_api_dml := false; -- Unset the api dml status
68: --
69: hr_utility.set_location(' Leaving:'||l_proc, 10);
70: --
71: Exception

Line 74: per_eco_shd.g_api_dml := false; -- Unset the api dml status

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

Line 75: per_eco_shd.constraint_error

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

Line 78: per_eco_shd.g_api_dml := false; -- Unset the api dml status

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

Line 114: Procedure pre_delete(p_rec in per_eco_shd.g_rec_type) is

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

Line 156: Procedure post_delete(p_rec in per_eco_shd.g_rec_type) is

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

Line 168: => per_eco_shd.g_old_rec.election_id

164: per_eco_rkd.after_delete
165: (p_election_constituency_id
166: => p_rec.election_constituency_id
167: ,p_election_id_o
168: => per_eco_shd.g_old_rec.election_id
169: ,p_business_group_id_o
170: => per_eco_shd.g_old_rec.business_group_id
171: ,p_constituency_id_o
172: => per_eco_shd.g_old_rec.constituency_id

Line 170: => per_eco_shd.g_old_rec.business_group_id

166: => p_rec.election_constituency_id
167: ,p_election_id_o
168: => per_eco_shd.g_old_rec.election_id
169: ,p_business_group_id_o
170: => per_eco_shd.g_old_rec.business_group_id
171: ,p_constituency_id_o
172: => per_eco_shd.g_old_rec.constituency_id
173: ,p_attribute_category_o
174: => per_eco_shd.g_old_rec.attribute_category

Line 172: => per_eco_shd.g_old_rec.constituency_id

168: => per_eco_shd.g_old_rec.election_id
169: ,p_business_group_id_o
170: => per_eco_shd.g_old_rec.business_group_id
171: ,p_constituency_id_o
172: => per_eco_shd.g_old_rec.constituency_id
173: ,p_attribute_category_o
174: => per_eco_shd.g_old_rec.attribute_category
175: ,p_attribute1_o
176: => per_eco_shd.g_old_rec.attribute1

Line 174: => per_eco_shd.g_old_rec.attribute_category

170: => per_eco_shd.g_old_rec.business_group_id
171: ,p_constituency_id_o
172: => per_eco_shd.g_old_rec.constituency_id
173: ,p_attribute_category_o
174: => per_eco_shd.g_old_rec.attribute_category
175: ,p_attribute1_o
176: => per_eco_shd.g_old_rec.attribute1
177: ,p_attribute2_o
178: => per_eco_shd.g_old_rec.attribute2

Line 176: => per_eco_shd.g_old_rec.attribute1

172: => per_eco_shd.g_old_rec.constituency_id
173: ,p_attribute_category_o
174: => per_eco_shd.g_old_rec.attribute_category
175: ,p_attribute1_o
176: => per_eco_shd.g_old_rec.attribute1
177: ,p_attribute2_o
178: => per_eco_shd.g_old_rec.attribute2
179: ,p_attribute3_o
180: => per_eco_shd.g_old_rec.attribute3

Line 178: => per_eco_shd.g_old_rec.attribute2

174: => per_eco_shd.g_old_rec.attribute_category
175: ,p_attribute1_o
176: => per_eco_shd.g_old_rec.attribute1
177: ,p_attribute2_o
178: => per_eco_shd.g_old_rec.attribute2
179: ,p_attribute3_o
180: => per_eco_shd.g_old_rec.attribute3
181: ,p_attribute4_o
182: => per_eco_shd.g_old_rec.attribute4

Line 180: => per_eco_shd.g_old_rec.attribute3

176: => per_eco_shd.g_old_rec.attribute1
177: ,p_attribute2_o
178: => per_eco_shd.g_old_rec.attribute2
179: ,p_attribute3_o
180: => per_eco_shd.g_old_rec.attribute3
181: ,p_attribute4_o
182: => per_eco_shd.g_old_rec.attribute4
183: ,p_attribute5_o
184: => per_eco_shd.g_old_rec.attribute5

Line 182: => per_eco_shd.g_old_rec.attribute4

178: => per_eco_shd.g_old_rec.attribute2
179: ,p_attribute3_o
180: => per_eco_shd.g_old_rec.attribute3
181: ,p_attribute4_o
182: => per_eco_shd.g_old_rec.attribute4
183: ,p_attribute5_o
184: => per_eco_shd.g_old_rec.attribute5
185: ,p_attribute6_o
186: => per_eco_shd.g_old_rec.attribute6

Line 184: => per_eco_shd.g_old_rec.attribute5

180: => per_eco_shd.g_old_rec.attribute3
181: ,p_attribute4_o
182: => per_eco_shd.g_old_rec.attribute4
183: ,p_attribute5_o
184: => per_eco_shd.g_old_rec.attribute5
185: ,p_attribute6_o
186: => per_eco_shd.g_old_rec.attribute6
187: ,p_attribute7_o
188: => per_eco_shd.g_old_rec.attribute7

Line 186: => per_eco_shd.g_old_rec.attribute6

182: => per_eco_shd.g_old_rec.attribute4
183: ,p_attribute5_o
184: => per_eco_shd.g_old_rec.attribute5
185: ,p_attribute6_o
186: => per_eco_shd.g_old_rec.attribute6
187: ,p_attribute7_o
188: => per_eco_shd.g_old_rec.attribute7
189: ,p_attribute8_o
190: => per_eco_shd.g_old_rec.attribute8

Line 188: => per_eco_shd.g_old_rec.attribute7

184: => per_eco_shd.g_old_rec.attribute5
185: ,p_attribute6_o
186: => per_eco_shd.g_old_rec.attribute6
187: ,p_attribute7_o
188: => per_eco_shd.g_old_rec.attribute7
189: ,p_attribute8_o
190: => per_eco_shd.g_old_rec.attribute8
191: ,p_attribute9_o
192: => per_eco_shd.g_old_rec.attribute9

Line 190: => per_eco_shd.g_old_rec.attribute8

186: => per_eco_shd.g_old_rec.attribute6
187: ,p_attribute7_o
188: => per_eco_shd.g_old_rec.attribute7
189: ,p_attribute8_o
190: => per_eco_shd.g_old_rec.attribute8
191: ,p_attribute9_o
192: => per_eco_shd.g_old_rec.attribute9
193: ,p_attribute10_o
194: => per_eco_shd.g_old_rec.attribute10

Line 192: => per_eco_shd.g_old_rec.attribute9

188: => per_eco_shd.g_old_rec.attribute7
189: ,p_attribute8_o
190: => per_eco_shd.g_old_rec.attribute8
191: ,p_attribute9_o
192: => per_eco_shd.g_old_rec.attribute9
193: ,p_attribute10_o
194: => per_eco_shd.g_old_rec.attribute10
195: ,p_attribute11_o
196: => per_eco_shd.g_old_rec.attribute11

Line 194: => per_eco_shd.g_old_rec.attribute10

190: => per_eco_shd.g_old_rec.attribute8
191: ,p_attribute9_o
192: => per_eco_shd.g_old_rec.attribute9
193: ,p_attribute10_o
194: => per_eco_shd.g_old_rec.attribute10
195: ,p_attribute11_o
196: => per_eco_shd.g_old_rec.attribute11
197: ,p_attribute12_o
198: => per_eco_shd.g_old_rec.attribute12

Line 196: => per_eco_shd.g_old_rec.attribute11

192: => per_eco_shd.g_old_rec.attribute9
193: ,p_attribute10_o
194: => per_eco_shd.g_old_rec.attribute10
195: ,p_attribute11_o
196: => per_eco_shd.g_old_rec.attribute11
197: ,p_attribute12_o
198: => per_eco_shd.g_old_rec.attribute12
199: ,p_attribute13_o
200: => per_eco_shd.g_old_rec.attribute13

Line 198: => per_eco_shd.g_old_rec.attribute12

194: => per_eco_shd.g_old_rec.attribute10
195: ,p_attribute11_o
196: => per_eco_shd.g_old_rec.attribute11
197: ,p_attribute12_o
198: => per_eco_shd.g_old_rec.attribute12
199: ,p_attribute13_o
200: => per_eco_shd.g_old_rec.attribute13
201: ,p_attribute14_o
202: => per_eco_shd.g_old_rec.attribute14

Line 200: => per_eco_shd.g_old_rec.attribute13

196: => per_eco_shd.g_old_rec.attribute11
197: ,p_attribute12_o
198: => per_eco_shd.g_old_rec.attribute12
199: ,p_attribute13_o
200: => per_eco_shd.g_old_rec.attribute13
201: ,p_attribute14_o
202: => per_eco_shd.g_old_rec.attribute14
203: ,p_attribute15_o
204: => per_eco_shd.g_old_rec.attribute15

Line 202: => per_eco_shd.g_old_rec.attribute14

198: => per_eco_shd.g_old_rec.attribute12
199: ,p_attribute13_o
200: => per_eco_shd.g_old_rec.attribute13
201: ,p_attribute14_o
202: => per_eco_shd.g_old_rec.attribute14
203: ,p_attribute15_o
204: => per_eco_shd.g_old_rec.attribute15
205: ,p_attribute16_o
206: => per_eco_shd.g_old_rec.attribute16

Line 204: => per_eco_shd.g_old_rec.attribute15

200: => per_eco_shd.g_old_rec.attribute13
201: ,p_attribute14_o
202: => per_eco_shd.g_old_rec.attribute14
203: ,p_attribute15_o
204: => per_eco_shd.g_old_rec.attribute15
205: ,p_attribute16_o
206: => per_eco_shd.g_old_rec.attribute16
207: ,p_attribute17_o
208: => per_eco_shd.g_old_rec.attribute17

Line 206: => per_eco_shd.g_old_rec.attribute16

202: => per_eco_shd.g_old_rec.attribute14
203: ,p_attribute15_o
204: => per_eco_shd.g_old_rec.attribute15
205: ,p_attribute16_o
206: => per_eco_shd.g_old_rec.attribute16
207: ,p_attribute17_o
208: => per_eco_shd.g_old_rec.attribute17
209: ,p_attribute18_o
210: => per_eco_shd.g_old_rec.attribute18

Line 208: => per_eco_shd.g_old_rec.attribute17

204: => per_eco_shd.g_old_rec.attribute15
205: ,p_attribute16_o
206: => per_eco_shd.g_old_rec.attribute16
207: ,p_attribute17_o
208: => per_eco_shd.g_old_rec.attribute17
209: ,p_attribute18_o
210: => per_eco_shd.g_old_rec.attribute18
211: ,p_attribute19_o
212: => per_eco_shd.g_old_rec.attribute19

Line 210: => per_eco_shd.g_old_rec.attribute18

206: => per_eco_shd.g_old_rec.attribute16
207: ,p_attribute17_o
208: => per_eco_shd.g_old_rec.attribute17
209: ,p_attribute18_o
210: => per_eco_shd.g_old_rec.attribute18
211: ,p_attribute19_o
212: => per_eco_shd.g_old_rec.attribute19
213: ,p_attribute20_o
214: => per_eco_shd.g_old_rec.attribute20

Line 212: => per_eco_shd.g_old_rec.attribute19

208: => per_eco_shd.g_old_rec.attribute17
209: ,p_attribute18_o
210: => per_eco_shd.g_old_rec.attribute18
211: ,p_attribute19_o
212: => per_eco_shd.g_old_rec.attribute19
213: ,p_attribute20_o
214: => per_eco_shd.g_old_rec.attribute20
215: ,p_attribute21_o
216: => per_eco_shd.g_old_rec.attribute21

Line 214: => per_eco_shd.g_old_rec.attribute20

210: => per_eco_shd.g_old_rec.attribute18
211: ,p_attribute19_o
212: => per_eco_shd.g_old_rec.attribute19
213: ,p_attribute20_o
214: => per_eco_shd.g_old_rec.attribute20
215: ,p_attribute21_o
216: => per_eco_shd.g_old_rec.attribute21
217: ,p_attribute22_o
218: => per_eco_shd.g_old_rec.attribute22

Line 216: => per_eco_shd.g_old_rec.attribute21

212: => per_eco_shd.g_old_rec.attribute19
213: ,p_attribute20_o
214: => per_eco_shd.g_old_rec.attribute20
215: ,p_attribute21_o
216: => per_eco_shd.g_old_rec.attribute21
217: ,p_attribute22_o
218: => per_eco_shd.g_old_rec.attribute22
219: ,p_attribute23_o
220: => per_eco_shd.g_old_rec.attribute23

Line 218: => per_eco_shd.g_old_rec.attribute22

214: => per_eco_shd.g_old_rec.attribute20
215: ,p_attribute21_o
216: => per_eco_shd.g_old_rec.attribute21
217: ,p_attribute22_o
218: => per_eco_shd.g_old_rec.attribute22
219: ,p_attribute23_o
220: => per_eco_shd.g_old_rec.attribute23
221: ,p_attribute24_o
222: => per_eco_shd.g_old_rec.attribute24

Line 220: => per_eco_shd.g_old_rec.attribute23

216: => per_eco_shd.g_old_rec.attribute21
217: ,p_attribute22_o
218: => per_eco_shd.g_old_rec.attribute22
219: ,p_attribute23_o
220: => per_eco_shd.g_old_rec.attribute23
221: ,p_attribute24_o
222: => per_eco_shd.g_old_rec.attribute24
223: ,p_attribute25_o
224: => per_eco_shd.g_old_rec.attribute25

Line 222: => per_eco_shd.g_old_rec.attribute24

218: => per_eco_shd.g_old_rec.attribute22
219: ,p_attribute23_o
220: => per_eco_shd.g_old_rec.attribute23
221: ,p_attribute24_o
222: => per_eco_shd.g_old_rec.attribute24
223: ,p_attribute25_o
224: => per_eco_shd.g_old_rec.attribute25
225: ,p_attribute26_o
226: => per_eco_shd.g_old_rec.attribute26

Line 224: => per_eco_shd.g_old_rec.attribute25

220: => per_eco_shd.g_old_rec.attribute23
221: ,p_attribute24_o
222: => per_eco_shd.g_old_rec.attribute24
223: ,p_attribute25_o
224: => per_eco_shd.g_old_rec.attribute25
225: ,p_attribute26_o
226: => per_eco_shd.g_old_rec.attribute26
227: ,p_attribute27_o
228: => per_eco_shd.g_old_rec.attribute27

Line 226: => per_eco_shd.g_old_rec.attribute26

222: => per_eco_shd.g_old_rec.attribute24
223: ,p_attribute25_o
224: => per_eco_shd.g_old_rec.attribute25
225: ,p_attribute26_o
226: => per_eco_shd.g_old_rec.attribute26
227: ,p_attribute27_o
228: => per_eco_shd.g_old_rec.attribute27
229: ,p_attribute28_o
230: => per_eco_shd.g_old_rec.attribute28

Line 228: => per_eco_shd.g_old_rec.attribute27

224: => per_eco_shd.g_old_rec.attribute25
225: ,p_attribute26_o
226: => per_eco_shd.g_old_rec.attribute26
227: ,p_attribute27_o
228: => per_eco_shd.g_old_rec.attribute27
229: ,p_attribute28_o
230: => per_eco_shd.g_old_rec.attribute28
231: ,p_attribute29_o
232: => per_eco_shd.g_old_rec.attribute29

Line 230: => per_eco_shd.g_old_rec.attribute28

226: => per_eco_shd.g_old_rec.attribute26
227: ,p_attribute27_o
228: => per_eco_shd.g_old_rec.attribute27
229: ,p_attribute28_o
230: => per_eco_shd.g_old_rec.attribute28
231: ,p_attribute29_o
232: => per_eco_shd.g_old_rec.attribute29
233: ,p_attribute30_o
234: => per_eco_shd.g_old_rec.attribute30

Line 232: => per_eco_shd.g_old_rec.attribute29

228: => per_eco_shd.g_old_rec.attribute27
229: ,p_attribute28_o
230: => per_eco_shd.g_old_rec.attribute28
231: ,p_attribute29_o
232: => per_eco_shd.g_old_rec.attribute29
233: ,p_attribute30_o
234: => per_eco_shd.g_old_rec.attribute30
235: ,p_object_version_number_o
236: => per_eco_shd.g_old_rec.object_version_number

Line 234: => per_eco_shd.g_old_rec.attribute30

230: => per_eco_shd.g_old_rec.attribute28
231: ,p_attribute29_o
232: => per_eco_shd.g_old_rec.attribute29
233: ,p_attribute30_o
234: => per_eco_shd.g_old_rec.attribute30
235: ,p_object_version_number_o
236: => per_eco_shd.g_old_rec.object_version_number
237: );
238: --

Line 236: => per_eco_shd.g_old_rec.object_version_number

232: => per_eco_shd.g_old_rec.attribute29
233: ,p_attribute30_o
234: => per_eco_shd.g_old_rec.attribute30
235: ,p_object_version_number_o
236: => per_eco_shd.g_old_rec.object_version_number
237: );
238: --
239: exception
240: --

Line 256: (p_rec in per_eco_shd.g_rec_type

252: -- ----------------------------------------------------------------------------
253: -- |---------------------------------< del >----------------------------------|
254: -- ----------------------------------------------------------------------------
255: Procedure del
256: (p_rec in per_eco_shd.g_rec_type
257: ,p_validate in boolean default false
258: ) is
259: --
260: l_proc varchar2(72) := g_package||'del';

Line 282: per_eco_shd.lck

278: ,p_argument => 'object_version_number'
279: ,p_argument_value => p_rec.object_version_number
280: );
281: --
282: per_eco_shd.lck
283: (p_rec.election_constituency_id
284: ,p_rec.object_version_number
285: );
286: --

Line 331: l_rec per_eco_shd.g_rec_type;

327: ,p_validate in boolean default false
328: ,p_object_version_number in number
329: ) is
330: --
331: l_rec per_eco_shd.g_rec_type;
332: l_proc varchar2(72) := g_package||'del';
333: --
334: Begin
335: hr_utility.set_location('Entering:'||l_proc, 5);