PACKAGE: APPS.WIP_WIPDJPCK_XMLP_PKG

Source

1 PACKAGE WIP_WIPDJPCK_XMLP_PKG AS
2 /* $Header: WIPDJPCKS.pls 120.2 2008/01/31 12:21:47 npannamp noship $ */
3   P_ASSY VARCHAR2(850);
4 
5   P_COMP VARCHAR2(850);
6 
7   P_CONC_REQUEST_ID NUMBER := 0;
8 
9   P_ORGANIZATION_ID NUMBER;
10 
11   P_SUPPLY_TYPE NUMBER;
12 
13   P_SORT_BY NUMBER;
14 
15   P_FROM_JOB VARCHAR2(240);
16 
17   P_TO_JOB VARCHAR2(240);
18 
19   P_FROM_DATE DATE;
20 
21   P_TO_DATE DATE;
22 
23   P_SUPPLY_SUBINV VARCHAR2(40);
24 
25   P_SUPPLY_LOC VARCHAR2(850);
26 
27   P_DETAIL_LOC VARCHAR2(850);
28 
29   P_TXN_ONLY NUMBER;
30 
31   item_id_flex_num number;
32 
33   P_QTY_PRECISION NUMBER;
34 
35   QTY_PRECISION varchar2(40);
36 
37   P_DEBUG NUMBER;
38 
39   P_SCHEDULE_GROUP_FROM VARCHAR2(30);
40 
41   P_SCHEDULE_GROUP_TO VARCHAR2(30);
42 
43   P_SG_OUTER VARCHAR2(10) := '(+)';
44 
45   FUNCTION BEFOREREPORT RETURN BOOLEAN;
46 
47   FUNCTION AFTERREPORT RETURN BOOLEAN;
48 
49   FUNCTION C_LIMIT_SUPPLY_TYPEFORMULA RETURN VARCHAR2;
50 
51   FUNCTION LIMIT_JOBS RETURN CHARACTER;
52 
53   FUNCTION DATE_LIMITER RETURN CHARACTER;
54 
55   FUNCTION C_LIMIT_SUBINVFORMULA RETURN VARCHAR2;
56 
57   FUNCTION C_P_SUPPLY_TYPEFORMULA RETURN NUMBER;
58 
59   FUNCTION ORDER_FUNC(COMPONENT IN VARCHAR2
60                      ,SUPPLY_LOCATOR IN VARCHAR2
61                      ,C_COMPONENT_DISP IN VARCHAR2
62                      ,C_LOCATOR_DISP IN VARCHAR2
63                      ,C_COMP_SORT IN VARCHAR2
64                      ,C_LOC_SORT IN VARCHAR2
65                      ,SUPPLY_SUBINV IN VARCHAR2
66                      ,OP_SEQ IN NUMBER
67                      ,DATE_REQUIRED IN DATE
68                      ,ITEM_SEQ IN NUMBER) RETURN CHARACTER;
69 
70   FUNCTION C_LIMIT_STATUSFORMULA RETURN VARCHAR2;
71 
72   FUNCTION ZEROFORMULA RETURN NUMBER;
73 
74   FUNCTION C_COMP_SORTFORMULA(C_COMPONENT_DISP IN VARCHAR2
75                              ,C_COMP_SORT IN VARCHAR2) RETURN VARCHAR2;
76 
77   FUNCTION C_LOC_SORTFORMULA(C_LOCATOR_DISP IN VARCHAR2
78                             ,LOCATOR_ID IN NUMBER
79                             ,C_LOC_SORT IN VARCHAR2) RETURN VARCHAR2;
80 
81   FUNCTION AFTERPFORM RETURN BOOLEAN;
82 
83   FUNCTION C_LIMITER RETURN VARCHAR2;
84 
85 END WIP_WIPDJPCK_XMLP_PKG;
86