APPS.ONT_OEXOEUBD_XMLP_PKG dependencies on ONT_OEXOEUBD_XMLP_PKG

Line 1: PACKAGE BODY ONT_OEXOEUBD_XMLP_PKG AS

1: PACKAGE BODY ONT_OEXOEUBD_XMLP_PKG AS
2: /* $Header: OEXOEUBDB.pls 120.1 2007/12/25 07:26:50 npannamp noship $ */
3: FUNCTION AFTERREPORT RETURN BOOLEAN IS
4: BEGIN
5: BEGIN

Line 30: AND LOOKUP_TYPE = 'ONT_OEXOEUBD_XMLP_PKG SORT BY';

26: INTO LP_ORDER_BY_MEAN
27: FROM
28: OE_LOOKUPS
29: WHERE LOOKUP_CODE = UPPER(P_ORDER_BY)
30: AND LOOKUP_TYPE = 'ONT_OEXOEUBD_XMLP_PKG SORT BY';
31: IF (UPPER(P_ORDER_BY) = 'CREATED_BY') THEN
32: LP_ORDER_BY := 'order by 5,2,1';
33: ELSIF (UPPER(P_ORDER_BY) = 'MANAGER') THEN
34: LP_ORDER_BY := 'order by 4,2,1';

Line 445: END ONT_OEXOEUBD_XMLP_PKG;

441: END ;
442: return (TRUE);
443: end;
444:
445: END ONT_OEXOEUBD_XMLP_PKG;
446:
447: