APPS.PAY_APP_INS dependencies on PAY_APP_SHD

Line 78: (p_rec in out nocopy pay_app_shd.g_rec_type

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

Line 89: pay_app_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_app_shd.g_api_dml := true; -- Set the api dml status
90: --
91: -- Insert the row into: pay_au_process_parameters
92: --
93: insert into pay_au_process_parameters

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

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

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

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

Line 117: pay_app_shd.constraint_error

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

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

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

Line 122: pay_app_shd.constraint_error

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

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

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

Line 127: pay_app_shd.constraint_error

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

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

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

Line 172: (p_rec in out nocopy pay_app_shd.g_rec_type

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

Line 261: (p_rec in pay_app_shd.g_rec_type

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

Line 278: (p_rec in out nocopy pay_app_shd.g_rec_type

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

Line 329: l_rec pay_app_shd.g_rec_type;

325: ,p_process_parameter_id out nocopy number
326: ,p_object_version_number out nocopy number
327: ) is
328: --
329: l_rec pay_app_shd.g_rec_type;
330: l_proc varchar2(72);
331: --
332: Begin
333: l_proc := g_package||'ins';

Line 341: pay_app_shd.convert_args

337: -- Call conversion function to turn arguments into the
338: -- p_rec structure.
339: --
340: l_rec :=
341: pay_app_shd.convert_args
342: (null
343: ,p_process_id
344: ,p_internal_name
345: ,p_data_type