86: --
87: -- {End Of Comments}
88: -- ----------------------------------------------------------------------------
89: Procedure chk_name
90: (p_name in irc_posting_contents_tl.name%TYPE
91: ,p_language in irc_posting_contents_tl.language%TYPE
92: ) IS
93: --
94: l_proc varchar2(72) := g_package || 'chk_name';
87: -- {End Of Comments}
88: -- ----------------------------------------------------------------------------
89: Procedure chk_name
90: (p_name in irc_posting_contents_tl.name%TYPE
91: ,p_language in irc_posting_contents_tl.language%TYPE
92: ) IS
93: --
94: l_proc varchar2(72) := g_package || 'chk_name';
95: l_name varchar2(1);
94: l_proc varchar2(72) := g_package || 'chk_name';
95: l_name varchar2(1);
96: cursor csr_name is
97: select null
98: from irc_posting_contents_tl
99: where name = p_name
100: and language = p_language;
101: --
102: Begin
125: hr_utility.set_location(' Leaving:'||l_proc,35);
126: exception
127: when app_exception.application_exception then
128: if hr_multi_message.exception_add
129: (p_associated_column1 => 'IRC_POSTING_CONTENTS_TL.POSTING_CONTENT_ID'
130: )then
131: hr_utility.set_location(' Leaving:'||l_proc, 40);
132: raise;
133: end if;
137: -- ----------------------------------------------------------------------------
138: -- |---------------------------< chk_source_lang >----------------------------|
139: -- ----------------------------------------------------------------------------
140: Procedure chk_source_lang
141: (p_language in irc_posting_contents_tl.language%TYPE
142: ,p_source_lang in irc_posting_contents_tl.source_language%TYPE
143: ) is
144: --
145: cursor csr_language is
138: -- |---------------------------< chk_source_lang >----------------------------|
139: -- ----------------------------------------------------------------------------
140: Procedure chk_source_lang
141: (p_language in irc_posting_contents_tl.language%TYPE
142: ,p_source_lang in irc_posting_contents_tl.source_language%TYPE
143: ) is
144: --
145: cursor csr_language is
146: select l.installed_flag