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_GRS_UPD dependencies on PER_GRS_SHD

Line 54: Procedure update_dml(p_rec in out nocopy per_grs_shd.g_rec_type) is

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

Line 65: per_grs_shd.g_api_dml := true; -- Set the api dml status

61: -- Increment the object version
62: --
63: p_rec.object_version_number := p_rec.object_version_number + 1;
64: --
65: per_grs_shd.g_api_dml := true; -- Set the api dml status
66: --
67: -- Update the per_cagr_grade_structures Row
68: --
69: update per_cagr_grade_structures

Line 99: per_grs_shd.g_api_dml := false; -- Unset the api dml status

95: attribute19 = p_rec.attribute19,
96: attribute20 = p_rec.attribute20
97: where cagr_grade_structure_id = p_rec.cagr_grade_structure_id;
98: --
99: per_grs_shd.g_api_dml := false; -- Unset the api dml status
100: --
101: hr_utility.set_location(' Leaving:'||l_proc, 10);
102: --
103: Exception

Line 106: per_grs_shd.g_api_dml := false; -- Unset the api dml status

102: --
103: Exception
104: When hr_api.check_integrity_violated Then
105: -- A check constraint has been violated
106: per_grs_shd.g_api_dml := false; -- Unset the api dml status
107: per_grs_shd.constraint_error
108: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
109: When hr_api.parent_integrity_violated Then
110: -- Parent integrity has been violated

Line 107: per_grs_shd.constraint_error

103: Exception
104: When hr_api.check_integrity_violated Then
105: -- A check constraint has been violated
106: per_grs_shd.g_api_dml := false; -- Unset the api dml status
107: per_grs_shd.constraint_error
108: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
109: When hr_api.parent_integrity_violated Then
110: -- Parent integrity has been violated
111: per_grs_shd.g_api_dml := false; -- Unset the api dml status

Line 111: per_grs_shd.g_api_dml := false; -- Unset the api dml status

107: per_grs_shd.constraint_error
108: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
109: When hr_api.parent_integrity_violated Then
110: -- Parent integrity has been violated
111: per_grs_shd.g_api_dml := false; -- Unset the api dml status
112: per_grs_shd.constraint_error
113: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
114: When hr_api.unique_integrity_violated Then
115: -- Unique integrity has been violated

Line 112: per_grs_shd.constraint_error

108: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
109: When hr_api.parent_integrity_violated Then
110: -- Parent integrity has been violated
111: per_grs_shd.g_api_dml := false; -- Unset the api dml status
112: per_grs_shd.constraint_error
113: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
114: When hr_api.unique_integrity_violated Then
115: -- Unique integrity has been violated
116: per_grs_shd.g_api_dml := false; -- Unset the api dml status

Line 116: per_grs_shd.g_api_dml := false; -- Unset the api dml status

112: per_grs_shd.constraint_error
113: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
114: When hr_api.unique_integrity_violated Then
115: -- Unique integrity has been violated
116: per_grs_shd.g_api_dml := false; -- Unset the api dml status
117: per_grs_shd.constraint_error
118: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
119: When Others Then
120: per_grs_shd.g_api_dml := false; -- Unset the api dml status

Line 117: per_grs_shd.constraint_error

113: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
114: When hr_api.unique_integrity_violated Then
115: -- Unique integrity has been violated
116: per_grs_shd.g_api_dml := false; -- Unset the api dml status
117: per_grs_shd.constraint_error
118: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
119: When Others Then
120: per_grs_shd.g_api_dml := false; -- Unset the api dml status
121: Raise;

Line 120: per_grs_shd.g_api_dml := false; -- Unset the api dml status

116: per_grs_shd.g_api_dml := false; -- Unset the api dml status
117: per_grs_shd.constraint_error
118: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
119: When Others Then
120: per_grs_shd.g_api_dml := false; -- Unset the api dml status
121: Raise;
122: End update_dml;
123: --
124: -- ----------------------------------------------------------------------------

Line 157: p_rec in per_grs_shd.g_rec_type) is

153: --
154: -- {End Of Comments}
155: -- ----------------------------------------------------------------------------
156: Procedure pre_update(p_effective_date in date,
157: p_rec in per_grs_shd.g_rec_type) is
158: --
159: l_proc varchar2(72) := g_package||'pre_update';
160: --
161: Begin

Line 200: p_rec in per_grs_shd.g_rec_type) is

196: --
197: -- {End Of Comments}
198: -- ----------------------------------------------------------------------------
199: Procedure post_update(p_effective_date in date,
200: p_rec in per_grs_shd.g_rec_type) is
201: --
202: l_proc varchar2(72) := g_package||'post_update';
203: --
204: Begin

Line 240: ,p_collective_agreement_id_o =>per_grs_shd.g_old_rec.collective_agreement_id

236: ,p_attribute17 =>p_rec.attribute17
237: ,p_attribute18 =>p_rec.attribute18
238: ,p_attribute19 =>p_rec.attribute19
239: ,p_attribute20 =>p_rec.attribute20
240: ,p_collective_agreement_id_o =>per_grs_shd.g_old_rec.collective_agreement_id
241: ,p_object_version_number_o =>per_grs_shd.g_old_rec.object_version_number
242: ,p_id_flex_num_o =>per_grs_shd.g_old_rec.id_flex_num
243: ,p_dynamic_insert_allowed_o =>per_grs_shd.g_old_rec.dynamic_insert_allowed
244: ,p_attribute_category_o =>per_grs_shd.g_old_rec.attribute_category

Line 241: ,p_object_version_number_o =>per_grs_shd.g_old_rec.object_version_number

237: ,p_attribute18 =>p_rec.attribute18
238: ,p_attribute19 =>p_rec.attribute19
239: ,p_attribute20 =>p_rec.attribute20
240: ,p_collective_agreement_id_o =>per_grs_shd.g_old_rec.collective_agreement_id
241: ,p_object_version_number_o =>per_grs_shd.g_old_rec.object_version_number
242: ,p_id_flex_num_o =>per_grs_shd.g_old_rec.id_flex_num
243: ,p_dynamic_insert_allowed_o =>per_grs_shd.g_old_rec.dynamic_insert_allowed
244: ,p_attribute_category_o =>per_grs_shd.g_old_rec.attribute_category
245: ,p_attribute1_o =>per_grs_shd.g_old_rec.attribute1

Line 242: ,p_id_flex_num_o =>per_grs_shd.g_old_rec.id_flex_num

238: ,p_attribute19 =>p_rec.attribute19
239: ,p_attribute20 =>p_rec.attribute20
240: ,p_collective_agreement_id_o =>per_grs_shd.g_old_rec.collective_agreement_id
241: ,p_object_version_number_o =>per_grs_shd.g_old_rec.object_version_number
242: ,p_id_flex_num_o =>per_grs_shd.g_old_rec.id_flex_num
243: ,p_dynamic_insert_allowed_o =>per_grs_shd.g_old_rec.dynamic_insert_allowed
244: ,p_attribute_category_o =>per_grs_shd.g_old_rec.attribute_category
245: ,p_attribute1_o =>per_grs_shd.g_old_rec.attribute1
246: ,p_attribute2_o =>per_grs_shd.g_old_rec.attribute2

Line 243: ,p_dynamic_insert_allowed_o =>per_grs_shd.g_old_rec.dynamic_insert_allowed

239: ,p_attribute20 =>p_rec.attribute20
240: ,p_collective_agreement_id_o =>per_grs_shd.g_old_rec.collective_agreement_id
241: ,p_object_version_number_o =>per_grs_shd.g_old_rec.object_version_number
242: ,p_id_flex_num_o =>per_grs_shd.g_old_rec.id_flex_num
243: ,p_dynamic_insert_allowed_o =>per_grs_shd.g_old_rec.dynamic_insert_allowed
244: ,p_attribute_category_o =>per_grs_shd.g_old_rec.attribute_category
245: ,p_attribute1_o =>per_grs_shd.g_old_rec.attribute1
246: ,p_attribute2_o =>per_grs_shd.g_old_rec.attribute2
247: ,p_attribute3_o =>per_grs_shd.g_old_rec.attribute3

Line 244: ,p_attribute_category_o =>per_grs_shd.g_old_rec.attribute_category

240: ,p_collective_agreement_id_o =>per_grs_shd.g_old_rec.collective_agreement_id
241: ,p_object_version_number_o =>per_grs_shd.g_old_rec.object_version_number
242: ,p_id_flex_num_o =>per_grs_shd.g_old_rec.id_flex_num
243: ,p_dynamic_insert_allowed_o =>per_grs_shd.g_old_rec.dynamic_insert_allowed
244: ,p_attribute_category_o =>per_grs_shd.g_old_rec.attribute_category
245: ,p_attribute1_o =>per_grs_shd.g_old_rec.attribute1
246: ,p_attribute2_o =>per_grs_shd.g_old_rec.attribute2
247: ,p_attribute3_o =>per_grs_shd.g_old_rec.attribute3
248: ,p_attribute4_o =>per_grs_shd.g_old_rec.attribute4

Line 245: ,p_attribute1_o =>per_grs_shd.g_old_rec.attribute1

241: ,p_object_version_number_o =>per_grs_shd.g_old_rec.object_version_number
242: ,p_id_flex_num_o =>per_grs_shd.g_old_rec.id_flex_num
243: ,p_dynamic_insert_allowed_o =>per_grs_shd.g_old_rec.dynamic_insert_allowed
244: ,p_attribute_category_o =>per_grs_shd.g_old_rec.attribute_category
245: ,p_attribute1_o =>per_grs_shd.g_old_rec.attribute1
246: ,p_attribute2_o =>per_grs_shd.g_old_rec.attribute2
247: ,p_attribute3_o =>per_grs_shd.g_old_rec.attribute3
248: ,p_attribute4_o =>per_grs_shd.g_old_rec.attribute4
249: ,p_attribute5_o =>per_grs_shd.g_old_rec.attribute5

Line 246: ,p_attribute2_o =>per_grs_shd.g_old_rec.attribute2

242: ,p_id_flex_num_o =>per_grs_shd.g_old_rec.id_flex_num
243: ,p_dynamic_insert_allowed_o =>per_grs_shd.g_old_rec.dynamic_insert_allowed
244: ,p_attribute_category_o =>per_grs_shd.g_old_rec.attribute_category
245: ,p_attribute1_o =>per_grs_shd.g_old_rec.attribute1
246: ,p_attribute2_o =>per_grs_shd.g_old_rec.attribute2
247: ,p_attribute3_o =>per_grs_shd.g_old_rec.attribute3
248: ,p_attribute4_o =>per_grs_shd.g_old_rec.attribute4
249: ,p_attribute5_o =>per_grs_shd.g_old_rec.attribute5
250: ,p_attribute6_o =>per_grs_shd.g_old_rec.attribute6

Line 247: ,p_attribute3_o =>per_grs_shd.g_old_rec.attribute3

243: ,p_dynamic_insert_allowed_o =>per_grs_shd.g_old_rec.dynamic_insert_allowed
244: ,p_attribute_category_o =>per_grs_shd.g_old_rec.attribute_category
245: ,p_attribute1_o =>per_grs_shd.g_old_rec.attribute1
246: ,p_attribute2_o =>per_grs_shd.g_old_rec.attribute2
247: ,p_attribute3_o =>per_grs_shd.g_old_rec.attribute3
248: ,p_attribute4_o =>per_grs_shd.g_old_rec.attribute4
249: ,p_attribute5_o =>per_grs_shd.g_old_rec.attribute5
250: ,p_attribute6_o =>per_grs_shd.g_old_rec.attribute6
251: ,p_attribute7_o =>per_grs_shd.g_old_rec.attribute7

Line 248: ,p_attribute4_o =>per_grs_shd.g_old_rec.attribute4

244: ,p_attribute_category_o =>per_grs_shd.g_old_rec.attribute_category
245: ,p_attribute1_o =>per_grs_shd.g_old_rec.attribute1
246: ,p_attribute2_o =>per_grs_shd.g_old_rec.attribute2
247: ,p_attribute3_o =>per_grs_shd.g_old_rec.attribute3
248: ,p_attribute4_o =>per_grs_shd.g_old_rec.attribute4
249: ,p_attribute5_o =>per_grs_shd.g_old_rec.attribute5
250: ,p_attribute6_o =>per_grs_shd.g_old_rec.attribute6
251: ,p_attribute7_o =>per_grs_shd.g_old_rec.attribute7
252: ,p_attribute8_o =>per_grs_shd.g_old_rec.attribute8

Line 249: ,p_attribute5_o =>per_grs_shd.g_old_rec.attribute5

245: ,p_attribute1_o =>per_grs_shd.g_old_rec.attribute1
246: ,p_attribute2_o =>per_grs_shd.g_old_rec.attribute2
247: ,p_attribute3_o =>per_grs_shd.g_old_rec.attribute3
248: ,p_attribute4_o =>per_grs_shd.g_old_rec.attribute4
249: ,p_attribute5_o =>per_grs_shd.g_old_rec.attribute5
250: ,p_attribute6_o =>per_grs_shd.g_old_rec.attribute6
251: ,p_attribute7_o =>per_grs_shd.g_old_rec.attribute7
252: ,p_attribute8_o =>per_grs_shd.g_old_rec.attribute8
253: ,p_attribute9_o =>per_grs_shd.g_old_rec.attribute9

Line 250: ,p_attribute6_o =>per_grs_shd.g_old_rec.attribute6

246: ,p_attribute2_o =>per_grs_shd.g_old_rec.attribute2
247: ,p_attribute3_o =>per_grs_shd.g_old_rec.attribute3
248: ,p_attribute4_o =>per_grs_shd.g_old_rec.attribute4
249: ,p_attribute5_o =>per_grs_shd.g_old_rec.attribute5
250: ,p_attribute6_o =>per_grs_shd.g_old_rec.attribute6
251: ,p_attribute7_o =>per_grs_shd.g_old_rec.attribute7
252: ,p_attribute8_o =>per_grs_shd.g_old_rec.attribute8
253: ,p_attribute9_o =>per_grs_shd.g_old_rec.attribute9
254: ,p_attribute10_o =>per_grs_shd.g_old_rec.attribute10

Line 251: ,p_attribute7_o =>per_grs_shd.g_old_rec.attribute7

247: ,p_attribute3_o =>per_grs_shd.g_old_rec.attribute3
248: ,p_attribute4_o =>per_grs_shd.g_old_rec.attribute4
249: ,p_attribute5_o =>per_grs_shd.g_old_rec.attribute5
250: ,p_attribute6_o =>per_grs_shd.g_old_rec.attribute6
251: ,p_attribute7_o =>per_grs_shd.g_old_rec.attribute7
252: ,p_attribute8_o =>per_grs_shd.g_old_rec.attribute8
253: ,p_attribute9_o =>per_grs_shd.g_old_rec.attribute9
254: ,p_attribute10_o =>per_grs_shd.g_old_rec.attribute10
255: ,p_attribute11_o =>per_grs_shd.g_old_rec.attribute11

Line 252: ,p_attribute8_o =>per_grs_shd.g_old_rec.attribute8

248: ,p_attribute4_o =>per_grs_shd.g_old_rec.attribute4
249: ,p_attribute5_o =>per_grs_shd.g_old_rec.attribute5
250: ,p_attribute6_o =>per_grs_shd.g_old_rec.attribute6
251: ,p_attribute7_o =>per_grs_shd.g_old_rec.attribute7
252: ,p_attribute8_o =>per_grs_shd.g_old_rec.attribute8
253: ,p_attribute9_o =>per_grs_shd.g_old_rec.attribute9
254: ,p_attribute10_o =>per_grs_shd.g_old_rec.attribute10
255: ,p_attribute11_o =>per_grs_shd.g_old_rec.attribute11
256: ,p_attribute12_o =>per_grs_shd.g_old_rec.attribute12

Line 253: ,p_attribute9_o =>per_grs_shd.g_old_rec.attribute9

249: ,p_attribute5_o =>per_grs_shd.g_old_rec.attribute5
250: ,p_attribute6_o =>per_grs_shd.g_old_rec.attribute6
251: ,p_attribute7_o =>per_grs_shd.g_old_rec.attribute7
252: ,p_attribute8_o =>per_grs_shd.g_old_rec.attribute8
253: ,p_attribute9_o =>per_grs_shd.g_old_rec.attribute9
254: ,p_attribute10_o =>per_grs_shd.g_old_rec.attribute10
255: ,p_attribute11_o =>per_grs_shd.g_old_rec.attribute11
256: ,p_attribute12_o =>per_grs_shd.g_old_rec.attribute12
257: ,p_attribute13_o =>per_grs_shd.g_old_rec.attribute13

Line 254: ,p_attribute10_o =>per_grs_shd.g_old_rec.attribute10

250: ,p_attribute6_o =>per_grs_shd.g_old_rec.attribute6
251: ,p_attribute7_o =>per_grs_shd.g_old_rec.attribute7
252: ,p_attribute8_o =>per_grs_shd.g_old_rec.attribute8
253: ,p_attribute9_o =>per_grs_shd.g_old_rec.attribute9
254: ,p_attribute10_o =>per_grs_shd.g_old_rec.attribute10
255: ,p_attribute11_o =>per_grs_shd.g_old_rec.attribute11
256: ,p_attribute12_o =>per_grs_shd.g_old_rec.attribute12
257: ,p_attribute13_o =>per_grs_shd.g_old_rec.attribute13
258: ,p_attribute14_o =>per_grs_shd.g_old_rec.attribute14

Line 255: ,p_attribute11_o =>per_grs_shd.g_old_rec.attribute11

251: ,p_attribute7_o =>per_grs_shd.g_old_rec.attribute7
252: ,p_attribute8_o =>per_grs_shd.g_old_rec.attribute8
253: ,p_attribute9_o =>per_grs_shd.g_old_rec.attribute9
254: ,p_attribute10_o =>per_grs_shd.g_old_rec.attribute10
255: ,p_attribute11_o =>per_grs_shd.g_old_rec.attribute11
256: ,p_attribute12_o =>per_grs_shd.g_old_rec.attribute12
257: ,p_attribute13_o =>per_grs_shd.g_old_rec.attribute13
258: ,p_attribute14_o =>per_grs_shd.g_old_rec.attribute14
259: ,p_attribute15_o =>per_grs_shd.g_old_rec.attribute15

Line 256: ,p_attribute12_o =>per_grs_shd.g_old_rec.attribute12

252: ,p_attribute8_o =>per_grs_shd.g_old_rec.attribute8
253: ,p_attribute9_o =>per_grs_shd.g_old_rec.attribute9
254: ,p_attribute10_o =>per_grs_shd.g_old_rec.attribute10
255: ,p_attribute11_o =>per_grs_shd.g_old_rec.attribute11
256: ,p_attribute12_o =>per_grs_shd.g_old_rec.attribute12
257: ,p_attribute13_o =>per_grs_shd.g_old_rec.attribute13
258: ,p_attribute14_o =>per_grs_shd.g_old_rec.attribute14
259: ,p_attribute15_o =>per_grs_shd.g_old_rec.attribute15
260: ,p_attribute16_o =>per_grs_shd.g_old_rec.attribute16

Line 257: ,p_attribute13_o =>per_grs_shd.g_old_rec.attribute13

253: ,p_attribute9_o =>per_grs_shd.g_old_rec.attribute9
254: ,p_attribute10_o =>per_grs_shd.g_old_rec.attribute10
255: ,p_attribute11_o =>per_grs_shd.g_old_rec.attribute11
256: ,p_attribute12_o =>per_grs_shd.g_old_rec.attribute12
257: ,p_attribute13_o =>per_grs_shd.g_old_rec.attribute13
258: ,p_attribute14_o =>per_grs_shd.g_old_rec.attribute14
259: ,p_attribute15_o =>per_grs_shd.g_old_rec.attribute15
260: ,p_attribute16_o =>per_grs_shd.g_old_rec.attribute16
261: ,p_attribute17_o =>per_grs_shd.g_old_rec.attribute17

Line 258: ,p_attribute14_o =>per_grs_shd.g_old_rec.attribute14

254: ,p_attribute10_o =>per_grs_shd.g_old_rec.attribute10
255: ,p_attribute11_o =>per_grs_shd.g_old_rec.attribute11
256: ,p_attribute12_o =>per_grs_shd.g_old_rec.attribute12
257: ,p_attribute13_o =>per_grs_shd.g_old_rec.attribute13
258: ,p_attribute14_o =>per_grs_shd.g_old_rec.attribute14
259: ,p_attribute15_o =>per_grs_shd.g_old_rec.attribute15
260: ,p_attribute16_o =>per_grs_shd.g_old_rec.attribute16
261: ,p_attribute17_o =>per_grs_shd.g_old_rec.attribute17
262: ,p_attribute18_o =>per_grs_shd.g_old_rec.attribute18

Line 259: ,p_attribute15_o =>per_grs_shd.g_old_rec.attribute15

255: ,p_attribute11_o =>per_grs_shd.g_old_rec.attribute11
256: ,p_attribute12_o =>per_grs_shd.g_old_rec.attribute12
257: ,p_attribute13_o =>per_grs_shd.g_old_rec.attribute13
258: ,p_attribute14_o =>per_grs_shd.g_old_rec.attribute14
259: ,p_attribute15_o =>per_grs_shd.g_old_rec.attribute15
260: ,p_attribute16_o =>per_grs_shd.g_old_rec.attribute16
261: ,p_attribute17_o =>per_grs_shd.g_old_rec.attribute17
262: ,p_attribute18_o =>per_grs_shd.g_old_rec.attribute18
263: ,p_attribute19_o =>per_grs_shd.g_old_rec.attribute19

Line 260: ,p_attribute16_o =>per_grs_shd.g_old_rec.attribute16

256: ,p_attribute12_o =>per_grs_shd.g_old_rec.attribute12
257: ,p_attribute13_o =>per_grs_shd.g_old_rec.attribute13
258: ,p_attribute14_o =>per_grs_shd.g_old_rec.attribute14
259: ,p_attribute15_o =>per_grs_shd.g_old_rec.attribute15
260: ,p_attribute16_o =>per_grs_shd.g_old_rec.attribute16
261: ,p_attribute17_o =>per_grs_shd.g_old_rec.attribute17
262: ,p_attribute18_o =>per_grs_shd.g_old_rec.attribute18
263: ,p_attribute19_o =>per_grs_shd.g_old_rec.attribute19
264: ,p_attribute20_o =>per_grs_shd.g_old_rec.attribute20

Line 261: ,p_attribute17_o =>per_grs_shd.g_old_rec.attribute17

257: ,p_attribute13_o =>per_grs_shd.g_old_rec.attribute13
258: ,p_attribute14_o =>per_grs_shd.g_old_rec.attribute14
259: ,p_attribute15_o =>per_grs_shd.g_old_rec.attribute15
260: ,p_attribute16_o =>per_grs_shd.g_old_rec.attribute16
261: ,p_attribute17_o =>per_grs_shd.g_old_rec.attribute17
262: ,p_attribute18_o =>per_grs_shd.g_old_rec.attribute18
263: ,p_attribute19_o =>per_grs_shd.g_old_rec.attribute19
264: ,p_attribute20_o =>per_grs_shd.g_old_rec.attribute20
265: ,p_effective_date =>p_effective_date

Line 262: ,p_attribute18_o =>per_grs_shd.g_old_rec.attribute18

258: ,p_attribute14_o =>per_grs_shd.g_old_rec.attribute14
259: ,p_attribute15_o =>per_grs_shd.g_old_rec.attribute15
260: ,p_attribute16_o =>per_grs_shd.g_old_rec.attribute16
261: ,p_attribute17_o =>per_grs_shd.g_old_rec.attribute17
262: ,p_attribute18_o =>per_grs_shd.g_old_rec.attribute18
263: ,p_attribute19_o =>per_grs_shd.g_old_rec.attribute19
264: ,p_attribute20_o =>per_grs_shd.g_old_rec.attribute20
265: ,p_effective_date =>p_effective_date
266: );

Line 263: ,p_attribute19_o =>per_grs_shd.g_old_rec.attribute19

259: ,p_attribute15_o =>per_grs_shd.g_old_rec.attribute15
260: ,p_attribute16_o =>per_grs_shd.g_old_rec.attribute16
261: ,p_attribute17_o =>per_grs_shd.g_old_rec.attribute17
262: ,p_attribute18_o =>per_grs_shd.g_old_rec.attribute18
263: ,p_attribute19_o =>per_grs_shd.g_old_rec.attribute19
264: ,p_attribute20_o =>per_grs_shd.g_old_rec.attribute20
265: ,p_effective_date =>p_effective_date
266: );
267: --

Line 264: ,p_attribute20_o =>per_grs_shd.g_old_rec.attribute20

260: ,p_attribute16_o =>per_grs_shd.g_old_rec.attribute16
261: ,p_attribute17_o =>per_grs_shd.g_old_rec.attribute17
262: ,p_attribute18_o =>per_grs_shd.g_old_rec.attribute18
263: ,p_attribute19_o =>per_grs_shd.g_old_rec.attribute19
264: ,p_attribute20_o =>per_grs_shd.g_old_rec.attribute20
265: ,p_effective_date =>p_effective_date
266: );
267: --
268: exception

Line 327: Procedure convert_defs(p_rec in out nocopy per_grs_shd.g_rec_type) is

323: -- Internal Row Handler Use Only.
324: --
325: -- {End Of Comments}
326: -- ----------------------------------------------------------------------------
327: Procedure convert_defs(p_rec in out nocopy per_grs_shd.g_rec_type) is
328: --
329: l_proc varchar2(72) := g_package||'convert_defs';
330: --
331: Begin

Line 342: per_grs_shd.g_old_rec.collective_agreement_id;

338: -- is being used then we must set to the 'current' argument value.
339: --
340: If (p_rec.collective_agreement_id = hr_api.g_number) then
341: p_rec.collective_agreement_id :=
342: per_grs_shd.g_old_rec.collective_agreement_id;
343: End If;
344: If (p_rec.id_flex_num = hr_api.g_number) then
345: p_rec.id_flex_num :=
346: per_grs_shd.g_old_rec.id_flex_num;

Line 346: per_grs_shd.g_old_rec.id_flex_num;

342: per_grs_shd.g_old_rec.collective_agreement_id;
343: End If;
344: If (p_rec.id_flex_num = hr_api.g_number) then
345: p_rec.id_flex_num :=
346: per_grs_shd.g_old_rec.id_flex_num;
347: End If;
348: If (p_rec.dynamic_insert_allowed = hr_api.g_varchar2) then
349: p_rec.dynamic_insert_allowed :=
350: per_grs_shd.g_old_rec.dynamic_insert_allowed;

Line 350: per_grs_shd.g_old_rec.dynamic_insert_allowed;

346: per_grs_shd.g_old_rec.id_flex_num;
347: End If;
348: If (p_rec.dynamic_insert_allowed = hr_api.g_varchar2) then
349: p_rec.dynamic_insert_allowed :=
350: per_grs_shd.g_old_rec.dynamic_insert_allowed;
351: End If;
352: If (p_rec.attribute_category = hr_api.g_varchar2) then
353: p_rec.attribute_category :=
354: per_grs_shd.g_old_rec.attribute_category;

Line 354: per_grs_shd.g_old_rec.attribute_category;

350: per_grs_shd.g_old_rec.dynamic_insert_allowed;
351: End If;
352: If (p_rec.attribute_category = hr_api.g_varchar2) then
353: p_rec.attribute_category :=
354: per_grs_shd.g_old_rec.attribute_category;
355: End If;
356: If (p_rec.attribute1 = hr_api.g_varchar2) then
357: p_rec.attribute1 :=
358: per_grs_shd.g_old_rec.attribute1;

Line 358: per_grs_shd.g_old_rec.attribute1;

354: per_grs_shd.g_old_rec.attribute_category;
355: End If;
356: If (p_rec.attribute1 = hr_api.g_varchar2) then
357: p_rec.attribute1 :=
358: per_grs_shd.g_old_rec.attribute1;
359: End If;
360: If (p_rec.attribute2 = hr_api.g_varchar2) then
361: p_rec.attribute2 :=
362: per_grs_shd.g_old_rec.attribute2;

Line 362: per_grs_shd.g_old_rec.attribute2;

358: per_grs_shd.g_old_rec.attribute1;
359: End If;
360: If (p_rec.attribute2 = hr_api.g_varchar2) then
361: p_rec.attribute2 :=
362: per_grs_shd.g_old_rec.attribute2;
363: End If;
364: If (p_rec.attribute3 = hr_api.g_varchar2) then
365: p_rec.attribute3 :=
366: per_grs_shd.g_old_rec.attribute3;

Line 366: per_grs_shd.g_old_rec.attribute3;

362: per_grs_shd.g_old_rec.attribute2;
363: End If;
364: If (p_rec.attribute3 = hr_api.g_varchar2) then
365: p_rec.attribute3 :=
366: per_grs_shd.g_old_rec.attribute3;
367: End If;
368: If (p_rec.attribute4 = hr_api.g_varchar2) then
369: p_rec.attribute4 :=
370: per_grs_shd.g_old_rec.attribute4;

Line 370: per_grs_shd.g_old_rec.attribute4;

366: per_grs_shd.g_old_rec.attribute3;
367: End If;
368: If (p_rec.attribute4 = hr_api.g_varchar2) then
369: p_rec.attribute4 :=
370: per_grs_shd.g_old_rec.attribute4;
371: End If;
372: If (p_rec.attribute5 = hr_api.g_varchar2) then
373: p_rec.attribute5 :=
374: per_grs_shd.g_old_rec.attribute5;

Line 374: per_grs_shd.g_old_rec.attribute5;

370: per_grs_shd.g_old_rec.attribute4;
371: End If;
372: If (p_rec.attribute5 = hr_api.g_varchar2) then
373: p_rec.attribute5 :=
374: per_grs_shd.g_old_rec.attribute5;
375: End If;
376: If (p_rec.attribute6 = hr_api.g_varchar2) then
377: p_rec.attribute6 :=
378: per_grs_shd.g_old_rec.attribute6;

Line 378: per_grs_shd.g_old_rec.attribute6;

374: per_grs_shd.g_old_rec.attribute5;
375: End If;
376: If (p_rec.attribute6 = hr_api.g_varchar2) then
377: p_rec.attribute6 :=
378: per_grs_shd.g_old_rec.attribute6;
379: End If;
380: If (p_rec.attribute7 = hr_api.g_varchar2) then
381: p_rec.attribute7 :=
382: per_grs_shd.g_old_rec.attribute7;

Line 382: per_grs_shd.g_old_rec.attribute7;

378: per_grs_shd.g_old_rec.attribute6;
379: End If;
380: If (p_rec.attribute7 = hr_api.g_varchar2) then
381: p_rec.attribute7 :=
382: per_grs_shd.g_old_rec.attribute7;
383: End If;
384: If (p_rec.attribute8 = hr_api.g_varchar2) then
385: p_rec.attribute8 :=
386: per_grs_shd.g_old_rec.attribute8;

Line 386: per_grs_shd.g_old_rec.attribute8;

382: per_grs_shd.g_old_rec.attribute7;
383: End If;
384: If (p_rec.attribute8 = hr_api.g_varchar2) then
385: p_rec.attribute8 :=
386: per_grs_shd.g_old_rec.attribute8;
387: End If;
388: If (p_rec.attribute9 = hr_api.g_varchar2) then
389: p_rec.attribute9 :=
390: per_grs_shd.g_old_rec.attribute9;

Line 390: per_grs_shd.g_old_rec.attribute9;

386: per_grs_shd.g_old_rec.attribute8;
387: End If;
388: If (p_rec.attribute9 = hr_api.g_varchar2) then
389: p_rec.attribute9 :=
390: per_grs_shd.g_old_rec.attribute9;
391: End If;
392: If (p_rec.attribute10 = hr_api.g_varchar2) then
393: p_rec.attribute10 :=
394: per_grs_shd.g_old_rec.attribute10;

Line 394: per_grs_shd.g_old_rec.attribute10;

390: per_grs_shd.g_old_rec.attribute9;
391: End If;
392: If (p_rec.attribute10 = hr_api.g_varchar2) then
393: p_rec.attribute10 :=
394: per_grs_shd.g_old_rec.attribute10;
395: End If;
396: If (p_rec.attribute11 = hr_api.g_varchar2) then
397: p_rec.attribute11 :=
398: per_grs_shd.g_old_rec.attribute11;

Line 398: per_grs_shd.g_old_rec.attribute11;

394: per_grs_shd.g_old_rec.attribute10;
395: End If;
396: If (p_rec.attribute11 = hr_api.g_varchar2) then
397: p_rec.attribute11 :=
398: per_grs_shd.g_old_rec.attribute11;
399: End If;
400: If (p_rec.attribute12 = hr_api.g_varchar2) then
401: p_rec.attribute12 :=
402: per_grs_shd.g_old_rec.attribute12;

Line 402: per_grs_shd.g_old_rec.attribute12;

398: per_grs_shd.g_old_rec.attribute11;
399: End If;
400: If (p_rec.attribute12 = hr_api.g_varchar2) then
401: p_rec.attribute12 :=
402: per_grs_shd.g_old_rec.attribute12;
403: End If;
404: If (p_rec.attribute13 = hr_api.g_varchar2) then
405: p_rec.attribute13 :=
406: per_grs_shd.g_old_rec.attribute13;

Line 406: per_grs_shd.g_old_rec.attribute13;

402: per_grs_shd.g_old_rec.attribute12;
403: End If;
404: If (p_rec.attribute13 = hr_api.g_varchar2) then
405: p_rec.attribute13 :=
406: per_grs_shd.g_old_rec.attribute13;
407: End If;
408: If (p_rec.attribute14 = hr_api.g_varchar2) then
409: p_rec.attribute14 :=
410: per_grs_shd.g_old_rec.attribute14;

Line 410: per_grs_shd.g_old_rec.attribute14;

406: per_grs_shd.g_old_rec.attribute13;
407: End If;
408: If (p_rec.attribute14 = hr_api.g_varchar2) then
409: p_rec.attribute14 :=
410: per_grs_shd.g_old_rec.attribute14;
411: End If;
412: If (p_rec.attribute15 = hr_api.g_varchar2) then
413: p_rec.attribute15 :=
414: per_grs_shd.g_old_rec.attribute15;

Line 414: per_grs_shd.g_old_rec.attribute15;

410: per_grs_shd.g_old_rec.attribute14;
411: End If;
412: If (p_rec.attribute15 = hr_api.g_varchar2) then
413: p_rec.attribute15 :=
414: per_grs_shd.g_old_rec.attribute15;
415: End If;
416: If (p_rec.attribute16 = hr_api.g_varchar2) then
417: p_rec.attribute16 :=
418: per_grs_shd.g_old_rec.attribute16;

Line 418: per_grs_shd.g_old_rec.attribute16;

414: per_grs_shd.g_old_rec.attribute15;
415: End If;
416: If (p_rec.attribute16 = hr_api.g_varchar2) then
417: p_rec.attribute16 :=
418: per_grs_shd.g_old_rec.attribute16;
419: End If;
420: If (p_rec.attribute17 = hr_api.g_varchar2) then
421: p_rec.attribute17 :=
422: per_grs_shd.g_old_rec.attribute17;

Line 422: per_grs_shd.g_old_rec.attribute17;

418: per_grs_shd.g_old_rec.attribute16;
419: End If;
420: If (p_rec.attribute17 = hr_api.g_varchar2) then
421: p_rec.attribute17 :=
422: per_grs_shd.g_old_rec.attribute17;
423: End If;
424: If (p_rec.attribute18 = hr_api.g_varchar2) then
425: p_rec.attribute18 :=
426: per_grs_shd.g_old_rec.attribute18;

Line 426: per_grs_shd.g_old_rec.attribute18;

422: per_grs_shd.g_old_rec.attribute17;
423: End If;
424: If (p_rec.attribute18 = hr_api.g_varchar2) then
425: p_rec.attribute18 :=
426: per_grs_shd.g_old_rec.attribute18;
427: End If;
428: If (p_rec.attribute19 = hr_api.g_varchar2) then
429: p_rec.attribute19 :=
430: per_grs_shd.g_old_rec.attribute19;

Line 430: per_grs_shd.g_old_rec.attribute19;

426: per_grs_shd.g_old_rec.attribute18;
427: End If;
428: If (p_rec.attribute19 = hr_api.g_varchar2) then
429: p_rec.attribute19 :=
430: per_grs_shd.g_old_rec.attribute19;
431: End If;
432: If (p_rec.attribute20 = hr_api.g_varchar2) then
433: p_rec.attribute20 :=
434: per_grs_shd.g_old_rec.attribute20;

Line 434: per_grs_shd.g_old_rec.attribute20;

430: per_grs_shd.g_old_rec.attribute19;
431: End If;
432: If (p_rec.attribute20 = hr_api.g_varchar2) then
433: p_rec.attribute20 :=
434: per_grs_shd.g_old_rec.attribute20;
435: End If;
436: --
437: hr_utility.set_location(' Leaving:'||l_proc, 10);
438: --

Line 446: p_rec in out nocopy per_grs_shd.g_rec_type

442: -- |---------------------------------< upd >----------------------------------|
443: -- ----------------------------------------------------------------------------
444: Procedure upd
445: (p_effective_date in date,
446: p_rec in out nocopy per_grs_shd.g_rec_type
447: ) is
448: --
449: l_proc varchar2(72) := g_package||'upd';
450: --

Line 456: per_grs_shd.lck

452: hr_utility.set_location('Entering:'||l_proc, 5);
453: --
454: -- We must lock the row which we need to update.
455: --
456: per_grs_shd.lck
457: (p_effective_date => p_effective_date,
458: p_cagr_grade_structure_id => p_rec.cagr_grade_structure_id,
459: p_object_version_number => p_rec.object_version_number
460: );

Line 524: l_rec per_grs_shd.g_rec_type;

520: p_attribute20 in varchar2 default hr_api.g_varchar2,
521: p_effective_date in date
522: ) is
523: --
524: l_rec per_grs_shd.g_rec_type;
525: l_proc varchar2(72) := g_package||'upd';
526: --
527: Begin
528: hr_utility.set_location('Entering:'||l_proc, 5);

Line 534: per_grs_shd.convert_args

530: -- Call conversion function to turn arguments into the
531: -- l_rec structure.
532: --
533: l_rec :=
534: per_grs_shd.convert_args
535: (
536: p_cagr_grade_structure_id,
537: p_collective_agreement_id,
538: p_object_version_number,