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