APPS.OE_TRANSACTION_TYPES_PKG dependencies on OE_TRANSACTION_TYPES_TL

Line 225: insert into OE_TRANSACTION_TYPES_TL (

221: X_quote_num_as_ord_num_flag,
222: X_CONTRACT_TEMPLATE_ID
223: );
224:
225: insert into OE_TRANSACTION_TYPES_TL (
226: TRANSACTION_TYPE_ID,
227: NAME,
228: DESCRIPTION,
229: CREATION_DATE,

Line 257: from OE_TRANSACTION_TYPES_TL T

253: from FND_LANGUAGES L
254: where L.INSTALLED_FLAG in ('I', 'B')
255: and not exists
256: (select NULL
257: from OE_TRANSACTION_TYPES_TL T
258: where T.TRANSACTION_TYPE_ID = X_TRANSACTION_TYPE_ID
259: and T.LANGUAGE = L.LANGUAGE_CODE);
260:
261: open c;

Line 408: from OE_TRANSACTION_TYPES_TL

404: cursor c1 is select
405: NAME,
406: DESCRIPTION,
407: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
408: from OE_TRANSACTION_TYPES_TL
409: where TRANSACTION_TYPE_ID = X_TRANSACTION_TYPE_ID
410: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
411: for update of TRANSACTION_TYPE_ID nowait;
412: begin

Line 704: update OE_TRANSACTION_TYPES_TL set

700: if (sql%notfound) then
701: raise no_data_found;
702: end if;
703:
704: update OE_TRANSACTION_TYPES_TL set
705: NAME = X_NAME,
706: DESCRIPTION = X_DESCRIPTION,
707: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
708: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 723: delete from OE_TRANSACTION_TYPES_TL

719: procedure DELETE_ROW (
720: X_TRANSACTION_TYPE_ID in NUMBER
721: ) is
722: begin
723: delete from OE_TRANSACTION_TYPES_TL
724: where TRANSACTION_TYPE_ID = X_TRANSACTION_TYPE_ID;
725:
726: if (sql%notfound) then
727: raise no_data_found;

Line 741: delete from OE_TRANSACTION_TYPES_TL T

737:
738: procedure ADD_LANGUAGE
739: is
740: begin
741: delete from OE_TRANSACTION_TYPES_TL T
742: where not exists
743: (select NULL
744: from OE_TRANSACTION_TYPES_ALL B
745: where B.TRANSACTION_TYPE_ID = T.TRANSACTION_TYPE_ID

Line 748: update OE_TRANSACTION_TYPES_TL T set (

744: from OE_TRANSACTION_TYPES_ALL B
745: where B.TRANSACTION_TYPE_ID = T.TRANSACTION_TYPE_ID
746: );
747:
748: update OE_TRANSACTION_TYPES_TL T set (
749: NAME,
750: DESCRIPTION
751: ) = (select
752: B.NAME,

Line 754: from OE_TRANSACTION_TYPES_TL B

750: DESCRIPTION
751: ) = (select
752: B.NAME,
753: B.DESCRIPTION
754: from OE_TRANSACTION_TYPES_TL B
755: where B.TRANSACTION_TYPE_ID = T.TRANSACTION_TYPE_ID
756: and B.LANGUAGE = T.SOURCE_LANG)
757: where (
758: T.TRANSACTION_TYPE_ID,

Line 763: from OE_TRANSACTION_TYPES_TL SUBB, OE_TRANSACTION_TYPES_TL SUBT

759: T.LANGUAGE
760: ) in (select
761: SUBT.TRANSACTION_TYPE_ID,
762: SUBT.LANGUAGE
763: from OE_TRANSACTION_TYPES_TL SUBB, OE_TRANSACTION_TYPES_TL SUBT
764: where SUBB.TRANSACTION_TYPE_ID = SUBT.TRANSACTION_TYPE_ID
765: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
766: and (SUBB.NAME <> SUBT.NAME
767: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 772: insert into OE_TRANSACTION_TYPES_TL (

768: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
769: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
770: ));
771:
772: insert into OE_TRANSACTION_TYPES_TL (
773: TRANSACTION_TYPE_ID,
774: NAME,
775: DESCRIPTION,
776: CREATION_DATE,

Line 800: from OE_TRANSACTION_TYPES_TL B, FND_LANGUAGES L

796: B.PROGRAM_ID,
797: B.REQUEST_ID,
798: L.LANGUAGE_CODE,
799: B.SOURCE_LANG
800: from OE_TRANSACTION_TYPES_TL B, FND_LANGUAGES L
801: where L.INSTALLED_FLAG in ('I', 'B')
802: and B.LANGUAGE = userenv('LANG')
803: and not exists
804: (select NULL

Line 805: from OE_TRANSACTION_TYPES_TL T

801: where L.INSTALLED_FLAG in ('I', 'B')
802: and B.LANGUAGE = userenv('LANG')
803: and not exists
804: (select NULL
805: from OE_TRANSACTION_TYPES_TL T
806: where T.TRANSACTION_TYPE_ID = B.TRANSACTION_TYPE_ID
807: and T.LANGUAGE = L.LANGUAGE_CODE);
808: end ADD_LANGUAGE;
809:

Line 895: update oe_transaction_types_tl

891: p_name varchar2(80) := Name;
892: p_desc varchar2(2000) := Description;
893:
894: begin
895: update oe_transaction_types_tl
896: set name = nvl(p_name,name),
897: description = nvl(p_Desc,description),
898: source_lang = userenv('LANG')
899: where Transaction_type_id = p_Transaction_type_id and

Line 985: FROM oe_transaction_types_tl

981: l_count number:=0;
982: l_name varchar2(30);
983: BEGIN
984: SELECT name INTO l_name
985: FROM oe_transaction_types_tl
986: WHERE LANGUAGE = p_language
987: AND transaction_type_id = p_transaction_id;
988:
989: IF l_name <> p_name THEN

Line 1006: from oe_transaction_types_tl

1002: FND_MESSAGE.SET_NAME('ONT','OE_OE_TYPE_IN_USE');
1003: app_exception.raise_exception;
1004: ELSE
1005: select count(transaction_type_id) into l_count
1006: from oe_transaction_types_tl
1007: where UPPER(name) = UPPER(p_name)
1008: and LANGUAGE = p_language
1009: and transaction_type_id <> p_transaction_id;
1010: