PACKAGE: APPS.BOM_CSTRAIVR_XMLP_PKG

Source

1 PACKAGE BOM_CSTRAIVR_XMLP_PKG AUTHID CURRENT_USER AS
2 /* $Header: CSTRAIVRS.pls 120.0 2007/12/24 09:52:53 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_ITEM_FROM VARCHAR2(800);
14 
15   P_ITEM_TO VARCHAR2(800);
16 
17   P_CATEGORY_SET NUMBER;
18 
19   P_CAT_NUM NUMBER;
20 
21   P_CAT_FROM VARCHAR2(800);
22 
23   P_CAT_TO VARCHAR2(800);
24 
25   P_NEG_QTY NUMBER;
26 
27   P_ZERO_COST NUMBER;
28 
29   P_ORGANIZATION VARCHAR2(240);
30 
31   ROUND_UNIT NUMBER;
32 
33   P_ITEM_SEG VARCHAR2(2400) := 'MSI.description||MSI.description||MSI.description||MSI.segment1||MSI.segment2||MSI.segment3';
34 
35   P_CAT_SEG VARCHAR2(2400) := 'MC.attribute1||MC.attribute2||MC.attribute3||MC.attribute4||MC.attribute5||MC.description||MC.segment1';
36 
37   P_ITEM_WHERE VARCHAR2(2400);
38 
39   P_CAT_WHERE VARCHAR2(2400);
40 
41   P_SORT_BY VARCHAR2(80);
42 
43   P_CAT_SET_NAME VARCHAR2(40);
44 
45   P_GL_NUM NUMBER;
46 
47   P_DETAIL_LEVEL VARCHAR2(80);
48 
49   P_COST_TYPE_ID NUMBER;
50 
51   P_DEF_COST_TYPE NUMBER :=1 ;
52 
53   P_COST_TYPE VARCHAR2(10);
54 
55   P_TRACE VARCHAR2(1);
56 
57   P_EXT_PREC NUMBER := 5;
58 
59   P_QTY_WHERE VARCHAR2(1440);
60 
61   P_EXP_ITEM NUMBER;
62 
63   P_QTY_PRECISION NUMBER;
64 
65   P_CURRENCY_DSP VARCHAR2(50);
66 
67   P_VIEW_COST NUMBER;
68 
69   P_EXP_SUBINV NUMBER;
70 
71   P_RPT_MODE NUMBER;
72 
73   P_COST_ORG_ID NUMBER;
74 
75   P_EXCHANGE_RATE_CHAR VARCHAR2(38);
76 
77   P_AS_OF_DATE VARCHAR2(30);
78 
79   P_AS_OF_DATE1 VARCHAR2(30);
80 
81   P_TITLE VARCHAR2(240);
82 
83   FUNCTION AFTERREPORT RETURN BOOLEAN;
84 
85   FUNCTION BEFOREREPORT RETURN BOOLEAN;
86 
87   FUNCTION CATEGORY_PSEGFORMULA(CATEGORY IN VARCHAR2
88                                ,CATEGORY_SEGMENT IN VARCHAR2
89                                ,CATEGORY_PSEG IN VARCHAR2) RETURN VARCHAR2;
90 
91   FUNCTION ITEM_PSEGFORMULA(ITEM_NUMBER IN VARCHAR2
92                            ,ITEM_SEGMENT IN VARCHAR2
93                            ,ITEM_PSEG IN VARCHAR2) RETURN VARCHAR2;
94 
95   FUNCTION ITEM_TOTAL_QUANTITYFORMULA(STK_QUANTITY IN NUMBER
96                                      ,INT_QUANTITY IN NUMBER
97                                      ,RCV_QUANTITY IN NUMBER) RETURN NUMBER;
98 
99   FUNCTION ITEM_TOTAL_VALUEFORMULA(ITEM_STK_VALUE IN NUMBER
100                                   ,ITEM_INT_VALUE IN NUMBER
101                                   ,ITEM_RCV_VALUE IN NUMBER) RETURN NUMBER;
102 
103   FUNCTION CAT_TOTAL_VALUEFORMULA(CAT_STK_VALUE IN NUMBER
104                                  ,CAT_INT_VALUE IN NUMBER
105                                  ,CAT_RCV_VALUE IN NUMBER) RETURN NUMBER;
106 
107   FUNCTION C_ORDERFORMULA(ITEM_NUMBER IN VARCHAR2
108                          ,ITEM_SEGMENT IN VARCHAR2
109                          ,ITEM_PSEG IN VARCHAR2
110                          ,CATEGORY IN VARCHAR2
111                          ,CATEGORY_SEGMENT IN VARCHAR2
112                          ,CATEGORY_PSEG IN VARCHAR2) RETURN VARCHAR2;
113 
114   FUNCTION REP_TOTAL_VALUEFORMULA(REP_STK_VALUE IN NUMBER
115                                  ,REP_INT_VALUE IN NUMBER
116                                  ,REP_RCV_VALUE IN NUMBER) RETURN NUMBER;
117 
118   FUNCTION P_TITLEVALIDTRIGGER RETURN BOOLEAN;
119 
120 END BOM_CSTRAIVR_XMLP_PKG;
121