APPS.ONT_OEXOECOD_XMLP_PKG dependencies on OE_TRANSACTION_TYPES_TL

Line 520: OE_TRANSACTION_TYPES_TL OEOT

516: SELECT
517: OEOT.NAME
518: INTO L_ORDER_TYPE_LOW
519: FROM
520: OE_TRANSACTION_TYPES_TL OEOT
521: WHERE OEOT.TRANSACTION_TYPE_ID = P_ORDER_TYPE_LO
522: AND OEOT.LANGUAGE = USERENV('LANG');
523: SELECT
524: OEOT.NAME

Line 527: OE_TRANSACTION_TYPES_TL OEOT

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

Line 537: OE_TRANSACTION_TYPES_TL OEOT

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

Line 547: OE_TRANSACTION_TYPES_TL OEOT

543: SELECT
544: OEOT.NAME
545: INTO L_ORDER_TYPE_LOW
546: FROM
547: OE_TRANSACTION_TYPES_TL OEOT
548: WHERE OEOT.TRANSACTION_TYPE_ID = P_ORDER_TYPE_LO
549: AND OEOT.LANGUAGE = USERENV('LANG');
550: ELSE
551: LP_ORDER_TYPE := ' ';

Line 574: OE_TRANSACTION_TYPES_TL OEOT

570: SELECT
571: OEOT.NAME
572: INTO L_LINE_TYPE_HIGH
573: FROM
574: OE_TRANSACTION_TYPES_TL OEOT
575: WHERE OEOT.TRANSACTION_TYPE_ID = P_LINE_TYPE_HI
576: AND OEOT.LANGUAGE = USERENV('LANG');
577: SELECT
578: OEOT.NAME

Line 581: OE_TRANSACTION_TYPES_TL OEOT

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

Line 591: OE_TRANSACTION_TYPES_TL OEOT

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

Line 601: OE_TRANSACTION_TYPES_TL OEOT

597: SELECT
598: OEOT.NAME
599: INTO L_LINE_TYPE_LOW
600: FROM
601: OE_TRANSACTION_TYPES_TL OEOT
602: WHERE OEOT.TRANSACTION_TYPE_ID = P_LINE_TYPE_LO
603: AND OEOT.LANGUAGE = USERENV('LANG');
604: ELSE
605: LP_LINE_TYPE := ' ';