PACKAGE: APPS.WIP_WIPREPCK_XMLP_PKG

Source

1 PACKAGE WIP_WIPREPCK_XMLP_PKG AS
2 /* $Header: WIPREPCKS.pls 120.1 2008/01/31 12:39:13 npannamp noship $ */
3   P_COMP VARCHAR2(850);
4 
5   P_START_DATE1 varchar2(25);
6 
7   P_CONC_REQUEST_ID NUMBER := 0;
8 
9   P_ORGANIZATION_ID NUMBER;
10 
11   P_SUPPLY_LOC VARCHAR2(850);
12 
13   P_DETAIL_LOC VARCHAR2(850);
14 
15   P_SUPPLY_TYPE NUMBER;
16 
17   P_SORT_BY NUMBER;
18 
19   P_FROM_LINE VARCHAR2(10);
20 
21   P_TO_LINE VARCHAR2(10);
22 
23   P_FROM_JOB VARCHAR2(240);
24 
25   P_TO_JOB VARCHAR2(240);
26 
27   P_SUPPLY_SUBINV VARCHAR2(40);
28 
29   P_START_DATE DATE;
30 
31   P_SUPPLY_DAYS NUMBER;
32 
33   QTY VARCHAR2(45);
34 
35   P_TXN_ONLY NUMBER;
36 
37   P_QTY_PRECISION NUMBER;
38 
39   P_DEBUG NUMBER;
40 
41   FUNCTION BEFOREREPORT RETURN BOOLEAN;
42 
43   FUNCTION AFTERREPORT RETURN BOOLEAN;
44 
45   FUNCTION C_LIMIT_SUPPLY_TYPEFORMULA RETURN VARCHAR2;
46 
47   FUNCTION C_LIMIT_SUBINVFORMULA RETURN VARCHAR2;
48 
49   FUNCTION C_P_SUPPLY_TYPEFORMULA RETURN NUMBER;
50 
51   FUNCTION LIMIT_LINES RETURN CHARACTER;
52 
53   FUNCTION LIMIT_JOBS RETURN CHARACTER;
54 
55   FUNCTION ORDER_FUNC(OP_SEQ IN NUMBER
56                      ,SUPPLY_SUBINV IN VARCHAR2
57                      ,C_COMPONENT_DISP IN VARCHAR2
58                      ,DEPARTMENT IN VARCHAR2
59                      ,C_LOCATOR_DISP IN VARCHAR2
60                      ,C_COMP_SORT IN VARCHAR2
61                      ,C_LOC_SORT IN VARCHAR2) RETURN CHARACTER;
62 
63   FUNCTION C_LIMIT_STATUSFORMULA RETURN VARCHAR2;
64 
65   FUNCTION ZEROFORMULA RETURN NUMBER;
66 
67   FUNCTION C_COMP_SORTFORMULA(C_COMP_SORT IN VARCHAR2) RETURN VARCHAR2;
68 
69   FUNCTION C_LOC_SORTFORMULA(LOCATOR_ID IN NUMBER
70                             ,C_LOC_SORT IN VARCHAR2) RETURN VARCHAR2;
71 
72   FUNCTION AFTERPFORM RETURN BOOLEAN;
73   function get_precision(qty_precision in number) return VARCHAR2;
74 
75 END WIP_WIPREPCK_XMLP_PKG;
76