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_BIL_DEL dependencies on PER_BIL_SHD

Line 51: Procedure delete_dml(p_rec in per_bil_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_bil_shd.g_rec_type) is
52: --
53: l_proc varchar2(72) := g_package||'delete_dml';
54: --
55: Begin

Line 58: per_bil_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_bil_shd.g_api_dml := true; -- Set the api dml status
59: --
60: -- Delete the hr_summary row.
61: --
62: delete from hr_summary

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

61: --
62: delete from hr_summary
63: where id_value = p_rec.id_value;
64: --
65: per_bil_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_bil_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_bil_shd.g_api_dml := false; -- Unset the api dml status
73: per_bil_shd.constraint_error
74: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
75: When Others Then
76: per_bil_shd.g_api_dml := false; -- Unset the api dml status

Line 73: per_bil_shd.constraint_error

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

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

72: per_bil_shd.g_api_dml := false; -- Unset the api dml status
73: per_bil_shd.constraint_error
74: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
75: When Others Then
76: per_bil_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_bil_shd.g_rec_type) is

108: -- Internal Row Handler Use Only.
109: --
110: -- {End Of Comments}
111: -- ----------------------------------------------------------------------------
112: Procedure pre_delete(p_rec in per_bil_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_bil_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_bil_shd.g_rec_type) is
155: --
156: l_proc varchar2(72) := g_package||'post_delete';
157: --
158: Begin

Line 170: ,p_type_o =>per_bil_shd.g_old_rec.type

166: /*
167: per_bil_rkd.after_delete
168: (
169: p_id_value =>p_rec.id_value
170: ,p_type_o =>per_bil_shd.g_old_rec.type
171: ,p_business_group_id_o =>per_bil_shd.g_old_rec.business_group_id
172: ,p_object_version_number_o =>per_bil_shd.g_old_rec.object_version_number
173: ,p_fk_value1_o =>per_bil_shd.g_old_rec.fk_value1
174: ,p_fk_value2_o =>per_bil_shd.g_old_rec.fk_value2

Line 171: ,p_business_group_id_o =>per_bil_shd.g_old_rec.business_group_id

167: per_bil_rkd.after_delete
168: (
169: p_id_value =>p_rec.id_value
170: ,p_type_o =>per_bil_shd.g_old_rec.type
171: ,p_business_group_id_o =>per_bil_shd.g_old_rec.business_group_id
172: ,p_object_version_number_o =>per_bil_shd.g_old_rec.object_version_number
173: ,p_fk_value1_o =>per_bil_shd.g_old_rec.fk_value1
174: ,p_fk_value2_o =>per_bil_shd.g_old_rec.fk_value2
175: ,p_fk_value3_o =>per_bil_shd.g_old_rec.fk_value3

Line 172: ,p_object_version_number_o =>per_bil_shd.g_old_rec.object_version_number

168: (
169: p_id_value =>p_rec.id_value
170: ,p_type_o =>per_bil_shd.g_old_rec.type
171: ,p_business_group_id_o =>per_bil_shd.g_old_rec.business_group_id
172: ,p_object_version_number_o =>per_bil_shd.g_old_rec.object_version_number
173: ,p_fk_value1_o =>per_bil_shd.g_old_rec.fk_value1
174: ,p_fk_value2_o =>per_bil_shd.g_old_rec.fk_value2
175: ,p_fk_value3_o =>per_bil_shd.g_old_rec.fk_value3
176: ,p_text_value1_o =>per_bil_shd.g_old_rec.text_value1

Line 173: ,p_fk_value1_o =>per_bil_shd.g_old_rec.fk_value1

169: p_id_value =>p_rec.id_value
170: ,p_type_o =>per_bil_shd.g_old_rec.type
171: ,p_business_group_id_o =>per_bil_shd.g_old_rec.business_group_id
172: ,p_object_version_number_o =>per_bil_shd.g_old_rec.object_version_number
173: ,p_fk_value1_o =>per_bil_shd.g_old_rec.fk_value1
174: ,p_fk_value2_o =>per_bil_shd.g_old_rec.fk_value2
175: ,p_fk_value3_o =>per_bil_shd.g_old_rec.fk_value3
176: ,p_text_value1_o =>per_bil_shd.g_old_rec.text_value1
177: ,p_text_value2_o =>per_bil_shd.g_old_rec.text_value2

Line 174: ,p_fk_value2_o =>per_bil_shd.g_old_rec.fk_value2

170: ,p_type_o =>per_bil_shd.g_old_rec.type
171: ,p_business_group_id_o =>per_bil_shd.g_old_rec.business_group_id
172: ,p_object_version_number_o =>per_bil_shd.g_old_rec.object_version_number
173: ,p_fk_value1_o =>per_bil_shd.g_old_rec.fk_value1
174: ,p_fk_value2_o =>per_bil_shd.g_old_rec.fk_value2
175: ,p_fk_value3_o =>per_bil_shd.g_old_rec.fk_value3
176: ,p_text_value1_o =>per_bil_shd.g_old_rec.text_value1
177: ,p_text_value2_o =>per_bil_shd.g_old_rec.text_value2
178: ,p_text_value3_o =>per_bil_shd.g_old_rec.text_value3

Line 175: ,p_fk_value3_o =>per_bil_shd.g_old_rec.fk_value3

171: ,p_business_group_id_o =>per_bil_shd.g_old_rec.business_group_id
172: ,p_object_version_number_o =>per_bil_shd.g_old_rec.object_version_number
173: ,p_fk_value1_o =>per_bil_shd.g_old_rec.fk_value1
174: ,p_fk_value2_o =>per_bil_shd.g_old_rec.fk_value2
175: ,p_fk_value3_o =>per_bil_shd.g_old_rec.fk_value3
176: ,p_text_value1_o =>per_bil_shd.g_old_rec.text_value1
177: ,p_text_value2_o =>per_bil_shd.g_old_rec.text_value2
178: ,p_text_value3_o =>per_bil_shd.g_old_rec.text_value3
179: ,p_text_value4_o =>per_bil_shd.g_old_rec.text_value4

Line 176: ,p_text_value1_o =>per_bil_shd.g_old_rec.text_value1

172: ,p_object_version_number_o =>per_bil_shd.g_old_rec.object_version_number
173: ,p_fk_value1_o =>per_bil_shd.g_old_rec.fk_value1
174: ,p_fk_value2_o =>per_bil_shd.g_old_rec.fk_value2
175: ,p_fk_value3_o =>per_bil_shd.g_old_rec.fk_value3
176: ,p_text_value1_o =>per_bil_shd.g_old_rec.text_value1
177: ,p_text_value2_o =>per_bil_shd.g_old_rec.text_value2
178: ,p_text_value3_o =>per_bil_shd.g_old_rec.text_value3
179: ,p_text_value4_o =>per_bil_shd.g_old_rec.text_value4
180: ,p_text_value5_o =>per_bil_shd.g_old_rec.text_value5

Line 177: ,p_text_value2_o =>per_bil_shd.g_old_rec.text_value2

173: ,p_fk_value1_o =>per_bil_shd.g_old_rec.fk_value1
174: ,p_fk_value2_o =>per_bil_shd.g_old_rec.fk_value2
175: ,p_fk_value3_o =>per_bil_shd.g_old_rec.fk_value3
176: ,p_text_value1_o =>per_bil_shd.g_old_rec.text_value1
177: ,p_text_value2_o =>per_bil_shd.g_old_rec.text_value2
178: ,p_text_value3_o =>per_bil_shd.g_old_rec.text_value3
179: ,p_text_value4_o =>per_bil_shd.g_old_rec.text_value4
180: ,p_text_value5_o =>per_bil_shd.g_old_rec.text_value5
181: ,p_text_value6_o =>per_bil_shd.g_old_rec.text_value6

Line 178: ,p_text_value3_o =>per_bil_shd.g_old_rec.text_value3

174: ,p_fk_value2_o =>per_bil_shd.g_old_rec.fk_value2
175: ,p_fk_value3_o =>per_bil_shd.g_old_rec.fk_value3
176: ,p_text_value1_o =>per_bil_shd.g_old_rec.text_value1
177: ,p_text_value2_o =>per_bil_shd.g_old_rec.text_value2
178: ,p_text_value3_o =>per_bil_shd.g_old_rec.text_value3
179: ,p_text_value4_o =>per_bil_shd.g_old_rec.text_value4
180: ,p_text_value5_o =>per_bil_shd.g_old_rec.text_value5
181: ,p_text_value6_o =>per_bil_shd.g_old_rec.text_value6
182: ,p_text_value7_o =>per_bil_shd.g_old_rec.text_value7

Line 179: ,p_text_value4_o =>per_bil_shd.g_old_rec.text_value4

175: ,p_fk_value3_o =>per_bil_shd.g_old_rec.fk_value3
176: ,p_text_value1_o =>per_bil_shd.g_old_rec.text_value1
177: ,p_text_value2_o =>per_bil_shd.g_old_rec.text_value2
178: ,p_text_value3_o =>per_bil_shd.g_old_rec.text_value3
179: ,p_text_value4_o =>per_bil_shd.g_old_rec.text_value4
180: ,p_text_value5_o =>per_bil_shd.g_old_rec.text_value5
181: ,p_text_value6_o =>per_bil_shd.g_old_rec.text_value6
182: ,p_text_value7_o =>per_bil_shd.g_old_rec.text_value7
183: ,p_num_value1_o =>per_bil_shd.g_old_rec.num_value1

Line 180: ,p_text_value5_o =>per_bil_shd.g_old_rec.text_value5

176: ,p_text_value1_o =>per_bil_shd.g_old_rec.text_value1
177: ,p_text_value2_o =>per_bil_shd.g_old_rec.text_value2
178: ,p_text_value3_o =>per_bil_shd.g_old_rec.text_value3
179: ,p_text_value4_o =>per_bil_shd.g_old_rec.text_value4
180: ,p_text_value5_o =>per_bil_shd.g_old_rec.text_value5
181: ,p_text_value6_o =>per_bil_shd.g_old_rec.text_value6
182: ,p_text_value7_o =>per_bil_shd.g_old_rec.text_value7
183: ,p_num_value1_o =>per_bil_shd.g_old_rec.num_value1
184: ,p_num_value2_o =>per_bil_shd.g_old_rec.num_value2

Line 181: ,p_text_value6_o =>per_bil_shd.g_old_rec.text_value6

177: ,p_text_value2_o =>per_bil_shd.g_old_rec.text_value2
178: ,p_text_value3_o =>per_bil_shd.g_old_rec.text_value3
179: ,p_text_value4_o =>per_bil_shd.g_old_rec.text_value4
180: ,p_text_value5_o =>per_bil_shd.g_old_rec.text_value5
181: ,p_text_value6_o =>per_bil_shd.g_old_rec.text_value6
182: ,p_text_value7_o =>per_bil_shd.g_old_rec.text_value7
183: ,p_num_value1_o =>per_bil_shd.g_old_rec.num_value1
184: ,p_num_value2_o =>per_bil_shd.g_old_rec.num_value2
185: ,p_num_value3_o =>per_bil_shd.g_old_rec.num_value3

Line 182: ,p_text_value7_o =>per_bil_shd.g_old_rec.text_value7

178: ,p_text_value3_o =>per_bil_shd.g_old_rec.text_value3
179: ,p_text_value4_o =>per_bil_shd.g_old_rec.text_value4
180: ,p_text_value5_o =>per_bil_shd.g_old_rec.text_value5
181: ,p_text_value6_o =>per_bil_shd.g_old_rec.text_value6
182: ,p_text_value7_o =>per_bil_shd.g_old_rec.text_value7
183: ,p_num_value1_o =>per_bil_shd.g_old_rec.num_value1
184: ,p_num_value2_o =>per_bil_shd.g_old_rec.num_value2
185: ,p_num_value3_o =>per_bil_shd.g_old_rec.num_value3
186: ,p_date_value1_o =>per_bil_shd.g_old_rec.date_value1

Line 183: ,p_num_value1_o =>per_bil_shd.g_old_rec.num_value1

179: ,p_text_value4_o =>per_bil_shd.g_old_rec.text_value4
180: ,p_text_value5_o =>per_bil_shd.g_old_rec.text_value5
181: ,p_text_value6_o =>per_bil_shd.g_old_rec.text_value6
182: ,p_text_value7_o =>per_bil_shd.g_old_rec.text_value7
183: ,p_num_value1_o =>per_bil_shd.g_old_rec.num_value1
184: ,p_num_value2_o =>per_bil_shd.g_old_rec.num_value2
185: ,p_num_value3_o =>per_bil_shd.g_old_rec.num_value3
186: ,p_date_value1_o =>per_bil_shd.g_old_rec.date_value1
187: ,p_date_value2_o =>per_bil_shd.g_old_rec.date_value2

Line 184: ,p_num_value2_o =>per_bil_shd.g_old_rec.num_value2

180: ,p_text_value5_o =>per_bil_shd.g_old_rec.text_value5
181: ,p_text_value6_o =>per_bil_shd.g_old_rec.text_value6
182: ,p_text_value7_o =>per_bil_shd.g_old_rec.text_value7
183: ,p_num_value1_o =>per_bil_shd.g_old_rec.num_value1
184: ,p_num_value2_o =>per_bil_shd.g_old_rec.num_value2
185: ,p_num_value3_o =>per_bil_shd.g_old_rec.num_value3
186: ,p_date_value1_o =>per_bil_shd.g_old_rec.date_value1
187: ,p_date_value2_o =>per_bil_shd.g_old_rec.date_value2
188: ,p_date_value3_o =>per_bil_shd.g_old_rec.date_value3

Line 185: ,p_num_value3_o =>per_bil_shd.g_old_rec.num_value3

181: ,p_text_value6_o =>per_bil_shd.g_old_rec.text_value6
182: ,p_text_value7_o =>per_bil_shd.g_old_rec.text_value7
183: ,p_num_value1_o =>per_bil_shd.g_old_rec.num_value1
184: ,p_num_value2_o =>per_bil_shd.g_old_rec.num_value2
185: ,p_num_value3_o =>per_bil_shd.g_old_rec.num_value3
186: ,p_date_value1_o =>per_bil_shd.g_old_rec.date_value1
187: ,p_date_value2_o =>per_bil_shd.g_old_rec.date_value2
188: ,p_date_value3_o =>per_bil_shd.g_old_rec.date_value3
189: );

Line 186: ,p_date_value1_o =>per_bil_shd.g_old_rec.date_value1

182: ,p_text_value7_o =>per_bil_shd.g_old_rec.text_value7
183: ,p_num_value1_o =>per_bil_shd.g_old_rec.num_value1
184: ,p_num_value2_o =>per_bil_shd.g_old_rec.num_value2
185: ,p_num_value3_o =>per_bil_shd.g_old_rec.num_value3
186: ,p_date_value1_o =>per_bil_shd.g_old_rec.date_value1
187: ,p_date_value2_o =>per_bil_shd.g_old_rec.date_value2
188: ,p_date_value3_o =>per_bil_shd.g_old_rec.date_value3
189: );
190: */

Line 187: ,p_date_value2_o =>per_bil_shd.g_old_rec.date_value2

183: ,p_num_value1_o =>per_bil_shd.g_old_rec.num_value1
184: ,p_num_value2_o =>per_bil_shd.g_old_rec.num_value2
185: ,p_num_value3_o =>per_bil_shd.g_old_rec.num_value3
186: ,p_date_value1_o =>per_bil_shd.g_old_rec.date_value1
187: ,p_date_value2_o =>per_bil_shd.g_old_rec.date_value2
188: ,p_date_value3_o =>per_bil_shd.g_old_rec.date_value3
189: );
190: */
191: null;

Line 188: ,p_date_value3_o =>per_bil_shd.g_old_rec.date_value3

184: ,p_num_value2_o =>per_bil_shd.g_old_rec.num_value2
185: ,p_num_value3_o =>per_bil_shd.g_old_rec.num_value3
186: ,p_date_value1_o =>per_bil_shd.g_old_rec.date_value1
187: ,p_date_value2_o =>per_bil_shd.g_old_rec.date_value2
188: ,p_date_value3_o =>per_bil_shd.g_old_rec.date_value3
189: );
190: */
191: null;
192: --

Line 214: p_rec in per_bil_shd.g_rec_type

210: -- |---------------------------------< del >----------------------------------|
211: -- ----------------------------------------------------------------------------
212: Procedure del
213: (
214: p_rec in per_bil_shd.g_rec_type
215: ) is
216: --
217: l_proc varchar2(72) := g_package||'del';
218: --

Line 224: per_bil_shd.lck

220: hr_utility.set_location('Entering:'||l_proc, 5);
221: --
222: -- We must lock the row which we need to delete.
223: --
224: per_bil_shd.lck
225: (
226: p_rec.id_value,
227: p_rec.object_version_number
228: );

Line 256: l_rec per_bil_shd.g_rec_type;

252: p_id_value in number,
253: p_object_version_number in number
254: ) is
255: --
256: l_rec per_bil_shd.g_rec_type;
257: l_proc varchar2(72) := g_package||'del';
258: --
259: Begin
260: hr_utility.set_location('Entering:'||l_proc, 5);