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