APPS.ONT_OEXOECOD_XMLP_PKG dependencies on OE_TRANSACTION_TYPES_TL

Line 524: OE_TRANSACTION_TYPES_TL OEOT

520: SELECT
521: OEOT.NAME
522: INTO L_ORDER_TYPE_LOW
523: FROM
524: OE_TRANSACTION_TYPES_TL OEOT
525: WHERE OEOT.TRANSACTION_TYPE_ID = P_ORDER_TYPE_LO
526: AND OEOT.LANGUAGE = USERENV('LANG');
527: SELECT
528: OEOT.NAME

Line 531: OE_TRANSACTION_TYPES_TL OEOT

527: SELECT
528: OEOT.NAME
529: INTO L_ORDER_TYPE_HIGH
530: FROM
531: OE_TRANSACTION_TYPES_TL OEOT
532: WHERE OEOT.TRANSACTION_TYPE_ID = P_ORDER_TYPE_HI
533: AND OEOT.LANGUAGE = USERENV('LANG');
534: ELSE
535: IF P_ORDER_TYPE_LO IS NULL AND P_ORDER_TYPE_HI IS NOT NULL THEN

Line 541: OE_TRANSACTION_TYPES_TL OEOT

537: SELECT
538: OEOT.NAME
539: INTO L_ORDER_TYPE_HIGH
540: FROM
541: OE_TRANSACTION_TYPES_TL OEOT
542: WHERE OEOT.TRANSACTION_TYPE_ID = P_ORDER_TYPE_HI
543: AND OEOT.LANGUAGE = USERENV('LANG');
544: ELSE
545: IF P_ORDER_TYPE_LO IS NOT NULL AND P_ORDER_TYPE_HI IS NULL THEN

Line 551: OE_TRANSACTION_TYPES_TL OEOT

547: SELECT
548: OEOT.NAME
549: INTO L_ORDER_TYPE_LOW
550: FROM
551: OE_TRANSACTION_TYPES_TL OEOT
552: WHERE OEOT.TRANSACTION_TYPE_ID = P_ORDER_TYPE_LO
553: AND OEOT.LANGUAGE = USERENV('LANG');
554: ELSE
555: LP_ORDER_TYPE := ' ';

Line 578: OE_TRANSACTION_TYPES_TL OEOT

574: SELECT
575: OEOT.NAME
576: INTO L_LINE_TYPE_HIGH
577: FROM
578: OE_TRANSACTION_TYPES_TL OEOT
579: WHERE OEOT.TRANSACTION_TYPE_ID = P_LINE_TYPE_HI
580: AND OEOT.LANGUAGE = USERENV('LANG');
581: SELECT
582: OEOT.NAME

Line 585: OE_TRANSACTION_TYPES_TL OEOT

581: SELECT
582: OEOT.NAME
583: INTO L_LINE_TYPE_LOW
584: FROM
585: OE_TRANSACTION_TYPES_TL OEOT
586: WHERE OEOT.TRANSACTION_TYPE_ID = P_LINE_TYPE_LO
587: AND OEOT.LANGUAGE = USERENV('LANG');
588: ELSE
589: IF P_LINE_TYPE_LO IS NULL AND P_LINE_TYPE_HI IS NOT NULL THEN

Line 595: OE_TRANSACTION_TYPES_TL OEOT

591: SELECT
592: OEOT.NAME
593: INTO L_LINE_TYPE_HIGH
594: FROM
595: OE_TRANSACTION_TYPES_TL OEOT
596: WHERE OEOT.TRANSACTION_TYPE_ID = P_LINE_TYPE_HI
597: AND OEOT.LANGUAGE = USERENV('LANG');
598: ELSE
599: IF P_LINE_TYPE_LO IS NOT NULL AND P_LINE_TYPE_HI IS NULL THEN

Line 605: OE_TRANSACTION_TYPES_TL OEOT

601: SELECT
602: OEOT.NAME
603: INTO L_LINE_TYPE_LOW
604: FROM
605: OE_TRANSACTION_TYPES_TL OEOT
606: WHERE OEOT.TRANSACTION_TYPE_ID = P_LINE_TYPE_LO
607: AND OEOT.LANGUAGE = USERENV('LANG');
608: ELSE
609: LP_LINE_TYPE := ' ';