[Home] [Help]
PACKAGE: APPS.MRP_MRPRPLOR_XMLP_PKG
Source
1 PACKAGE MRP_MRPRPLOR_XMLP_PKG AS
2 /* $Header: MRPRPLORS.pls 120.2 2007/12/25 08:31:56 nchinnam noship $ */
3 P_ORG_ID VARCHAR2(22);
4
5 P_ADVANCE_NOTICE_DATE DATE;
6
7 LP_ADVANCE_NOTICE_DATE VARCHAR2(20);
8
9 P_FLEXDATA_ITEM VARCHAR2(750);
10
11 P_CONC_REQUEST_ID NUMBER := 0;
12
13 P_STRUCT_NUM VARCHAR2(15);
14
15 P_SORT VARCHAR2(22);
16
17 P_PLANNER VARCHAR2(10);
18
19 P_BUYER VARCHAR2(22);
20
21 P_LOW_ITEM VARCHAR2(240);
22
23 P_HIGH_ITEM VARCHAR2(240);
24
25 P_CAT_SET 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_PLAN_NAME VARCHAR2(10);
36
37 P_ITEM_RANGE VARCHAR2(750);
38
39 P_CAT_RANGE VARCHAR2(750);
40
41 P_ORDER_BY VARCHAR2(300);
42
43 P_DEBUG VARCHAR2(1);
44
45 P_CAL_CODE VARCHAR2(10);
46
47 P_CAL_EXCEPTION_SET_ID NUMBER;
48
49 P_CAT_STRUCT VARCHAR2(22);
50
51 P_QTY_PRECISION VARCHAR2(40);
52
53 P_ITEM_ORDER_BY VARCHAR2(300);
54
55 P_CAT_STRUCT_NUM NUMBER;
56
57 P_ORG_TYPE VARCHAR2(40);
58
59 FUNCTION C_PLANNER_RANGEFORMULA RETURN VARCHAR2;
60
61 FUNCTION C_BUYER_RANGEFORMULA RETURN VARCHAR2;
62
63 FUNCTION C_CATEGORY_FROMFORMULA RETURN VARCHAR2;
64
65 FUNCTION C_SORT_COLUMNFORMULA RETURN VARCHAR2;
66
67 FUNCTION C_ORDER_BYFORMULA RETURN VARCHAR2;
68
69 FUNCTION C_ABC_WHEREFORMULA RETURN VARCHAR2;
70
71 FUNCTION C_ABC_FROMFORMULA RETURN VARCHAR2;
72
73 FUNCTION C_ABC_RANGEFORMULA RETURN VARCHAR2;
74
75 FUNCTION C_CATEGORY_WHEREFORMULA RETURN VARCHAR2;
76
77 FUNCTION BEFOREREPORT RETURN BOOLEAN;
78
79 FUNCTION AFTERREPORT RETURN BOOLEAN;
80
81 FUNCTION C_SORT_PFORMULA RETURN VARCHAR2;
82
83 FUNCTION C_BUYER_PFORMULA RETURN VARCHAR2;
84
85 FUNCTION C_CAT_SET_PFORMULA RETURN VARCHAR2;
86
87 FUNCTION C_ABC_ASSGN_PFORMULA RETURN VARCHAR2;
88
89 FUNCTION C_ABC_CLASS_PFORMULA RETURN VARCHAR2;
90
91 FUNCTION C_P_MULTI_ORGFORMULA RETURN NUMBER;
92
93 FUNCTION C_P_ORG_TYPEFORMULA RETURN VARCHAR2;
94
95 END MRP_MRPRPLOR_XMLP_PKG;
96
97