DBA Data[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