PACKAGE: APPS.GML_PORIRUSR_XMLP_PKG

Source

1 PACKAGE GML_PORIRUSR_XMLP_PKG AS
2 /* $Header: PORIRUSRS.pls 120.0 2007/12/24 13:29:55 nchinnam noship $ */
3   P_RECV_DATE_FROM DATE;
4 
5   CP_RECV_DATE_FROM VARCHAR2(20);
6 
7   CP_RECV_DATE_TO VARCHAR2(20);
8 
9   P_RECV_DATE_TO DATE;
10 
11   P_ITEM_NO_FROM VARCHAR2(32);
12 
13   P_ITEM_NO_TO VARCHAR2(32);
14 
15   P_TO_WHSE_FROM VARCHAR2(4);
16 
17   P_TO_WHSE_TO VARCHAR2(4);
18 
19   P_SORT_BY VARCHAR2(12);
20 
21   NONBLOCKSQL VARCHAR2(5);
22 
23   PARAM_WHERE_CLAUSE VARCHAR2(500);
24 
25   P_CONC_REQUEST_ID NUMBER;
26 
27   CP_ROWS NUMBER;
28 
29   FUNCTION BEFOREREPORT RETURN BOOLEAN;
30 
31   FUNCTION LOT_NOFORMULA(ITEM_ID IN NUMBER
32                         ,LOT_ID IN NUMBER) RETURN VARCHAR2;
33 
34   FUNCTION SUBLOT_NOFORMULA(ITEM_ID IN NUMBER
35                            ,LOT_ID IN NUMBER) RETURN VARCHAR2;
36 
37   FUNCTION SORTRETCFFORMULA RETURN VARCHAR2;
38 
39   FUNCTION AFTERPFORM RETURN BOOLEAN;
40 
41   FUNCTION AFTERREPORT RETURN BOOLEAN;
42 
43   FUNCTION CP_ROWS_P RETURN NUMBER;
44 
45   PRN_ROWS NUMBER;
46 
47   FTR_FLAG NUMBER;
48 
49 END GML_PORIRUSR_XMLP_PKG;
50