DBA Data[Home] [Help]

APPS.HR_TRN_INS dependencies on HR_TRN_SHD

Line 77: Procedure insert_dml(p_rec in out nocopy hr_trn_shd.g_rec_type) is

73: -- Internal Table Handler Use Only.
74: --
75: -- {End Of Comments}
76: -- ----------------------------------------------------------------------------
77: Procedure insert_dml(p_rec in out nocopy hr_trn_shd.g_rec_type) is
78: --
79: l_proc varchar2(72) := g_package||'insert_dml';
80: --
81: Begin

Line 85: hr_trn_shd.g_api_dml := true; -- Set the api dml status

81: Begin
82: hr_utility.set_location('Entering:'||l_proc, 5);
83: --
84: --
85: hr_trn_shd.g_api_dml := true; -- Set the api dml status
86: --
87: -- Insert the row into: hr_api_transactions
88: --
89: insert into hr_api_transactions

Line 152: hr_trn_shd.g_api_dml := false; -- Unset the api dml status

148: );
149: --
150: -- plan_id, rptg_grp_id, effective_date_option added by sanej
151: --
152: hr_trn_shd.g_api_dml := false; -- Unset the api dml status
153: --
154: hr_utility.set_location(' Leaving:'||l_proc, 10);
155: Exception
156: When hr_api.check_integrity_violated Then

Line 158: hr_trn_shd.g_api_dml := false; -- Unset the api dml status

154: hr_utility.set_location(' Leaving:'||l_proc, 10);
155: Exception
156: When hr_api.check_integrity_violated Then
157: -- A check constraint has been violated
158: hr_trn_shd.g_api_dml := false; -- Unset the api dml status
159: hr_trn_shd.constraint_error
160: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
161: When hr_api.parent_integrity_violated Then
162: -- Parent integrity has been violated

Line 159: hr_trn_shd.constraint_error

155: Exception
156: When hr_api.check_integrity_violated Then
157: -- A check constraint has been violated
158: hr_trn_shd.g_api_dml := false; -- Unset the api dml status
159: hr_trn_shd.constraint_error
160: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
161: When hr_api.parent_integrity_violated Then
162: -- Parent integrity has been violated
163: hr_trn_shd.g_api_dml := false; -- Unset the api dml status

Line 163: hr_trn_shd.g_api_dml := false; -- Unset the api dml status

159: hr_trn_shd.constraint_error
160: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
161: When hr_api.parent_integrity_violated Then
162: -- Parent integrity has been violated
163: hr_trn_shd.g_api_dml := false; -- Unset the api dml status
164: hr_trn_shd.constraint_error
165: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
166: When hr_api.unique_integrity_violated Then
167: -- Unique integrity has been violated

Line 164: hr_trn_shd.constraint_error

160: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
161: When hr_api.parent_integrity_violated Then
162: -- Parent integrity has been violated
163: hr_trn_shd.g_api_dml := false; -- Unset the api dml status
164: hr_trn_shd.constraint_error
165: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
166: When hr_api.unique_integrity_violated Then
167: -- Unique integrity has been violated
168: hr_trn_shd.g_api_dml := false; -- Unset the api dml status

Line 168: hr_trn_shd.g_api_dml := false; -- Unset the api dml status

164: hr_trn_shd.constraint_error
165: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
166: When hr_api.unique_integrity_violated Then
167: -- Unique integrity has been violated
168: hr_trn_shd.g_api_dml := false; -- Unset the api dml status
169: hr_trn_shd.constraint_error
170: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
171: When Others Then
172: hr_trn_shd.g_api_dml := false; -- Unset the api dml status

Line 169: hr_trn_shd.constraint_error

165: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
166: When hr_api.unique_integrity_violated Then
167: -- Unique integrity has been violated
168: hr_trn_shd.g_api_dml := false; -- Unset the api dml status
169: hr_trn_shd.constraint_error
170: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
171: When Others Then
172: hr_trn_shd.g_api_dml := false; -- Unset the api dml status
173: Raise;

Line 172: hr_trn_shd.g_api_dml := false; -- Unset the api dml status

168: hr_trn_shd.g_api_dml := false; -- Unset the api dml status
169: hr_trn_shd.constraint_error
170: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
171: When Others Then
172: hr_trn_shd.g_api_dml := false; -- Unset the api dml status
173: Raise;
174: End insert_dml;
175: --
176: -- ----------------------------------------------------------------------------

Line 213: Procedure pre_insert(p_rec in out nocopy hr_trn_shd.g_rec_type) is

209: -- Internal Table Handler Use Only.
210: --
211: -- {End Of Comments}
212: -- ----------------------------------------------------------------------------
213: Procedure pre_insert(p_rec in out nocopy hr_trn_shd.g_rec_type) is
214: --
215: l_proc varchar2(72) := g_package||'pre_insert';
216: l_exists varchar2(1);
217: --

Line 299: Procedure post_insert(p_rec in hr_trn_shd.g_rec_type) is

295: -- Internal Table Handler Use Only.
296: --
297: -- {End Of Comments}
298: -- ----------------------------------------------------------------------------
299: Procedure post_insert(p_rec in hr_trn_shd.g_rec_type) is
300: --
301: l_proc varchar2(72) := g_package||'post_insert';
302: --
303: Begin

Line 314: p_rec in out nocopy hr_trn_shd.g_rec_type,

310: -- |---------------------------------< ins >----------------------------------|
311: -- ----------------------------------------------------------------------------
312: Procedure ins
313: (
314: p_rec in out nocopy hr_trn_shd.g_rec_type,
315: p_validate in boolean default false
316: ) is
317: --
318: l_proc varchar2(72) := g_package||'ins';

Line 375: l_rec hr_trn_shd.g_rec_type;

371: p_transaction_privilege in varchar2,
372: p_validate in boolean default false
373: ) is
374: --
375: l_rec hr_trn_shd.g_rec_type;
376: l_proc varchar2(72) := g_package||'ins';
377: --
378: Begin
379: hr_utility.set_location('Entering:'||l_proc, 5);

Line 386: hr_trn_shd.convert_args

382: -- p_rec structure.
383: --
384: /*
385: l_rec :=
386: hr_trn_shd.convert_args
387: (
388: null,
389: p_creator_person_id,
390: p_transaction_privilege

Line 476: l_rec hr_trn_shd.g_rec_type;

472: ) is
473: --
474: -- p_plan_id, p_rptg_grp_id, p_effective_date_option added by sanej
475: --
476: l_rec hr_trn_shd.g_rec_type;
477: l_proc varchar2(72) := g_package||'ins';
478: Begin
479: hr_utility.set_location('Entering:'||l_proc, 5);
480: --

Line 485: hr_trn_shd.convert_args

481: -- Call conversion function to turn arguments into the
482: -- p_rec structure.
483: --
484: l_rec :=
485: hr_trn_shd.convert_args
486: (
487: null,
488: p_creator_person_id,
489: p_transaction_privilege,