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