PACKAGE: APPS.WIP_WIPLBPER_XMLP_PKG

Source

1 PACKAGE WIP_WIPLBPER_XMLP_PKG AUTHID CURRENT_USER AS
2 /* $Header: WIPLBPERS.pls 120.1 2008/01/31 12:25:54 npannamp noship $ */
3   P_QTY_PRECISION NUMBER;
4 
5   P_FROM_DATE DATE;
6 
7   P_TO_DATE DATE;
8 
9    P_FROM_DATE1 varchar2(15);
10 
11   P_TO_DATE1 varchar2(15);
12 
13 
14 
15   P_FROM_RESOURCE VARCHAR2(10);
16 
17   P_TO_RESOURCE VARCHAR2(10);
18 
19   P_FROM_DEPARTMENT VARCHAR2(10);
20 
21   P_TO_DEPARTMENT VARCHAR2(10);
22 
23   P_MINIMUM_EFFICIENCY NUMBER;
24 
25   P_MAXIMUM_EFFICIENCY NUMBER;
26 
27   P_ORGANIZATION_ID NUMBER;
28 
29   CP_CURRENCY_CODE VARCHAr2(30);
30 
31   P_DEBUG NUMBER;
32 
33   P_CONC_REQUEST_ID NUMBER;
34 
35   FUNCTION LIMIT_EFFICIENCY(C_EFF_TOTAL_MAIN IN NUMBER) RETURN BOOLEAN;
36 
37   FUNCTION LIMIT_DEPT RETURN CHARACTER;
38 
39   FUNCTION LIMIT_RESOURCE RETURN CHARACTER;
40 
41   FUNCTION LIMIT_JOB_DATES RETURN CHARACTER;
42 
43   FUNCTION C_STD_UNITSFORMULA(BASIS_TYPE IN NUMBER
44                              ,USAGE_RATE1 IN NUMBER
45                              ,ASSY_UNITS1 IN NUMBER
46                              ,USAGE_RATE IN NUMBER) RETURN NUMBER;
47 
48   FUNCTION C_EFFICIENCYFORMULA(APPLIED IN NUMBER
49                               ,C_STD_UNITS IN NUMBER) RETURN NUMBER;
50 
51   FUNCTION C_EFF_TOTAL_MAINFORMULA(C_APPLIED_TOTAL IN NUMBER
52                                   ,C_STD_TOTAL IN NUMBER) RETURN NUMBER;
53 
54   FUNCTION C_EFF_FLAGFORMULA(C_EFF_TOTAL_MAIN IN NUMBER) RETURN NUMBER;
55 
56   FUNCTION BEFOREREPORT RETURN BOOLEAN;
57 
58   FUNCTION AFTERREPORT RETURN BOOLEAN;
59 
60   FUNCTION AFTERPFORM RETURN BOOLEAN;
61 
62   FUNCTION C_LIMIT_DATE_FLOWFORMULA RETURN CHAR;
63 
64 END WIP_WIPLBPER_XMLP_PKG;
65