APPS.PQH_TKT_BUS dependencies on PQH_TKT_SHD

Line 194: ,p_rec in pqh_tkt_shd.g_rec_type

190: -- {End Of Comments}
191: -- ----------------------------------------------------------------------------
192: Procedure chk_non_updateable_args
193: (p_effective_date in date
194: ,p_rec in pqh_tkt_shd.g_rec_type
195: ) IS
196: --
197: l_proc varchar2(72) := g_package || 'chk_non_updateable_args';
198:

Line 205: IF NOT pqh_tkt_shd.api_updating

201: --
202: -- Only proceed with the validation if a row exists for the current
203: -- record in the HR Schema.
204: --
205: IF NOT pqh_tkt_shd.api_updating
206: (p_tatigkeit_detail_id => p_rec.tatigkeit_detail_id
207: ,p_object_version_number => p_rec.object_version_number
208: ) THEN
209: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');

Line 219: nvl(pqh_tkt_shd.g_old_rec.TATIGKEIT_NUMBER, hr_api.g_varchar2) THEN

215: -- EDIT_HERE: Add checks to ensure non-updateable args have
216: -- not been updated.
217: --
218: IF nvl(p_rec.TATIGKEIT_NUMBER, hr_api.g_varchar2) <>
219: nvl(pqh_tkt_shd.g_old_rec.TATIGKEIT_NUMBER, hr_api.g_varchar2) THEN
220: hr_utility.set_message(8302, 'PQH_DE_NONUPD_TATIGKEIT_NUMBER');
221: fnd_message.raise_error;
222: END IF;
223:

Line 229: (p_rec in pqh_tkt_shd.g_rec_type) is

225: -- ----------------------------------------------------------------------------
226: -- |-----------------------< chk_delete >-------------------------------------|
227: -- ----------------------------------------------------------------------------
228: Procedure Chk_delete
229: (p_rec in pqh_tkt_shd.g_rec_type) is
230: l_proc varchar2(72) := g_package||'Ckh_Delete';
231: Cursor Del is
232: select '1' from per_gen_hierarchy_nodes
233: where NODE_TYPE = 'OPR_JOB_DTLS'

Line 259: (p_rec in pqh_tkt_shd.g_rec_type) is

255: -- ----------------------------------------------------------------------------
256: -- |-----------------------< Chk_Unique_TATIGKEIT_NUMBER >---------------------|
257: -- ----------------------------------------------------------------------------
258: Procedure Chk_Unique_TATIGKEIT_NUMBER
259: (p_rec in pqh_tkt_shd.g_rec_type) is
260: --
261: Cursor c_TATIGKEIT_NUMBER is
262: Select TATIGKEIT_NUMBER
263: from PQH_DE_TATIGKEIT_DETAILS

Line 293: (p_rec in pqh_tkt_shd.g_rec_type) is

289: -- ----------------------------------------------------------------------------
290: -- |-----------------------< Chk_Unique_Description >-------------------------|
291: -- ----------------------------------------------------------------------------
292: Procedure Chk_Unique_Description
293: (p_rec in pqh_tkt_shd.g_rec_type) is
294: --
295: Cursor c_Description is
296: Select Description
297: from PQH_DE_TATIGKEIT_DETAILS

Line 332: ,p_rec in pqh_tkt_shd.g_rec_type

328: -- |---------------------------< insert_validate >----------------------------|
329: -- ----------------------------------------------------------------------------
330: Procedure insert_validate
331: (p_effective_date in date
332: ,p_rec in pqh_tkt_shd.g_rec_type
333: ) is
334: --
335: l_proc varchar2(72) := g_package||'insert_validate';
336: --

Line 364: ,p_rec in pqh_tkt_shd.g_rec_type

360: -- |---------------------------< update_validate >----------------------------|
361: -- ----------------------------------------------------------------------------
362: Procedure update_validate
363: (p_effective_date in date
364: ,p_rec in pqh_tkt_shd.g_rec_type
365: ) is
366: --
367: l_proc varchar2(72) := g_package||'update_validate';
368: --

Line 401: (p_rec in pqh_tkt_shd.g_rec_type

397: -- ----------------------------------------------------------------------------
398: -- |---------------------------< delete_validate >----------------------------|
399: -- ----------------------------------------------------------------------------
400: Procedure delete_validate
401: (p_rec in pqh_tkt_shd.g_rec_type
402: ) is
403: --
404: l_proc varchar2(72) := g_package||'delete_validate';
405: --