APPS.PAY_AMT_INS dependencies on PAY_AMT_SHD

Line 78: (p_rec in out nocopy pay_amt_shd.g_rec_type

74: --
75: -- {End Of Comments}
76: -- ----------------------------------------------------------------------------
77: Procedure insert_dml
78: (p_rec in out nocopy pay_amt_shd.g_rec_type
79: ) is
80: --
81: l_proc varchar2(72);
82: --

Line 89: pay_amt_shd.g_api_dml := true; -- Set the api dml status

85: --
86: hr_utility.set_location('Entering:'||l_proc, 5);
87: p_rec.object_version_number := 1; -- Initialise the object version
88: --
89: pay_amt_shd.g_api_dml := true; -- Set the api dml status
90: --
91: -- Insert the row into: pay_au_module_types
92: --
93: insert into pay_au_module_types

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

104: ,p_rec.description
105: ,p_rec.object_version_number
106: );
107: --
108: pay_amt_shd.g_api_dml := false; -- Unset the api dml status
109: --
110: hr_utility.set_location(' Leaving:'||l_proc, 10);
111: Exception
112: When hr_api.check_integrity_violated Then

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

110: hr_utility.set_location(' Leaving:'||l_proc, 10);
111: Exception
112: When hr_api.check_integrity_violated Then
113: -- A check constraint has been violated
114: pay_amt_shd.g_api_dml := false; -- Unset the api dml status
115: pay_amt_shd.constraint_error
116: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
117: When hr_api.parent_integrity_violated Then
118: -- Parent integrity has been violated

Line 115: pay_amt_shd.constraint_error

111: Exception
112: When hr_api.check_integrity_violated Then
113: -- A check constraint has been violated
114: pay_amt_shd.g_api_dml := false; -- Unset the api dml status
115: pay_amt_shd.constraint_error
116: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
117: When hr_api.parent_integrity_violated Then
118: -- Parent integrity has been violated
119: pay_amt_shd.g_api_dml := false; -- Unset the api dml status

Line 119: pay_amt_shd.g_api_dml := false; -- Unset the api dml status

115: pay_amt_shd.constraint_error
116: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
117: When hr_api.parent_integrity_violated Then
118: -- Parent integrity has been violated
119: pay_amt_shd.g_api_dml := false; -- Unset the api dml status
120: pay_amt_shd.constraint_error
121: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
122: When hr_api.unique_integrity_violated Then
123: -- Unique integrity has been violated

Line 120: pay_amt_shd.constraint_error

116: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
117: When hr_api.parent_integrity_violated Then
118: -- Parent integrity has been violated
119: pay_amt_shd.g_api_dml := false; -- Unset the api dml status
120: pay_amt_shd.constraint_error
121: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
122: When hr_api.unique_integrity_violated Then
123: -- Unique integrity has been violated
124: pay_amt_shd.g_api_dml := false; -- Unset the api dml status

Line 124: pay_amt_shd.g_api_dml := false; -- Unset the api dml status

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

Line 125: pay_amt_shd.constraint_error

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

Line 128: pay_amt_shd.g_api_dml := false; -- Unset the api dml status

124: pay_amt_shd.g_api_dml := false; -- Unset the api dml status
125: pay_amt_shd.constraint_error
126: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
127: When Others Then
128: pay_amt_shd.g_api_dml := false; -- Unset the api dml status
129: Raise;
130: End insert_dml;
131: --
132: -- ----------------------------------------------------------------------------

Line 170: (p_rec in out nocopy pay_amt_shd.g_rec_type

166: --
167: -- {End Of Comments}
168: -- ----------------------------------------------------------------------------
169: Procedure pre_insert
170: (p_rec in out nocopy pay_amt_shd.g_rec_type
171: ) is
172: --
173: Cursor C_Sel1 is select pay_au_module_types_s.nextval from sys.dual;
174: --

Line 259: (p_rec in pay_amt_shd.g_rec_type

255: --
256: -- {End Of Comments}
257: -- ----------------------------------------------------------------------------
258: Procedure post_insert
259: (p_rec in pay_amt_shd.g_rec_type
260: ) is
261: --
262: l_proc varchar2(72);
263: --

Line 276: (p_rec in out nocopy pay_amt_shd.g_rec_type

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

Line 326: l_rec pay_amt_shd.g_rec_type;

322: ,p_module_type_id out nocopy number
323: ,p_object_version_number out nocopy number
324: ) is
325: --
326: l_rec pay_amt_shd.g_rec_type;
327: l_proc varchar2(72);
328: --
329: Begin
330: l_proc := g_package||'ins';

Line 338: pay_amt_shd.convert_args

334: -- Call conversion function to turn arguments into the
335: -- p_rec structure.
336: --
337: l_rec :=
338: pay_amt_shd.convert_args
339: (null
340: ,p_name
341: ,p_enabled_flag
342: ,p_description