DBA Data[Home] [Help]

APPS.PAY_BCT_UPD dependencies on PAY_BCT_SHD

Line 55: (p_rec in out nocopy pay_bct_shd.g_rec_type

51: --
52: -- {End Of Comments}
53: -- ----------------------------------------------------------------------------
54: Procedure update_dml
55: (p_rec in out nocopy pay_bct_shd.g_rec_type
56: ) is
57: --
58: l_proc varchar2(72) := g_package||'update_dml';
59: l_range_flag varchar2(2) := 'F';

Line 68: pay_bct_shd.g_api_dml := true; -- Set the api dml status

64: --
65: -- Increment the object version
66: p_rec.object_version_number := p_rec.object_version_number + 1;
67: --
68: pay_bct_shd.g_api_dml := true; -- Set the api dml status
69: --
70: -- added for bug 6013383
71: -- convert the Number format from Display format( 99,999.99 OR 99.999,99) to
72: -- database format (99999.99)

Line 100: pay_bct_shd.g_api_dml := false; -- Unset the api dml status

96: ,control_type = p_rec.control_type
97: ,object_version_number = p_rec.object_version_number
98: where batch_control_id = p_rec.batch_control_id;
99: --
100: pay_bct_shd.g_api_dml := false; -- Unset the api dml status
101: --
102: hr_utility.set_location(' Leaving:'||l_proc, 10);
103: --
104: Exception

Line 107: pay_bct_shd.g_api_dml := false; -- Unset the api dml status

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

Line 108: pay_bct_shd.constraint_error

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

Line 112: pay_bct_shd.g_api_dml := false; -- Unset the api dml status

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

Line 113: pay_bct_shd.constraint_error

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

Line 117: pay_bct_shd.g_api_dml := false; -- Unset the api dml status

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

Line 118: pay_bct_shd.constraint_error

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

Line 121: pay_bct_shd.g_api_dml := false; -- Unset the api dml status

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

Line 158: (p_rec in pay_bct_shd.g_rec_type

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

Line 203: ,p_rec in pay_bct_shd.g_rec_type

199: -- {End Of Comments}
200: -- ----------------------------------------------------------------------------
201: Procedure post_update
202: (p_session_date in date
203: ,p_rec in pay_bct_shd.g_rec_type
204: ) is
205: --
206: l_proc varchar2(72) := g_package||'post_update';
207: --

Line 226: => pay_bct_shd.g_old_rec.batch_id

222: => p_rec.control_type
223: ,p_object_version_number
224: => p_rec.object_version_number
225: ,p_batch_id_o
226: => pay_bct_shd.g_old_rec.batch_id
227: ,p_control_status_o
228: => pay_bct_shd.g_old_rec.control_status
229: ,p_control_total_o
230: => pay_bct_shd.g_old_rec.control_total

Line 228: => pay_bct_shd.g_old_rec.control_status

224: => p_rec.object_version_number
225: ,p_batch_id_o
226: => pay_bct_shd.g_old_rec.batch_id
227: ,p_control_status_o
228: => pay_bct_shd.g_old_rec.control_status
229: ,p_control_total_o
230: => pay_bct_shd.g_old_rec.control_total
231: ,p_control_type_o
232: => pay_bct_shd.g_old_rec.control_type

Line 230: => pay_bct_shd.g_old_rec.control_total

226: => pay_bct_shd.g_old_rec.batch_id
227: ,p_control_status_o
228: => pay_bct_shd.g_old_rec.control_status
229: ,p_control_total_o
230: => pay_bct_shd.g_old_rec.control_total
231: ,p_control_type_o
232: => pay_bct_shd.g_old_rec.control_type
233: ,p_object_version_number_o
234: => pay_bct_shd.g_old_rec.object_version_number

Line 232: => pay_bct_shd.g_old_rec.control_type

228: => pay_bct_shd.g_old_rec.control_status
229: ,p_control_total_o
230: => pay_bct_shd.g_old_rec.control_total
231: ,p_control_type_o
232: => pay_bct_shd.g_old_rec.control_type
233: ,p_object_version_number_o
234: => pay_bct_shd.g_old_rec.object_version_number
235: );
236: --

Line 234: => pay_bct_shd.g_old_rec.object_version_number

230: => pay_bct_shd.g_old_rec.control_total
231: ,p_control_type_o
232: => pay_bct_shd.g_old_rec.control_type
233: ,p_object_version_number_o
234: => pay_bct_shd.g_old_rec.object_version_number
235: );
236: --
237: exception
238: --

Line 294: (p_rec in out nocopy pay_bct_shd.g_rec_type

290: --
291: -- {End Of Comments}
292: -- ----------------------------------------------------------------------------
293: Procedure convert_defs
294: (p_rec in out nocopy pay_bct_shd.g_rec_type
295: ) is
296: --
297: Begin
298: --

Line 306: pay_bct_shd.g_old_rec.batch_id;

302: -- is being used then we must set to the 'current' argument value.
303: --
304: If (p_rec.batch_id = hr_api.g_number) then
305: p_rec.batch_id :=
306: pay_bct_shd.g_old_rec.batch_id;
307: End If;
308: If (p_rec.control_status = hr_api.g_varchar2) then
309: p_rec.control_status :=
310: pay_bct_shd.g_old_rec.control_status;

Line 310: pay_bct_shd.g_old_rec.control_status;

306: pay_bct_shd.g_old_rec.batch_id;
307: End If;
308: If (p_rec.control_status = hr_api.g_varchar2) then
309: p_rec.control_status :=
310: pay_bct_shd.g_old_rec.control_status;
311: End If;
312: If (p_rec.control_total = hr_api.g_varchar2) then
313: p_rec.control_total :=
314: pay_bct_shd.g_old_rec.control_total;

Line 314: pay_bct_shd.g_old_rec.control_total;

310: pay_bct_shd.g_old_rec.control_status;
311: End If;
312: If (p_rec.control_total = hr_api.g_varchar2) then
313: p_rec.control_total :=
314: pay_bct_shd.g_old_rec.control_total;
315: End If;
316: If (p_rec.control_type = hr_api.g_varchar2) then
317: p_rec.control_type :=
318: pay_bct_shd.g_old_rec.control_type;

Line 318: pay_bct_shd.g_old_rec.control_type;

314: pay_bct_shd.g_old_rec.control_total;
315: End If;
316: If (p_rec.control_type = hr_api.g_varchar2) then
317: p_rec.control_type :=
318: pay_bct_shd.g_old_rec.control_type;
319: End If;
320: --
321: End convert_defs;
322: --

Line 328: ,p_rec in out nocopy pay_bct_shd.g_rec_type

324: -- |---------------------------------< upd >----------------------------------|
325: -- ----------------------------------------------------------------------------
326: Procedure upd
327: (p_session_date in date
328: ,p_rec in out nocopy pay_bct_shd.g_rec_type
329: ) is
330: --
331: l_proc varchar2(72) := g_package||'upd';
332: --

Line 338: pay_bct_shd.lck

334: hr_utility.set_location('Entering:'||l_proc, 5);
335: --
336: -- We must lock the row which we need to update.
337: --
338: pay_bct_shd.lck
339: (p_rec.batch_control_id
340: ,p_rec.object_version_number
341: );
342: --

Line 383: l_rec pay_bct_shd.g_rec_type;

379: ,p_control_total in varchar2 default hr_api.g_varchar2
380: ,p_control_type in varchar2 default hr_api.g_varchar2
381: ) is
382: --
383: l_rec pay_bct_shd.g_rec_type;
384: l_proc varchar2(72) := g_package||'upd';
385: --
386: Begin
387: hr_utility.set_location('Entering:'||l_proc, 5);

Line 393: pay_bct_shd.convert_args

389: -- Call conversion function to turn arguments into the
390: -- l_rec structure.
391: --
392: l_rec :=
393: pay_bct_shd.convert_args
394: (p_batch_control_id
395: ,hr_api.g_number
396: ,p_control_status
397: ,p_control_total