APPS.CS_TRANSACTION_TYPES_PKG dependencies on CS_TRANSACTION_TYPES_TL

Line 139: insert into CS_TRANSACTION_TYPES_TL (

135: X_OBJECT_VERSION_NUMBER,
136: X_INTERFACE_TO_OE_FLAG
137: );
138:
139: insert into CS_TRANSACTION_TYPES_TL (
140: LAST_UPDATE_LOGIN,
141: DESCRIPTION,
142: LAST_UPDATE_DATE,
143: LAST_UPDATED_BY,

Line 165: from CS_TRANSACTION_TYPES_TL T

161: from FND_LANGUAGES L
162: where L.INSTALLED_FLAG in ('I', 'B')
163: and not exists
164: (select NULL
165: from CS_TRANSACTION_TYPES_TL T
166: where T.TRANSACTION_TYPE_ID = X_TRANSACTION_TYPE_ID
167: and T.LANGUAGE = L.LANGUAGE_CODE);
168:
169: open c;

Line 265: from CS_TRANSACTION_TYPES_TL

261: cursor c1 is select
262: NAME,
263: DESCRIPTION,
264: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
265: from CS_TRANSACTION_TYPES_TL
266: where TRANSACTION_TYPE_ID = X_TRANSACTION_TYPE_ID
267: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
268: for update of TRANSACTION_TYPE_ID nowait;
269: begin

Line 457: update CS_TRANSACTION_TYPES_TL set

453: if (sql%notfound) then
454: raise no_data_found;
455: end if;
456:
457: update CS_TRANSACTION_TYPES_TL set
458: NAME = X_NAME,
459: DESCRIPTION = X_DESCRIPTION,
460: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
461: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 476: delete from CS_TRANSACTION_TYPES_TL

472: procedure DELETE_ROW (
473: X_TRANSACTION_TYPE_ID in NUMBER
474: ) is
475: begin
476: delete from CS_TRANSACTION_TYPES_TL
477: where TRANSACTION_TYPE_ID = X_TRANSACTION_TYPE_ID;
478:
479: if (sql%notfound) then
480: raise no_data_found;

Line 494: delete from CS_TRANSACTION_TYPES_TL T

490:
491: procedure ADD_LANGUAGE
492: is
493: begin
494: delete from CS_TRANSACTION_TYPES_TL T
495: where not exists
496: (select NULL
497: from CS_TRANSACTION_TYPES_B B
498: where B.TRANSACTION_TYPE_ID = T.TRANSACTION_TYPE_ID

Line 501: update CS_TRANSACTION_TYPES_TL T set (

497: from CS_TRANSACTION_TYPES_B B
498: where B.TRANSACTION_TYPE_ID = T.TRANSACTION_TYPE_ID
499: );
500:
501: update CS_TRANSACTION_TYPES_TL T set (
502: NAME,
503: DESCRIPTION
504: ) = (select
505: B.NAME,

Line 507: from CS_TRANSACTION_TYPES_TL B

503: DESCRIPTION
504: ) = (select
505: B.NAME,
506: B.DESCRIPTION
507: from CS_TRANSACTION_TYPES_TL B
508: where B.TRANSACTION_TYPE_ID = T.TRANSACTION_TYPE_ID
509: and B.LANGUAGE = T.SOURCE_LANG)
510: where (
511: T.TRANSACTION_TYPE_ID,

Line 516: from CS_TRANSACTION_TYPES_TL SUBB, CS_TRANSACTION_TYPES_TL SUBT

512: T.LANGUAGE
513: ) in (select
514: SUBT.TRANSACTION_TYPE_ID,
515: SUBT.LANGUAGE
516: from CS_TRANSACTION_TYPES_TL SUBB, CS_TRANSACTION_TYPES_TL SUBT
517: where SUBB.TRANSACTION_TYPE_ID = SUBT.TRANSACTION_TYPE_ID
518: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
519: and (SUBB.NAME <> SUBT.NAME
520: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 525: insert into CS_TRANSACTION_TYPES_TL (

521: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
522: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
523: ));
524:
525: insert into CS_TRANSACTION_TYPES_TL (
526: LAST_UPDATE_LOGIN,
527: DESCRIPTION,
528: LAST_UPDATE_DATE,
529: LAST_UPDATED_BY,

Line 547: from CS_TRANSACTION_TYPES_TL B, FND_LANGUAGES L

543: B.TRANSACTION_TYPE_ID,
544: B.NAME,
545: L.LANGUAGE_CODE,
546: B.SOURCE_LANG
547: from CS_TRANSACTION_TYPES_TL B, FND_LANGUAGES L
548: where L.INSTALLED_FLAG in ('I', 'B')
549: and B.LANGUAGE = userenv('LANG')
550: and not exists
551: (select NULL

Line 552: from CS_TRANSACTION_TYPES_TL T

548: where L.INSTALLED_FLAG in ('I', 'B')
549: and B.LANGUAGE = userenv('LANG')
550: and not exists
551: (select NULL
552: from CS_TRANSACTION_TYPES_TL T
553: where T.TRANSACTION_TYPE_ID = B.TRANSACTION_TYPE_ID
554: and T.LANGUAGE = L.LANGUAGE_CODE);
555: end ADD_LANGUAGE;
556:

Line 563: update CS_TRANSACTION_TYPES_TL set

559: X_NAME in VARCHAR2,
560: X_OWNER in VARCHAR2,
561: X_DESCRIPTION in VARCHAR2 ) is
562: begin
563: update CS_TRANSACTION_TYPES_TL set
564: name = X_NAME,
565: DESCRIPTION=X_DESCRIPTION,
566: last_update_date = sysdate,
567: last_updated_by = decode(X_OWNER, 'SEED', 1, 0),