APPS.OE_TRANSACTION_TYPES_PKG dependencies on OE_TRANSACTION_TYPES_TL

Line 230: insert into OE_TRANSACTION_TYPES_TL (

226: X_CREDIT_CARD_REV_REAUTH_CODE, --CC Reversal ER#16014135
227: X_use_ame_approval -- AME ER 16084377
228: );
229:
230: insert into OE_TRANSACTION_TYPES_TL (
231: TRANSACTION_TYPE_ID,
232: NAME,
233: DESCRIPTION,
234: CREATION_DATE,

Line 262: from OE_TRANSACTION_TYPES_TL T

258: from FND_LANGUAGES L
259: where L.INSTALLED_FLAG in ('I', 'B')
260: and not exists
261: (select NULL
262: from OE_TRANSACTION_TYPES_TL T
263: where T.TRANSACTION_TYPE_ID = X_TRANSACTION_TYPE_ID
264: and T.LANGUAGE = L.LANGUAGE_CODE);
265:
266: open c;

Line 417: from OE_TRANSACTION_TYPES_TL

413: cursor c1 is select
414: NAME,
415: DESCRIPTION,
416: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
417: from OE_TRANSACTION_TYPES_TL
418: where TRANSACTION_TYPE_ID = X_TRANSACTION_TYPE_ID
419: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
420: for update of TRANSACTION_TYPE_ID nowait;
421: begin

Line 721: update OE_TRANSACTION_TYPES_TL set

717: if (sql%notfound) then
718: raise no_data_found;
719: end if;
720:
721: update OE_TRANSACTION_TYPES_TL set
722: NAME = X_NAME,
723: DESCRIPTION = X_DESCRIPTION,
724: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
725: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 740: delete from OE_TRANSACTION_TYPES_TL

736: procedure DELETE_ROW (
737: X_TRANSACTION_TYPE_ID in NUMBER
738: ) is
739: begin
740: delete from OE_TRANSACTION_TYPES_TL
741: where TRANSACTION_TYPE_ID = X_TRANSACTION_TYPE_ID;
742:
743: if (sql%notfound) then
744: raise no_data_found;

Line 758: delete from OE_TRANSACTION_TYPES_TL T

754:
755: procedure ADD_LANGUAGE
756: is
757: begin
758: delete from OE_TRANSACTION_TYPES_TL T
759: where not exists
760: (select NULL
761: from OE_TRANSACTION_TYPES_ALL B
762: where B.TRANSACTION_TYPE_ID = T.TRANSACTION_TYPE_ID

Line 765: update OE_TRANSACTION_TYPES_TL T set (

761: from OE_TRANSACTION_TYPES_ALL B
762: where B.TRANSACTION_TYPE_ID = T.TRANSACTION_TYPE_ID
763: );
764:
765: update OE_TRANSACTION_TYPES_TL T set (
766: NAME,
767: DESCRIPTION
768: ) = (select
769: B.NAME,

Line 771: from OE_TRANSACTION_TYPES_TL B

767: DESCRIPTION
768: ) = (select
769: B.NAME,
770: B.DESCRIPTION
771: from OE_TRANSACTION_TYPES_TL B
772: where B.TRANSACTION_TYPE_ID = T.TRANSACTION_TYPE_ID
773: and B.LANGUAGE = T.SOURCE_LANG)
774: where (
775: T.TRANSACTION_TYPE_ID,

Line 780: from OE_TRANSACTION_TYPES_TL SUBB, OE_TRANSACTION_TYPES_TL SUBT

776: T.LANGUAGE
777: ) in (select
778: SUBT.TRANSACTION_TYPE_ID,
779: SUBT.LANGUAGE
780: from OE_TRANSACTION_TYPES_TL SUBB, OE_TRANSACTION_TYPES_TL SUBT
781: where SUBB.TRANSACTION_TYPE_ID = SUBT.TRANSACTION_TYPE_ID
782: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
783: and (SUBB.NAME <> SUBT.NAME
784: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 789: insert into OE_TRANSACTION_TYPES_TL (

785: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
786: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
787: ));
788:
789: insert into OE_TRANSACTION_TYPES_TL (
790: TRANSACTION_TYPE_ID,
791: NAME,
792: DESCRIPTION,
793: CREATION_DATE,

Line 817: from OE_TRANSACTION_TYPES_TL B, FND_LANGUAGES L

813: B.PROGRAM_ID,
814: B.REQUEST_ID,
815: L.LANGUAGE_CODE,
816: B.SOURCE_LANG
817: from OE_TRANSACTION_TYPES_TL B, FND_LANGUAGES L
818: where L.INSTALLED_FLAG in ('I', 'B')
819: and B.LANGUAGE = userenv('LANG')
820: and not exists
821: (select NULL

Line 822: from OE_TRANSACTION_TYPES_TL T

818: where L.INSTALLED_FLAG in ('I', 'B')
819: and B.LANGUAGE = userenv('LANG')
820: and not exists
821: (select NULL
822: from OE_TRANSACTION_TYPES_TL T
823: where T.TRANSACTION_TYPE_ID = B.TRANSACTION_TYPE_ID
824: and T.LANGUAGE = L.LANGUAGE_CODE);
825: end ADD_LANGUAGE;
826:

Line 913: update oe_transaction_types_tl

909: p_name varchar2(80) := Name;
910: p_desc varchar2(2000) := Description;
911:
912: begin
913: update oe_transaction_types_tl
914: set name = nvl(p_name,name),
915: description = nvl(p_Desc,description),
916: source_lang = userenv('LANG')
917: where Transaction_type_id = p_Transaction_type_id and

Line 1003: FROM oe_transaction_types_tl

999: l_count number:=0;
1000: l_name varchar2(30);
1001: BEGIN
1002: SELECT name INTO l_name
1003: FROM oe_transaction_types_tl
1004: WHERE LANGUAGE = p_language
1005: AND transaction_type_id = p_transaction_id;
1006:
1007: IF l_name <> p_name THEN

Line 1024: from oe_transaction_types_tl

1020: FND_MESSAGE.SET_NAME('ONT','OE_OE_TYPE_IN_USE');
1021: app_exception.raise_exception;
1022: ELSE
1023: select count(transaction_type_id) into l_count
1024: from oe_transaction_types_tl
1025: where UPPER(name) = UPPER(p_name)
1026: and LANGUAGE = p_language
1027: and transaction_type_id <> p_transaction_id;
1028: