1 PACKAGE INV_INVARHMA_XMLP_PKG AS
2 /* $Header: INVARHMAS.pls 120.2 2008/01/08 06:20:05 dwkrishn noship $ */
3 P_CONC_REQUEST_ID NUMBER := 0;
4
5 P_ORG_ID NUMBER;
6
7 P_HEADERID NUMBER;
8
9 P_FROMDATE DATE;
10
11 P_TODATE DATE;
12
13 LP_FROMDATE DATE;
14
15 LP_TODATE DATE;
16
17 P_CBO_FLAG NUMBER;
18
19 P_TRACE_FLAG NUMBER;
20
21 FUNCTION C_FORMATTEDCURRENCYCODEFORMULA(CURRENCY_CODE IN VARCHAR2) RETURN VARCHAR2;
22
23 FUNCTION BEFOREREPORT RETURN BOOLEAN;
24
25 FUNCTION AFTERREPORT RETURN BOOLEAN;
26
27 FUNCTION F_OUTTOLERANCEFLAGFORMULA(SERIAL_DETAIL IN NUMBER
28 ,SERIAL_NUMBER IN VARCHAR2
29 ,ADJ_QUANTITY IN NUMBER
30 ,SYS_QUANTITY IN NUMBER
31 ,NEG_TOL IN NUMBER
32 ,POS_TOL IN NUMBER) RETURN NUMBER;
33
34 FUNCTION F_ACCURACYPERCENTFORMULA(F_TOTALENTRIES IN NUMBER
35 ,C_TOTALOUTTOLERANCE IN NUMBER) RETURN NUMBER;
36
37 FUNCTION FS_ACCURACYPERCENTFORMULA(SS_TOTALENTRIES IN NUMBER
38 ,SS_TOTALOUTTOLERANCE IN NUMBER) RETURN NUMBER;
39
40 FUNCTION SR_ACCURACYPERCENTFORMULA(SR_TOTALENTRIES IN NUMBER
41 ,SR_TOTALOUTTOLERANCE IN NUMBER) RETURN NUMBER;
42
43 FUNCTION AFTERPFORM RETURN BOOLEAN;
44
45 FUNCTION C_SERIAL_YES_NOFORMULA(CNT_SL_NO IN NUMBER) RETURN VARCHAR2;
46
47 FUNCTION BEFOREPFORM RETURN BOOLEAN;
48
49 END INV_INVARHMA_XMLP_PKG;
50
51