[Home] [Help]
PACKAGE: APPS.INV_INVIRSNO_XMLP_PKG
Source
1 PACKAGE INV_INVIRSNO_XMLP_PKG AUTHID CURRENT_USER 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