PACKAGE: APPS.WIP_WIPDJDSP_XMLP_PKG

Source

1 PACKAGE WIP_WIPDJDSP_XMLP_PKG AS
2 /* $Header: WIPDJDSPS.pls 120.1 2008/01/31 12:15:43 npannamp noship $ */
3   P_CONC_REQUEST_ID NUMBER := 0;
4 
5   ORG_ID NUMBER;
6 
7   SORT_CODE NUMBER;
8 
9   FROM_DATE DATE;
10 
11   item_id_flex_num number(15);
12 
13   TO_DATE DATE;
14 
15   P_ITEM_DATA VARCHAR2(850);
16 
17   P_FROM_DEPT VARCHAR2(10);
18 
19   P_TO_DEPT VARCHAR2(10);
20 
21   P_QTY_PRECISION NUMBER;
22 
23   QTY_PRECISION varchar2(100);
24 
25   P_INCLUDE_UNRELEASE NUMBER;
26 
27   P_DEBUG NUMBER;
28 
29   P_SCHEDULE_GROUP VARCHAR2(30);
30 
31   P_SG_OUTER VARCHAR2(5) := '(+)';
32 
33   QUANTITY_REM_IN_PREV NUMBER := 0;
34 
35   FUNCTION BEFOREREPORT RETURN BOOLEAN;
36 
37   FUNCTION AFTERREPORT RETURN BOOLEAN;
38 
39   FUNCTION DYNAMIC_ORDER_BY RETURN CHARACTER;
40 
41   FUNCTION DATE_LIMITER RETURN CHARACTER;
42 
43   FUNCTION DEPARTMENT_LIMITER RETURN CHARACTER;
44 
45   FUNCTION C_QUANTITY_IN_PREVFORMULA(WE_ID_p IN NUMBER
46                                     ,OP_SEQ_p IN NUMBER) RETURN NUMBER;
47 
48   FUNCTION QUANTITY_REMAININGFORMULA(STATUS_TYPE IN NUMBER
49                                     ,QUANTITY_SCHEDULED IN NUMBER
50                                     ,QUANTITY_IN_QUEUE IN NUMBER
51                                     ,QUANTITY_RUNNING IN NUMBER
52                                     ,C_QUANTITY_IN_PREV IN NUMBER) RETURN NUMBER;
53 
54   FUNCTION STATUS_LIMITER RETURN CHARACTER;
55 
56   FUNCTION AFTERPFORM RETURN BOOLEAN;
57 
58   FUNCTION C_LIMITER RETURN VARCHAR2;
59 
60   FUNCTION QUANTITY_REM_IN_PREV_P RETURN NUMBER;
61 
62 END WIP_WIPDJDSP_XMLP_PKG;
63