PACKAGE: APPS.MRP_MRPRPRSC_XMLP_PKG

Source

1 PACKAGE MRP_MRPRPRSC_XMLP_PKG AS
2 /* $Header: MRPRPRSCS.pls 120.3 2008/01/02 13:31:35 nchinnam noship $ */
3   P_ORG_ID VARCHAR2(22);
4 
5   P_PLAN_NAME VARCHAR2(10);
6 
7   P_ORDER_TYPE VARCHAR2(22);
8 
9   P_SORT VARCHAR2(22);
10 
11   P_OUT_DAYS NUMBER;
12 
13   P_IN_DAYS NUMBER;
14 
15   P_PLANNER VARCHAR2(10);
16 
17   P_BUYER VARCHAR2(40);
18 
19   P_LOW_ITEM VARCHAR2(240);
20 
21   P_HIGH_ITEM VARCHAR2(240);
22 
23   P_CAT_SET VARCHAR2(22);
24 
25   P_CAT_STRUCTURE VARCHAR2(22);
26 
27   P_LOW_CAT VARCHAR2(240);
28 
29   P_HIGH_CAT VARCHAR2(240);
30 
31   P_ABC_ASSGN VARCHAR2(22);
32 
33   P_ABC_CLASS VARCHAR2(22);
34 
35   P_CUTOFF_TYPE VARCHAR2(22);
36 
37   P_CUTOFF_DATE DATE;
38 
39   P_CAT_RANGE VARCHAR2(750);
40 
41   P_ITEM_RANGE VARCHAR2(750);
42 
43   P_CONC_REQUEST_ID NUMBER := 0;
44 
45   P_FLEXDATA VARCHAR2(838);
46 
47   P_STRUCT_NUM VARCHAR2(15);
48 
49   P_ITEM_ORDER VARCHAR2(750);
50 
51   P_CAT_ORDER VARCHAR2(750);
52 
53   P_FLEXCAT VARCHAR2(750);
54 
55   P_WIP_START VARCHAR2(16) := '''xxxxxxxxx''';
56 
57   P_CUTOFF_DATE_YY VARCHAR2(32767);
58 
59   P_PRECISION NUMBER := 2;
60 
61   P_QTY_PRECISION NUMBER;
62 
63   P_CURRENCY_CODE VARCHAR2(40);
64 
65   P_CURRENCY_DESC VARCHAR2(80);
66 
67   C_ORDER_NUM VARCHAR2(40);
68 
69   P_CUTOFF_DATE_1 VARCHAR2(30);
70   P_CUTOFF_DATE_2 VARCHAR2(30);
71 
72   P_DEBUG VARCHAR2(1);
73 
74   P_CANCEL_TEXT VARCHAR2(80) := 'CANCEL';
75 
76   P_ORDER_BY VARCHAR2(300);
77 
78   P_ITEM_ORDER_BY VARCHAR2(300);
79 
80   P_CAT_STRUCT_NUM NUMBER;
81 
82   P_REPORT_MULTIORG NUMBER;
83 
84   QTY_PRECISION varchar2(25);
85 
86   FUNCTION BEFOREREPORT RETURN BOOLEAN;
87 
88   FUNCTION C_CATEGORY_FROMFORMULA RETURN VARCHAR2;
89 
90   FUNCTION C_BUYER_RANGEFORMULA RETURN VARCHAR2;
91 
92   FUNCTION C_CATEGORY_WHEREFORMULA RETURN VARCHAR2;
93 
94   FUNCTION C_PLANNER_RANGEFORMULA RETURN VARCHAR2;
95 
96   FUNCTION C_ABC_FROMFORMULA RETURN VARCHAR2;
97 
98   FUNCTION C_ABC_WHEREFORMULA RETURN VARCHAR2;
99 
100   FUNCTION C_ORDER_BYFORMULA(P_ORDER_BY1 varchar2,P_ORDER_BY2 varchar2) RETURN VARCHAR2;
101 
102   FUNCTION C_CUTOFF_COLUMNFORMULA RETURN VARCHAR2;
103 
104   FUNCTION C_SORT_COLUMNFORMULA RETURN VARCHAR2;
105 
106   FUNCTION C_ABC_RANGEFORMULA RETURN VARCHAR2;
107 
108   FUNCTION AFTERREPORT RETURN BOOLEAN;
109 
110   FUNCTION C_DAYS_RANGEFORMULA RETURN VARCHAR2;
111 
112   FUNCTION C_WIP_FROMFORMULA RETURN VARCHAR2;
113 
114   FUNCTION C_WIP_WHEREFORMULA RETURN VARCHAR2;
115 
116   FUNCTION C_P_SORTFORMULA RETURN VARCHAR2;
117 
118   FUNCTION C_P_ORDER_TYPEFORMULA RETURN VARCHAR2;
119 
120   FUNCTION C_P_BUYERFORMULA RETURN VARCHAR2;
121 
122   FUNCTION C_P_CAT_SETFORMULA RETURN VARCHAR2;
123 
124   FUNCTION C_P_ABC_ASSIGNFORMULA RETURN VARCHAR2;
125 
126   FUNCTION C_P_CUTOFF_TYPEFORMULA RETURN VARCHAR2;
127 
128   FUNCTION C_PO_FROMFORMULA RETURN VARCHAR2;
129 
130   FUNCTION C_PO_WHEREFORMULA RETURN VARCHAR2;
131 
132   FUNCTION C_PO_ORDER_NUMFORMULA RETURN VARCHAR2;
133 
134   FUNCTION C_REQ_ORDER_NUMFORMULA RETURN VARCHAR2;
135 
136   FUNCTION C_WIP_ORDER_NUMFORMULA RETURN VARCHAR2;
137 
138   FUNCTION C_P_ABC_CLASSFORMULA RETURN VARCHAR2;
139 
140   FUNCTION C_P_USE_MULTIORG_PLANFORMULA RETURN NUMBER;
141 
142   FUNCTION C_P_REPORT_MULTIORGFORMULA RETURN VARCHAR2;
143 
144 END MRP_MRPRPRSC_XMLP_PKG;
145