PACKAGE: APPS.INV_INVTRSNT_XMLP_PKG

Source

1 PACKAGE INV_INVTRSNT_XMLP_PKG AUTHID CURRENT_USER AS
2 /* $Header: INVTRSNTS.pls 120.1 2007/12/25 11:14:06 dwkrishn noship $ */
3   P_CONC_REQUEST_ID NUMBER := 0;
4 
5   P_STRUCT_NUM VARCHAR2(15);
6 
7   P_CATG_STRUCT_NUM VARCHAR2(15);
8 
9   P_ITEM_FLEXDATA VARCHAR2(300);
10 
11   P_CATG_FLEXDATA VARCHAR2(380);
12 
13   P_LOC_FLEXDATA VARCHAR2(320);
14 
15   P_MKTS_FLEXDATA VARCHAR2(380);
16 
17   P_GLCC_FLEXDATA VARCHAR2(380);
18 
19   P_MDSP_FLEXDATA VARCHAR2(380);
20 
21   P_ITEM_WHERE VARCHAR2(600);
22 
23   P_CATG_WHERE VARCHAR2(600);
24 
25   P_ITEM_ORDER_BY VARCHAR2(380);
26 
27   P_CATG_ORDER_BY VARCHAR2(380);
28 
29   P_CATG_SET_ID NUMBER;
30 
31   P_CATG_LO VARCHAR2(240);
32 
33   P_CATG_HI VARCHAR2(240);
34 
35   P_ITEM_LO VARCHAR2(820);
36 
37   P_ITEM_HI VARCHAR2(820);
38 
39   P_TXN_DATE_LO DATE;
40 
41   P_TXN_DATE_HI DATE;
42 
43   P_QTY_PRECISION NUMBER;
44 
45   P_REASON_LO VARCHAR2(100);
46 
47   P_REASON_HI VARCHAR2(100);
48 
49   P_SUBINV_LO VARCHAR2(10);
50 
51   P_SUBINV_HI VARCHAR2(10);
52 
53   P_TXN_TYPE_LO VARCHAR2(100);
54 
55   P_TXN_TYPE_HI VARCHAR2(100);
56 
57   P_RPT_QTY_TYPE NUMBER;
58 
59   P_RPT_UOM_TYPE NUMBER;
60 
61   P_AUDIT_DETAIL NUMBER;
62 
63   P_REASON_DETAIL NUMBER;
64 
65   P_LOT_DETAIL NUMBER;
66 
67   P_CATEGORY_DETAIL NUMBER;
68 
69   P_LOC_DETAIL NUMBER;
70 
71   P_TXN_SOURCE_TYPE_ID VARCHAR2(38);
72 
73   P_TXN_SOURCE_LO VARCHAR2(240);
74 
75   P_TXN_SOURCE_HI VARCHAR2(240);
76 
77   P_RPT_UOM NUMBER;
78 
79   P_ORG_ID NUMBER;
80 
81   P_SOURCE_WHERE VARCHAR2(1200);
82 
83   P_ORDER_SOURCE VARCHAR2(1200);
84 
85   P_BREAK_ID NUMBER;
86 
87   P_GLCC_STRUCT_NUM VARCHAR2(15);
88 
89   P_MKTS_ORDER_BY VARCHAR2(600);
90 
91   P_GLCC_ORDER_BY VARCHAR2(600);
92 
93   P_MDSP_ORDER_BY VARCHAR2(600);
94 
95   P_SERIAL_LO VARCHAR2(30);
96 
97   P_SERIAL_HI VARCHAR2(30);
98 
99   P_TRACE_FLAG NUMBER;
100 
101   P_OPTIMIZER_CODE NUMBER;
102 
103   P_G_ORG NUMBER;
104 
105   P_DUMMY_VALIDATE NUMBER;
106 
107   P_DUMMY NUMBER;
108 
109   FUNCTION P_STRUCT_NUMVALIDTRIGGER RETURN BOOLEAN;
110 
111   FUNCTION WHERE_SERIAL RETURN VARCHAR2;
112 
113   FUNCTION C_LOT_FROMFORMULA RETURN VARCHAR2;
114 
115   FUNCTION C_LOT_COLUMNFORMULA RETURN VARCHAR2;
116 
117   FUNCTION WHERE_REASON RETURN VARCHAR2;
118 
119   FUNCTION WHERE_SUBINV RETURN VARCHAR2;
120 
121   FUNCTION WHERE_TXN_TYPE RETURN VARCHAR2;
122 
123   FUNCTION C_DATE_WHEREFORMULA RETURN VARCHAR2;
124 
125   FUNCTION BEFOREREPORT RETURN BOOLEAN;
126 
127   FUNCTION C_SOURCE_WHEREFORMULA RETURN VARCHAR2;
128 
129   FUNCTION C_TYPE_BREAK_COLUMNFORMULA RETURN VARCHAR2;
130 
131   FUNCTION C_TYPE_BREAK_FROMFORMULA RETURN VARCHAR2;
132 
133   FUNCTION C_TYPE_BREAK_WHEREFORMULA RETURN VARCHAR2;
134 
135   FUNCTION C_REPORT_DATE_CURRENCY_TITFORM(C_CURRENCY_CODE IN VARCHAR2) RETURN VARCHAR2;
136 
137   FUNCTION C_ORDER_BYFORMULA RETURN VARCHAR2;
138 
139   FUNCTION P_MDSP_ORDER_BYVALIDTRIGGER RETURN BOOLEAN;
140 
141   FUNCTION AFTERREPORT RETURN BOOLEAN;
142 
143   FUNCTION CALC_UNIT_COST(TOT_QTY IN NUMBER
144                          ,EXTD_COST IN NUMBER
145                          ,C_EXT_PRECISION IN VARCHAR2) RETURN NUMBER;
146 
147   FUNCTION AFTERPFORM RETURN BOOLEAN;
148 
149   FUNCTION C_SOURCE_TYPE_WHEREFORMULA RETURN VARCHAR2;
150 
151 END INV_INVTRSNT_XMLP_PKG;
152