DBA Data[Home] [Help]

APPS.PER_QTT_BUS dependencies on PER_QUALIFICATION_TYPES_TL

Line 31: from per_qualification_types_tl qtt

27: l_dummy varchar2(1);
28: --
29: cursor c1 is
30: select 'x'
31: from per_qualification_types_tl qtt
32: where qtt.name = p_name
33: and qtt.language = p_language
34: and ( (p_qualification_type_id is null)
35: or

Line 144: ,p_qualification_type_id in per_qualification_types_tl.qualification_type_id%TYPE default null

140: -- |------------------------< validate_translation>--------------------------|
141: -- ----------------------------------------------------------------------------
142: Procedure validate_translation
143: (p_rec in per_qtt_shd.g_rec_type
144: ,p_qualification_type_id in per_qualification_types_tl.qualification_type_id%TYPE default null
145: ) IS
146: --
147: l_proc varchar2(72) := g_package||'validate_translation';
148: --

Line 171: ,p_qualification_type_id in per_qualification_types_tl.qualification_type_id%TYPE

167: -- |---------------------------< insert_validate >----------------------------|
168: -- ----------------------------------------------------------------------------
169: Procedure insert_validate
170: (p_rec in per_qtt_shd.g_rec_type
171: ,p_qualification_type_id in per_qualification_types_tl.qualification_type_id%TYPE
172: ) is
173: --
174: l_proc varchar2(72) := g_package||'insert_validate';
175: --