APPS.CS_TRANSACTION_TYPES_PKG dependencies on CS_TRANSACTION_TYPES_TL

Line 148: insert into CS_TRANSACTION_TYPES_TL (

144: X_CALCULATE_PRICE_FLAG, -- shachoud 12.2 Charges Logistics
145: X_UPDATE_TASK_ACTUALS_FLAG --added by nic for sun 12.1.3 ER
146: );
147:
148: insert into CS_TRANSACTION_TYPES_TL (
149: LAST_UPDATE_LOGIN,
150: DESCRIPTION,
151: LAST_UPDATE_DATE,
152: LAST_UPDATED_BY,

Line 174: from CS_TRANSACTION_TYPES_TL T

170: from FND_LANGUAGES L
171: where L.INSTALLED_FLAG in ('I', 'B')
172: and not exists
173: (select NULL
174: from CS_TRANSACTION_TYPES_TL T
175: where T.TRANSACTION_TYPE_ID = X_TRANSACTION_TYPE_ID
176: and T.LANGUAGE = L.LANGUAGE_CODE);
177:
178: open c;

Line 280: from CS_TRANSACTION_TYPES_TL

276: cursor c1 is select
277: NAME,
278: DESCRIPTION,
279: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
280: from CS_TRANSACTION_TYPES_TL
281: where TRANSACTION_TYPE_ID = X_TRANSACTION_TYPE_ID
282: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
283: for update of TRANSACTION_TYPE_ID nowait;
284: begin

Line 481: update CS_TRANSACTION_TYPES_TL set

477: if (sql%notfound) then
478: raise no_data_found;
479: end if;
480:
481: update CS_TRANSACTION_TYPES_TL set
482: NAME = X_NAME,
483: DESCRIPTION = X_DESCRIPTION,
484: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
485: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 500: delete from CS_TRANSACTION_TYPES_TL

496: procedure DELETE_ROW (
497: X_TRANSACTION_TYPE_ID in NUMBER
498: ) is
499: begin
500: delete from CS_TRANSACTION_TYPES_TL
501: where TRANSACTION_TYPE_ID = X_TRANSACTION_TYPE_ID;
502:
503: if (sql%notfound) then
504: raise no_data_found;

Line 518: delete from CS_TRANSACTION_TYPES_TL T

514:
515: procedure ADD_LANGUAGE
516: is
517: begin
518: delete from CS_TRANSACTION_TYPES_TL T
519: where not exists
520: (select NULL
521: from CS_TRANSACTION_TYPES_B B
522: where B.TRANSACTION_TYPE_ID = T.TRANSACTION_TYPE_ID

Line 525: update CS_TRANSACTION_TYPES_TL T set (

521: from CS_TRANSACTION_TYPES_B B
522: where B.TRANSACTION_TYPE_ID = T.TRANSACTION_TYPE_ID
523: );
524:
525: update CS_TRANSACTION_TYPES_TL T set (
526: NAME,
527: DESCRIPTION
528: ) = (select
529: B.NAME,

Line 531: from CS_TRANSACTION_TYPES_TL B

527: DESCRIPTION
528: ) = (select
529: B.NAME,
530: B.DESCRIPTION
531: from CS_TRANSACTION_TYPES_TL B
532: where B.TRANSACTION_TYPE_ID = T.TRANSACTION_TYPE_ID
533: and B.LANGUAGE = T.SOURCE_LANG)
534: where (
535: T.TRANSACTION_TYPE_ID,

Line 540: from CS_TRANSACTION_TYPES_TL SUBB, CS_TRANSACTION_TYPES_TL SUBT

536: T.LANGUAGE
537: ) in (select
538: SUBT.TRANSACTION_TYPE_ID,
539: SUBT.LANGUAGE
540: from CS_TRANSACTION_TYPES_TL SUBB, CS_TRANSACTION_TYPES_TL SUBT
541: where SUBB.TRANSACTION_TYPE_ID = SUBT.TRANSACTION_TYPE_ID
542: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
543: and (SUBB.NAME <> SUBT.NAME
544: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 549: insert into CS_TRANSACTION_TYPES_TL (

545: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
546: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
547: ));
548:
549: insert into CS_TRANSACTION_TYPES_TL (
550: LAST_UPDATE_LOGIN,
551: DESCRIPTION,
552: LAST_UPDATE_DATE,
553: LAST_UPDATED_BY,

Line 571: from CS_TRANSACTION_TYPES_TL B, FND_LANGUAGES L

567: B.TRANSACTION_TYPE_ID,
568: B.NAME,
569: L.LANGUAGE_CODE,
570: B.SOURCE_LANG
571: from CS_TRANSACTION_TYPES_TL B, FND_LANGUAGES L
572: where L.INSTALLED_FLAG in ('I', 'B')
573: and B.LANGUAGE = userenv('LANG')
574: and not exists
575: (select NULL

Line 576: from CS_TRANSACTION_TYPES_TL T

572: where L.INSTALLED_FLAG in ('I', 'B')
573: and B.LANGUAGE = userenv('LANG')
574: and not exists
575: (select NULL
576: from CS_TRANSACTION_TYPES_TL T
577: where T.TRANSACTION_TYPE_ID = B.TRANSACTION_TYPE_ID
578: and T.LANGUAGE = L.LANGUAGE_CODE);
579: end ADD_LANGUAGE;
580:

Line 587: update CS_TRANSACTION_TYPES_TL set

583: X_NAME in VARCHAR2,
584: X_OWNER in VARCHAR2,
585: X_DESCRIPTION in VARCHAR2 ) is
586: begin
587: update CS_TRANSACTION_TYPES_TL set
588: name = X_NAME,
589: DESCRIPTION=X_DESCRIPTION,
590: last_update_date = sysdate,
591: last_updated_by = decode(X_OWNER, 'SEED', 1, 0),