PACKAGE: APPS.BOM_CSTRCTCR_XMLP_PKG

Source

1 PACKAGE BOM_CSTRCTCR_XMLP_PKG AS
2 /* $Header: CSTRCTCRS.pls 120.0 2007/12/24 09:53:34 dwkrishn noship $ */
3   COMPARISON_OPT NUMBER;
4 
5   COST_TYPE_ID1 NUMBER;
6 
7   COST_TYPE_ID2 NUMBER;
8 
9   ORG_ID NUMBER;
10 
11   REPORT_SORT_OPT NUMBER;
12 
13   COLUMN1 VARCHAR2(40) := 'cost_element';
14 --Added
15   PID_FLEX_NUM NUMBER;
16 
17   QTY_PRECISION varchar2(100);
18 
19   P_FLEXDATA_ITEM VARCHAR2(850);
20 
21   P_WHERE_ITEM VARCHAR2(850) := '1 = 1';
22 
23   P_FROM_ITEM VARCHAR2(80);
24 
25   P_TO_ITEM VARCHAR2(80);
26 
27   P_FLEXDATA_CAT VARCHAR2(850);
28 
29   P_CONC_REQUEST_ID NUMBER := 0;
30 
31   P_WHERE_CAT VARCHAR2(850) := '1 = 1';
32 
33   P_FROM_CAT VARCHAR2(80);
34 
35   P_TO_CAT VARCHAR2(80);
36 
37   P_STRUCT_NUM NUMBER;
38 
39   P_CATEGORY_SET NUMBER;
40 
41   MIN_PERC_DIFF NUMBER;
42 
43   MIN_AMT_DIFF NUMBER;
44 
45   MIN_UNIT_COST NUMBER;
46 
47   P_VIEW_COST NUMBER;
48 
49   P_TRACE VARCHAR2(2);
50 
51   --P_PRECISION NUMBER;
52   P_PRECISION NUMBER := 0;
53 
54   --P_EXT_PRECISION NUMBER;
55   P_EXT_PRECISION NUMBER := 5;
56 
57   P_HINT VARCHAR2(200);
58 
59   P_TABLE_ORDER VARCHAR2(300) := 'mtl_categories_kfv mc, mtl_item_categories mic, cst_item_costs cic,  mtl_system_items_vl msi, cst_detail_cost_view cdcv';
60 
61   CREATE_WHERE_ITEM1 varchar2(200) := '   ';
62   CREATE_WHERE_ITEM2 varchar2(200) := '   ';
63 
64   CREATE_WHERE_CAT1 varchar2(200) := '   ';
65   CREATE_WHERE_CAT2 varchar2(200) := '   ';
66 
67   FUNCTION TOT_PER_CHANGEFORMULA(TOT_ITEM_COST1 IN NUMBER
68                                 ,TOT_ITEM_COST2 IN NUMBER
69                                 ,TOT_DIFFERENCE IN NUMBER) RETURN NUMBER;
70 
71   FUNCTION BEFOREREPORT RETURN BOOLEAN;
72 
73   FUNCTION AFTERREPORT RETURN BOOLEAN;
74 
75   FUNCTION DISP_CURRENCYFORMULA(CURR_CODE_SAVED IN VARCHAR2) RETURN VARCHAR2;
76 
77   FUNCTION MIN_PERC_DIFF_SAVEDFORMULA(EXT_PRECISION_SAVED IN VARCHAR2) RETURN NUMBER;
78 
79   FUNCTION MIN_AMT_DIFF_SAVEDFORMULA(EXT_PRECISION_SAVED IN VARCHAR2) RETURN NUMBER;
80 
81   FUNCTION MIN_UNIT_COST_SAVEDFORMULA(EXT_PRECISION_SAVED IN VARCHAR2) RETURN NUMBER;
82 
83   FUNCTION COLUMN1_TITLE_HDRFORMULA(COLUMN1_TITLE_SAVED IN VARCHAR2) RETURN VARCHAR2;
84 
85   FUNCTION AFTERPFORM RETURN BOOLEAN;
86 
87 END BOM_CSTRCTCR_XMLP_PKG;
88