APPS.CSD_REPAIR_TYPES_PKG dependencies on CSD_REPAIR_TYPES_TL

Line 162: insert into CSD_REPAIR_TYPES_TL (

158: X_OBJECT_VERSION_NUMBER,
159: X_START_FLOW_STATUS_ID
160: );
161:
162: insert into CSD_REPAIR_TYPES_TL (
163: REPAIR_TYPE_ID,
164: CREATED_BY,
165: CREATION_DATE,
166: LAST_UPDATED_BY,

Line 188: from CSD_REPAIR_TYPES_TL T

184: from FND_LANGUAGES L
185: where L.INSTALLED_FLAG in ('I', 'B')
186: and not exists
187: (select NULL
188: from CSD_REPAIR_TYPES_TL T
189: where T.REPAIR_TYPE_ID = X_REPAIR_TYPE_ID
190: and T.LANGUAGE = L.LANGUAGE_CODE);
191:
192: open c;

Line 343: update CSD_REPAIR_TYPES_TL set

339: if (sql%notfound) then
340: raise no_data_found;
341: end if;
342:
343: update CSD_REPAIR_TYPES_TL set
344: DESCRIPTION = X_DESCRIPTION,
345: NAME = X_NAME,
346: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
347: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 362: delete from CSD_REPAIR_TYPES_TL

358: procedure DELETE_ROW (
359: X_REPAIR_TYPE_ID in NUMBER
360: ) is
361: begin
362: delete from CSD_REPAIR_TYPES_TL
363: where REPAIR_TYPE_ID = X_REPAIR_TYPE_ID;
364:
365: if (sql%notfound) then
366: raise no_data_found;

Line 380: delete from CSD_REPAIR_TYPES_TL T

376:
377: procedure ADD_LANGUAGE
378: is
379: begin
380: delete from CSD_REPAIR_TYPES_TL T
381: where not exists
382: (select NULL
383: from CSD_REPAIR_TYPES_B B
384: where B.REPAIR_TYPE_ID = T.REPAIR_TYPE_ID

Line 387: update CSD_REPAIR_TYPES_TL T set (

383: from CSD_REPAIR_TYPES_B B
384: where B.REPAIR_TYPE_ID = T.REPAIR_TYPE_ID
385: );
386:
387: update CSD_REPAIR_TYPES_TL T set (
388: DESCRIPTION,
389: NAME
390: ) = (select
391: B.DESCRIPTION,

Line 393: from CSD_REPAIR_TYPES_TL B

389: NAME
390: ) = (select
391: B.DESCRIPTION,
392: B.NAME
393: from CSD_REPAIR_TYPES_TL B
394: where B.REPAIR_TYPE_ID = T.REPAIR_TYPE_ID
395: and B.LANGUAGE = T.SOURCE_LANG)
396: where (
397: T.REPAIR_TYPE_ID,

Line 402: from CSD_REPAIR_TYPES_TL SUBB, CSD_REPAIR_TYPES_TL SUBT

398: T.LANGUAGE
399: ) in (select
400: SUBT.REPAIR_TYPE_ID,
401: SUBT.LANGUAGE
402: from CSD_REPAIR_TYPES_TL SUBB, CSD_REPAIR_TYPES_TL SUBT
403: where SUBB.REPAIR_TYPE_ID = SUBT.REPAIR_TYPE_ID
404: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
405: and (SUBB.DESCRIPTION <> SUBT.DESCRIPTION
406: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)

Line 411: insert into CSD_REPAIR_TYPES_TL (

407: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
408: or SUBB.NAME <> SUBT.NAME
409: ));
410:
411: insert into CSD_REPAIR_TYPES_TL (
412: REPAIR_TYPE_ID,
413: CREATED_BY,
414: CREATION_DATE,
415: LAST_UPDATED_BY,

Line 433: from CSD_REPAIR_TYPES_TL B, FND_LANGUAGES L

429: B.NAME,
430: B.DESCRIPTION,
431: L.LANGUAGE_CODE,
432: B.SOURCE_LANG
433: from CSD_REPAIR_TYPES_TL B, FND_LANGUAGES L
434: where L.INSTALLED_FLAG in ('I', 'B')
435: and B.LANGUAGE = userenv('LANG')
436: and not exists
437: (select NULL

Line 438: from CSD_REPAIR_TYPES_TL T

434: where L.INSTALLED_FLAG in ('I', 'B')
435: and B.LANGUAGE = userenv('LANG')
436: and not exists
437: (select NULL
438: from CSD_REPAIR_TYPES_TL T
439: where T.REPAIR_TYPE_ID = B.REPAIR_TYPE_ID
440: and T.LANGUAGE = L.LANGUAGE_CODE);
441: end ADD_LANGUAGE;
442:

Line 459: UPDATE csd_repair_types_tl

455: if p_owner = 'SEED' then
456: l_user_id := 1;
457: end if;
458: --
459: UPDATE csd_repair_types_tl
460: SET description = p_description,
461: name = p_name,
462: last_update_date = SYSDATE,
463: last_updated_by = l_user_id,