1 PACKAGE INV_INVARCLI_XMLP_PKG AUTHID CURRENT_USER AS
2 /* $Header: INVARCLIS.pls 120.2.12020000.2 2012/07/09 09:07:04 ptkumar ship $ */
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(P_CURRENCY_CODE IN VARCHAR2) RETURN VARCHAR2; -- For bug 14037978, modified the parameter by adding "p_" as prefix
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(P_SERIAL_NUMBER_CONTROL_CODE IN NUMBER -- For bug 14037978, modified the parameters by adding "p_" as prefix
54 ,P_SERIAL_COUNT_OPTION IN NUMBER
55 ,P_INVENTORY_ITEM_ID IN NUMBER
56 ,P_SUBINVENTORY IN VARCHAR2
57 ,P_LOTNUMBER IN VARCHAR2
58 ,P_REVISION IN VARCHAR2
59 ,P_LOCATOR IN NUMBER
60 ,P_PARENT_LPN_ID IN NUMBER
61 ,P_SERIAL_NUMBER IN VARCHAR2) RETURN NUMBER;
62
63 FUNCTION CF_ISSERIALPRESENTFORMULA(P_SERIAL_NUMBER IN VARCHAR2 -- For bug 14037978, modified the parameters by adding "p_" as prefix
64 ,P_INVENTORY_ITEM_ID IN NUMBER
65 ,P_SUBINVENTORY IN VARCHAR2
66 ,P_LOTNUMBER IN VARCHAR2
67 ,P_REVISION IN VARCHAR2
68 ,P_LOCATOR IN NUMBER) RETURN VARCHAR2;
69
70 FUNCTION CF_COST_GROUPFORMULA(P_COST_GROUP_ID IN NUMBER) RETURN VARCHAR2; -- For bug 14037978, modified the parameter by adding "p_" as prefix and replacing CHAR with VARCHAR2
71
72 FUNCTION CF_OUTERMOST_LPNFORMULA(P_CONTAINER_ENABLED_FLAG IN NUMBER -- For bug 14037978, modified the parameters by adding "p_" as prefix and replacing CHAR with VARCHAR2
73 ,P_OUTERMOST_LPN_ID IN NUMBER) RETURN VARCHAR2;
74
75 FUNCTION CF_PARENT_LPNFORMULA(P_CONTAINER_ENABLED_FLAG IN NUMBER -- For bug 14037978, modified the parameters by adding "p_" as prefix and replacing CHAR with VARCHAR2
76 ,P_PARENT_LPN_ID IN NUMBER) RETURN VARCHAR2;
77
78 EXPLANATION_FLAG BOOLEAN := FALSE;
79
80 END INV_INVARCLI_XMLP_PKG;
81
[Home] [Help]