PACKAGE: APPS.BOM_CSTRUSIA_XMLP_PKG

Source

1 PACKAGE BOM_CSTRUSIA_XMLP_PKG AS
2 /* $Header: CSTRUSIAS.pls 120.0 2007/12/24 10:20:11 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:=3;
16 
17   P_CAT_NUM NUMBER:=101;
18 
19   P_ORGANIZATION VARCHAR2(240);
20 
21   ROUND_UNIT NUMBER:=1;
22 
23   P_ITEM_SEG VARCHAR2(2400);
24 
25   P_CAT_SEG VARCHAR2(2400);
26 
27   P_SORT_BY VARCHAR2(80);
28 
29 
30 
31   P_CAT_SET_NAME VARCHAR2(40);
32 
33   P_ACCT_SEG1 VARCHAR2(2400);
34 
35   P_ACCT_SEG2 VARCHAR2(2400);
36 
37   P_ACCT_SEG3 VARCHAR2(2400);
38 
39   P_ACCT_SEG4 VARCHAR2(2400);
40 
41   P_ACCT_SEG5 VARCHAR2(2400);
42 
43   P_GL_NUM NUMBER:=101;
44 
45   P_ITEM_RANGE VARCHAR2(80);
46 
47   P_RANGE_OPTION NUMBER:=1;
48 
49   EXT_PREC NUMBER:=0;
50 
51   P_RPT_ONLY NUMBER;
52 
53   P_DEL_SNAPSHOT NUMBER;
54 
55   P_UPDATE_ID NUMBER;
56 
57   P_ADJ_ACCOUNT NUMBER:=0;
58 
59   P_ACCT_SEG6 VARCHAR2(2400);
60 
61   P_ITEM NUMBER;
62 
63   P_CAT NUMBER;
64 
65   P_QTY_PRECISION NUMBER;
66 
67   QTY_PRECISION varchar2(50);
68 
69   P_UPDATE_DATE DATE;
70 
71   P_UPDATE_DESC VARCHAR2(240);
72 
73   P_COST_TYPE VARCHAR2(10);
74 
75   P_COST_TYPE_ID NUMBER;
76 
77   P_TRACE VARCHAR2(1);
78 
79   FUNCTION BEFOREREPORT RETURN BOOLEAN;
80 
81   FUNCTION AFTERREPORT RETURN BOOLEAN;
82 
83   function g_filter1 return boolean;
84 
85   function g_filter2 return boolean;
86 
87   function g_filter3 return boolean;
88 
89   function g_filter4 return boolean;
90 
91   FUNCTION SI_SI_ADJFORMULA(SI_SI_MTL IN NUMBER
92                            ,SI_SI_MOH IN NUMBER
93                            ,SI_SI_RES IN NUMBER
94                            ,SI_SI_OSP IN NUMBER
95                            ,SI_SI_OVH IN NUMBER) RETURN NUMBER;
96 
97   FUNCTION ORG_ADJFORMULA(SI_ORG_MTL IN NUMBER
98                          ,SI_ORG_MOH IN NUMBER
99                          ,SI_ORG_RES IN NUMBER
100                          ,SI_ORG_OSP IN NUMBER
101                          ,SI_ORG_OVH IN NUMBER
102                          ,IC_ORG_MTL IN NUMBER
103                          ,IC_ORG_MOH IN NUMBER
104                          ,IC_ORG_RES IN NUMBER
105                          ,IC_ORG_OSP IN NUMBER
106                          ,IC_ORG_OVH IN NUMBER) RETURN NUMBER;
107 
108   FUNCTION REP_ADJFORMULA(SI_REP_MTL IN NUMBER
109                          ,SI_REP_MOH IN NUMBER
110                          ,SI_REP_RES IN NUMBER
111                          ,SI_REP_OSP IN NUMBER
112                          ,SI_REP_OVH IN NUMBER
113                          ,IC_REP_MTL IN NUMBER
114                          ,IC_REP_MOH IN NUMBER
115                          ,IC_REP_RES IN NUMBER
116                          ,IC_REP_OSP IN NUMBER
117                          ,IC_REP_OVH IN NUMBER) RETURN NUMBER;
118 
119   FUNCTION IC_ORDERFORMULA(IC_ITEM_NUMBER IN VARCHAR2
120                           ,IC_CATEGORY IN VARCHAR2
121                           ,IC_ITEM_SEG IN VARCHAR2
122                           ,IC_CAT_SEG IN VARCHAR2
123                           ,IC_ITEM_PSEG IN VARCHAR2
124                           ,IC_CAT_PSEG IN VARCHAR2) RETURN VARCHAR2;
125 
126   FUNCTION IC_CAT_PSEGFORMULA(IC_CATEGORY IN VARCHAR2
127                              ,IC_CAT_SEG IN VARCHAR2
128                              ,IC_CAT_PSEG IN VARCHAR2) RETURN VARCHAR2;
129 
130   FUNCTION IC_ITEM_PSEGFORMULA(IC_ITEM_NUMBER IN VARCHAR2
131                               ,IC_ITEM_SEG IN VARCHAR2
132                               ,IC_ITEM_PSEG IN VARCHAR2) RETURN VARCHAR2;
133 
134   FUNCTION SI_ITEM_PSEGFORMULA(SI_ITEM_NUMBER IN VARCHAR2
135                               ,SI_ITEM_SEG IN VARCHAR2
136                               ,SI_ITEM_PSEG IN VARCHAR2) RETURN VARCHAR2;
137 
138 END BOM_CSTRUSIA_XMLP_PKG;
139