PACKAGE: APPS.BOM_CSTRITVR_XMLP_PKG

Source

1 PACKAGE BOM_CSTRITVR_XMLP_PKG AUTHID CURRENT_USER AS
2 /* $Header: CSTRITVRS.pls 120.0 2007/12/24 10:03:19 dwkrishn noship $ */
3 	  P_CONC_REQUEST_ID VARCHAR2(32767) := '0';
4 	  P_ORG_ID VARCHAR2(40);
5 	  P_CURRENCY_CODE VARCHAR2(15);
6 	  P_EXCHANGE_RATE NUMBER ;
7 	    P_EXCHANGE_RATE1 NUMBER ;
8 	  P_SORT_OPTION NUMBER;
9 	  P_ITEM_FROM VARCHAR2(800);
10 	  P_ITEM_TO VARCHAR2(800);
11 	  P_CATEGORY_SET NUMBER;
12 	  P_CAT_NUM NUMBER;
13 	  P_CAT_FROM VARCHAR2(800);
14 	  P_CAT_TO VARCHAR2(800);
15 	  P_ZERO_COST NUMBER;
16 	  P_ORGANIZATION VARCHAR2(240);
17 	  ROUND_UNIT NUMBER;
18 	  P_ITEM_SEG VARCHAR2(2400);
19 	  P_CAT_SEG VARCHAR2(2400);
20 	  P_SORT_BY VARCHAR2(80);
21 	  P_CAT_SET_NAME VARCHAR2(40);
22 	  P_DETAIL_LEVEL VARCHAR2(80);
23 	  P_COST_TYPE_ID NUMBER;
24 	  P_DEF_COST_TYPE NUMBER;
25 	  P_COST_TYPE VARCHAR2(10);
26 	  P_EXT_PREC NUMBER;
27 	  P_EXP_ITEM NUMBER;
28 	  P_QTY_PRECISION NUMBER;
29 	  P_ORG_WHERE VARCHAR2(2400);
30 	  P_RPT_OPTION NUMBER;
31 	  P_RECEIPT NUMBER;
32 	  P_SHIPMENT NUMBER;
33 	  P_OWN NUMBER;
34 	  P_ITEM_REVISION NUMBER;
35 	  P_CURRENCY_DSP VARCHAR2(50);
36 	  P_VIEW_COST NUMBER;
37 	  P_TRACE VARCHAR2(1);
38 	  P_COST_TYPE_DUMMY NUMBER;
39 	    P_COST_TYPE_DUMMY1 NUMBER;
40 	  P_EXCHANGE_RATE_CHAR VARCHAR2(38);
41 	  P_CURR_TYPE VARCHAR2(30);
42 	  P_AS_OF_DATE VARCHAR2(30);
43 	  P_AS_OF_DATE1 VARCHAR2(30);
44 	  P_TITLE VARCHAR2(240);
45 	  FUNCTION AFTERREPORT RETURN BOOLEAN;
46 	  FUNCTION BEFOREREPORT RETURN BOOLEAN;
47 	  FUNCTION CATEGORY_PSEGFORMULA(CATEGORY IN VARCHAR2
48 				       ,CATEGORY_SEGMENT IN VARCHAR2
49 				       ,CATEGORY_PSEG IN VARCHAR2) RETURN VARCHAR2;
50 	  FUNCTION ITEM_PSEGFORMULA(ITEM_NUMBER IN VARCHAR2
51 				   ,ITEM_SEGMENT IN VARCHAR2
52 				   ,ITEM_PSEG IN VARCHAR2) RETURN VARCHAR2;
53 	  FUNCTION ITEMCATFORMULA(CATEGORY IN VARCHAR2
54 				 ,CATEGORY_SEGMENT IN VARCHAR2
55 				 ,CATEGORY_PSEG IN VARCHAR2) RETURN VARCHAR2;
56 	  FUNCTION XFER_COST_TOTALFORMULA(XFER_COST IN NUMBER
57 					 ,QUANTITY IN NUMBER) RETURN NUMBER;
58 	  FUNCTION XPORT_COST_TOTALFORMULA(XPORT_COST IN NUMBER
59 					  ,QUANTITY IN NUMBER) RETURN NUMBER;
60 	  FUNCTION ITEM_QTYFORMULA(UOM_CODE IN VARCHAR2
61 				  ,UOMCODE IN VARCHAR2
62 				  ,ITEM_ID IN NUMBER
63 				  ,QUANTITY IN NUMBER) RETURN NUMBER;
64 	  FUNCTION TOT_COSTFORMULA(OWNING_ORG_ID IN NUMBER
65 				  ,FROM_ORG_ID IN NUMBER
66 				  ,OWNING_ORG_PUOM_CODE IN VARCHAR2
67 				  ,UOMCODE IN VARCHAR2
68 				  ,ITEM_ID IN NUMBER
69 				  ,QUANTITY IN NUMBER
70 				  ,UNIT_COST IN NUMBER
71 				  ,TOTAL_COST IN NUMBER) RETURN NUMBER;
72 	END BOM_CSTRITVR_XMLP_PKG;
73