PACKAGE: APPS.BOM_CSTRUSIW_XMLP_PKG

Source

1 PACKAGE BOM_CSTRUSIW_XMLP_PKG AS
2 /* $Header: CSTRUSIWS.pls 120.0 2007/12/24 10:22:03 dwkrishn noship $ */
3   P_CONC_REQUEST_ID VARCHAR2(32767) := '0';
4 
5   P_ORG_ID NUMBER;
6 
7   P_CURRENCY_CODE VARCHAR2(15);
8 
9   P_SORT_OPTION NUMBER;
10 
11   P_ITEM_FROM VARCHAR2(1350);
12 
13   P_ITEM_TO VARCHAR2(1350);
14 
15   P_CATEGORY_SET NUMBER;
16 
17   P_CAT_NUM NUMBER;
18 
19   P_ORGANIZATION VARCHAR2(240);
20 
21   LP_ORGANIZATION VARCHAR2(240);
22 
23   ROUND_UNIT NUMBER;
24 
25   P_ITEM_SEG VARCHAR2(2400);
26 
27   P_CAT_SEG VARCHAR2(2400);
28 
29   P_SORT_BY VARCHAR2(80);
30 
31   LP_SORT_BY VARCHAR2(80);
32 
33   P_CAT_SET_NAME VARCHAR2(40);
34 
35   LP_CAT_SET_NAME VARCHAR2(40);
36 
37   P_ACCT_SEG1 VARCHAR2(2400);
38 
39   P_ACCT_SEG2 VARCHAR2(2400);
40 
41   P_ACCT_SEG3 VARCHAR2(2400);
42 
43   P_ACCT_SEG4 VARCHAR2(2400);
44 
45   P_ACCT_SEG5 VARCHAR2(2400);
46 
47   P_GL_NUM NUMBER;
48 
49   LP_GL_NUM NUMBER;
50 
51   P_ITEM_RANGE VARCHAR2(80);
52 
53   LP_ITEM_RANGE VARCHAR2(80);
54 
55   P_RANGE_OPTION NUMBER;
56 
57   LP_RANGE_OPTION NUMBER;
58 
59   EXT_PREC NUMBER;
60 
61   P_RPT_ONLY NUMBER;
62 
63   P_DEL_SNAPSHOT NUMBER;
64 
65   P_UPDATE_ID NUMBER;
66 
67   P_ADJ_ACCOUNT NUMBER;
68 
69   P_ACCT_SEG6 VARCHAR2(2400);
70 
71   P_ITEM NUMBER;
72 
73   P_CAT NUMBER;
74 
75   P_QTY_PRECISION NUMBER;
76 
77   P_UPDATE_DATE DATE;
78 
79   P_UPDATE_DESC VARCHAR2(240);
80 
81   P_COST_TYPE VARCHAR2(10);
82 
83   P_COST_TYPE_ID NUMBER;
84 
85   P_TRACE VARCHAR2(1);
86 
87   FUNCTION dummy1 return boolean;
88 
89   FUNCTION dummy2 return boolean;
90 
91   FUNCTION dummy3 return boolean;
92 
93   FUNCTION dummy4 return boolean;
94 
95   FUNCTION BEFOREREPORT RETURN BOOLEAN;
96 
97   FUNCTION AFTERREPORT RETURN BOOLEAN;
98 
99   FUNCTION CG_CG_ADJFORMULA(CG_CG_MTL IN NUMBER
100                            ,CG_CG_MOH IN NUMBER
101                            ,CG_CG_RES IN NUMBER
102                            ,CG_CG_OSP IN NUMBER
103                            ,CG_CG_OVH IN NUMBER) RETURN NUMBER;
104 
105   FUNCTION ORG_ADJFORMULA(CG_ORG_MTL IN NUMBER
106                          ,CG_ORG_MOH IN NUMBER
107                          ,CG_ORG_RES IN NUMBER
108                          ,CG_ORG_OSP IN NUMBER
109                          ,CG_ORG_OVH IN NUMBER
110                          ,IC_ORG_MTL IN NUMBER
111                          ,IC_ORG_MOH IN NUMBER
112                          ,IC_ORG_RES IN NUMBER
113                          ,IC_ORG_OSP IN NUMBER
114                          ,IC_ORG_OVH IN NUMBER) RETURN NUMBER;
115 
116   FUNCTION REP_ADJFORMULA(CG_REP_MTL IN NUMBER
117                          ,CG_REP_MOH IN NUMBER
118                          ,CG_REP_RES IN NUMBER
119                          ,CG_REP_OSP IN NUMBER
120                          ,CG_REP_OVH IN NUMBER
121                          ,IC_REP_MTL IN NUMBER
122                          ,IC_REP_MOH IN NUMBER
123                          ,IC_REP_RES IN NUMBER
124                          ,IC_REP_OSP IN NUMBER
125                          ,IC_REP_OVH IN NUMBER) RETURN NUMBER;
126 
127   FUNCTION IC_ORDERFORMULA(IC_ITEM_NUMBER IN VARCHAR2
128                           ,IC_CATEGORY IN VARCHAR2
129                           ,IC_ITEM_SEG IN VARCHAR2
130                           ,IC_CAT_SEG IN VARCHAR2
131                           ,IC_ITEM_PSEG IN VARCHAR2
132                           ,IC_CAT_PSEG IN VARCHAR2) RETURN VARCHAR2;
133 
134   FUNCTION IC_CAT_PSEGFORMULA(IC_CATEGORY IN VARCHAR2
135                              ,IC_CAT_SEG IN VARCHAR2
136                              ,IC_CAT_PSEG IN VARCHAR2) RETURN VARCHAR2;
137 
138   FUNCTION IC_ITEM_PSEGFORMULA(IC_ITEM_NUMBER IN VARCHAR2
139                               ,IC_ITEM_SEG IN VARCHAR2
140                               ,IC_ITEM_PSEG IN VARCHAR2) RETURN VARCHAR2;
141 
142   FUNCTION CG_ITEM_PSEGFORMULA(CG_ITEM_NUMBER IN VARCHAR2
143                               ,CG_ITEM_SEG IN VARCHAR2
144                               ,CG_ITEM_PSEG IN VARCHAR2) RETURN VARCHAR2;
145 
146 END BOM_CSTRUSIW_XMLP_PKG;
147