DBA Data[Home] [Help]

PACKAGE BODY: APPS.PO_POXRVRUR_XMLP_PKG

Source


1 PACKAGE BODY PO_POXRVRUR_XMLP_PKG AS
2 /* $Header: POXRVRURB.pls 120.1 2007/12/25 12:21:54 krreddy noship $ */
3   FUNCTION BEFOREREPORT RETURN BOOLEAN IS
4   BEGIN
5     DECLARE
6       L_ORG_DISPLAYED ORG_ORGANIZATION_DEFINITIONS.ORGANIZATION_NAME%TYPE;
7     BEGIN
8       IF (P_ORG_ID IS NOT NULL) THEN
9         BEGIN
10           SELECT
11             ORGANIZATION_NAME
12           INTO
13             L_ORG_DISPLAYED
14           FROM
15             ORG_ORGANIZATION_DEFINITIONS
16           WHERE ORGANIZATION_ID = P_ORG_ID;
17           P_ORG_DISPLAYED := L_ORG_DISPLAYED;
18         END;
19       ELSE
20         P_ORG_DISPLAYED := '';
21       END IF;
22     END;
23     BEGIN
24       FORMAT_MASK := PO_COMMON_xmlp_pkg.GET_PRECISION(P_QTY_PRECISION);
25       P_CONC_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
26       RETURN TRUE;
27     END;
28     RETURN (TRUE);
29   END BEFOREREPORT;
30   FUNCTION AFTERREPORT RETURN BOOLEAN IS
31   BEGIN
32     RETURN (TRUE);
33   END AFTERREPORT;
34   PROCEDURE GET_PRECISION IS
35   BEGIN
36     IF P_QTY_PRECISION = 0 THEN
37       NULL;
38     ELSE
39       IF P_QTY_PRECISION = 1 THEN
40         NULL;
41       ELSE
42         IF P_QTY_PRECISION = 3 THEN
43           NULL;
44         ELSE
45           IF P_QTY_PRECISION = 4 THEN
46             NULL;
47           ELSE
48             IF P_QTY_PRECISION = 5 THEN
49               NULL;
50             ELSE
51               IF P_QTY_PRECISION = 6 THEN
52                 NULL;
53               ELSE
54                 NULL;
55               END IF;
56             END IF;
57           END IF;
58         END IF;
59       END IF;
60     END IF;
61   END GET_PRECISION;
62   FUNCTION AFTERPFORM RETURN BOOLEAN IS
63   BEGIN
64     RETURN (TRUE);
65   END AFTERPFORM;
66   FUNCTION BETWEENPAGE RETURN BOOLEAN IS
67   BEGIN
68     RETURN (TRUE);
69   END BETWEENPAGE;
70   FUNCTION BEFOREPFORM RETURN BOOLEAN IS
71   BEGIN
72     RETURN (TRUE);
73   END BEFOREPFORM;
74 END PO_POXRVRUR_XMLP_PKG;
75