APPS.PAY_SPR_INS dependencies on PAY_SPR_SHD

Line 79: (p_rec in out nocopy pay_spr_shd.g_rec_type

75: --
76: -- {End Of Comments}
77: -- ----------------------------------------------------------------------------
78: Procedure insert_dml
79: (p_rec in out nocopy pay_spr_shd.g_rec_type
80: ) is
81: --
82: l_proc varchar2(72) := g_package||'insert_dml';
83: --

Line 88: pay_spr_shd.g_api_dml := true; -- Set the api dml status

84: Begin
85: hr_utility.set_location('Entering:'||l_proc, 5);
86: p_rec.object_version_number := 1; -- Initialise the object version
87: --
88: pay_spr_shd.g_api_dml := true; -- Set the api dml status
89: --
90: -- Insert the row into: pay_security_payrolls
91: --
92: hr_utility.set_location(to_char(p_rec.payroll_id),10);

Line 114: pay_spr_shd.g_api_dml := false; -- Unset the api dml status

110: ,p_rec.program_update_date
111: ,p_rec.object_version_number
112: );
113: --
114: pay_spr_shd.g_api_dml := false; -- Unset the api dml status
115: --
116: hr_utility.set_location(' Leaving:'||l_proc, 10);
117: Exception
118: When hr_api.check_integrity_violated Then

Line 120: pay_spr_shd.g_api_dml := false; -- Unset the api dml status

116: hr_utility.set_location(' Leaving:'||l_proc, 10);
117: Exception
118: When hr_api.check_integrity_violated Then
119: -- A check constraint has been violated
120: pay_spr_shd.g_api_dml := false; -- Unset the api dml status
121: pay_spr_shd.constraint_error
122: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
123: When hr_api.parent_integrity_violated Then
124: -- Parent integrity has been violated

Line 121: pay_spr_shd.constraint_error

117: Exception
118: When hr_api.check_integrity_violated Then
119: -- A check constraint has been violated
120: pay_spr_shd.g_api_dml := false; -- Unset the api dml status
121: pay_spr_shd.constraint_error
122: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
123: When hr_api.parent_integrity_violated Then
124: -- Parent integrity has been violated
125: pay_spr_shd.g_api_dml := false; -- Unset the api dml status

Line 125: pay_spr_shd.g_api_dml := false; -- Unset the api dml status

121: pay_spr_shd.constraint_error
122: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
123: When hr_api.parent_integrity_violated Then
124: -- Parent integrity has been violated
125: pay_spr_shd.g_api_dml := false; -- Unset the api dml status
126: pay_spr_shd.constraint_error
127: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
128: When hr_api.unique_integrity_violated Then
129: -- Unique integrity has been violated

Line 126: pay_spr_shd.constraint_error

122: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
123: When hr_api.parent_integrity_violated Then
124: -- Parent integrity has been violated
125: pay_spr_shd.g_api_dml := false; -- Unset the api dml status
126: pay_spr_shd.constraint_error
127: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
128: When hr_api.unique_integrity_violated Then
129: -- Unique integrity has been violated
130: pay_spr_shd.g_api_dml := false; -- Unset the api dml status

Line 130: pay_spr_shd.g_api_dml := false; -- Unset the api dml status

126: pay_spr_shd.constraint_error
127: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
128: When hr_api.unique_integrity_violated Then
129: -- Unique integrity has been violated
130: pay_spr_shd.g_api_dml := false; -- Unset the api dml status
131: pay_spr_shd.constraint_error
132: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
133: When Others Then
134: pay_spr_shd.g_api_dml := false; -- Unset the api dml status

Line 131: pay_spr_shd.constraint_error

127: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
128: When hr_api.unique_integrity_violated Then
129: -- Unique integrity has been violated
130: pay_spr_shd.g_api_dml := false; -- Unset the api dml status
131: pay_spr_shd.constraint_error
132: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
133: When Others Then
134: pay_spr_shd.g_api_dml := false; -- Unset the api dml status
135: Raise;

Line 134: pay_spr_shd.g_api_dml := false; -- Unset the api dml status

130: pay_spr_shd.g_api_dml := false; -- Unset the api dml status
131: pay_spr_shd.constraint_error
132: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
133: When Others Then
134: pay_spr_shd.g_api_dml := false; -- Unset the api dml status
135: Raise;
136: End insert_dml;
137: --
138: -- ----------------------------------------------------------------------------

Line 176: (p_rec in out nocopy pay_spr_shd.g_rec_type

172: --
173: -- {End Of Comments}
174: -- ----------------------------------------------------------------------------
175: Procedure pre_insert
176: (p_rec in out nocopy pay_spr_shd.g_rec_type
177: ) is
178: --
179: --
180: Cursor C_Sel2 is

Line 260: ,p_rec in pay_spr_shd.g_rec_type

256: -- {End Of Comments}
257: -- ----------------------------------------------------------------------------
258: Procedure post_insert
259: (p_effective_date in date
260: ,p_rec in pay_spr_shd.g_rec_type
261: ) is
262: --
263: l_proc varchar2(72) := g_package||'post_insert';
264: --

Line 299: ,p_rec in out nocopy pay_spr_shd.g_rec_type

295: -- |---------------------------------< ins >----------------------------------|
296: -- ----------------------------------------------------------------------------
297: Procedure ins
298: (p_effective_date in date
299: ,p_rec in out nocopy pay_spr_shd.g_rec_type
300: ) is
301: --
302: l_proc varchar2(72) := g_package||'ins';
303: --

Line 348: l_rec pay_spr_shd.g_rec_type;

344: ,p_payroll_id in number
345: ,p_object_version_number out nocopy number
346: ) is
347: --
348: l_rec pay_spr_shd.g_rec_type;
349: l_proc varchar2(72) := g_package||'ins';
350: l_business_group_id number;
351: --
352: Begin

Line 382: pay_spr_shd.convert_args

378: -- Call conversion function to turn arguments into the
379: -- p_rec structure.
380: --
381: l_rec :=
382: pay_spr_shd.convert_args
383: (l_business_group_id
384: ,p_security_profile_id
385: ,p_payroll_id
386: ,p_object_version_number