PACKAGE: APPS.INV_INVIRILC_XMLP_PKG

Source

1 PACKAGE INV_INVIRILC_XMLP_PKG AS
2 /* $Header: INVIRILCS.pls 120.2 2008/01/08 06:37:10 dwkrishn noship $ */
3   P_ORG VARCHAR2(22);
4 
5   P_LOC_NUM VARCHAR2(15);
6 
7   P_CONC_REQUEST_ID NUMBER := 0;
8 
9   P_LOC_FLEXDATA VARCHAR2(5000);
10 
11   P_LOC_WHERE VARCHAR2(5000);
12 
13   P_ITEM_FLEXDATA VARCHAR2(5000);
14 
15   P_ITEM_NUM VARCHAR2(15);
16 
17   P_LOC_HI VARCHAR2(820);
18 
19   P_LOC_LO VARCHAR2(820);
20 
21   P_QTY_PRECISION NUMBER;
22 
23   P_ITEM_ORDER_BY VARCHAR2(800);
24 
25   P_LOC_ORDER_BY VARCHAR2(800);
26 
27   P_TRACE_FLAG NUMBER;
28 
29   P_OPTIMIZER_CODE NUMBER;
30 
31   FUNCTION AFTERREPORT RETURN BOOLEAN;
32 
33   FUNCTION WEIGHT_CONV_RATE(MOH_ITEM_ID IN NUMBER
34                            ,MSI_UOM_CODE IN VARCHAR2
35                            ,MIL_WEIGHT_UOM IN VARCHAR2) RETURN NUMBER;
36 
37   FUNCTION DSPLY_WT_CNV_RATE(C_WEIGHT_CONV_RATE IN NUMBER) RETURN CHARACTER;
38 
39   FUNCTION VOL_CONV_RATE(MOH_ITEM_ID IN NUMBER
40                         ,MSI_UOM_CODE IN VARCHAR2
41                         ,MIL_VOL_UOM IN VARCHAR2) RETURN NUMBER;
42 
43   FUNCTION DSPLY_VOL_CNV_RATE(C_VOL_CONV_RATE IN NUMBER) RETURN CHARACTER;
44 
45   FUNCTION ITEM_REV_WT_CALC(C_WEIGHT_CONV_RATE IN NUMBER
46                            ,C_ITEM_REV_QTY IN NUMBER) RETURN NUMBER;
47 
48   FUNCTION ITEM_REV_VOL_CALC(C_VOL_CONV_RATE IN NUMBER
49                             ,C_ITEM_REV_QTY IN NUMBER) RETURN NUMBER;
50 
51   FUNCTION LOC_PCT_MAX_WT(MIL_MAX_WEIGHT IN NUMBER
52                          ,C_GROSS_WT IN NUMBER) RETURN NUMBER;
53 
54   FUNCTION LOC_PCT_MAX_VOL(MIL_MAX_CUBIC_AREA IN NUMBER
55                           ,C_GROSS_VOL IN NUMBER) RETURN NUMBER;
56 
57   FUNCTION BEFOREREPORT RETURN BOOLEAN;
58 
59   FUNCTION AFTERPFORM RETURN BOOLEAN;
60 
61   FUNCTION F_LOC_PROJ_TASK_NUMBER(P_LOC_FLEXDATA IN VARCHAR2
62                                  ,P_LOC IN VARCHAR2) RETURN CHAR;
63 
64   FUNCTION CF_LOC_HIFORMULA RETURN CHAR;
65 
66   FUNCTION CF_LOC_LOFORMULA RETURN CHAR;
67 
68 END INV_INVIRILC_XMLP_PKG;
69