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.PAY_NCR_UPD dependencies on PAY_NCR_SHD

Line 54: Procedure update_dml(p_rec in out nocopy pay_ncr_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 pay_ncr_shd.g_rec_type) is
55: --
56: l_proc varchar2(72) := g_package||'update_dml';
57: --
58: Begin

Line 65: pay_ncr_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: pay_ncr_shd.g_api_dml := true; -- Set the api dml status
66: --
67: -- Update the pay_net_calculation_rules Row
68: --
69: update pay_net_calculation_rules

Line 79: pay_ncr_shd.g_api_dml := false; -- Unset the api dml status

75: date_input_value_id = p_rec.date_input_value_id,
76: object_version_number = p_rec.object_version_number
77: where net_calculation_rule_id = p_rec.net_calculation_rule_id;
78: --
79: pay_ncr_shd.g_api_dml := false; -- Unset the api dml status
80: --
81: hr_utility.set_location(' Leaving:'||l_proc, 10);
82: --
83: Exception

Line 86: pay_ncr_shd.g_api_dml := false; -- Unset the api dml status

82: --
83: Exception
84: When hr_api.check_integrity_violated Then
85: -- A check constraint has been violated
86: pay_ncr_shd.g_api_dml := false; -- Unset the api dml status
87: pay_ncr_shd.constraint_error
88: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
89: When hr_api.parent_integrity_violated Then
90: -- Parent integrity has been violated

Line 87: pay_ncr_shd.constraint_error

83: Exception
84: When hr_api.check_integrity_violated Then
85: -- A check constraint has been violated
86: pay_ncr_shd.g_api_dml := false; -- Unset the api dml status
87: pay_ncr_shd.constraint_error
88: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
89: When hr_api.parent_integrity_violated Then
90: -- Parent integrity has been violated
91: pay_ncr_shd.g_api_dml := false; -- Unset the api dml status

Line 91: pay_ncr_shd.g_api_dml := false; -- Unset the api dml status

87: pay_ncr_shd.constraint_error
88: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
89: When hr_api.parent_integrity_violated Then
90: -- Parent integrity has been violated
91: pay_ncr_shd.g_api_dml := false; -- Unset the api dml status
92: pay_ncr_shd.constraint_error
93: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
94: When hr_api.unique_integrity_violated Then
95: -- Unique integrity has been violated

Line 92: pay_ncr_shd.constraint_error

88: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
89: When hr_api.parent_integrity_violated Then
90: -- Parent integrity has been violated
91: pay_ncr_shd.g_api_dml := false; -- Unset the api dml status
92: pay_ncr_shd.constraint_error
93: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
94: When hr_api.unique_integrity_violated Then
95: -- Unique integrity has been violated
96: pay_ncr_shd.g_api_dml := false; -- Unset the api dml status

Line 96: pay_ncr_shd.g_api_dml := false; -- Unset the api dml status

92: pay_ncr_shd.constraint_error
93: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
94: When hr_api.unique_integrity_violated Then
95: -- Unique integrity has been violated
96: pay_ncr_shd.g_api_dml := false; -- Unset the api dml status
97: pay_ncr_shd.constraint_error
98: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
99: When Others Then
100: pay_ncr_shd.g_api_dml := false; -- Unset the api dml status

Line 97: pay_ncr_shd.constraint_error

93: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
94: When hr_api.unique_integrity_violated Then
95: -- Unique integrity has been violated
96: pay_ncr_shd.g_api_dml := false; -- Unset the api dml status
97: pay_ncr_shd.constraint_error
98: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
99: When Others Then
100: pay_ncr_shd.g_api_dml := false; -- Unset the api dml status
101: Raise;

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

96: pay_ncr_shd.g_api_dml := false; -- Unset the api dml status
97: pay_ncr_shd.constraint_error
98: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
99: When Others Then
100: pay_ncr_shd.g_api_dml := false; -- Unset the api dml status
101: Raise;
102: End update_dml;
103: --
104: -- ----------------------------------------------------------------------------

Line 136: Procedure pre_update(p_rec in pay_ncr_shd.g_rec_type) is

132: -- Internal Row Handler Use Only.
133: --
134: -- {End Of Comments}
135: -- ----------------------------------------------------------------------------
136: Procedure pre_update(p_rec in pay_ncr_shd.g_rec_type) is
137: --
138: l_proc varchar2(72) := g_package||'pre_update';
139: --
140: Begin

Line 178: Procedure post_update(p_rec in pay_ncr_shd.g_rec_type) is

174: -- Internal Row Handler Use Only.
175: --
176: -- {End Of Comments}
177: -- ----------------------------------------------------------------------------
178: Procedure post_update(p_rec in pay_ncr_shd.g_rec_type) is
179: --
180: l_proc varchar2(72) := g_package||'post_update';
181: --
182: Begin

Line 198: ,p_accrual_plan_id_o =>pay_ncr_shd.g_old_rec.accrual_plan_id

194: ,p_input_value_id =>p_rec.input_value_id
195: ,p_add_or_subtract =>p_rec.add_or_subtract
196: ,p_date_input_value_id =>p_rec.date_input_value_id
197: ,p_object_version_number =>p_rec.object_version_number
198: ,p_accrual_plan_id_o =>pay_ncr_shd.g_old_rec.accrual_plan_id
199: ,p_business_group_id_o =>pay_ncr_shd.g_old_rec.business_group_id
200: ,p_input_value_id_o =>pay_ncr_shd.g_old_rec.input_value_id
201: ,p_add_or_subtract_o =>pay_ncr_shd.g_old_rec.add_or_subtract
202: ,p_date_input_value_id_o =>pay_ncr_shd.g_old_rec.date_input_value_id

Line 199: ,p_business_group_id_o =>pay_ncr_shd.g_old_rec.business_group_id

195: ,p_add_or_subtract =>p_rec.add_or_subtract
196: ,p_date_input_value_id =>p_rec.date_input_value_id
197: ,p_object_version_number =>p_rec.object_version_number
198: ,p_accrual_plan_id_o =>pay_ncr_shd.g_old_rec.accrual_plan_id
199: ,p_business_group_id_o =>pay_ncr_shd.g_old_rec.business_group_id
200: ,p_input_value_id_o =>pay_ncr_shd.g_old_rec.input_value_id
201: ,p_add_or_subtract_o =>pay_ncr_shd.g_old_rec.add_or_subtract
202: ,p_date_input_value_id_o =>pay_ncr_shd.g_old_rec.date_input_value_id
203: ,p_object_version_number_o =>pay_ncr_shd.g_old_rec.object_version_number

Line 200: ,p_input_value_id_o =>pay_ncr_shd.g_old_rec.input_value_id

196: ,p_date_input_value_id =>p_rec.date_input_value_id
197: ,p_object_version_number =>p_rec.object_version_number
198: ,p_accrual_plan_id_o =>pay_ncr_shd.g_old_rec.accrual_plan_id
199: ,p_business_group_id_o =>pay_ncr_shd.g_old_rec.business_group_id
200: ,p_input_value_id_o =>pay_ncr_shd.g_old_rec.input_value_id
201: ,p_add_or_subtract_o =>pay_ncr_shd.g_old_rec.add_or_subtract
202: ,p_date_input_value_id_o =>pay_ncr_shd.g_old_rec.date_input_value_id
203: ,p_object_version_number_o =>pay_ncr_shd.g_old_rec.object_version_number
204: );

Line 201: ,p_add_or_subtract_o =>pay_ncr_shd.g_old_rec.add_or_subtract

197: ,p_object_version_number =>p_rec.object_version_number
198: ,p_accrual_plan_id_o =>pay_ncr_shd.g_old_rec.accrual_plan_id
199: ,p_business_group_id_o =>pay_ncr_shd.g_old_rec.business_group_id
200: ,p_input_value_id_o =>pay_ncr_shd.g_old_rec.input_value_id
201: ,p_add_or_subtract_o =>pay_ncr_shd.g_old_rec.add_or_subtract
202: ,p_date_input_value_id_o =>pay_ncr_shd.g_old_rec.date_input_value_id
203: ,p_object_version_number_o =>pay_ncr_shd.g_old_rec.object_version_number
204: );
205: --

Line 202: ,p_date_input_value_id_o =>pay_ncr_shd.g_old_rec.date_input_value_id

198: ,p_accrual_plan_id_o =>pay_ncr_shd.g_old_rec.accrual_plan_id
199: ,p_business_group_id_o =>pay_ncr_shd.g_old_rec.business_group_id
200: ,p_input_value_id_o =>pay_ncr_shd.g_old_rec.input_value_id
201: ,p_add_or_subtract_o =>pay_ncr_shd.g_old_rec.add_or_subtract
202: ,p_date_input_value_id_o =>pay_ncr_shd.g_old_rec.date_input_value_id
203: ,p_object_version_number_o =>pay_ncr_shd.g_old_rec.object_version_number
204: );
205: --
206: exception

Line 203: ,p_object_version_number_o =>pay_ncr_shd.g_old_rec.object_version_number

199: ,p_business_group_id_o =>pay_ncr_shd.g_old_rec.business_group_id
200: ,p_input_value_id_o =>pay_ncr_shd.g_old_rec.input_value_id
201: ,p_add_or_subtract_o =>pay_ncr_shd.g_old_rec.add_or_subtract
202: ,p_date_input_value_id_o =>pay_ncr_shd.g_old_rec.date_input_value_id
203: ,p_object_version_number_o =>pay_ncr_shd.g_old_rec.object_version_number
204: );
205: --
206: exception
207: --

Line 265: Procedure convert_defs(p_rec in out nocopy pay_ncr_shd.g_rec_type) is

261: -- Internal Row Handler Use Only.
262: --
263: -- {End Of Comments}
264: -- ----------------------------------------------------------------------------
265: Procedure convert_defs(p_rec in out nocopy pay_ncr_shd.g_rec_type) is
266: --
267: l_proc varchar2(72) := g_package||'convert_defs';
268: --
269: Begin

Line 280: pay_ncr_shd.g_old_rec.accrual_plan_id;

276: -- is being used then we must set to the 'current' argument value.
277: --
278: If (p_rec.accrual_plan_id = hr_api.g_number) then
279: p_rec.accrual_plan_id :=
280: pay_ncr_shd.g_old_rec.accrual_plan_id;
281: End If;
282: If (p_rec.business_group_id = hr_api.g_number) then
283: p_rec.business_group_id :=
284: pay_ncr_shd.g_old_rec.business_group_id;

Line 284: pay_ncr_shd.g_old_rec.business_group_id;

280: pay_ncr_shd.g_old_rec.accrual_plan_id;
281: End If;
282: If (p_rec.business_group_id = hr_api.g_number) then
283: p_rec.business_group_id :=
284: pay_ncr_shd.g_old_rec.business_group_id;
285: End If;
286: If (p_rec.input_value_id = hr_api.g_number) then
287: p_rec.input_value_id :=
288: pay_ncr_shd.g_old_rec.input_value_id;

Line 288: pay_ncr_shd.g_old_rec.input_value_id;

284: pay_ncr_shd.g_old_rec.business_group_id;
285: End If;
286: If (p_rec.input_value_id = hr_api.g_number) then
287: p_rec.input_value_id :=
288: pay_ncr_shd.g_old_rec.input_value_id;
289: End If;
290: If (p_rec.add_or_subtract = hr_api.g_varchar2) then
291: p_rec.add_or_subtract :=
292: pay_ncr_shd.g_old_rec.add_or_subtract;

Line 292: pay_ncr_shd.g_old_rec.add_or_subtract;

288: pay_ncr_shd.g_old_rec.input_value_id;
289: End If;
290: If (p_rec.add_or_subtract = hr_api.g_varchar2) then
291: p_rec.add_or_subtract :=
292: pay_ncr_shd.g_old_rec.add_or_subtract;
293: End If;
294: If (p_rec.date_input_value_id = hr_api.g_number) then
295: p_rec.date_input_value_id :=
296: pay_ncr_shd.g_old_rec.date_input_value_id;

Line 296: pay_ncr_shd.g_old_rec.date_input_value_id;

292: pay_ncr_shd.g_old_rec.add_or_subtract;
293: End If;
294: If (p_rec.date_input_value_id = hr_api.g_number) then
295: p_rec.date_input_value_id :=
296: pay_ncr_shd.g_old_rec.date_input_value_id;
297: End If;
298:
299: --
300: hr_utility.set_location(' Leaving:'||l_proc, 10);

Line 309: p_rec in out nocopy pay_ncr_shd.g_rec_type

305: -- |---------------------------------< upd >----------------------------------|
306: -- ----------------------------------------------------------------------------
307: Procedure upd
308: (
309: p_rec in out nocopy pay_ncr_shd.g_rec_type
310: ) is
311: --
312: l_proc varchar2(72) := g_package||'upd';
313: --

Line 319: pay_ncr_shd.lck

315: hr_utility.set_location('Entering:'||l_proc, 5);
316: --
317: -- We must lock the row which we need to update.
318: --
319: pay_ncr_shd.lck
320: (
321: p_rec.net_calculation_rule_id,
322: p_rec.object_version_number
323: );

Line 360: l_rec pay_ncr_shd.g_rec_type;

356: p_date_input_value_id in number default hr_api.g_number,
357: p_object_version_number in out nocopy number
358: ) is
359: --
360: l_rec pay_ncr_shd.g_rec_type;
361: l_proc varchar2(72) := g_package||'upd';
362: --
363: Begin
364: hr_utility.set_location('Entering:'||l_proc, 5);

Line 370: pay_ncr_shd.convert_args

366: -- Call conversion function to turn arguments into the
367: -- l_rec structure.
368: --
369: l_rec :=
370: pay_ncr_shd.convert_args
371: (
372: p_net_calculation_rule_id,
373: p_accrual_plan_id,
374: hr_api.g_number,