PACKAGE: APPS.MRP_MRPRPPIT_XMLP_PKG

Source

1 PACKAGE MRP_MRPRPPIT_XMLP_PKG AUTHID CURRENT_USER AS
2 /* $Header: MRPRPPITS.pls 120.2 2007/12/25 08:32:58 nchinnam noship $ */
3   P_ORG_ID VARCHAR2(40);
4 
5   P_ORG_TYPE VARCHAR2(40);
6 
7   P_PLAN_NAME VARCHAR2(40);
8 
9   P_COST_TYPE NUMBER;
10 
11   P_PRECISION VARCHAR2(40);
12 
13   P_QUERY_ID NUMBER;
14 
15   P_DEBUG VARCHAR2(1);
16 
17   P_PERIODS NUMBER;
18 
19   P_PERIODS_ACTUAL NUMBER;
20 
21   P_WEEKS NUMBER;
22 
23   P_CURRENCY_CODE VARCHAR2(15);
24 
25   P_CURRENCY_DESC VARCHAR2(80);
26 
27   P_CONC_REQUEST_ID NUMBER := 0;
28 
29   P_START_DATE DATE;
30 
31   P_MSG_BUF VARCHAR2(100);
32 
33   FUNCTION C_PLANNED_ORG_CODEFORMULA(C_PLANNED_ORGANIZATION IN NUMBER) RETURN VARCHAR2;
34 
35   FUNCTION C_COST_TYPEFORMULA RETURN VARCHAR2;
36 
37   FUNCTION BEFOREREPORT RETURN BOOLEAN;
38 
39   FUNCTION C_P_MULTI_ORGFORMULA RETURN NUMBER;
40 
41   FUNCTION AFTERREPORT RETURN BOOLEAN;
42 
43   FUNCTION C_BEGIN_INV_D2FORMULA(C_BEGIN_INV_D IN VARCHAR2) RETURN VARCHAR2;
44 
45   PROCEDURE MRP_WEEKS_MONTHS(ARG_QUERY_ID IN NUMBER
46                             ,ARG_USER_ID IN NUMBER
47                             ,ARG_WEEKS IN NUMBER
48                             ,ARG_PERIODS IN NUMBER
49                             ,ARG_START_DATE IN DATE
50                             ,ARG_ORG_ID IN NUMBER);
51 
52   PROCEDURE MRP_CALCULATE_INVENTORY_TURNS(ARG_QUERY_ID IN NUMBER
53                                          ,ARG_ORG_ID IN NUMBER
54                                          ,ARG_COMPILE_DESIG IN VARCHAR2
55                                          ,ARG_SCHED_DESIG IN VARCHAR2
56                                          ,ARG_COST_TYPE IN NUMBER
57                                          ,ARG_DEF_COST_TYPE IN NUMBER);
58 
59 END MRP_MRPRPPIT_XMLP_PKG;
60