DBA Data[Home] [Help]

APPS.PAY_MGR_INS dependencies on PAY_MGR_SHD

Line 53: Procedure insert_dml(p_rec in out nocopy pay_mgr_shd.g_rec_type) is

49: -- Internal Development Use Only.
50: --
51: -- {End Of Comments}
52: -- ----------------------------------------------------------------------------
53: Procedure insert_dml(p_rec in out nocopy pay_mgr_shd.g_rec_type) is
54: --
55: l_proc varchar2(72) := g_package||'insert_dml';
56: --
57: Begin

Line 61: pay_mgr_shd.g_api_dml := true; -- Set the api dml status

57: Begin
58: hr_utility.set_location('Entering:'||l_proc, 5);
59: --
60: --
61: pay_mgr_shd.g_api_dml := true; -- Set the api dml status
62: --
63: -- Insert the row into: pay_magnetic_records
64: --
65: insert into pay_magnetic_records

Line 92: pay_mgr_shd.g_api_dml := false; -- Unset the api dml status

88: p_rec.block_row_label,
89: p_rec.xml_proc_name
90: );
91: --
92: pay_mgr_shd.g_api_dml := false; -- Unset the api dml status
93: --
94: hr_utility.set_location(' Leaving:'||l_proc, 10);
95: Exception
96: When hr_api.check_integrity_violated Then

Line 98: pay_mgr_shd.g_api_dml := false; -- Unset the api dml status

94: hr_utility.set_location(' Leaving:'||l_proc, 10);
95: Exception
96: When hr_api.check_integrity_violated Then
97: -- A check constraint has been violated
98: pay_mgr_shd.g_api_dml := false; -- Unset the api dml status
99: pay_mgr_shd.constraint_error
100: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
101: When hr_api.parent_integrity_violated Then
102: -- Parent integrity has been violated

Line 99: pay_mgr_shd.constraint_error

95: Exception
96: When hr_api.check_integrity_violated Then
97: -- A check constraint has been violated
98: pay_mgr_shd.g_api_dml := false; -- Unset the api dml status
99: pay_mgr_shd.constraint_error
100: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
101: When hr_api.parent_integrity_violated Then
102: -- Parent integrity has been violated
103: pay_mgr_shd.g_api_dml := false; -- Unset the api dml status

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

99: pay_mgr_shd.constraint_error
100: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
101: When hr_api.parent_integrity_violated Then
102: -- Parent integrity has been violated
103: pay_mgr_shd.g_api_dml := false; -- Unset the api dml status
104: pay_mgr_shd.constraint_error
105: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
106: When hr_api.unique_integrity_violated Then
107: -- Unique integrity has been violated

Line 104: pay_mgr_shd.constraint_error

100: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
101: When hr_api.parent_integrity_violated Then
102: -- Parent integrity has been violated
103: pay_mgr_shd.g_api_dml := false; -- Unset the api dml status
104: pay_mgr_shd.constraint_error
105: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
106: When hr_api.unique_integrity_violated Then
107: -- Unique integrity has been violated
108: pay_mgr_shd.g_api_dml := false; -- Unset the api dml status

Line 108: pay_mgr_shd.g_api_dml := false; -- Unset the api dml status

104: pay_mgr_shd.constraint_error
105: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
106: When hr_api.unique_integrity_violated Then
107: -- Unique integrity has been violated
108: pay_mgr_shd.g_api_dml := false; -- Unset the api dml status
109: pay_mgr_shd.constraint_error
110: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
111: When Others Then
112: pay_mgr_shd.g_api_dml := false; -- Unset the api dml status

Line 109: pay_mgr_shd.constraint_error

105: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
106: When hr_api.unique_integrity_violated Then
107: -- Unique integrity has been violated
108: pay_mgr_shd.g_api_dml := false; -- Unset the api dml status
109: pay_mgr_shd.constraint_error
110: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
111: When Others Then
112: pay_mgr_shd.g_api_dml := false; -- Unset the api dml status
113: Raise;

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

108: pay_mgr_shd.g_api_dml := false; -- Unset the api dml status
109: pay_mgr_shd.constraint_error
110: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
111: When Others Then
112: pay_mgr_shd.g_api_dml := false; -- Unset the api dml status
113: Raise;
114: End insert_dml;
115: --
116: -- ----------------------------------------------------------------------------

Line 153: Procedure pre_insert(p_rec in out nocopy pay_mgr_shd.g_rec_type) is

149: -- Internal Development Use Only.
150: --
151: -- {End Of Comments}
152: -- ----------------------------------------------------------------------------
153: Procedure pre_insert(p_rec in out nocopy pay_mgr_shd.g_rec_type) is
154: --
155: l_proc varchar2(72) := g_package||'pre_insert';
156: --
157: --

Line 199: Procedure post_insert(p_rec in pay_mgr_shd.g_rec_type) is

195: -- Internal Development Use Only.
196: --
197: -- {End Of Comments}
198: -- ----------------------------------------------------------------------------
199: Procedure post_insert(p_rec in pay_mgr_shd.g_rec_type) is
200: --
201: l_proc varchar2(72) := g_package||'post_insert';
202: --
203: Begin

Line 214: p_rec in out nocopy pay_mgr_shd.g_rec_type,

210: -- |---------------------------------< ins >----------------------------------|
211: -- ----------------------------------------------------------------------------
212: Procedure ins
213: (
214: p_rec in out nocopy pay_mgr_shd.g_rec_type,
215: p_validate in boolean default false
216: ) is
217: --
218: l_proc varchar2(72) := g_package||'ins';

Line 283: l_rec pay_mgr_shd.g_rec_type;

279: p_block_row_label in varchar2 default null,
280: p_xml_proc_name in varchar2 default null
281: ) is
282: --
283: l_rec pay_mgr_shd.g_rec_type;
284: l_proc varchar2(72) := g_package||'ins';
285: --
286: Begin
287: hr_utility.set_location('Entering:'||l_proc, 5);

Line 293: pay_mgr_shd.convert_args

289: -- Call conversion function to turn arguments into the
290: -- p_rec structure.
291: --
292: l_rec :=
293: pay_mgr_shd.convert_args
294: (
295: p_formula_id,
296: p_magnetic_block_id,
297: p_next_block_id,