PACKAGE: APPS.MRP_MRPRPSST_XMLP_PKG

Source

1 PACKAGE MRP_MRPRPSST_XMLP_PKG AS
2 /* $Header: MRPRPSSTS.pls 120.2 2007/12/25 08:34:55 nchinnam noship $ */
3   P_ORG_ID NUMBER;
4 
5   P_FLEXDATA_ITEM VARCHAR2(750);
6 
7   P_CONC_REQUEST_ID NUMBER := 0;
8 
9   P_STRUCT_NUM VARCHAR2(15);
10 
11   P_SORT NUMBER;
12 
13   P_LOW_ITEM VARCHAR2(240);
14   format_string VARCHAR2(20);
15 
16   P_HIGH_ITEM VARCHAR2(240);
17 
18   P_CAT_SET VARCHAR2(22);
19 
20   P_LOW_CAT VARCHAR2(240);
21 
22   P_HIGH_CAT VARCHAR2(240);
23 
24   P_SCHED_NAME VARCHAR2(10);
25 
26   P_ITEM_RANGE VARCHAR2(750);
27 
28   P_CAT_RANGE VARCHAR2(750);
29 
30   P_ORDER_BY VARCHAR2(300);
31 
32   P_DEBUG VARCHAR2(1);
33 
34   P_PRECISION NUMBER := 2;
35 
36   P_CURRENCY_CODE VARCHAR2(15);
37 
38   P_SCHED_VERSION NUMBER;
39 
40   P_START_DATE DATE;
41   LP_START_DATE varchar2(11);
42 
43   P_WEEKS NUMBER;
44 
45   P_PERIODS NUMBER;
46 
47   P_CAT_STRUCT VARCHAR2(22);
48 
49   P_SCHED_TYPE NUMBER;
50 
51   P_QUERY_ID NUMBER;
52 
53   P_CAL_CODE VARCHAR2(10);
54 
55   P_CAL_EXCEPTION_SET_ID NUMBER;
56 
57   P_PERIODS_ACTUAL NUMBER;
58 
59   P_QTY_PRECISION VARCHAR2(40);
60 
61   P_CURRENCY_DESC VARCHAR2(80);
62 
63   P_SCHED_TYPE_DESC VARCHAR2(80);
64 
65   P_SCHED_VERSION_DESC VARCHAR2(80);
66 
67   P_CAT_STRUCT_NUM NUMBER;
68 
69   P_REPORT_MULTIORG NUMBER;
70 
71   FUNCTION AFTERREPORT RETURN BOOLEAN;
72 
73   FUNCTION C_PERIOD_DELTAFORMULA(C_ACTUAL_SUM IN NUMBER
74                                 ,C_SCHED_SUM IN NUMBER) RETURN NUMBER;
75 
76   FUNCTION C_SCHED_COSTFORMULA(C_SCHED_SUM IN NUMBER
77                               ,C_ITEM_COST IN NUMBER) RETURN NUMBER;
78 
79   FUNCTION C_PERIOD_DELTA_COSTFORMULA(C_PERIOD_DELTA IN NUMBER
80                                      ,C_ITEM_COST IN NUMBER) RETURN NUMBER;
81 
82   FUNCTION C_PERIOD_DELTA_CUM_COSTFORMULA(C_PERIOD_DELTA_CUM IN NUMBER
83                                          ,C_ITEM_COST IN NUMBER) RETURN NUMBER;
84 
85   FUNCTION C_ACTUAL_COSTFORMULA(C_ACTUAL_SUM IN NUMBER
86                                ,C_ITEM_COST IN NUMBER) RETURN NUMBER;
87 
88   FUNCTION C_SCHED_VERSIONFORMULA RETURN VARCHAR2;
89 
90   FUNCTION C_SORTFORMULA RETURN VARCHAR2;
91 
92   FUNCTION C_CAT_SETFORMULA RETURN VARCHAR2;
93 
94   FUNCTION C_CATEGORY_FROMFORMULA RETURN VARCHAR2;
95 
96   FUNCTION C_CATEGORY_WHEREFORMULA RETURN VARCHAR2;
97 
98   FUNCTION BEFOREREPORT RETURN BOOLEAN;
99 
100   FUNCTION C_P_MULTIORG_MPSFORMULA RETURN NUMBER;
101 
102   FUNCTION C_ORDER_BYFORMULA RETURN VARCHAR2;
103 
104   FUNCTION C_P_REPORT_MULTIORGFORMULA RETURN VARCHAR2;
105 
106   FUNCTION C_P_USE_MULTIORG_PLANFORMULA RETURN NUMBER;
107 
108   /*PROCEDURE MRP_WEEKS_MONTHS(ARG_QUERY_ID IN NUMBER
109                             ,ARG_USER_ID IN NUMBER
110                             ,ARG_WEEKS IN NUMBER
111                             ,ARG_PERIODS IN NUMBER
112                             ,ARG_START_DATE IN DATE
113                             ,ARG_ORG_ID IN NUMBER);*/
114 
115   PROCEDURE MRP_WEEKS_MONTHS(ARG_QUERY_ID IN NUMBER
116                             ,ARG_USER_ID IN NUMBER
117                             ,ARG_WEEKS IN NUMBER
118                             ,ARG_PERIODS IN NUMBER
119                             ,ARG_START_DATE IN DATE
120                             ,ARG_ORG_ID IN NUMBER);
121 
122 END MRP_MRPRPSST_XMLP_PKG;
123