PACKAGE: APPS.WIP_WIPREORQ_XMLP_PKG

Source

1 PACKAGE WIP_WIPREORQ_XMLP_PKG AUTHID CURRENT_USER 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