PACKAGE: APPS.INV_INVIRSNO_XMLP_PKG

Source

1 PACKAGE INV_INVIRSNO_XMLP_PKG AS
2 /* $Header: INVIRSNOS.pls 120.1 2007/12/25 10:34:26 dwkrishn noship $ */
3   P_ORG NUMBER;
4 
5   P_ITEM_NUM VARCHAR2(15);
6 
7   P_GL_NUM VARCHAR2(15);
8 
9   P_MDSP_NUM VARCHAR2(15);
10 
11   P_MKTS_NUM VARCHAR2(15);
12 
13   P_CONC_REQUEST_ID VARCHAR2(15) := '0';
14 
15   P_ITEM_LO VARCHAR2(240);
16 
17   P_ITEM_HI VARCHAR2(240);
18 
19   P_ITEM_WHERE VARCHAR2(820);
20 
21   P_ITEM_FLEXDATA VARCHAR2(480);
22 
23   P_GL_FLEXDATA VARCHAR2(480);
24 
25   P_MDSP_FLEXDATA VARCHAR2(480);
26 
27   P_MKTS_FLEXDATA VARCHAR2(480);
28 
29   P_SERIAL_LO VARCHAR2(30);
30 
31   P_SERIAL_HI VARCHAR2(30);
32 
33   P_VENDOR_LO VARCHAR2(30);
34 
35   P_VENDOR_HI VARCHAR2(30);
36 
37   P_VEND_SERIAL_LO VARCHAR2(30);
38 
39   P_VEND_SERIAL_HI VARCHAR2(30);
40 
41   P_LOC_FLEXDATA VARCHAR2(480);
42 
43   P_LOC_NUM VARCHAR2(15);
44 
45   P_ITEM_ORDER_BY VARCHAR2(480);
46 
47   P_SOURCE_TYPE NUMBER;
48 
49   P_UNIT_STATUS NUMBER;
50 
51   P_TRACE_FLAG NUMBER;
52 
53   P_OPTIMIZER_CODE NUMBER;
54 
55   FUNCTION WHERE_SERIAL_NUM RETURN VARCHAR2;
56 
57   FUNCTION WHERE_VENDOR RETURN VARCHAR2;
58 
59   FUNCTION WHERE_VEND_SN RETURN VARCHAR2;
60 
61   FUNCTION BEFOREREPORT RETURN BOOLEAN;
62 
63   FUNCTION C_UNIT_STATUS_WHEREFORMULA RETURN VARCHAR2;
64 
65   FUNCTION C_SOURCE_TYPE_WHEREFORMULA RETURN VARCHAR2;
66 
67   FUNCTION AFTERPFORM RETURN BOOLEAN;
68 
69   FUNCTION AFTERREPORT RETURN BOOLEAN;
70 
71 END INV_INVIRSNO_XMLP_PKG;
72