APPS.OE_PAYMENT_TYPES_UTIL dependencies on OE_PAYMENT_TYPES_TL

Line 69: INSERT INTO oe_payment_types_tl

65: l_org_id := OE_GLOBALS.G_ORG_ID;
66:
67: end if;
68:
69: INSERT INTO oe_payment_types_tl
70: (payment_type_code
71: ,language
72: ,source_lang
73: ,name

Line 106: from oe_payment_types_tl t

102: FROM FND_LANGUAGES L
103: WHERE L.INSTALLED_FLAG IN ('I', 'B')
104: and not exists
105: ( select null
106: from oe_payment_types_tl t
107: where t.org_id = p_org_id
108: and t.payment_type_code = p_payment_type_code
109: and t.language = L.LANGUAGE_CODE);
110:

Line 225: FROM oe_payment_types_tl

221:
222: CURSOR C1 IS
223: SELECT name,description,payment_type_code,
224: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
225: FROM oe_payment_types_tl
226: WHERE payment_type_code = p_payment_type_code
227: AND nvl(org_id,-1) = nvl(p_org_id,-1)
228: AND userenv('LANG') in (LANGUAGE, SOURCE_LANG)
229: FOR UPDATE OF PAYMENT_TYPE_CODE NOWAIT;

Line 374: UPDATE oe_payment_types_tl

370: ) IS
371: BEGIN
372:
373:
374: UPDATE oe_payment_types_tl
375: SET
376: org_id = p_org_id,
377: payment_type_code = p_payment_type_code,
378: name = p_name,

Line 441: DELETE FROM oe_payment_types_tl

437:
438: end if;
439:
440:
441: DELETE FROM oe_payment_types_tl
442: WHERE nvl(org_id,-1) = nvl(l_org_id,-1)
443: AND payment_type_code = p_payment_type_code;
444:
445: DELETE FROM oe_payment_types_all

Line 465: UPDATE oe_payment_types_tl

461: p_org_id in varchar2) IS
462: l_user_id number :=0;
463: BEGIN
464: l_user_id :=fnd_load_util.owner_id(p_owner); --seed data version changes
465: UPDATE oe_payment_types_tl
466: SET
467: payment_type_code = p_payment_type_code,
468: name = p_name,
469: description = p_description,

Line 728: delete from OE_PAYMENT_TYPES_TL T

724:
725: procedure ADD_LANGUAGE
726: is
727: begin
728: delete from OE_PAYMENT_TYPES_TL T
729: where not exists
730: (select NULL
731: from OE_PAYMENT_TYPES_ALL B
732: where B.PAYMENT_TYPE_CODE = T.PAYMENT_TYPE_CODE

Line 736: update OE_PAYMENT_TYPES_TL T set (

732: where B.PAYMENT_TYPE_CODE = T.PAYMENT_TYPE_CODE
733: and NVL(B.ORG_ID, -1) = NVL(T.ORG_ID, -1)
734: );
735:
736: update OE_PAYMENT_TYPES_TL T set (
737: NAME,
738: DESCRIPTION
739: ) = (select
740: B.NAME,

Line 742: from OE_PAYMENT_TYPES_TL B

738: DESCRIPTION
739: ) = (select
740: B.NAME,
741: B.DESCRIPTION
742: from OE_PAYMENT_TYPES_TL B
743: where B.PAYMENT_TYPE_CODE = T.PAYMENT_TYPE_CODE
744: and NVL(B.ORG_ID, -1) = NVL(T.ORG_ID, -1)
745: and B.LANGUAGE = T.SOURCE_LANG)
746: where (

Line 754: from OE_PAYMENT_TYPES_TL SUBB, OE_PAYMENT_TYPES_TL SUBT

750: ) in (select
751: SUBT.PAYMENT_TYPE_CODE,
752: NVL(SUBT.ORG_ID, -1),
753: SUBT.LANGUAGE
754: from OE_PAYMENT_TYPES_TL SUBB, OE_PAYMENT_TYPES_TL SUBT
755: where SUBB.PAYMENT_TYPE_CODE = SUBT.PAYMENT_TYPE_CODE
756: and NVL(SUBB.ORG_ID, -1) = NVL(SUBT.ORG_ID, -1)
757: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
758: and (SUBB.NAME <> SUBT.NAME

Line 764: insert into OE_PAYMENT_TYPES_TL (

760: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
761: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
762: ));
763:
764: insert into OE_PAYMENT_TYPES_TL (
765: PAYMENT_TYPE_CODE,
766: ORG_ID,
767: NAME,
768: DESCRIPTION,

Line 794: from OE_PAYMENT_TYPES_TL B, FND_LANGUAGES L

790: B.PROGRAM_ID,
791: B.REQUEST_ID,
792: L.LANGUAGE_CODE,
793: B.SOURCE_LANG
794: from OE_PAYMENT_TYPES_TL B, FND_LANGUAGES L
795: where L.INSTALLED_FLAG in ('I', 'B')
796: and B.LANGUAGE = userenv('LANG')
797: and not exists
798: (select NULL

Line 799: from OE_PAYMENT_TYPES_TL T

795: where L.INSTALLED_FLAG in ('I', 'B')
796: and B.LANGUAGE = userenv('LANG')
797: and not exists
798: (select NULL
799: from OE_PAYMENT_TYPES_TL T
800: where T.PAYMENT_TYPE_CODE = B.PAYMENT_TYPE_CODE
801: and nvl(T.ORG_ID, -1) = NVL(B.ORG_ID, -1)
802: and T.LANGUAGE = L.LANGUAGE_CODE);
803: end ADD_LANGUAGE;