APPS.PQH_TCT_INS dependencies on PQH_TCT_SHD

Line 47: Procedure insert_dml(p_rec in out nocopy pqh_tct_shd.g_rec_type) is

43: -- Internal Row Handler Use Only.
44: --
45: -- {End Of Comments}
46: -- ----------------------------------------------------------------------------
47: Procedure insert_dml(p_rec in out nocopy pqh_tct_shd.g_rec_type) is
48: --
49: l_proc varchar2(72) := g_package||'insert_dml';
50: --
51: Begin

Line 110: pqh_tct_shd.constraint_error

106: hr_utility.set_location(' Leaving:'||l_proc, 10);
107: Exception
108: When hr_api.check_integrity_violated Then
109: -- A check constraint has been violated
110: pqh_tct_shd.constraint_error
111: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
112: When hr_api.parent_integrity_violated Then
113: -- Parent integrity has been violated
114: pqh_tct_shd.constraint_error

Line 114: pqh_tct_shd.constraint_error

110: pqh_tct_shd.constraint_error
111: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
112: When hr_api.parent_integrity_violated Then
113: -- Parent integrity has been violated
114: pqh_tct_shd.constraint_error
115: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
116: When hr_api.unique_integrity_violated Then
117: -- Unique integrity has been violated
118: pqh_tct_shd.constraint_error

Line 118: pqh_tct_shd.constraint_error

114: pqh_tct_shd.constraint_error
115: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
116: When hr_api.unique_integrity_violated Then
117: -- Unique integrity has been violated
118: pqh_tct_shd.constraint_error
119: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
120: When Others Then
121: Raise;
122: End insert_dml;

Line 161: Procedure pre_insert(p_rec in out nocopy pqh_tct_shd.g_rec_type) is

157: -- Internal Row Handler Use Only.
158: --
159: -- {End Of Comments}
160: -- ----------------------------------------------------------------------------
161: Procedure pre_insert(p_rec in out nocopy pqh_tct_shd.g_rec_type) is
162: --
163: l_proc varchar2(72) := g_package||'pre_insert';
164: --
165: Cursor C_Sel1 is select pqh_transaction_categories_s.nextval from sys.dual;

Line 213: p_effective_date in date,p_rec in pqh_tct_shd.g_rec_type) is

209: --
210: -- {End Of Comments}
211: -- ----------------------------------------------------------------------------
212: Procedure post_insert(
213: p_effective_date in date,p_rec in pqh_tct_shd.g_rec_type) is
214: --
215: l_proc varchar2(72) := g_package||'post_insert';
216: --
217: Begin

Line 273: p_rec in out nocopy pqh_tct_shd.g_rec_type

269: -- ----------------------------------------------------------------------------
270: Procedure ins
271: (
272: p_effective_date in date,
273: p_rec in out nocopy pqh_tct_shd.g_rec_type
274: ) is
275: --
276: l_proc varchar2(72) := g_package||'ins';
277: --

Line 329: l_rec pqh_tct_shd.g_rec_type;

325: p_setup_type_cd in varchar2 ,
326: p_master_table_route_id in number
327: ) is
328: --
329: l_rec pqh_tct_shd.g_rec_type;
330: l_proc varchar2(72) := g_package||'ins';
331: --
332: Begin
333: hr_utility.set_location('Entering:'||l_proc, 5);

Line 339: pqh_tct_shd.convert_args

335: -- Call conversion function to turn arguments into the
336: -- p_rec structure.
337: --
338: l_rec :=
339: pqh_tct_shd.convert_args
340: (
341: null,
342: p_custom_wf_process_name,
343: p_custom_workflow_name,