APPS.PQH_TTL_UPD dependencies on PQH_TEMPLATES

Line 57: -- Update the pqh_templates_tl Row

53: hr_utility.set_location('Entering:'||l_proc, 5);
54: --
55: --
56: --
57: -- Update the pqh_templates_tl Row
58: --
59: update pqh_templates_tl
60: set
61: template_id = p_rec.template_id,

Line 59: update pqh_templates_tl

55: --
56: --
57: -- Update the pqh_templates_tl Row
58: --
59: update pqh_templates_tl
60: set
61: template_id = p_rec.template_id,
62: template_name = p_rec.template_name,
63: language = p_rec.language,

Line 190: (p_module_name => 'pqh_templates_tl'

186: --
187: when hr_api.cannot_find_prog_unit then
188: --
189: hr_api.cannot_find_prog_unit_error
190: (p_module_name => 'pqh_templates_tl'
191: ,p_hook_type => 'AU');
192: --
193: end;
194: --

Line 367: from pqh_templates_tl ttl

363: )is
364:
365: Cursor csr_upd_langs is
366: select ttl.language
367: from pqh_templates_tl ttl
368: where ttl.template_id = p_template_id
369: AND p_language_code in (ttl.language,ttl.source_lang);
370: --
371: l_proc varchar2(72) := g_package||'upd_tl';

Line 402: l_template_id pqh_templates.template_id%type := 0;

398: p_template_name in varchar2 ,
399: p_owner in varchar2
400: ) is
401:
402: l_template_id pqh_templates.template_id%type := 0;
403: --
404: --
405: l_created_by pqh_templates.created_by%TYPE;
406: l_last_updated_by pqh_templates.last_updated_by%TYPE;

Line 405: l_created_by pqh_templates.created_by%TYPE;

401:
402: l_template_id pqh_templates.template_id%type := 0;
403: --
404: --
405: l_created_by pqh_templates.created_by%TYPE;
406: l_last_updated_by pqh_templates.last_updated_by%TYPE;
407: l_creation_date pqh_templates.creation_date%TYPE;
408: l_last_update_date pqh_templates.last_update_date%TYPE;
409: l_last_update_login pqh_templates.last_update_login%TYPE;

Line 406: l_last_updated_by pqh_templates.last_updated_by%TYPE;

402: l_template_id pqh_templates.template_id%type := 0;
403: --
404: --
405: l_created_by pqh_templates.created_by%TYPE;
406: l_last_updated_by pqh_templates.last_updated_by%TYPE;
407: l_creation_date pqh_templates.creation_date%TYPE;
408: l_last_update_date pqh_templates.last_update_date%TYPE;
409: l_last_update_login pqh_templates.last_update_login%TYPE;
410: --

Line 407: l_creation_date pqh_templates.creation_date%TYPE;

403: --
404: --
405: l_created_by pqh_templates.created_by%TYPE;
406: l_last_updated_by pqh_templates.last_updated_by%TYPE;
407: l_creation_date pqh_templates.creation_date%TYPE;
408: l_last_update_date pqh_templates.last_update_date%TYPE;
409: l_last_update_login pqh_templates.last_update_login%TYPE;
410: --
411: --

Line 408: l_last_update_date pqh_templates.last_update_date%TYPE;

404: --
405: l_created_by pqh_templates.created_by%TYPE;
406: l_last_updated_by pqh_templates.last_updated_by%TYPE;
407: l_creation_date pqh_templates.creation_date%TYPE;
408: l_last_update_date pqh_templates.last_update_date%TYPE;
409: l_last_update_login pqh_templates.last_update_login%TYPE;
410: --
411: --
412: Cursor c1 is

Line 409: l_last_update_login pqh_templates.last_update_login%TYPE;

405: l_created_by pqh_templates.created_by%TYPE;
406: l_last_updated_by pqh_templates.last_updated_by%TYPE;
407: l_creation_date pqh_templates.creation_date%TYPE;
408: l_last_update_date pqh_templates.last_update_date%TYPE;
409: l_last_update_login pqh_templates.last_update_login%TYPE;
410: --
411: --
412: Cursor c1 is
413: select template_id

Line 414: from pqh_templates

410: --
411: --
412: Cursor c1 is
413: select template_id
414: from pqh_templates
415: where short_name = p_short_name ;
416: --
417: --
418: BEGIN

Line 445: UPDATE pqh_templates_tl

441: l_last_update_login := 0;
442: --
443: -- update the tl table
444: --
445: UPDATE pqh_templates_tl
446: SET template_name = p_template_name,
447: last_updated_by = l_last_updated_by,
448: last_update_date = l_last_update_date,
449: last_update_login = l_last_update_login,