1 PACKAGE INV_INVARCTA_XMLP_PKG AUTHID CURRENT_USER AS
2 /* $Header: INVARCTAS.pls 120.1 2007/12/25 10:02:39 dwkrishn noship $ */
3 P_ORG_ID NUMBER;
4
5 P_FROM_DATE DATE;
6 LP_FROM_DATE varchar2(11);
7
8 P_TO_DATE DATE;
9 LP_TO_DATE varchar2(11);
10
11 P_CYCLE_COUNT_HEADER_ID VARCHAR2(40);
12
13 P_SUBINVENTORY VARCHAR2(40);
14
15 P_CONC_REQUEST_ID NUMBER := 0;
16
17 P_LOCATOR_FLEX VARCHAR2(1000);
18
19 P_LOCATOR_STRUC_NUM NUMBER;
20
21 P_ITEM_STRUCT_NUM NUMBER;
22
23 P_ITEM_FLEX VARCHAR2(1000);
24
25 P_QTY_PRECISION NUMBER;
26
27 P_TRACE_FLAG NUMBER;
28
29 P_CBO_FLAG NUMBER;
30
31 P_SERIAL_DISPLAY NUMBER;
32
33 P_WMS_INSTALLED VARCHAR2(6) := 'FALSE';
34
35 P_APPROVED VARCHAR2(5);
36 pstd_precision number;
37
38 FUNCTION S_OTHER_COUNTSFORMULA(S_TOTAL_COUNTS IN NUMBER
39 ,S_COUNTS_COMPLETED IN NUMBER) RETURN NUMBER;
40
41 FUNCTION S_GROSS_ADJFORMULA(S_POS_ADJ IN NUMBER
42 ,S_NEG_ADJ IN NUMBER) RETURN NUMBER;
43
44 FUNCTION S_NET_ADJFORMULA(S_POS_ADJ IN NUMBER
45 ,S_NEG_ADJ IN NUMBER) RETURN NUMBER;
46
47 FUNCTION S_GROSS_ACCURACYFORMULA(S_GROSS_ADJ IN NUMBER
48 ,S_INVENTORY_VALUE IN NUMBER) RETURN NUMBER;
49
50 FUNCTION S_NET_ACCURACYFORMULA(S_NET_ADJ IN NUMBER
51 ,S_INVENTORY_VALUE IN NUMBER) RETURN NUMBER;
52
53 FUNCTION BEFOREREPORT RETURN BOOLEAN;
54
55 FUNCTION AFTERREPORT RETURN BOOLEAN;
56
57 FUNCTION C_FCURRENCYCODEFORMULA(C_CURRENCY_CODE IN VARCHAR2) RETURN VARCHAR2;
58
59 FUNCTION ADJUSTMENT_AMOUNTFORMULA(ENTRY_STATUS_CODE IN NUMBER
60 ,COUNT_TYPE_CODE IN NUMBER
61 ,ADJUSTMENT_QUANTITY_CURRENT IN NUMBER
62 ,CONV_RATE_CURRENT IN NUMBER
63 ,ITEM_UNIT_COST IN NUMBER
64 ,S_STD_PRECISION IN VARCHAR2) RETURN NUMBER;
65
66 FUNCTION POS_ADJFORMULA(ADJUSTMENT_AMOUNT IN NUMBER) RETURN NUMBER;
67
68 FUNCTION NEG_ADJFORMULA(ADJUSTMENT_AMOUNT IN NUMBER
69 ,NEG_ADJUSTMENT_AMOUNT IN NUMBER) RETURN NUMBER;
70
71 FUNCTION SF_NETACCURACYFORMULA(SR_NETADJ IN NUMBER
72 ,SR_INVENTORYVALUE IN NUMBER) RETURN NUMBER;
73
74 FUNCTION SF_GROSSACCURACYFORMULA(SR_GROSSADJ IN NUMBER
75 ,SR_INVENTORYVALUE IN NUMBER) RETURN NUMBER;
76
77 FUNCTION AFTERPFORM RETURN BOOLEAN;
78
79 FUNCTION C_APPROVEDFIELDFORMULA(ENTRY_STATUS_CODE IN NUMBER
80 ,COMPLETED_FLAG IN VARCHAR2
81 ,NON_COMPLETED_FLAG IN VARCHAR2) RETURN VARCHAR2;
82
83 FUNCTION ADJUSTMENT_AMOUNT_PRIORFORMULA(ENTRY_STATUS_CODE IN NUMBER
84 ,COUNT_TYPE_CODE IN NUMBER
85 ,ADJUSTMENT_QUANTITY_PRIOR IN NUMBER
86 ,CONV_RATE_PRIOR IN NUMBER
87 ,ITEM_UNIT_COST IN NUMBER
88 ,S_STD_PRECISION IN VARCHAR2) RETURN NUMBER;
89
90 FUNCTION ADJUSTMENT_AMOUNT_FIRSTFORMULA(ENTRY_STATUS_CODE IN NUMBER
91 ,COUNT_TYPE_CODE IN NUMBER
92 ,ADJUSTMENT_QUANTITY_FIRST IN NUMBER
93 ,CONV_RATE_FIRST IN NUMBER
94 ,ITEM_UNIT_COST IN NUMBER
95 ,S_STD_PRECISION IN VARCHAR2) RETURN NUMBER;
96
97 FUNCTION CONV_RATE_CURRENTFORMULA(COUNT_UOM_CURRENT IN VARCHAR2
98 ,INVENTORY_ITEM_ID1 IN NUMBER
99 ,UOM IN VARCHAR2) RETURN NUMBER;
100
101 FUNCTION CONV_RATE_PRIORFORMULA(COUNT_UOM_PRIOR IN VARCHAR2
102 ,INVENTORY_ITEM_ID1 IN NUMBER
103 ,UOM IN VARCHAR2) RETURN NUMBER;
104
105 FUNCTION CONV_RATE_FIRSTFORMULA(COUNT_UOM_FIRST IN VARCHAR2
106 ,INVENTORY_ITEM_ID1 IN NUMBER
107 ,UOM IN VARCHAR2) RETURN NUMBER;
108
109 FUNCTION ITEM_INV_VALUE_CURRENTFORMULA(ENTRY_STATUS_CODE IN NUMBER
110 ,COUNT_TYPE_CODE IN NUMBER
111 ,SYSTEM_QUANTITY_CURRENT IN NUMBER
112 ,CONV_RATE_CURRENT IN NUMBER
113 ,ITEM_UNIT_COST IN NUMBER
114 ,S_STD_PRECISION IN VARCHAR2) RETURN NUMBER;
115
116 FUNCTION P_LOCATOR_FLEXVALIDTRIGGER RETURN BOOLEAN;
117
118 FUNCTION CF_OUTERMOST_LPNFORMULA(OUTERMOST_LPN_ID IN NUMBER) RETURN CHAR;
119
120 FUNCTION CF_PARENT_LPNFORMULA(PARENT_LPN_ID IN NUMBER) RETURN CHAR;
121
122 FUNCTION CF_COST_GROUPFORMULA(COST_GROUP_ID IN NUMBER) RETURN CHAR;
123
124 END INV_INVARCTA_XMLP_PKG;
125
[Home] [Help]