[Home] [Help]
PACKAGE: APPS.MRP_MRPRPPLO_XMLP_PKG
Source
1 PACKAGE MRP_MRPRPPLO_XMLP_PKG AS
2 /* $Header: MRPRPPLOS.pls 120.3 2008/01/02 13:06:35 nchinnam noship $ */
3 P_ORG_ID VARCHAR2(22);
4
5 P_ITEM_SELECT VARCHAR2(22);
6
7 P_FLEXDATA_ITEM VARCHAR2(750);
8
9 P_CONC_REQUEST_ID NUMBER := 0;
10
11 P_STRUCT_NUM VARCHAR2(15);
12
13 P_CUTOFF_DATE DATE;
14
15 P_CUTOFF_DATE_1 varchar2(20);
16
17 P_INCLUDE_COST VARCHAR2(22);
18
19 P_SORT VARCHAR2(22);
20
21 P_PLANNER VARCHAR2(10);
22
23 P_BUYER VARCHAR2(22);
24
25 P_LOW_ITEM VARCHAR2(240);
26
27 P_HIGH_ITEM VARCHAR2(240);
28
29 P_CAT_SET VARCHAR2(22);
30
31 P_LOW_CAT VARCHAR2(240);
32
33 P_HIGH_CAT VARCHAR2(240);
34
35 P_ABC_ASSGN VARCHAR2(22);
36
37 P_ABC_CLASS VARCHAR2(22);
38
39 P_CUTOFF_TYPE VARCHAR2(22);
40
41 P_PLAN_NAME VARCHAR2(10);
42
43 P_CUTOFF_COLUMN VARCHAR2(100);
44
45 P_ITEM_RANGE VARCHAR2(750);
46
47 P_CAT_RANGE VARCHAR2(750);
48
49 P_ORDER_BY VARCHAR2(300);
50
51 P_DEBUG VARCHAR2(1);
52
53 P_PRECISION NUMBER;
54
55 P_CURRENCY_CODE VARCHAR2(15);
56
57 P_CURRENCY_DESC VARCHAR2(80);
58
59 P_CAT_STRUCT VARCHAR2(22);
60
61 P_QTY_PRECISION VARCHAR2(40);
62
63 P_ITEM_ORDER_BY VARCHAR2(500);
64
65 P_CAT_STRUCT_NUM NUMBER;
66
67 P_ORG_TYPE VARCHAR2(40);
68
69 QTY_PRECISION varchar2(25);
70
71 FUNCTION BEFOREREPORT RETURN BOOLEAN;
72
73 FUNCTION AFTERREPORT RETURN BOOLEAN;
74
75 FUNCTION C_PLANNER_RANGEFORMULA RETURN VARCHAR2;
76
77 FUNCTION CP_order(P_ORDER_BY1 varchar2,P_ORDER_BY2 varchar2) RETURN VARCHAR2;
78
79 FUNCTION C_BUYER_RANGEFORMULA RETURN VARCHAR2;
80
81 FUNCTION C_CATEGORY_FROMFORMULA RETURN VARCHAR2;
82
83 FUNCTION C_SORT_COLUMNFORMULA RETURN VARCHAR2;
84
85 FUNCTION C_ABC_WHEREFORMULA RETURN VARCHAR2;
86
87 FUNCTION C_CUTOFF_COLUMNFORMULA RETURN VARCHAR2;
88
89 FUNCTION C_ABC_FROMFORMULA RETURN VARCHAR2;
90
91 FUNCTION C_ABC_RANGEFORMULA RETURN VARCHAR2;
92
93 FUNCTION C_CATEGORY_WHEREFORMULA RETURN VARCHAR2;
94
95 FUNCTION C_ORDER_BYFORMULA(P_ITEM_ORDER_BY varchar2) return VARCHAR2;
96
97 FUNCTION C_P_ITEM_SELECTFORMULA RETURN VARCHAR2;
98
99 FUNCTION C_P_INCLUDE_COSTFORMULA RETURN VARCHAR2;
100
101 FUNCTION C_P_SORTFORMULA RETURN VARCHAR2;
102
103 FUNCTION C_P_BUYERFORMULA RETURN VARCHAR2;
104
105 FUNCTION C_P_CAT_SETFORMULA RETURN VARCHAR2;
106
107 FUNCTION C_P_ABC_ASSGNFORMULA RETURN VARCHAR2;
108
109 FUNCTION C_P_CUTOFF_TYPEFORMULA RETURN VARCHAR2;
110
111 FUNCTION C_P_MULTI_ORGFORMULA RETURN NUMBER;
112
113 FUNCTION C_P_ORG_TYPEFORMULA RETURN VARCHAR2;
114
115 END MRP_MRPRPPLO_XMLP_PKG;
116