PACKAGE: APPS.BOM_CSTROMMA_XMLP_PKG

Source

1 PACKAGE BOM_CSTROMMA_XMLP_PKG AS
2 /* $Header: CSTROMMAS.pls 120.0 2007/12/24 10:07:33 dwkrishn noship $ */
3   P_ITEM_SEG VARCHAR2(2400);
4 
5   P_CAT_SEG VARCHAR2(2400);
6 
7   P_ITEM_WHERE VARCHAR2(2400);
8 
9   P_CAT_WHERE VARCHAR2(2400);
10 
11   P_CONC_REQUEST_ID NUMBER := 0;
12 
13   P_CURRENCY_CODE VARCHAR2(15) := 'USD';
14   LP_CURRENCY_CODE VARCHAR2(15);
15 
16   QTY VARCHAR2(50);
17   QTY_V VARCHAR2(50);
18 
19   P_ROUND_UNIT NUMBER := 1;
20 
21   P_ORGANIZATION VARCHAR2(240);
22 
23   P_CAT_NUM NUMBER;
24 
25   P_CAT_TO VARCHAR2(2400);
26 
27   P_CAT_FROM VARCHAR2(2400);
28 
29   P_ITEM_TO VARCHAR2(2400);
30 
31   P_ITEM_FROM VARCHAR2(2400);
32 
33   P_CATEGORY_SET NUMBER;
34 
35   P_SORT_OPTION NUMBER;
36 
37   P_DATE_FROM DATE;
38   LP_DATE_FROM VARCHAR2(11);
39 
40   P_DATE_TO DATE;
41   LP_DATE_TO VARCHAR2(11);
42 
43   P_PCT_TO NUMBER;
44   P_PCT_TO_V NUMBER;
45 
46   P_PCT_FROM NUMBER;
47   P_PCT_FROM_V NUMBER;
48 
49   P_COST_TYPE_ID NUMBER;
50 
51   P_CUSTOMER NUMBER;
52 
53   P_SALESREP NUMBER;
54 
55   P_EXCHANGE_RATE NUMBER;
56 
57   P_SORT_BY VARCHAR2(80);
58 
59   P_CAT_SET_NAME VARCHAR2(30);
60 
61   P_CUST_OPT NUMBER;
62 
63   P_CURRENCY_DSP VARCHAR2(50);
64 
65   P_CUST_OPT_DSP VARCHAR2(80);
66 
67   P_QTY_PRECISION NUMBER;
68 
69   P_VIEW_COST NUMBER;
70 
71   P_CUSTOMER_NAME VARCHAR2(50);
72 
73   P_SALESREP_NAME VARCHAR2(240);
74 
75   P_COST_TYPE VARCHAR2(10);
76 
77   P_RPT_OPTION NUMBER;
78 
79   P_RPT_OPT_DSP VARCHAR2(80);
80 
81   P_CONTEXT VARCHAR2(80);
82 
83   P_EXT_PREC NUMBER;
84 
85   P_COST_ORG_ID NUMBER;
86 
87   P_DEF_COST_TYPE NUMBER;
88 
89   P_TRACE VARCHAR2(1);
90 
91   P_ITEM_COGS VARCHAR2(50);
92 
93   P_ITEM_COST_TABLE VARCHAR2(200);
94 
95   P_ITEM_COST_WHERE VARCHAR2(2000);
96 
97   P_ITEM_COST_COLUMN VARCHAR2(32767);
98 
99   P_MASTER_ORG_ID NUMBER;
100 
101   P_PROFILE VARCHAR2(80);
102 
103   P_HEADER_ID NUMBER;
104 
105   P_SALES_CHANNEL_CODE VARCHAR2(30);
106 
107   P_CLASS_CODE VARCHAR2(30);
108 
109   P_TERRITORY_ID NUMBER;
110 
111   P_OPERATING_UNIT NUMBER;
112 
113   P_SALES_CHANNEL VARCHAR2(80);
114 
115   P_CLASS VARCHAR2(80);
116 
117   P_TERRITORY VARCHAR2(40);
118 
119   P_RANGE_WHERE VARCHAR2(100) := '1 = 1';
120 
121   P_OPERATING_UNIT_NAME VARCHAR2(240);
122 
123   P_SQL_SELECT_COST_TYPE VARCHAR2(4000) := 'NVL( temp.COGS_amount, 0 ) ';
124 
125   P_SQL_FROM_COST_TYPE VARCHAR2(4000) := ' ';
126 
127   P_SQL_WHERE_COST_TYPE VARCHAR2(4000) := '0=0';
128 
129   P_ORDER_NUMBER NUMBER;
130 
131   P_MULTI_ORG_FLAG VARCHAR2(1);
132 
133   P_CONFIG_ITEM_DETAILS NUMBER;
134 
135   P_DETAIL_DUMMY NUMBER;
136 
137   P_CONFIG_ITEM_DTLS_OPTS VARCHAR2(240);
138 
139   FUNCTION BEFOREREPORT RETURN BOOLEAN;
140 
141   FUNCTION ITEM_MARGIN_PCTFORMULA(ITEM_SALES IN NUMBER
142                                  ,ITEM_MARGIN IN NUMBER) RETURN NUMBER;
143 
144   FUNCTION REP_MARGIN_PCTFORMULA(REP_O_SALES IN NUMBER
145                                 ,REP_O_MARGIN IN NUMBER
146                                 ,REP_IC_SALES IN NUMBER
147                                 ,REP_IC_MARGIN IN NUMBER) RETURN NUMBER;
148 
149   FUNCTION CAT_MARGIN_PCTFORMULA(CAT_SALES IN NUMBER
150                                 ,CAT_MARGIN IN NUMBER) RETURN NUMBER;
151 
152   FUNCTION CATEGORY_PSEGFORMULA(CATEGORY IN VARCHAR2
153                                ,CATEGORY_SEGMENT IN VARCHAR2
154                                ,CATEGORY_PSEG IN VARCHAR2) RETURN VARCHAR2;
155 
156   FUNCTION ITEM_PSEGFORMULA(ITEM_NUMBER IN VARCHAR2
157                            ,ITEM_SEGMENT IN VARCHAR2
158                            ,ITEM_PSEG IN VARCHAR2) RETURN VARCHAR2;
159 
160   FUNCTION AFTERREPORT RETURN BOOLEAN;
161 
162   FUNCTION AVG_UNIT_PRICEFORMULA(ITEM_INVOICE_QTY IN NUMBER
163                                 ,ITEM_SALES IN NUMBER) RETURN NUMBER;
164 
165   FUNCTION AVG_UNIT_COSTFORMULA(ITEM_SHIP_QTY IN NUMBER
166                                ,ITEM_COGS IN NUMBER) RETURN NUMBER;
167 
168   FUNCTION ITEMCATFORMULA(CATEGORY IN VARCHAR2
169                          ,CATEGORY_SEGMENT IN VARCHAR2
170                          ,CATEGORY_PSEG IN VARCHAR2) RETURN VARCHAR2;
171 
172   FUNCTION ORDER_MARGIN_PCTFORMULA(ORDER_SALES IN NUMBER
173                                   ,ORDER_MARGIN IN NUMBER) RETURN NUMBER;
174 
175   FUNCTION ORDER_SALES1FORMULA(ORDER_SALES IN NUMBER
176                               ,ORDER_MARGIN_PCT IN NUMBER) RETURN NUMBER;
177 
178   FUNCTION ORDER_COGS1FORMULA(ORDER_COGS IN NUMBER
179                              ,ORDER_MARGIN_PCT IN NUMBER) RETURN NUMBER;
180 
181   FUNCTION ORDER_MARGIN1FORMULA(ORDER_MARGIN IN NUMBER
182                                ,ORDER_MARGIN_PCT IN NUMBER) RETURN NUMBER;
183 
184   FUNCTION ITEM_SALES1FORMULA(ITEM_SALES IN NUMBER
185                              ,ITEM_MARGIN_PCT IN NUMBER) RETURN NUMBER;
186 
187   FUNCTION ITEM_COGS1FORMULA(ITEM_COGS IN NUMBER
188                             ,ITEM_MARGIN_PCT IN NUMBER) RETURN NUMBER;
189 
190   FUNCTION ITEM_MARGIN1FORMULA(ITEM_MARGIN IN NUMBER
191                               ,ITEM_MARGIN_PCT IN NUMBER) RETURN NUMBER;
192 
193   FUNCTION MARGINFORMULA(TOTAL_SALES_AMOUNT IN NUMBER
194                         ,TOTAL_COGS_AMOUNT IN NUMBER) RETURN NUMBER;
195 
196   FUNCTION MARGIN_PCTFORMULA(TOTAL_SALES_AMOUNT IN NUMBER
197                             ,MARGIN IN NUMBER) RETURN NUMBER;
198 
199   FUNCTION BETWEENPAGE RETURN BOOLEAN;
200 
201   FUNCTION CONFIG_ITEM_MARGINFORMULA(CONFIG_ITEM_SALES_AMOUNT IN NUMBER
202                                     ,CONFIG_ITEM_COGS_AMOUNT IN NUMBER) RETURN NUMBER;
203 
204   FUNCTION CONFIG_ITEM_MARGIN_PCTFORMULA(CONFIG_ITEM_SALES_AMOUNT IN NUMBER
205                                         ,CONFIG_ITEM_MARGIN IN NUMBER) RETURN NUMBER;
206 
207   FUNCTION AFTERPFORM RETURN BOOLEAN;
208 
209   FUNCTION P_OPERATING_UNIT_NAMEVALIDTRIG RETURN BOOLEAN;
210 
211   FUNCTION BEFOREPFORM RETURN BOOLEAN;
212 function get_precision(qty_precision in number) return VARCHAR2;
213 END BOM_CSTROMMA_XMLP_PKG;
214