APPS.IEB_SVC_CAT_TEMPS_SEED_PKG dependencies on IEB_SVC_CAT_TEMPS_TL

Line 71: INSERT INTO ieb_svc_cat_temps_tl (

67: , DECODE(x_src_tbl_where_clause,FND_API.G_MISS_CHAR,NULL,x_src_tbl_where_clause)
68: , x_MEDIA_TYPE_ID
69: );
70:
71: INSERT INTO ieb_svc_cat_temps_tl (
72: wbsc_id
73: , created_by
74: , creation_date
75: , last_update_date

Line 99: FROM ieb_svc_cat_temps_tl t

95: from fnd_languages l
96: WHERE l.installed_flag IN ('I', 'B')
97: AND NOT EXISTS
98: (SELECT NULL
99: FROM ieb_svc_cat_temps_tl t
100: WHERE t.wbsc_id = x_wbsc_id
101: AND t.language = l.language_code);
102:
103: END insert_row;

Line 151: UPDATE ieb_svc_cat_temps_tl

147: IF (SQL%NOTFOUND) THEN
148: RAISE NO_DATA_FOUND;
149: END IF;
150:
151: UPDATE ieb_svc_cat_temps_tl
152: SET
153: last_update_date=DECODE(x_last_update_date,FND_API.G_MISS_DATE,TO_DATE(NULL),x_last_update_date)
154: , last_updated_by=DECODE(x_last_updated_by,FND_API.G_MISS_NUM,NULL,x_last_updated_by)
155: , last_update_login=DECODE(x_last_update_login,FND_API.G_MISS_NUM,NULL,x_last_update_login)

Line 276: UPDATE ieb_svc_cat_temps_tl

272: BEGIN
273: user_id := fnd_load_util.owner_id(p_OWNER);
274:
275:
276: UPDATE ieb_svc_cat_temps_tl
277: SET
278: last_update_date=sysdate
279: , last_updated_by=user_id
280: , last_update_login=0

Line 297: delete from IEB_SVC_CAT_TEMPS_TL T

293:
294: procedure ADD_LANGUAGE
295: is
296: begin
297: delete from IEB_SVC_CAT_TEMPS_TL T
298: where not exists
299: (select NULL
300: from IEB_SVC_CAT_TEMPS_B B
301: where B.WBSC_ID = T.WBSC_ID

Line 304: update IEB_SVC_CAT_TEMPS_TL T set (

300: from IEB_SVC_CAT_TEMPS_B B
301: where B.WBSC_ID = T.WBSC_ID
302: );
303:
304: update IEB_SVC_CAT_TEMPS_TL T set (
305: SERVICE_CATEGORY_NAME,
306: DESCRIPTION
307: ) = (select
308: B.SERVICE_CATEGORY_NAME,

Line 310: from IEB_SVC_CAT_TEMPS_TL B

306: DESCRIPTION
307: ) = (select
308: B.SERVICE_CATEGORY_NAME,
309: B.DESCRIPTION
310: from IEB_SVC_CAT_TEMPS_TL B
311: where B.WBSC_ID = T.WBSC_ID
312: and B.LANGUAGE = T.SOURCE_LANG)
313: where (
314: T.WBSC_ID,

Line 319: from IEB_SVC_CAT_TEMPS_TL SUBB, IEB_SVC_CAT_TEMPS_TL SUBT

315: T.LANGUAGE
316: ) in (select
317: SUBT.WBSC_ID,
318: SUBT.LANGUAGE
319: from IEB_SVC_CAT_TEMPS_TL SUBB, IEB_SVC_CAT_TEMPS_TL SUBT
320: where SUBB.WBSC_ID = SUBT.WBSC_ID
321: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
322: and (SUBB.SERVICE_CATEGORY_NAME <> SUBT.SERVICE_CATEGORY_NAME
323: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 328: insert into IEB_SVC_CAT_TEMPS_TL (

324: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
325: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
326: ));
327:
328: insert into IEB_SVC_CAT_TEMPS_TL (
329: DESCRIPTION,
330: CREATION_DATE,
331: LAST_UPDATED_BY,
332: LAST_UPDATE_DATE,

Line 350: from IEB_SVC_CAT_TEMPS_TL B, FND_LANGUAGES L

346: B.WBSC_ID,
347: B.CREATED_BY,
348: L.LANGUAGE_CODE,
349: B.SOURCE_LANG
350: from IEB_SVC_CAT_TEMPS_TL B, FND_LANGUAGES L
351: where L.INSTALLED_FLAG in ('I', 'B')
352: and B.LANGUAGE = userenv('LANG')
353: and not exists
354: (select NULL

Line 355: from IEB_SVC_CAT_TEMPS_TL T

351: where L.INSTALLED_FLAG in ('I', 'B')
352: and B.LANGUAGE = userenv('LANG')
353: and not exists
354: (select NULL
355: from IEB_SVC_CAT_TEMPS_TL T
356: where T.WBSC_ID = B.WBSC_ID
357: and T.LANGUAGE = L.LANGUAGE_CODE);
358:
359: end ADD_LANGUAGE;