APPS.CSD_REPAIR_TYPES_PKG dependencies on CSD_REPAIR_TYPES_TL

Line 165: insert into CSD_REPAIR_TYPES_TL (

161: X_START_FLOW_STATUS_ID,
162: X_RES_DT_CALC_POINT
163: );
164:
165: insert into CSD_REPAIR_TYPES_TL (
166: REPAIR_TYPE_ID,
167: CREATED_BY,
168: CREATION_DATE,
169: LAST_UPDATED_BY,

Line 191: from CSD_REPAIR_TYPES_TL T

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

Line 348: update CSD_REPAIR_TYPES_TL set

344: if (sql%notfound) then
345: raise no_data_found;
346: end if;
347:
348: update CSD_REPAIR_TYPES_TL set
349: DESCRIPTION = X_DESCRIPTION,
350: NAME = X_NAME,
351: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
352: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 367: delete from CSD_REPAIR_TYPES_TL

363: procedure DELETE_ROW (
364: X_REPAIR_TYPE_ID in NUMBER
365: ) is
366: begin
367: delete from CSD_REPAIR_TYPES_TL
368: where REPAIR_TYPE_ID = X_REPAIR_TYPE_ID;
369:
370: if (sql%notfound) then
371: raise no_data_found;

Line 385: delete from CSD_REPAIR_TYPES_TL T

381:
382: procedure ADD_LANGUAGE
383: is
384: begin
385: delete from CSD_REPAIR_TYPES_TL T
386: where not exists
387: (select NULL
388: from CSD_REPAIR_TYPES_B B
389: where B.REPAIR_TYPE_ID = T.REPAIR_TYPE_ID

Line 392: update CSD_REPAIR_TYPES_TL T set (

388: from CSD_REPAIR_TYPES_B B
389: where B.REPAIR_TYPE_ID = T.REPAIR_TYPE_ID
390: );
391:
392: update CSD_REPAIR_TYPES_TL T set (
393: DESCRIPTION,
394: NAME
395: ) = (select
396: B.DESCRIPTION,

Line 398: from CSD_REPAIR_TYPES_TL B

394: NAME
395: ) = (select
396: B.DESCRIPTION,
397: B.NAME
398: from CSD_REPAIR_TYPES_TL B
399: where B.REPAIR_TYPE_ID = T.REPAIR_TYPE_ID
400: and B.LANGUAGE = T.SOURCE_LANG)
401: where (
402: T.REPAIR_TYPE_ID,

Line 407: from CSD_REPAIR_TYPES_TL SUBB, CSD_REPAIR_TYPES_TL SUBT

403: T.LANGUAGE
404: ) in (select
405: SUBT.REPAIR_TYPE_ID,
406: SUBT.LANGUAGE
407: from CSD_REPAIR_TYPES_TL SUBB, CSD_REPAIR_TYPES_TL SUBT
408: where SUBB.REPAIR_TYPE_ID = SUBT.REPAIR_TYPE_ID
409: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
410: and (SUBB.DESCRIPTION <> SUBT.DESCRIPTION
411: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)

Line 416: insert into CSD_REPAIR_TYPES_TL (

412: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
413: or SUBB.NAME <> SUBT.NAME
414: ));
415:
416: insert into CSD_REPAIR_TYPES_TL (
417: REPAIR_TYPE_ID,
418: CREATED_BY,
419: CREATION_DATE,
420: LAST_UPDATED_BY,

Line 438: from CSD_REPAIR_TYPES_TL B, FND_LANGUAGES L

434: B.NAME,
435: B.DESCRIPTION,
436: L.LANGUAGE_CODE,
437: B.SOURCE_LANG
438: from CSD_REPAIR_TYPES_TL B, FND_LANGUAGES L
439: where L.INSTALLED_FLAG in ('I', 'B')
440: and B.LANGUAGE = userenv('LANG')
441: and not exists
442: (select NULL

Line 443: from CSD_REPAIR_TYPES_TL T

439: where L.INSTALLED_FLAG in ('I', 'B')
440: and B.LANGUAGE = userenv('LANG')
441: and not exists
442: (select NULL
443: from CSD_REPAIR_TYPES_TL T
444: where T.REPAIR_TYPE_ID = B.REPAIR_TYPE_ID
445: and T.LANGUAGE = L.LANGUAGE_CODE);
446: end ADD_LANGUAGE;
447:

Line 464: UPDATE csd_repair_types_tl

460: if p_owner = 'SEED' then
461: l_user_id := 1;
462: end if;
463: --
464: UPDATE csd_repair_types_tl
465: SET description = p_description,
466: name = p_name,
467: last_update_date = SYSDATE,
468: last_updated_by = l_user_id,