PACKAGE: APPS.INV_INVARCLI_XMLP_PKG

Source

1 PACKAGE INV_INVARCLI_XMLP_PKG AS
2 /* $Header: INVARCLIS.pls 120.2 2008/01/08 06:17:14 dwkrishn noship $ */
3   P_CONC_REQUEST_ID NUMBER := 0;
4 
5   P_ORG_ID NUMBER;
6 
7   P_LOCATOR_STRUC_NUM NUMBER;
8 
9   P_LOCATOR_FLEXSQL VARCHAR2(1000);
10 
11   P_HEADERID NUMBER;
12 
13   P_FROMDATE DATE;
14 
15   P_TODATE DATE;
16 
17   LP_FROMDATE DATE;
18 
19   LP_TODATE DATE;
20 
21   P_ITEM_FLEXSQL VARCHAR2(1000);
22 
23   P_ITEM_FLEXNUM NUMBER;
24 
25   P_RECOUNTONLY NUMBER;
26 
27   P_SUBINVENTORY VARCHAR2(32767);
28 
29   P_TRACE_FLAG NUMBER;
30 
31   P_CBO_FLAG NUMBER;
32 
33   P_SERIAL_DISPLAY NUMBER;
34 
35   P_ONHANDQTY_DISPLAY NUMBER;
36 
37   P_EXPORT_DISPLAY NUMBER;
38 
39   P_EXPORT_EXPLANATION_ON_FOOTER NUMBER;
40 
41   P_WMS_INSTALLED VARCHAR2(6) := 'FALSE';
42 
43   FUNCTION C_FORMATTEDCURRENCYCODEFORMULA(CURRENCY_CODE IN VARCHAR2) RETURN VARCHAR2;
44 
45   FUNCTION BEFOREREPORT RETURN BOOLEAN;
46 
47   FUNCTION AFTERREPORT RETURN BOOLEAN;
48 
49   FUNCTION F_RECOUNTONLYFORMULA RETURN VARCHAR2;
50 
51   FUNCTION AFTERPFORM RETURN BOOLEAN;
52 
53   FUNCTION CF_SYSQTYFORMULA(SERIAL_NUMBER_CONTROL_CODE IN NUMBER
54                            ,SERIAL_COUNT_OPTION IN NUMBER
55                            ,INVENTORY_ITEM_ID_V IN NUMBER
56                            ,SUBINVENTORY IN VARCHAR2
57                            ,LOTNUMBER IN VARCHAR2
58                            ,REVISION IN VARCHAR2
59                            ,LOCATOR IN NUMBER
60                            ,PARENT_LPN_ID IN NUMBER
61                            ,SERIAL_NUMBER IN VARCHAR2) RETURN NUMBER;
62 
63   FUNCTION CF_ISSERIALPRESENTFORMULA(SL_SERIAL_NUMBER IN VARCHAR2
64                                     ,INVENTORY_ITEM_ID_V IN NUMBER
65                                     ,SUBINVENTORY IN VARCHAR2
66                                     ,LOTNUMBER IN VARCHAR2
67                                     ,REVISION IN VARCHAR2
68                                     ,LOCATOR IN NUMBER) RETURN VARCHAR2;
69 
70   FUNCTION CF_COST_GROUPFORMULA(COST_GROUP_ID IN NUMBER) RETURN CHAR;
71 
72   FUNCTION CF_OUTERMOST_LPNFORMULA(CONTAINER_ENABLED_FLAG IN NUMBER
73                                   ,OUTERMOST_LPN_ID IN NUMBER) RETURN CHAR;
74 
75   FUNCTION CF_PARENT_LPNFORMULA(CONTAINER_ENABLED_FLAG IN NUMBER
76                                ,PARENT_LPN_ID IN NUMBER) RETURN CHAR;
77 
78   EXPLANATION_FLAG BOOLEAN := FALSE;
79 
80 END INV_INVARCLI_XMLP_PKG;
81