APPS.ONT_OEXPRPRD_XMLP_PKG dependencies on OE_TRANSACTION_TYPES_TL

Line 347: OE_TRANSACTION_TYPES_TL OEOT

343: SELECT
344: OEOT.NAME
345: INTO L_ORDER_TYPE_LOW
346: FROM
347: OE_TRANSACTION_TYPES_TL OEOT
348: WHERE OEOT.TRANSACTION_TYPE_ID = P_ORDER_TYPE_LOW
349: AND OEOT.LANGUAGE = USERENV('LANG');
350: SELECT
351: OEOT.NAME

Line 354: OE_TRANSACTION_TYPES_TL OEOT

350: SELECT
351: OEOT.NAME
352: INTO L_ORDER_TYPE_HIGH
353: FROM
354: OE_TRANSACTION_TYPES_TL OEOT
355: WHERE OEOT.TRANSACTION_TYPE_ID = P_ORDER_TYPE_HIGH
356: AND OEOT.LANGUAGE = USERENV('LANG');
357: ORDER_TYPE_PARMS := 'From ' || SUBSTR(L_ORDER_TYPE_LOW
358: ,1

Line 374: OE_TRANSACTION_TYPES_TL OEOT

370: SELECT
371: OEOT.NAME
372: INTO L_ORDER_TYPE_LOW
373: FROM
374: OE_TRANSACTION_TYPES_TL OEOT
375: WHERE OEOT.TRANSACTION_TYPE_ID = P_ORDER_TYPE_LOW
376: AND OEOT.LANGUAGE = USERENV('LANG');
377: ORDER_TYPE_PARMS := 'From ' || SUBSTR(L_ORDER_TYPE_LOW
378: ,1

Line 390: OE_TRANSACTION_TYPES_TL OEOT

386: SELECT
387: OEOT.NAME
388: INTO L_ORDER_TYPE_HIGH
389: FROM
390: OE_TRANSACTION_TYPES_TL OEOT
391: WHERE OEOT.TRANSACTION_TYPE_ID = P_ORDER_TYPE_HIGH
392: AND OEOT.LANGUAGE = USERENV('LANG');
393: ORDER_TYPE_PARMS := 'From ' || BLANKS || 'To ' || SUBSTR(L_ORDER_TYPE_HIGH
394: ,1

Line 411: OE_TRANSACTION_TYPES_TL OEOT

407: SELECT
408: OEOT.NAME
409: INTO L_LINE_TYPE_LOW
410: FROM
411: OE_TRANSACTION_TYPES_TL OEOT
412: WHERE OEOT.TRANSACTION_TYPE_ID = P_LINE_TYPE_LOW
413: AND OEOT.LANGUAGE = USERENV('LANG');
414: END IF;
415: IF (P_LINE_TYPE_HIGH IS NOT NULL) THEN

Line 420: OE_TRANSACTION_TYPES_TL OEOT

416: SELECT
417: OEOT.NAME
418: INTO L_LINE_TYPE_HIGH
419: FROM
420: OE_TRANSACTION_TYPES_TL OEOT
421: WHERE OEOT.TRANSACTION_TYPE_ID = P_LINE_TYPE_HIGH
422: AND OEOT.LANGUAGE = USERENV('LANG');
423: END IF;
424: IF (P_ITEM_LOW IS NOT NULL) AND (P_ITEM_HI IS NOT NULL) THEN