PACKAGE BODY: APPS.INV_INVIRXRF_XMLP_PKG

Source

1 PACKAGE BODY INV_INVIRXRF_XMLP_PKG AS
2 /* $Header: INVIRXRFB.pls 120.1 2007/12/25 10:36:51 dwkrishn noship $ */
3   FUNCTION BEFOREREPORT RETURN BOOLEAN IS
4   BEGIN
5     IF P_REPORT_TYPE = '1' THEN
6       /*SRW.SET_MAXROW('Q_XREF_BY_ITEM'
7                     ,0)*/NULL;
8     ELSE
9       /*SRW.SET_MAXROW('Q_ITEM_BY_XREF'
10                     ,0)*/NULL;
11     END IF;
12     BEGIN
13       P_CONC_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
14       /*SRW.USER_EXIT('FND SRWINIT')*/NULL;
15     EXCEPTION
16       WHEN /*SRW.USER_EXIT_FAILURE*/OTHERS THEN
17         /*SRW.MESSAGE(1
18                    ,'Srwinit failed in before report trigger')*/NULL;
19         RAISE;
20     END;
21     BEGIN
22       NULL;
23     EXCEPTION
24       WHEN /*SRW.USER_EXIT_FAILURE*/OTHERS THEN
25         /*SRW.MESSAGE(2
26                    ,'Item Flex Select failed in before report trigger')*/NULL;
27         RAISE;
28     END;
29     BEGIN
30       NULL;
31     EXCEPTION
32       WHEN /*SRW.USER_EXIT_FAILURE*/OTHERS THEN
33         /*SRW.MESSAGE(2
34                    ,'Item flex select sort failed in before report trigger')*/NULL;
35         RAISE;
36     END;
37     BEGIN
38       NULL;
39     EXCEPTION
40       WHEN /*SRW.USER_EXIT_FAILURE*/OTHERS THEN
41         /*SRW.MESSAGE(13
42                    ,'CATG Flex Select Failed in before report trigger')*/NULL;
43         RAISE;
44     END;
45     BEGIN
46       NULL;
47     EXCEPTION
48       WHEN /*SRW.USER_EXIT_FAILURE*/OTHERS THEN
49         /*SRW.MESSAGE(8
50                    ,'CATG2 FLEX WHERE FAILED IN BEFORE REPORT TRIGGER')*/NULL;
51         RAISE;
52     END;
53     BEGIN
54       NULL;
55     EXCEPTION
56       WHEN /*SRW.USER_EXIT_FAILURE*/OTHERS THEN
57         /*SRW.MESSAGE(4
58                    ,'Item Flex Where failed in before report trigger')*/NULL;
59         RAISE;
60     END;
61     RETURN (TRUE);
62   END BEFOREREPORT;
63 
64   FUNCTION C_XREF_TYPE_MARG_FORMULAFORMUL RETURN VARCHAR2 IS
65   BEGIN
66     RETURN ('Cross Reference Type:  ' || P_XREF_TYPE);
67   END C_XREF_TYPE_MARG_FORMULAFORMUL;
68 
69   FUNCTION AFTERPFORM RETURN BOOLEAN IS
70   BEGIN
71     RETURN (TRUE);
72   END AFTERPFORM;
73 
74   FUNCTION C_ORG_INDPFORMULA(ORG_INDP IN VARCHAR2) RETURN VARCHAR2 IS
75   BEGIN
76     /*SRW.REFERENCE(ORG_INDP)*/NULL;
77     IF ORG_INDP = 'Y' THEN
78       RETURN ('Yes');
79     ELSE
80       RETURN ('No');
81     END IF;
82     RETURN NULL;
83   END C_ORG_INDPFORMULA;
84 
85   FUNCTION C_ORG_INDP1FORMULA(ORG_INDP1 IN VARCHAR2) RETURN VARCHAR2 IS
86   BEGIN
87     /*SRW.REFERENCE(ORG_INDP1)*/NULL;
88     IF ORG_INDP1 = 'Y' THEN
89       RETURN ('Yes');
90     ELSE
91       RETURN ('No');
92     END IF;
93     RETURN NULL;
94   END C_ORG_INDP1FORMULA;
95 
96   FUNCTION AFTERREPORT RETURN BOOLEAN IS
97   BEGIN
98     /*SRW.USER_EXIT('FND SRWEXIT')*/NULL;
99     RETURN (TRUE);
100   END AFTERREPORT;
101 
102 END INV_INVIRXRF_XMLP_PKG;
103