eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PQH_DOA_INS dependencies on PQH_DOA_SHD

Line 80: (p_rec in out NOCOPY pqh_doa_shd.g_rec_type

76: --
77: -- {End Of Comments}
78: -- ----------------------------------------------------------------------------
79: Procedure dt_insert_dml
80: (p_rec in out NOCOPY pqh_doa_shd.g_rec_type
81: ,p_effective_date in date
82: ,p_datetrack_mode in varchar2
83: ,p_validation_start_date in date
84: ,p_validation_end_date in date

Line 94: pqh_doa_shd.g_old_rec.effective_start_date

90: t.creation_date
91: from pqh_document_attributes_f t
92: where t.document_attribute_id = p_rec.document_attribute_id
93: and t.effective_start_date =
94: pqh_doa_shd.g_old_rec.effective_start_date
95: and t.effective_end_date = (p_validation_start_date - 1);
96: --
97: l_proc varchar2(72) := g_package||'dt_insert_dml';
98: l_created_by pqh_document_attributes_f.created_by%TYPE;

Line 152: pqh_doa_shd.g_api_dml := true; -- Set the api dml status

148: l_last_updated_by := fnd_global.user_id;
149: l_last_update_login := fnd_global.login_id;
150: End If;
151: --
152: pqh_doa_shd.g_api_dml := true; -- Set the api dml status
153: --
154: -- Insert the row into: pqh_document_attributes_f
155: --
156: insert into pqh_document_attributes_f

Line 185: pqh_doa_shd.g_api_dml := false; -- Unset the api dml status

181: ,l_last_updated_by
182: ,l_last_update_login
183: );
184: --
185: pqh_doa_shd.g_api_dml := false; -- Unset the api dml status
186: hr_utility.set_location(' Leaving:'||l_proc, 15);
187: --
188: Exception
189: When hr_api.check_integrity_violated Then

Line 191: pqh_doa_shd.g_api_dml := false; -- Unset the api dml status

187: --
188: Exception
189: When hr_api.check_integrity_violated Then
190: -- A check constraint has been violated
191: pqh_doa_shd.g_api_dml := false; -- Unset the api dml status
192: pqh_doa_shd.constraint_error
193: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
194: When hr_api.unique_integrity_violated Then
195: -- Unique integrity has been violated

Line 192: pqh_doa_shd.constraint_error

188: Exception
189: When hr_api.check_integrity_violated Then
190: -- A check constraint has been violated
191: pqh_doa_shd.g_api_dml := false; -- Unset the api dml status
192: pqh_doa_shd.constraint_error
193: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
194: When hr_api.unique_integrity_violated Then
195: -- Unique integrity has been violated
196: pqh_doa_shd.g_api_dml := false; -- Unset the api dml status

Line 196: pqh_doa_shd.g_api_dml := false; -- Unset the api dml status

192: pqh_doa_shd.constraint_error
193: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
194: When hr_api.unique_integrity_violated Then
195: -- Unique integrity has been violated
196: pqh_doa_shd.g_api_dml := false; -- Unset the api dml status
197: pqh_doa_shd.constraint_error
198: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
199: When Others Then
200: pqh_doa_shd.g_api_dml := false; -- Unset the api dml status

Line 197: pqh_doa_shd.constraint_error

193: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
194: When hr_api.unique_integrity_violated Then
195: -- Unique integrity has been violated
196: pqh_doa_shd.g_api_dml := false; -- Unset the api dml status
197: pqh_doa_shd.constraint_error
198: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
199: When Others Then
200: pqh_doa_shd.g_api_dml := false; -- Unset the api dml status
201: Raise;

Line 200: pqh_doa_shd.g_api_dml := false; -- Unset the api dml status

196: pqh_doa_shd.g_api_dml := false; -- Unset the api dml status
197: pqh_doa_shd.constraint_error
198: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
199: When Others Then
200: pqh_doa_shd.g_api_dml := false; -- Unset the api dml status
201: Raise;
202: End dt_insert_dml;
203: --
204: -- ----------------------------------------------------------------------------

Line 208: (p_rec in out NOCOPY pqh_doa_shd.g_rec_type

204: -- ----------------------------------------------------------------------------
205: -- |------------------------------< insert_dml >------------------------------|
206: -- ----------------------------------------------------------------------------
207: Procedure insert_dml
208: (p_rec in out NOCOPY pqh_doa_shd.g_rec_type
209: ,p_effective_date in date
210: ,p_datetrack_mode in varchar2
211: ,p_validation_start_date in date
212: ,p_validation_end_date in date

Line 271: (p_rec in out NOCOPY pqh_doa_shd.g_rec_type

267: --
268: -- {End Of Comments}
269: -- ----------------------------------------------------------------------------
270: Procedure pre_insert
271: (p_rec in out NOCOPY pqh_doa_shd.g_rec_type
272: ,p_effective_date in date
273: ,p_datetrack_mode in varchar2
274: ,p_validation_start_date in date
275: ,p_validation_end_date in date

Line 363: (p_rec in pqh_doa_shd.g_rec_type

359: --
360: -- {End Of Comments}
361: -- ----------------------------------------------------------------------------
362: Procedure post_insert
363: (p_rec in pqh_doa_shd.g_rec_type
364: ,p_effective_date in date
365: ,p_datetrack_mode in varchar2
366: ,p_validation_start_date in date
367: ,p_validation_end_date in date

Line 451: ,p_rec in pqh_doa_shd.g_rec_type

447: -- ----------------------------------------------------------------------------
448: Procedure ins_lck
449: (p_effective_date in date
450: ,p_datetrack_mode in varchar2
451: ,p_rec in pqh_doa_shd.g_rec_type
452: ,p_validation_start_date out NOCOPY date
453: ,p_validation_end_date out NOCOPY date
454: ) is
455: --

Line 491: ,p_rec in out NOCOPY pqh_doa_shd.g_rec_type

487: -- |---------------------------------< ins >----------------------------------|
488: -- ----------------------------------------------------------------------------
489: Procedure ins
490: (p_effective_date in date
491: ,p_rec in out NOCOPY pqh_doa_shd.g_rec_type
492: ) is
493: --
494: l_proc varchar2(72) := g_package||'ins';
495: l_datetrack_mode varchar2(30) := hr_api.g_insert;

Line 575: l_rec pqh_doa_shd.g_rec_type;

571: ,p_effective_start_date out NOCOPY date
572: ,p_effective_end_date out NOCOPY date
573: ) is
574: --
575: l_rec pqh_doa_shd.g_rec_type;
576: l_proc varchar2(72) := g_package||'ins';
577: --
578: Begin
579: hr_utility.set_location('Entering:'||l_proc, 5);

Line 585: pqh_doa_shd.convert_args

581: -- Call conversion function to turn arguments into the
582: -- p_rec structure.
583: --
584: l_rec :=
585: pqh_doa_shd.convert_args
586: (null
587: ,null
588: ,null
589: ,p_document_id