DBA Data[Home] [Help]

APPS.PAY_APP_UPD dependencies on PAY_APP_SHD

Line 55: (p_rec in out nocopy pay_app_shd.g_rec_type

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

Line 68: pay_app_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_app_shd.g_api_dml := true; -- Set the api dml status
69: --
70: -- Update the pay_au_process_parameters Row
71: --
72: update pay_au_process_parameters

Line 82: pay_app_shd.g_api_dml := false; -- Unset the api dml status

78: ,enabled_flag = p_rec.enabled_flag
79: ,object_version_number = p_rec.object_version_number
80: where process_parameter_id = p_rec.process_parameter_id;
81: --
82: pay_app_shd.g_api_dml := false; -- Unset the api dml status
83: --
84: hr_utility.set_location(' Leaving:'||l_proc, 10);
85: --
86: Exception

Line 89: pay_app_shd.g_api_dml := false; -- Unset the api dml status

85: --
86: Exception
87: When hr_api.check_integrity_violated Then
88: -- A check constraint has been violated
89: pay_app_shd.g_api_dml := false; -- Unset the api dml status
90: pay_app_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

Line 90: pay_app_shd.constraint_error

86: Exception
87: When hr_api.check_integrity_violated Then
88: -- A check constraint has been violated
89: pay_app_shd.g_api_dml := false; -- Unset the api dml status
90: pay_app_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: pay_app_shd.g_api_dml := false; -- Unset the api dml status

Line 94: pay_app_shd.g_api_dml := false; -- Unset the api dml status

90: pay_app_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: pay_app_shd.g_api_dml := false; -- Unset the api dml status
95: pay_app_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

Line 95: pay_app_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: pay_app_shd.g_api_dml := false; -- Unset the api dml status
95: pay_app_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: pay_app_shd.g_api_dml := false; -- Unset the api dml status

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

95: pay_app_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: pay_app_shd.g_api_dml := false; -- Unset the api dml status
100: pay_app_shd.constraint_error
101: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
102: When Others Then
103: pay_app_shd.g_api_dml := false; -- Unset the api dml status

Line 100: pay_app_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: pay_app_shd.g_api_dml := false; -- Unset the api dml status
100: pay_app_shd.constraint_error
101: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
102: When Others Then
103: pay_app_shd.g_api_dml := false; -- Unset the api dml status
104: Raise;

Line 103: pay_app_shd.g_api_dml := false; -- Unset the api dml status

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

Line 140: (p_rec in pay_app_shd.g_rec_type

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

Line 186: (p_rec in pay_app_shd.g_rec_type

182: --
183: -- {End Of Comments}
184: -- ----------------------------------------------------------------------------
185: Procedure post_update
186: (p_rec in pay_app_shd.g_rec_type
187: ) is
188: --
189: l_proc varchar2(72);
190: --

Line 243: (p_rec in out nocopy pay_app_shd.g_rec_type

239: --
240: -- {End Of Comments}
241: -- ----------------------------------------------------------------------------
242: Procedure convert_defs
243: (p_rec in out nocopy pay_app_shd.g_rec_type
244: ) is
245: --
246: Begin
247: --

Line 255: pay_app_shd.g_old_rec.process_id;

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

Line 259: pay_app_shd.g_old_rec.internal_name;

255: pay_app_shd.g_old_rec.process_id;
256: End If;
257: If (p_rec.internal_name = hr_api.g_varchar2) then
258: p_rec.internal_name :=
259: pay_app_shd.g_old_rec.internal_name;
260: End If;
261: If (p_rec.data_type = hr_api.g_varchar2) then
262: p_rec.data_type :=
263: pay_app_shd.g_old_rec.data_type;

Line 263: pay_app_shd.g_old_rec.data_type;

259: pay_app_shd.g_old_rec.internal_name;
260: End If;
261: If (p_rec.data_type = hr_api.g_varchar2) then
262: p_rec.data_type :=
263: pay_app_shd.g_old_rec.data_type;
264: End If;
265: If (p_rec.enabled_flag = hr_api.g_varchar2) then
266: p_rec.enabled_flag :=
267: pay_app_shd.g_old_rec.enabled_flag;

Line 267: pay_app_shd.g_old_rec.enabled_flag;

263: pay_app_shd.g_old_rec.data_type;
264: End If;
265: If (p_rec.enabled_flag = hr_api.g_varchar2) then
266: p_rec.enabled_flag :=
267: pay_app_shd.g_old_rec.enabled_flag;
268: End If;
269: --
270: End convert_defs;
271: --

Line 276: (p_rec in out nocopy pay_app_shd.g_rec_type

272: -- ----------------------------------------------------------------------------
273: -- |---------------------------------< upd >----------------------------------|
274: -- ----------------------------------------------------------------------------
275: Procedure upd
276: (p_rec in out nocopy pay_app_shd.g_rec_type
277: ) is
278: --
279: l_proc varchar2(72);
280: --

Line 288: pay_app_shd.lck

284: hr_utility.set_location('Entering:'||l_proc, 5);
285: --
286: -- We must lock the row which we need to update.
287: --
288: pay_app_shd.lck
289: (p_rec.process_parameter_id
290: ,p_rec.object_version_number
291: );
292: --

Line 337: l_rec pay_app_shd.g_rec_type;

333: ,p_data_type in varchar2
334: ,p_enabled_flag in varchar2
335: ) is
336: --
337: l_rec pay_app_shd.g_rec_type;
338: l_proc varchar2(72);
339: --
340: Begin
341: l_proc := g_package||'upd';

Line 349: pay_app_shd.convert_args

345: -- Call conversion function to turn arguments into the
346: -- l_rec structure.
347: --
348: l_rec :=
349: pay_app_shd.convert_args
350: (p_process_parameter_id
351: ,p_process_id
352: ,p_internal_name
353: ,p_data_type