[Home] [Help]
PACKAGE: APPS.BOM_CSTREIVR_XMLP_PKG
Source
1 PACKAGE BOM_CSTREIVR_XMLP_PKG AUTHID CURRENT_USER AS
2 /* $Header: CSTREIVRS.pls 120.0 2007/12/24 09:57:20 dwkrishn noship $ */
3 P_CONC_REQUEST_ID VARCHAR2(32767) := '0';
4
5 P_ORG_ID VARCHAR2(40);
6
7 P_CURRENCY_CODE VARCHAR2(15);
8
9 P_EXCHANGE_RATE NUMBER := 1;
10
11 P_SORT_OPTION NUMBER;
12
13 P_RPT_OPTION NUMBER;
14
15 P_ITEM_FROM VARCHAR2(800);
16
17 P_ITEM_TO VARCHAR2(800);
18
19 P_CATEGORY_SET NUMBER;
20
21 P_CAT_NUM NUMBER;
22
23 P_CAT_FROM VARCHAR2(800);
24
25 P_CAT_TO VARCHAR2(800);
26
27 P_SUBINV_FROM VARCHAR2(10);
28
29 P_SUBINV_TO VARCHAR2(10);
30
31 P_NEG_QTY NUMBER;
32
33 P_ZERO_COST NUMBER;
34
35 P_ORGANIZATION VARCHAR2(240);
36
37 ROUND_UNIT NUMBER := 1;
38
39 P_ITEM_SEG VARCHAR2(2400);
40
41 P_CAT_SEG VARCHAR2(2400);
42
43 P_ITEM_WHERE VARCHAR2(2400) := '1 = 1';
44
45 P_CAT_WHERE VARCHAR2(2400) := '1 = 1';
46
47 P_SORT_BY VARCHAR2(80);
48
49 P_CAT_SET_NAME VARCHAR2(40);
50
51 P_GL_NUM NUMBER;
52
53 P_DETAIL_LEVEL VARCHAR2(80);
54
55 P_COST_TYPE_ID NUMBER;
56
57 P_DEF_COST_TYPE NUMBER := 1;
58
59 P_COST_TYPE VARCHAR2(10);
60
61 P_TRACE VARCHAR2(1);
62
63 P_ZERO_QTY NUMBER;
64
65 P_EXP_ITEM NUMBER;
66
67 P_QTY_WHERE VARCHAR2(800);
68
69 P_QTY_PRECISION NUMBER;
70
71 P_UNCOSTED_TXN VARCHAR2(40);
72
73 P_SESSIONID NUMBER;
74
75 P_CURRENCY_DSP VARCHAR2(50);
76
77 P_VIEW_COST NUMBER;
78
79 P_COST_ORG_ID NUMBER;
80
81 P_EXCHANGE_RATE_CHAR VARCHAR2(38);
82
83 P_EXP_SUB NUMBER;
84
85 P_AS_OF_DATE VARCHAR2(30);
86
87 P_AS_OF_DATE1 VARCHAR2(30);
88
89 P_TITLE VARCHAR2(240);
90
91 P_INTRANSIT NUMBER;
92
93 FUNCTION BEFOREREPORT RETURN BOOLEAN;
94
95 FUNCTION AFTERREPORT RETURN BOOLEAN;
96
97 FUNCTION AFTERPFORM RETURN BOOLEAN;
98
99 FUNCTION IC_MATL1FORMULA(IC_QUANTITY IN NUMBER
100 ,IC_MATL IN NUMBER) RETURN NUMBER;
101
102 FUNCTION IC_MOVH1FORMULA(IC_QUANTITY IN NUMBER
103 ,IC_MOVH IN NUMBER) RETURN NUMBER;
104
105 FUNCTION IC_RES1FORMULA(IC_QUANTITY IN NUMBER
106 ,IC_RES IN NUMBER) RETURN NUMBER;
107
108 FUNCTION IC_OSP1FORMULA(IC_QUANTITY IN NUMBER
109 ,IC_OSP IN NUMBER) RETURN NUMBER;
110
111 FUNCTION IC_OVHD1FORMULA(IC_QUANTITY IN NUMBER
112 ,IC_OVHD IN NUMBER) RETURN NUMBER;
113
114 FUNCTION IC_TOTAL1FORMULA(IC_QUANTITY IN NUMBER
115 ,IC_TOTAL IN NUMBER) RETURN NUMBER;
116
117 FUNCTION SI_MATL1FORMULA(SI_QUANTITY IN NUMBER
118 ,SI_MATL IN NUMBER) RETURN NUMBER;
119
120 FUNCTION SI_MOVH1FORMULA(SI_QUANTITY IN NUMBER
121 ,SI_MOVH IN NUMBER) RETURN NUMBER;
122
123 FUNCTION SI_RES1FORMULA(SI_QUANTITY IN NUMBER
124 ,SI_RES IN NUMBER) RETURN NUMBER;
125
126 FUNCTION SI_OSP1FORMULA(SI_QUANTITY IN NUMBER
127 ,SI_OSP IN NUMBER) RETURN NUMBER;
128
129 FUNCTION SI_OVHD1FORMULA(SI_QUANTITY IN NUMBER
130 ,SI_OVHD IN NUMBER) RETURN NUMBER;
131
132 FUNCTION SI_TOTAL1FORMULA(SI_QUANTITY IN NUMBER
133 ,SI_TOTAL IN NUMBER) RETURN NUMBER;
134
135 FUNCTION IC_QUANTITY1FORMULA(IC_QUANTITY IN NUMBER) RETURN NUMBER;
136
137 FUNCTION IC_ROWCOUNTFORMULA(IC_QUANTITY IN NUMBER) RETURN NUMBER;
138
139 FUNCTION SI_ROWCOUNTFORMULA(SI_QUANTITY IN NUMBER) RETURN NUMBER;
140
141 FUNCTION IC_ORDERFORMULA(IC_ITEM_NUMBER IN VARCHAR2
142 ,IC_CATEGORY IN VARCHAR2
143 ,IC_ITEM_SEGMENT IN VARCHAR2
144 ,IC_CATEGORY_SEGMENT IN VARCHAR2
145 ,IC_ITEM_PSEG IN VARCHAR2
146 ,IC_CAT_PSEG IN VARCHAR2) RETURN VARCHAR2;
147
148 FUNCTION IC_ITEM_PSEGFORMULA(IC_ITEM_SEGMENT IN VARCHAR2
149 ,IC_ITEM_NUMBER IN VARCHAR2
150 ,IC_ITEM_PSEG IN VARCHAR2) RETURN VARCHAR2;
151
152 FUNCTION IC_CAT_PSEGFORMULA(IC_CATEGORY_SEGMENT IN VARCHAR2
153 ,IC_CATEGORY IN VARCHAR2
154 ,IC_CAT_PSEG IN VARCHAR2) RETURN VARCHAR2;
155
156 FUNCTION SI_ITEM_PSEGFORMULA(SI_ITEM_NUMBER IN VARCHAR2
157 ,SI_ITEM_SEGMENT IN VARCHAR2
158 ,SI_ITEM_PSEG IN VARCHAR2) RETURN VARCHAR2;
159
160 FUNCTION BEFOREPFORM RETURN BOOLEAN;
161
162 END BOM_CSTREIVR_XMLP_PKG;
163