APPS.PQH_RTL_SHD dependencies on PQH_RULE_SETS_TL

Line 49: from pqh_rule_sets_tl

45: rule_set_name,
46: description,
47: language,
48: source_lang
49: from pqh_rule_sets_tl
50: where rule_set_id = p_rule_set_id
51: and language = p_language;
52: --
53: l_proc varchar2(72) := g_package||'api_updating';

Line 121: from pqh_rule_sets_tl

117: rule_set_name,
118: description,
119: language,
120: source_lang
121: from pqh_rule_sets_tl
122: where rule_set_id = p_rule_set_id
123: and language = p_language
124: for update nowait;
125: --

Line 162: hr_utility.set_message_token('TABLE_NAME', 'pqh_rule_sets_tl');

158: -- The object is locked therefore we need to supply a meaningful
159: -- error message.
160: --
161: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
162: hr_utility.set_message_token('TABLE_NAME', 'pqh_rule_sets_tl');
163: hr_utility.raise_error;
164: End lck;
165: --
166: -- ------------------------------------------------------------------------

Line 172: -- Maintains the PQH_RULE_SETS_TL table. Ensures there is translation for every

168: -- ------------------------------------------------------------------------
169: -- {Start Of Comments}
170: --
171: -- Description:
172: -- Maintains the PQH_RULE_SETS_TL table. Ensures there is translation for every
173: -- installed language, removes any orphaned translation rows and
174: -- corrects any translations which have got out of synchronisation.
175: --
176: -- Prerequisites:

Line 197: delete from PQH_RULE_SETS_TL T

193: -- ------------------------------------------------------------------------
194: procedure ADD_LANGUAGE
195: is
196: begin
197: delete from PQH_RULE_SETS_TL T
198: where not exists
199: (select NULL
200: from PQH_RULE_SETS B
201: where B.RULE_SET_ID = T.RULE_SET_ID

Line 204: update PQH_RULE_SETS_TL T set (

200: from PQH_RULE_SETS B
201: where B.RULE_SET_ID = T.RULE_SET_ID
202: );
203:
204: update PQH_RULE_SETS_TL T set (
205: RULE_SET_NAME
206: ) = (select
207: B.RULE_SET_NAME
208: from PQH_RULE_SETS_TL B

Line 208: from PQH_RULE_SETS_TL B

204: update PQH_RULE_SETS_TL T set (
205: RULE_SET_NAME
206: ) = (select
207: B.RULE_SET_NAME
208: from PQH_RULE_SETS_TL B
209: where B.RULE_SET_ID = T.RULE_SET_ID
210: and B.LANGUAGE = T.SOURCE_LANG)
211: where (
212: T.RULE_SET_ID,

Line 217: from PQH_RULE_SETS_TL SUBB, PQH_RULE_SETS_TL SUBT

213: T.LANGUAGE
214: ) in (select
215: SUBT.RULE_SET_ID,
216: SUBT.LANGUAGE
217: from PQH_RULE_SETS_TL SUBB, PQH_RULE_SETS_TL SUBT
218: where SUBB.RULE_SET_ID = SUBT.RULE_SET_ID
219: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
220: and (SUBB.RULE_SET_NAME <> SUBT.RULE_SET_NAME
221: or (SUBB.RULE_SET_NAME is null and SUBT.RULE_SET_NAME is not null)

Line 225: insert into PQH_RULE_SETS_TL (

221: or (SUBB.RULE_SET_NAME is null and SUBT.RULE_SET_NAME is not null)
222: or (SUBB.RULE_SET_NAME is not null and SUBT.RULE_SET_NAME is null)
223: ));
224:
225: insert into PQH_RULE_SETS_TL (
226: RULE_SET_ID,
227: RULE_SET_NAME,
228: CREATION_DATE,
229: CREATED_BY,

Line 245: from PQH_RULE_SETS_TL B, FND_LANGUAGES L

241: B.LAST_UPDATED_BY,
242: B.LAST_UPDATE_DATE,
243: L.LANGUAGE_CODE,
244: B.SOURCE_LANG
245: from PQH_RULE_SETS_TL B, FND_LANGUAGES L
246: where L.INSTALLED_FLAG in ('I', 'B')
247: and B.LANGUAGE = userenv('LANG')
248: and not exists
249: (select NULL

Line 250: from PQH_RULE_SETS_TL T

246: where L.INSTALLED_FLAG in ('I', 'B')
247: and B.LANGUAGE = userenv('LANG')
248: and not exists
249: (select NULL
250: from PQH_RULE_SETS_TL T
251: where T.RULE_SET_ID = B.RULE_SET_ID
252: and T.LANGUAGE = L.LANGUAGE_CODE);
253: end ADD_LANGUAGE;
254: --