PACKAGE: APPS.BOM_CSTRSCCR_XMLP_PKG

Source

1 PACKAGE BOM_CSTRSCCR_XMLP_PKG AS
2 /* $Header: CSTRSCCRS.pls 120.0 2007/12/24 10:17:49 dwkrishn noship $ */
3   P_ORGANIZATION_ID NUMBER;
4 
5   P_COST_TYPE_ID NUMBER;
6 
7   P_MATERIAL_DTL_FLAG NUMBER;
8 
9   P_MATERIAL_OVERHEAD_DTL_FLAG NUMBER;
10 
11   P_ROUTING_DTL_FLAG NUMBER;
12 
13   P_REPORT_LEVEL NUMBER := 20;
14   LP_REPORT_LEVEL NUMBER;
15 
16   P_QTY_PRECISION NUMBER;
17 
18   P_ORGANIZATION_NAME VARCHAR2(60);
19 
20   P_ITEM_FROM VARCHAR2(400);
21 
22   P_ITEM_TO VARCHAR2(400);
23 
24   P_ITEM_ID NUMBER;
25 
26   P_EXPLOSION_LEVEL NUMBER := 20;
27   LP_EXPLOSION_LEVEL NUMBER;
28   P_REVISION_DATE VARCHAR2(32767);
29 LP_REVISION_DATE VARCHAR2(32767);
30   P_ASSIGNMENT_SET_ID NUMBER;
31   LP_ASSIGNMENT_SET_ID NUMBER;
32 
33   P_BUY_COST_TYPE_ID NUMBER;
34   LP_BUY_COST_TYPE_ID NUMBER;
35 
36   P_INC_UNIMP_ECN_FLAG NUMBER;
37 
38   P_ENG_BILL_FLAG NUMBER;
39 
40   P_ALT_BOM_DESG VARCHAR2(200);
41 
42   P_ALT_RTG_DESG VARCHAR2(200);
43 
44   P_ROLLUP_ID VARCHAR2(40);
45 
46   P_CATEGORY_SET_ID NUMBER;
47   LP_CATEGORY_SET_ID NUMBER;
48 
49   P_CONVERSION_TYPE VARCHAR2(30);
50 
51   P_LOCK_FLAG NUMBER;
52   QTY_PRECISION varchar2(30);
53 
54   P_ASSIGNMENT_SET_NAME VARCHAR2(30);
55 
56   P_ROLLUP_OPTION_TYPE NUMBER;
57 
58   P_REPORT_OPTION_TYPE NUMBER;
59 
60   P_RANGE_TYPE NUMBER;
61   LP_RANGE_TYPE NUMBER;
62 
63 
64   P_REPORT_TYPE_TYPE NUMBER;
65 
66   P_DEFAULT_ORG_ID NUMBER;
67 
68   P_CATEGORY_STRUCTURE_ID NUMBER;
69 
70   P_CATEGORY_ID VARCHAR2(2000);
71 
72   P_ITEM_NAME VARCHAR2(2000);
73 
74   P_CATEGORY_NAME VARCHAR2(2000);
75 
76   P_BUY_COST_TYPE_NAME VARCHAR2(10);
77 
78   P_COST_TYPE_NAME VARCHAR2(10);
79 
80   P_CONVERSION_TYPE_NAME VARCHAR2(30);
81 
82   P_CONC_REQUEST_ID NUMBER;
83 
84   P_DESCRIPTION VARCHAR2(240);
85   LP_DESCRIPTION VARCHAR2(240);
86 
87   P_NUM_CURRENCIES NUMBER;
88 
89   P_DEFAULT_COST_TYPE_ID NUMBER;
90 
91   P_TRACE VARCHAR2(1);
92 
93   P_LOT_SIZE_OPTION NUMBER;
94 
95   P_LOT_SIZE_SETTING NUMBER;
96 
97   P_LOT_SIZE_OPTION_NAME VARCHAR2(2000);
98 
99   P_CATEGORY_FROM VARCHAR2(2000);
100 
101   P_CATEGORY_TO VARCHAR2(2000);
102 
103   P_PHANTOM_MAT NUMBER;
104 
105   P_BUY_COST_DETAIL NUMBER;
106 
107   P_ALT_BOM_DESG_DSP VARCHAR2(240);
108 
109   P_ALT_RTG_DESG_DSP VARCHAR2(240);
110 
111   FUNCTION BEFOREREPORT RETURN BOOLEAN;
112 
113   FUNCTION CF_S_DIFFERENCEFORMULA(S_FROZEN_VALUE IN NUMBER
114                                  ,S_REPORT_VALUE IN NUMBER) RETURN NUMBER;
115 
116   FUNCTION CF_S_PERCENTFORMULA(S_FROZEN_VALUE IN NUMBER
117                               ,S_REPORT_VALUE IN NUMBER
118                               ,CF_S_DIFFERENCE IN NUMBER) RETURN NUMBER;
119 
120   FUNCTION CF_S_S_SRC_TOTALFORMULA(S_S_PERCENT IN NUMBER
121                                   ,S_S_EFFECTIVE_ITEM_COST IN NUMBER) RETURN NUMBER;
122 
123   FUNCTION CF_S_R_USER_DEFINED_COSTFORMUL(S_R_ITEM_COST IN NUMBER
124                                          ,CS_SUM_EFFECTIVE_COST IN NUMBER) RETURN NUMBER;
125 
126   FUNCTION CF_S_S_PERCENT_COSTFORMULA(S_R_ITEM_COST IN NUMBER
127                                      ,S_S_EFFECTIVE_ITEM_COST IN NUMBER) RETURN NUMBER;
128 
129   FUNCTION CF_S_R_USER_DEFINED_PERCENTFOR(S_R_ITEM_COST IN NUMBER
130                                          ,CF_S_R_USER_DEFINED_COST IN NUMBER) RETURN NUMBER;
131 
132   FUNCTION CF_SUM_EXT_COSTFORMULA0009(CS_SUM_COMP_EXT_COST IN NUMBER
133                                      ,CS_SUM_RES_EXT_COST IN NUMBER) RETURN NUMBER;
134 
135   FUNCTION CF_S_SUM_PERCENTFORMULA0011(CS_S_SUM_DIFFERENCE IN NUMBER) RETURN NUMBER;
136 
137   FUNCTION AFTERREPORT RETURN BOOLEAN;
138 
139   FUNCTION AFTERPFORM RETURN BOOLEAN;
140 
141 END BOM_CSTRSCCR_XMLP_PKG;
142