APPS.PAY_SIR_UPD dependencies on PAY_SIR_SHD

Line 55: (p_rec in out nocopy pay_sir_shd.g_rec_type

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

Line 90: pay_sir_shd.constraint_error

86: Exception
87: When hr_api.check_integrity_violated Then
88: -- A check constraint has been violated
89: --
90: pay_sir_shd.constraint_error
91: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
92: When hr_api.parent_integrity_violated Then
93: -- Parent integrity has been violated
94: --

Line 95: pay_sir_shd.constraint_error

91: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
92: When hr_api.parent_integrity_violated Then
93: -- Parent integrity has been violated
94: --
95: pay_sir_shd.constraint_error
96: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
97: When hr_api.unique_integrity_violated Then
98: -- Unique integrity has been violated
99: --

Line 100: pay_sir_shd.constraint_error

96: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
97: When hr_api.unique_integrity_violated Then
98: -- Unique integrity has been violated
99: --
100: pay_sir_shd.constraint_error
101: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
102: When Others Then
103: --
104: Raise;

Line 140: (p_rec in pay_sir_shd.g_rec_type

136: --
137: -- {End Of Comments}
138: -- ----------------------------------------------------------------------------
139: Procedure pre_update
140: (p_rec in pay_sir_shd.g_rec_type
141: ) is
142: --
143: l_proc varchar2(72) := g_package||'pre_update';
144: --

Line 184: (p_rec in pay_sir_shd.g_rec_type

180: --
181: -- {End Of Comments}
182: -- ----------------------------------------------------------------------------
183: Procedure post_update
184: (p_rec in pay_sir_shd.g_rec_type
185: ) is
186: --
187: l_proc varchar2(72) := g_package||'post_update';
188: --

Line 240: (p_rec in out nocopy pay_sir_shd.g_rec_type

236: --
237: -- {End Of Comments}
238: -- ----------------------------------------------------------------------------
239: Procedure convert_defs
240: (p_rec in out nocopy pay_sir_shd.g_rec_type
241: ) is
242: --
243: l_proc varchar2(72) := g_package||'convert_defs';
244: --

Line 254: pay_sir_shd.g_old_rec.element_type_id;

250: -- is being used then we must set to the 'current' argument value.
251: --
252: If (p_rec.element_type_id = hr_api.g_number) then
253: p_rec.element_type_id :=
254: pay_sir_shd.g_old_rec.element_type_id;
255: End If;
256: If (p_rec.result_name = hr_api.g_varchar2) then
257: p_rec.result_name :=
258: pay_sir_shd.g_old_rec.result_name;

Line 258: pay_sir_shd.g_old_rec.result_name;

254: pay_sir_shd.g_old_rec.element_type_id;
255: End If;
256: If (p_rec.result_name = hr_api.g_varchar2) then
257: p_rec.result_name :=
258: pay_sir_shd.g_old_rec.result_name;
259: End If;
260: If (p_rec.iterative_rule_type = hr_api.g_varchar2) then
261: p_rec.iterative_rule_type :=
262: pay_sir_shd.g_old_rec.iterative_rule_type;

Line 262: pay_sir_shd.g_old_rec.iterative_rule_type;

258: pay_sir_shd.g_old_rec.result_name;
259: End If;
260: If (p_rec.iterative_rule_type = hr_api.g_varchar2) then
261: p_rec.iterative_rule_type :=
262: pay_sir_shd.g_old_rec.iterative_rule_type;
263: End If;
264: If (p_rec.input_value_id = hr_api.g_number) then
265: p_rec.input_value_id :=
266: pay_sir_shd.g_old_rec.input_value_id;

Line 266: pay_sir_shd.g_old_rec.input_value_id;

262: pay_sir_shd.g_old_rec.iterative_rule_type;
263: End If;
264: If (p_rec.input_value_id = hr_api.g_number) then
265: p_rec.input_value_id :=
266: pay_sir_shd.g_old_rec.input_value_id;
267: End If;
268: If (p_rec.severity_level = hr_api.g_varchar2) then
269: p_rec.severity_level :=
270: pay_sir_shd.g_old_rec.severity_level;

Line 270: pay_sir_shd.g_old_rec.severity_level;

266: pay_sir_shd.g_old_rec.input_value_id;
267: End If;
268: If (p_rec.severity_level = hr_api.g_varchar2) then
269: p_rec.severity_level :=
270: pay_sir_shd.g_old_rec.severity_level;
271: End If;
272: If (p_rec.exclusion_rule_id = hr_api.g_number) then
273: p_rec.exclusion_rule_id :=
274: pay_sir_shd.g_old_rec.exclusion_rule_id;

Line 274: pay_sir_shd.g_old_rec.exclusion_rule_id;

270: pay_sir_shd.g_old_rec.severity_level;
271: End If;
272: If (p_rec.exclusion_rule_id = hr_api.g_number) then
273: p_rec.exclusion_rule_id :=
274: pay_sir_shd.g_old_rec.exclusion_rule_id;
275: End If;
276: --
277: End convert_defs;
278: --

Line 284: ,p_rec in out nocopy pay_sir_shd.g_rec_type

280: -- |---------------------------------< upd >----------------------------------|
281: -- ----------------------------------------------------------------------------
282: Procedure upd
283: (p_effective_date in date
284: ,p_rec in out nocopy pay_sir_shd.g_rec_type
285: ) is
286: --
287: l_proc varchar2(72) := g_package||'upd';
288: --

Line 294: pay_sir_shd.lck

290: hr_utility.set_location('Entering:'||l_proc, 5);
291: --
292: -- We must lock the row which we need to update.
293: --
294: pay_sir_shd.lck
295: (p_rec.iterative_rule_id
296: ,p_rec.object_version_number
297: );
298: --

Line 339: l_rec pay_sir_shd.g_rec_type;

335: ,p_severity_level in varchar2 default hr_api.g_varchar2
336: ,p_exclusion_rule_id in number default hr_api.g_number
337: ) is
338: --
339: l_rec pay_sir_shd.g_rec_type;
340: l_proc varchar2(72) := g_package||'upd';
341: --
342: Begin
343: hr_utility.set_location('Entering:'||l_proc, 5);

Line 349: pay_sir_shd.convert_args

345: -- Call conversion function to turn arguments into the
346: -- l_rec structure.
347: --
348: l_rec :=
349: pay_sir_shd.convert_args
350: (p_iterative_rule_id
351: ,p_element_type_id
352: ,p_result_name
353: ,p_iterative_rule_type