[Home] [Help]
PACKAGE: APPS.WIP_WIPREORQ_XMLP_PKG
Source
1 PACKAGE WIP_WIPREORQ_XMLP_PKG AS
2 /* $Header: WIPREORQS.pls 120.1 2008/01/31 12:38:29 npannamp noship $ */
3 P_ASSY VARCHAR2(850);
4
5 P_COMP VARCHAR2(850);
6
7 P_CONC_REQUEST_ID NUMBER := 0;
8
9 P_ORGANIZATION_ID VARCHAR2(40);
10 QTY VARCHAR2(40);
11
12 P_SUPPLY_LOC VARCHAR2(850);
13
14 P_FROM_LINE VARCHAR2(10);
15
16 P_TO_LINE VARCHAR2(10);
17
18 P_FROM_ASSEMBLY VARCHAR2(850);
19
20 P_TO_ASSEMBLY VARCHAR2(850);
21
22 P_SUPPLY_DAYS NUMBER;
23
24 P_OPEN_SHORT NUMBER;
25
26 P_AHEAD_BEHIND NUMBER;
27
28 P_NETTABLE NUMBER;
29
30 P_QTY_PRECISION NUMBER;
31
32 P_FROM_COMP VARCHAR2(850);
33
34 P_TO_COMP VARCHAR2(850);
35
36 P_FLEXWHERE VARCHAR2(2400):=' ';
37
38 P_REQ_END_DATE DATE;
39
40 P_DEBUG NUMBER;
41
42 P_ITEM_ORG VARCHAR2(200):=' ';
43
44 P_INCLUDE_BULK NUMBER;
45
46 P_INCLUDE_VENDOR NUMBER;
47
48 FUNCTION BEFOREREPORT RETURN BOOLEAN;
49
50 FUNCTION AFTERREPORT RETURN BOOLEAN;
51
52 FUNCTION LIMIT_LINES RETURN CHARACTER;
53
54 FUNCTION OPEN_SHORT_LIMITER RETURN CHARACTER;
55
56 FUNCTION OPEN_SHORTFORMULA RETURN NUMBER;
57
58 FUNCTION ASSEMBLY_LIMITER RETURN CHARACTER;
59
60 FUNCTION C_NETTABLE_CONSTRAINTFORMULA RETURN VARCHAR2;
61
62 FUNCTION C_QTY_SHORT_QOHFORMULA(NET_QTY_COMP IN NUMBER
63 ,C_ITEM_TOTAL_QTY IN NUMBER
64 ,C_QTY_SHORT_FORMULA IN NUMBER
65 ,C_OPEN_REQUIREMENTS IN VARCHAR2
66 ,AVAIL_QTY IN NUMBER) RETURN NUMBER;
67
68 FUNCTION C_TOTAL_QTY_FORMULAFORMULA(C_TOTAL_QTY IN NUMBER
69 ,SUPPLY_FLAG IN NUMBER) RETURN NUMBER;
70
71 FUNCTION C_QTY_SHORT_SUB_LOCFORMULA(C_QTY_SHORT_FORMULA IN NUMBER
72 ,QTY_OPEN IN NUMBER) RETURN NUMBER;
73
74 FUNCTION NET_QTY_DETAILFORMULA(AVAILABILITY_TYPE IN NUMBER
75 ,QUANTITY_ON_HAND IN NUMBER) RETURN NUMBER;
76
77 FUNCTION AVAIL_QTYFORMULA(NET_QTY_COMP IN NUMBER
78 ,C_ITEM_TOTAL_QTY IN NUMBER) RETURN NUMBER;
79
80 FUNCTION C_LIMIT_COMPONENTSFORMULA RETURN VARCHAR2;
81
82 FUNCTION ZEROFORMULA RETURN NUMBER;
83
84 FUNCTION C_COMPONENT_DISP_SORTFORMULA(C_COMPONENT_DISP_SORT IN VARCHAR2) RETURN VARCHAR2;
85
86 FUNCTION AFTERPFORM RETURN BOOLEAN;
87
88 FUNCTION LIMIT_BULK_SUPPLY_TYPE RETURN CHARACTER;
89
90 FUNCTION LIMIT_VENDOR_SUPPLY_TYPE RETURN CHARACTER;
91 function get_precision(qty_precision in number) return VARCHAR2;
92
93 END WIP_WIPREORQ_XMLP_PKG;
94