APPS.PQH_CRL_SHD dependencies on PQH_CRITERIA_RATE_DEFN_TL

Line 52: from pqh_criteria_rate_defn_tl

48: criteria_rate_defn_id
49: ,name
50: ,language
51: ,source_lang
52: from pqh_criteria_rate_defn_tl
53: where criteria_rate_defn_id = p_criteria_rate_defn_id
54: and language = p_language;
55: --
56: l_fct_ret boolean;

Line 118: from pqh_criteria_rate_defn_tl

114: criteria_rate_defn_id
115: ,name
116: ,language
117: ,source_lang
118: from pqh_criteria_rate_defn_tl
119: where criteria_rate_defn_id = p_criteria_rate_defn_id
120: and language = p_language
121: for update nowait;
122: --

Line 164: fnd_message.set_token('TABLE_NAME', 'pqh_criteria_rate_defn_tl');

160: -- The object is locked therefore we need to supply a meaningful
161: -- error message.
162: --
163: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
164: fnd_message.set_token('TABLE_NAME', 'pqh_criteria_rate_defn_tl');
165: fnd_message.raise_error;
166: End lck;
167: --
168: -- ----------------------------------------------------------------------------

Line 177: delete from PQH_CRITERIA_RATE_DEFN_TL T

173: -- ----------------------------------------------------------------------------
174: PROCEDURE add_language IS
175: Begin
176: --
177: delete from PQH_CRITERIA_RATE_DEFN_TL T
178: where not exists
179: (select NULL
180: from PQH_CRITERIA_RATE_DEFN B
181: where B.CRITERIA_RATE_DEFN_ID = T.CRITERIA_RATE_DEFN_ID

Line 184: update PQH_CRITERIA_RATE_DEFN_TL T set (

180: from PQH_CRITERIA_RATE_DEFN B
181: where B.CRITERIA_RATE_DEFN_ID = T.CRITERIA_RATE_DEFN_ID
182: );
183:
184: update PQH_CRITERIA_RATE_DEFN_TL T set (
185: NAME
186: ) = (select
187: B.NAME
188: from PQH_CRITERIA_RATE_DEFN_TL B

Line 188: from PQH_CRITERIA_RATE_DEFN_TL B

184: update PQH_CRITERIA_RATE_DEFN_TL T set (
185: NAME
186: ) = (select
187: B.NAME
188: from PQH_CRITERIA_RATE_DEFN_TL B
189: where B.CRITERIA_RATE_DEFN_ID = T.CRITERIA_RATE_DEFN_ID
190: and B.LANGUAGE = T.SOURCE_LANG)
191: where (
192: T.CRITERIA_RATE_DEFN_ID,

Line 197: from PQH_CRITERIA_RATE_DEFN_TL SUBB, PQH_CRITERIA_RATE_DEFN_TL SUBT

193: T.LANGUAGE
194: ) in (select
195: SUBT.CRITERIA_RATE_DEFN_ID,
196: SUBT.LANGUAGE
197: from PQH_CRITERIA_RATE_DEFN_TL SUBB, PQH_CRITERIA_RATE_DEFN_TL SUBT
198: where SUBB.CRITERIA_RATE_DEFN_ID = SUBT.CRITERIA_RATE_DEFN_ID
199: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
200: and (SUBB.NAME <> SUBT.NAME
201: ));

Line 203: insert into PQH_CRITERIA_RATE_DEFN_TL (

199: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
200: and (SUBB.NAME <> SUBT.NAME
201: ));
202:
203: insert into PQH_CRITERIA_RATE_DEFN_TL (
204: CRITERIA_RATE_DEFN_ID,
205: NAME,
206: LAST_UPDATE_DATE,
207: CREATION_DATE,

Line 223: from PQH_CRITERIA_RATE_DEFN_TL B, FND_LANGUAGES L

219: B.LAST_UPDATE_LOGIN,
220: B.LAST_UPDATED_BY,
221: L.LANGUAGE_CODE,
222: B.SOURCE_LANG
223: from PQH_CRITERIA_RATE_DEFN_TL B, FND_LANGUAGES L
224: where L.INSTALLED_FLAG in ('I', 'B')
225: and B.LANGUAGE = userenv('LANG')
226: and not exists
227: (select NULL

Line 228: from PQH_CRITERIA_RATE_DEFN_TL T

224: where L.INSTALLED_FLAG in ('I', 'B')
225: and B.LANGUAGE = userenv('LANG')
226: and not exists
227: (select NULL
228: from PQH_CRITERIA_RATE_DEFN_TL T
229: where T.CRITERIA_RATE_DEFN_ID = B.CRITERIA_RATE_DEFN_ID
230: and T.LANGUAGE = L.LANGUAGE_CODE);
231: --
232: --