DBA Data[Home] [Help]

APPS.PQH_RTL_INS dependencies on PQH_RULE_SETS_TL

Line 60: p_entity_name=>'PQH_RULE_SETS_TL',

56: -- Added the following code as a part of Zero Downtime Patching Project.
57: -- Code Starts Here.
58: --
59: per_ric_pkg.Chk_integrity(
60: p_entity_name=>'PQH_RULE_SETS_TL',
61: p_ref_entity=>'PQH_RULE_SETS',
62: p_ref_column_name=>'RULE_SET_ID',
63: p_ref_col_value_number=>p_rec.rule_set_id,
64: p_ref_col_value_varchar=>NULL,

Line 71: -- Insert the row into: pqh_rule_sets_tl

67: --
68: -- Code Ends Here
69: --
70: --
71: -- Insert the row into: pqh_rule_sets_tl
72: --
73: insert into pqh_rule_sets_tl
74: ( rule_set_id,
75: rule_set_name,

Line 73: insert into pqh_rule_sets_tl

69: --
70: --
71: -- Insert the row into: pqh_rule_sets_tl
72: --
73: insert into pqh_rule_sets_tl
74: ( rule_set_id,
75: rule_set_name,
76: description,
77: language,

Line 219: (p_module_name => 'pqh_rule_sets_tl'

215: --
216: when hr_api.cannot_find_prog_unit then
217: --
218: hr_api.cannot_find_prog_unit_error
219: (p_module_name => 'pqh_rule_sets_tl'
220: ,p_hook_type => 'AI');
221: --
222: end;
223: --

Line 319: from pqh_rule_sets_tl rtl

315: select l.language_code
316: from fnd_languages l
317: where l.installed_flag in ('I','B')
318: and not exists (select null
319: from pqh_rule_sets_tl rtl
320: where rtl.rule_set_id = p_rule_set_id
321: and rtl.language = l.language_code );
322: --
323: l_proc varchar2(72) := g_package||'ins_tl';