APPS.PER_CIT_SHD dependencies on PER_CAGR_ENTITLEMENT_ITEMS

Line 52: from per_cagr_entitlement_items_tl

48: cagr_entitlement_item_id
49: ,item_name
50: ,language
51: ,source_lang
52: from per_cagr_entitlement_items_tl
53: where cagr_entitlement_item_id = p_cagr_entitlement_item_id
54: and language = p_language;
55: --
56: l_fct_ret boolean;

Line 118: from per_cagr_entitlement_items_tl

114: cagr_entitlement_item_id
115: ,item_name
116: ,language
117: ,source_lang
118: from per_cagr_entitlement_items_tl
119: where cagr_entitlement_item_id = p_cagr_entitlement_item_id
120: and language = p_language
121: for update nowait;
122: --

Line 164: fnd_message.set_token('TABLE_NAME', 'per_cagr_entitlement_items_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', 'per_cagr_entitlement_items_tl');
165: fnd_message.raise_error;
166: End lck;
167: --
168: -- ----------------------------------------------------------------------------

Line 181: delete from PER_CAGR_ENTITLEMENT_ITEMS_TL T

177: -- ----------------------------------------------------------------------------
178: procedure ADD_LANGUAGE
179: is
180: begin
181: delete from PER_CAGR_ENTITLEMENT_ITEMS_TL T
182: where not exists
183: (select NULL
184: from PER_CAGR_ENTITLEMENT_ITEMS B
185: where B.CAGR_ENTITLEMENT_ITEM_ID = T.CAGR_ENTITLEMENT_ITEM_ID

Line 184: from PER_CAGR_ENTITLEMENT_ITEMS B

180: begin
181: delete from PER_CAGR_ENTITLEMENT_ITEMS_TL T
182: where not exists
183: (select NULL
184: from PER_CAGR_ENTITLEMENT_ITEMS B
185: where B.CAGR_ENTITLEMENT_ITEM_ID = T.CAGR_ENTITLEMENT_ITEM_ID
186: );
187:
188: update PER_CAGR_ENTITLEMENT_ITEMS_TL T set (

Line 188: update PER_CAGR_ENTITLEMENT_ITEMS_TL T set (

184: from PER_CAGR_ENTITLEMENT_ITEMS B
185: where B.CAGR_ENTITLEMENT_ITEM_ID = T.CAGR_ENTITLEMENT_ITEM_ID
186: );
187:
188: update PER_CAGR_ENTITLEMENT_ITEMS_TL T set (
189: ITEM_NAME
190: ) = (select
191: B.ITEM_NAME
192: from PER_CAGR_ENTITLEMENT_ITEMS_TL B

Line 192: from PER_CAGR_ENTITLEMENT_ITEMS_TL B

188: update PER_CAGR_ENTITLEMENT_ITEMS_TL T set (
189: ITEM_NAME
190: ) = (select
191: B.ITEM_NAME
192: from PER_CAGR_ENTITLEMENT_ITEMS_TL B
193: where B.CAGR_ENTITLEMENT_ITEM_ID = T.CAGR_ENTITLEMENT_ITEM_ID
194: and B.LANGUAGE = T.SOURCE_LANG)
195: where (
196: T.CAGR_ENTITLEMENT_ITEM_ID,

Line 201: from PER_CAGR_ENTITLEMENT_ITEMS_TL SUBB, PER_CAGR_ENTITLEMENT_ITEMS_TL SUBT

197: T.LANGUAGE
198: ) in (select
199: SUBT.CAGR_ENTITLEMENT_ITEM_ID,
200: SUBT.LANGUAGE
201: from PER_CAGR_ENTITLEMENT_ITEMS_TL SUBB, PER_CAGR_ENTITLEMENT_ITEMS_TL SUBT
202: where SUBB.CAGR_ENTITLEMENT_ITEM_ID = SUBT.CAGR_ENTITLEMENT_ITEM_ID
203: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
204: and (SUBB.ITEM_NAME <> SUBT.ITEM_NAME
205: ));

Line 207: insert into PER_CAGR_ENTITLEMENT_ITEMS_TL (

203: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
204: and (SUBB.ITEM_NAME <> SUBT.ITEM_NAME
205: ));
206:
207: insert into PER_CAGR_ENTITLEMENT_ITEMS_TL (
208: CREATED_BY,
209: CREATION_DATE,
210: LAST_UPDATE_LOGIN,
211: LAST_UPDATE_DATE,

Line 227: from PER_CAGR_ENTITLEMENT_ITEMS_TL B, FND_LANGUAGES L

223: B.CAGR_ENTITLEMENT_ITEM_ID,
224: B.ITEM_NAME,
225: L.LANGUAGE_CODE,
226: B.SOURCE_LANG
227: from PER_CAGR_ENTITLEMENT_ITEMS_TL B, FND_LANGUAGES L
228: where L.INSTALLED_FLAG in ('I', 'B')
229: and B.LANGUAGE = userenv('LANG')
230: and not exists
231: (select NULL

Line 232: from PER_CAGR_ENTITLEMENT_ITEMS_TL T

228: where L.INSTALLED_FLAG in ('I', 'B')
229: and B.LANGUAGE = userenv('LANG')
230: and not exists
231: (select NULL
232: from PER_CAGR_ENTITLEMENT_ITEMS_TL T
233: where T.CAGR_ENTITLEMENT_ITEM_ID = B.CAGR_ENTITLEMENT_ITEM_ID
234: and T.LANGUAGE = L.LANGUAGE_CODE);
235:
236: end ADD_LANGUAGE;