APPS.PQH_RTL_UPD dependencies on PQH_RULE_SETS

Line 57: -- Update the pqh_rule_sets_tl Row

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

Line 59: update pqh_rule_sets_tl

55: --
56: --
57: -- Update the pqh_rule_sets_tl Row
58: --
59: update pqh_rule_sets_tl
60: set
61: rule_set_id = p_rec.rule_set_id,
62: rule_set_name = p_rec.rule_set_name,
63: description = p_rec.description,

Line 193: (p_module_name => 'pqh_rule_sets_tl'

189: --
190: when hr_api.cannot_find_prog_unit then
191: --
192: hr_api.cannot_find_prog_unit_error
193: (p_module_name => 'pqh_rule_sets_tl'
194: ,p_hook_type => 'AU');
195: --
196: end;
197: --

Line 373: from pqh_rule_sets_tl rtl

369: ) is
370: --
371: cursor csr_upd_langs is
372: select rtl.language
373: from pqh_rule_sets_tl rtl
374: where rtl.rule_set_id = p_rule_set_id
375: AND p_language_code in (rtl.language,rtl.source_lang);
376: --
377: l_proc varchar2(72) := g_package||'upd_tl';

Line 410: l_rule_set_id pqh_rule_sets.rule_set_id%type := 0;

406: p_owner in varchar2
407: ) is
408:
409: --
410: l_rule_set_id pqh_rule_sets.rule_set_id%type := 0;
411: --
412: --
413: l_created_by pqh_rule_sets.created_by%TYPE;
414: l_last_updated_by pqh_rule_sets.last_updated_by%TYPE;

Line 413: l_created_by pqh_rule_sets.created_by%TYPE;

409: --
410: l_rule_set_id pqh_rule_sets.rule_set_id%type := 0;
411: --
412: --
413: l_created_by pqh_rule_sets.created_by%TYPE;
414: l_last_updated_by pqh_rule_sets.last_updated_by%TYPE;
415: l_creation_date pqh_rule_sets.creation_date%TYPE;
416: l_last_update_date pqh_rule_sets.last_update_date%TYPE;
417: l_last_update_login pqh_rule_sets.last_update_login%TYPE;

Line 414: l_last_updated_by pqh_rule_sets.last_updated_by%TYPE;

410: l_rule_set_id pqh_rule_sets.rule_set_id%type := 0;
411: --
412: --
413: l_created_by pqh_rule_sets.created_by%TYPE;
414: l_last_updated_by pqh_rule_sets.last_updated_by%TYPE;
415: l_creation_date pqh_rule_sets.creation_date%TYPE;
416: l_last_update_date pqh_rule_sets.last_update_date%TYPE;
417: l_last_update_login pqh_rule_sets.last_update_login%TYPE;
418: --

Line 415: l_creation_date pqh_rule_sets.creation_date%TYPE;

411: --
412: --
413: l_created_by pqh_rule_sets.created_by%TYPE;
414: l_last_updated_by pqh_rule_sets.last_updated_by%TYPE;
415: l_creation_date pqh_rule_sets.creation_date%TYPE;
416: l_last_update_date pqh_rule_sets.last_update_date%TYPE;
417: l_last_update_login pqh_rule_sets.last_update_login%TYPE;
418: --
419: --

Line 416: l_last_update_date pqh_rule_sets.last_update_date%TYPE;

412: --
413: l_created_by pqh_rule_sets.created_by%TYPE;
414: l_last_updated_by pqh_rule_sets.last_updated_by%TYPE;
415: l_creation_date pqh_rule_sets.creation_date%TYPE;
416: l_last_update_date pqh_rule_sets.last_update_date%TYPE;
417: l_last_update_login pqh_rule_sets.last_update_login%TYPE;
418: --
419: --
420: Cursor c1 is select rule_set_id

Line 417: l_last_update_login pqh_rule_sets.last_update_login%TYPE;

413: l_created_by pqh_rule_sets.created_by%TYPE;
414: l_last_updated_by pqh_rule_sets.last_updated_by%TYPE;
415: l_creation_date pqh_rule_sets.creation_date%TYPE;
416: l_last_update_date pqh_rule_sets.last_update_date%TYPE;
417: l_last_update_login pqh_rule_sets.last_update_login%TYPE;
418: --
419: --
420: Cursor c1 is select rule_set_id
421: from pqh_rule_sets

Line 421: from pqh_rule_sets

417: l_last_update_login pqh_rule_sets.last_update_login%TYPE;
418: --
419: --
420: Cursor c1 is select rule_set_id
421: from pqh_rule_sets
422: where short_name = p_short_name ;
423: --
424: --
425: BEGIN

Line 452: update pqh_rule_sets_tl

448: l_last_update_login := 0;
449:
450: --
451: --
452: update pqh_rule_sets_tl
453: set rule_set_name = p_rule_set_name ,
454: description = p_description,
455: last_updated_by = l_last_updated_by,
456: last_update_date = l_last_update_date,