PACKAGE: APPS.WIP_WIPDJORQ_XMLP_PKG

Source

1 PACKAGE WIP_WIPDJORQ_XMLP_PKG AS
2 /* $Header: WIPDJORQS.pls 120.1 2008/01/31 12:18:41 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 
11   P_FROM_JOB VARCHAR2(240);
12 
13   P_TO_JOB VARCHAR2(240);
14 
15   P_FROM_DATE DATE;
16 
17   P_TO_DATE DATE;
18 
19   P_SUPPLY_LOC VARCHAR2(850);
20 
21   P_DETAIL_LOC VARCHAR2(850);
22 
23   P_NETTABLE NUMBER;
24 
25   P_OPEN_SHORT NUMBER;
26 
27   P_TO_DEPT VARCHAR2(10);
28 
29   P_FROM_DEPT VARCHAR2(10);
30 
31   P_SORT_BY NUMBER;
32 
33   P_FLEXWHERE VARCHAR2(2400);
34 
35   P_FROM_COMP VARCHAR2(850);
36 
37   P_TO_COMP VARCHAR2(850);
38 
39   P_QTY_PRECISION NUMBER;
40 
41   P_REQ_END_DATE DATE;
42 
43   P_FROM_BUYER VARCHAR2(240);
44 
45   P_TO_BUYER VARCHAR2(240);
46 
47   P_FROM_PLANNER VARCHAR2(240);
48 
49   P_TO_PLANNER VARCHAR2(240);
50 
51   P_MAKE_BUY NUMBER;
52 
53   P_DEBUG NUMBER;
54 
55   P_ITEM_ORG VARCHAR2(200) :=  ' ';
56 
57   P_INCLUDE_BULK NUMBER;
58 
59   P_INCLUDE_VENDOR NUMBER;
60 
61   P_SCHEDULE_GROUP VARCHAR2(30);
62 
63   P_SG_OUTER VARCHAR2(5) := '(+)';
64 
65   FUNCTION BEFOREREPORT RETURN BOOLEAN;
66 
67   FUNCTION AFTERREPORT RETURN BOOLEAN;
68 
69   FUNCTION LIMIT_JOBS RETURN CHARACTER;
70 
71   FUNCTION LIMIT_DATES RETURN CHARACTER;
72 
73   FUNCTION C_NETTABLE_CONSTRAINTFORMULA RETURN VARCHAR2;
74 
75   FUNCTION C_TOTAL_QTY_FORMULAFORMULA(C_TOTAL_QTY IN NUMBER
76                                      ,SUPPLY_FLAG IN NUMBER) RETURN NUMBER;
77 
78   FUNCTION C_QTY_SHORT_QOHFORMULA(C_QTY_SHORT_FORMULA IN NUMBER
79                                  ,C_OPEN_REQUIREMENTS IN VARCHAR2
80                                  ,AVAIL_QTY IN NUMBER) RETURN NUMBER;
81 
82   FUNCTION DEPARTMENT_LIMITER RETURN CHARACTER;
83 
84   FUNCTION C_BREAK_JOBFORMULA(JOB IN VARCHAR2) RETURN VARCHAR2;
85 
86   FUNCTION C_BREAK_DATE_REQUIREDFORMULA(DATE_REQUIRED IN DATE) RETURN DATE;
87 
88   FUNCTION C_BREAK_DEPARTMENTFORMULA(DEPARTMENT IN VARCHAR2) RETURN VARCHAR2;
89 
90   FUNCTION C_LIMIT_COMPONENTSFORMULA RETURN VARCHAR2;
91 
92   FUNCTION C_BREAK_COMP_DISPFORMULA(COMPONENT IN VARCHAR2
93                                    ,C_COMPONENT_DISP IN VARCHAR2) RETURN VARCHAR2;
94 
95   FUNCTION NET_QTY_DETAILFORMULA(AVAILABILITY_TYPE IN NUMBER
96                                 ,QUANTITY_ON_HAND IN NUMBER) RETURN NUMBER;
97 
98   FUNCTION AVAIL_QTYFORMULA(NET_QTY_COMP IN NUMBER
99                            ,C_ITEM_TOTAL_QTY IN NUMBER) RETURN NUMBER;
100 
101   FUNCTION C_COMPONENT_SORTFORMULA(COMPONENT IN VARCHAR2
102                                   ,C_COMPONENT_DISP IN VARCHAR2
103                                   ,C_COMPONENT_SORT IN VARCHAR2) RETURN VARCHAR2;
104 
105   FUNCTION ZEROFORMULA RETURN NUMBER;
106 
107   FUNCTION LIMIT_PLANNERS RETURN CHARACTER;
108 
109   FUNCTION LIMIT_BUYER RETURN CHARACTER;
110 
111   FUNCTION C_BREAK_ASSY_DISPFORMULA(C_ASSY IN VARCHAR2
112                                    ,C_ASSY_DISP IN VARCHAR2) RETURN VARCHAR2;
113 
114   FUNCTION MASTER_BREAK_FUNC(COMPONENT IN VARCHAR2
115                             ,C_COMPONENT_DISP IN VARCHAR2
116                             ,C_COMPONENT_SORT IN VARCHAR2
117                             ,JOB IN VARCHAR2
118                             ,DEPARTMENT IN VARCHAR2
119                             ,MAKE_BUY IN VARCHAR2
120                             ,BUYER_NAME IN VARCHAR2
121                             ,PLANNER_CODE IN VARCHAR2
122                             ,DATE_REQUIRED IN DATE) RETURN CHARACTER;
123 
124   FUNCTION C_FIRST_SORTFORMULA RETURN VARCHAR2;
125 
126   FUNCTION C_TOT_QTY_SHORTFORMULA(C_TOTAL_AVAIL_QTY IN VARCHAR2
127                                  ,C_TOTAL_AVAIL_NET_QTY IN VARCHAR2
128                                  ,C_TOT_QTY_OPEN IN VARCHAR2) RETURN NUMBER;
129 
130   FUNCTION C_BREAK_COMP_DESCFORMULA(COMP_DESC IN VARCHAR2) RETURN VARCHAR2;
131 
132   FUNCTION C_DISPLAY_FORMULAFORMULA(C_QTY_SHORT_QOH IN NUMBER) RETURN NUMBER;
133 
134   FUNCTION AFTERPFORM RETURN BOOLEAN;
135 
136   FUNCTION LIMIT_BULK_SUPPLY_TYPE RETURN CHARACTER;
137 
138   FUNCTION LIMIT_VENDOR_SUPPLY_TYPE RETURN CHARACTER;
139 
140   FUNCTION C_LIMITER RETURN VARCHAR2;
141 
142   FUNCTION C_LIMIT_DATE_REQFORMULA RETURN CHAR;
143 
144 END WIP_WIPDJORQ_XMLP_PKG;
145