PACKAGE: APPS.BOM_CSTRUSJA_XMLP_PKG

Source

1 PACKAGE BOM_CSTRUSJA_XMLP_PKG AS
2 /* $Header: CSTRUSJAS.pls 120.0 2007/12/24 10:22:45 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_ITEM_FROM VARCHAR2(1350);
10 
11   P_ITEM_TO VARCHAR2(1350);
12 
13   P_CATEGORY_SET NUMBER;
14 
15   P_CAT_NUM NUMBER;
16 
17   P_ORGANIZATION VARCHAR2(240);
18 
19   ROUND_UNIT NUMBER;
20 
21   P_ITEM_SEG VARCHAR2(2400);
22 
23   P_CAT_SEG VARCHAR2(2400);
24 
25   P_CAT_SET_NAME VARCHAR2(40);
26 
27   P_ACCT_SEG1 VARCHAR2(2400);
28 
29   P_ACCT_SEG2 VARCHAR2(2400);
30 
31   P_ACCT_SEG3 VARCHAR2(2400);
32 
33   P_ACCT_SEG4 VARCHAR2(2400);
34 
35   P_ACCT_SEG5 VARCHAR2(2400);
36 
37   P_GL_NUM NUMBER;
38 
39   P_ITEM_RANGE VARCHAR2(80);
40 
41   P_RANGE_OPTION NUMBER;
42 
43   EXT_PREC NUMBER;
44 
45   P_RPT_ONLY NUMBER;
46 
47   P_DEL_SNAPSHOT NUMBER;
48 
49   P_UPDATE_ID NUMBER;
50 
51   P_ADJ_ACCOUNT NUMBER;
52 
53   P_ACCT_SEG6 VARCHAR2(2400);
54 
55   P_ITEM NUMBER;
56 
57   P_CAT NUMBER;
58 
59   P_QTY_PRECISION NUMBER;
60 
61   QTY_PRECISION varchar2(50);
62 
63   P_COST_TYPE_ID NUMBER;
64 
65   P_COST_TYPE VARCHAR2(10);
66 
67   P_UPDATE_DATE DATE;
68 
69   P_UPDATE_DESC VARCHAR2(240);
70 
71   P_TRACE VARCHAR2(1);
72 
73   P_JOB_OVH_ROUND NUMBER;
74 
75   P_JOB_MOH_ROUND NUMBER;
76 
77   P_JOB_MTL_ROUND NUMBER;
78 
79   P_JOB_OSP_ROUND NUMBER;
80 
81   P_JOB_RES_ROUND NUMBER;
82 
83   P_CLASS_MOH_ROUND NUMBER;
84 
85   P_CLASS_MTL_ROUND NUMBER;
86 
87   P_CLASS_OSP_ROUND NUMBER;
88 
89   P_CLASS_OVH_ROUND NUMBER;
90 
91   P_CLASS_RES_ROUND NUMBER;
92 
93   P_REP_MOH_ROUND NUMBER;
94 
95   P_REP_MTL_ROUND NUMBER;
96 
97   P_REP_OSP_ROUND NUMBER;
98 
99   P_REP_OVH_ROUND NUMBER;
100 
101   P_REP_RES_ROUND NUMBER;
102 
103   FUNCTION BEFOREREPORT RETURN BOOLEAN;
104 
105   FUNCTION AFTERREPORT RETURN BOOLEAN;
106 
107   FUNCTION JOB_ADJFORMULA(JOB_MTL IN NUMBER
108                          ,JOB_MOH IN NUMBER
109                          ,JOB_RES IN NUMBER
110                          ,JOB_OSP IN NUMBER
111                          ,JOB_OVH IN NUMBER) RETURN NUMBER;
112 
113   FUNCTION CLASS_ADJFORMULA(CLASS_MTL IN NUMBER
114                            ,CLASS_MOH IN NUMBER
115                            ,CLASS_RES IN NUMBER
116                            ,CLASS_OSP IN NUMBER
117                            ,CLASS_OVH IN NUMBER) RETURN NUMBER;
118 
119   FUNCTION REP_ADJFORMULA(REP_MTL IN NUMBER
120                          ,REP_MOH IN NUMBER
121                          ,REP_RES IN NUMBER
122                          ,REP_OSP IN NUMBER
123                          ,REP_OVH IN NUMBER) RETURN NUMBER;
124 
125   FUNCTION AFTERPFORM RETURN BOOLEAN;
126 
127   FUNCTION OLD_COST2FORMULA(TRANS_TYPE IN NUMBER
128                            ,OUC IN NUMBER
129                            ,COUNT_QTY IN NUMBER
130                            ,SUM_LEVEL IN NUMBER) RETURN NUMBER;
131 
132   FUNCTION NEW_COST2FORMULA(TRANS_TYPE IN NUMBER
133                            ,NUC IN NUMBER
134                            ,COUNT_QTY IN NUMBER
135                            ,SUM_LEVEL IN NUMBER) RETURN NUMBER;
136 
137   FUNCTION ADJ_QTY_DISPLAYFORMULA(COUNT_QTY IN NUMBER
138                                  ,ADJ_QTY_DSP IN NUMBER
139                                  ,TRANSACTION_CODE IN NUMBER
140                                  ,SUM_LEVEL IN NUMBER) RETURN NUMBER;
141 
142 END BOM_CSTRUSJA_XMLP_PKG;
143