DBA Data[Home] [Help]

PACKAGE: APPS.INV_INVARHMA_XMLP_PKG

Source


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