PACKAGE: APPS.GML_POR03USR_XMLP_PKG

Source

1 PACKAGE GML_POR03USR_XMLP_PKG AS
2 /* $Header: POR03USRS.pls 120.0 2007/12/24 13:29:09 nchinnam noship $ */
3   P_ORGN_CODE VARCHAR2(4);
4 
5   P_RETURN_NO_FROM VARCHAR2(32);
6 
7   P_RETURN_NO_TO VARCHAR2(32);
8 
9   P_RETURN_DATE_FROM DATE;
10 
11   P_RETURN_DATE_TO DATE;
12 
13   CP_RETURN_DATE_FROM VARCHAR2(20);
14 
15   CP_RETURN_DATE_TO VARCHAR2(20);
16 
17   P_VENDOR_NO_FROM VARCHAR2(32);
18 
19   P_VENDOR_NO_TO VARCHAR2(32);
20 
21   P_RETURN_CODE_FROM VARCHAR2(4);
22 
23   P_RETURN_CODE_TO VARCHAR2(4);
24 
25   P_ITEM_NO_FROM VARCHAR2(32);
26 
27   P_ITEM_NO_TO VARCHAR2(32);
28 
29   P_WHSE_CODE_FROM VARCHAR2(4);
30 
31   P_WHSE_CODE_TO VARCHAR2(4);
32 
33   P_LOT_NO_FROM VARCHAR2(32);
34 
35   P_LOT_NO_TO VARCHAR2(32);
36 
37   P_SUBLOT_NO_FROM VARCHAR2(32);
38 
39   P_SUBLOT_NO_TO VARCHAR2(32);
40 
41   P_PO_RETURNS VARCHAR2(3);
42 
43   P_STOCK_RETURNS VARCHAR2(3);
44 
45   PARAM_WHERE_CLAUSE VARCHAR2(1500);
46 
47   P_ORGN_CODE_1 VARCHAR2(4);
48 
49   P_USER_ID VARCHAR2(32);
50 
51   NONBLOCKSQK VARCHAR2(5);
52 
53   P_CONC_REQUEST_ID NUMBER;
54 
55   CP_ROWS NUMBER;
56 
57   CP_ORGN_NAME VARCHAR2(100);
58 
59   FUNCTION AFTERPFORM RETURN BOOLEAN;
60 
61   FUNCTION BEFOREREPORT RETURN BOOLEAN;
62 
63   FUNCTION AFTERREPORT RETURN BOOLEAN;
64 
65   FUNCTION CP_ROWS_P RETURN NUMBER;
66 
67   FUNCTION CP_ORGN_NAME_P RETURN VARCHAR2;
68 
69   PRN_ROWS NUMBER;
70 
71 END GML_POR03USR_XMLP_PKG;
72