DBA Data[Home] [Help]

PACKAGE: APPS.BOM_CSTGILEV_XMLP_PKG

Source


1 PACKAGE BOM_CSTGILEV_XMLP_PKG AS
2 /* $Header: CSTGILEVS.pls 120.0 2007/12/24 09:48:23 dwkrishn noship $ */
3   P_LEGAL_ENTITY_ID NUMBER;
4 
5   P_COST_GROUP_ID NUMBER;
6 
7   P_COST_TYPE_ID NUMBER;
8 
9   P_PAC_PERIOD_ID NUMBER;
10 
11   P_CONC_REQUEST_ID NUMBER;
12 
13   P_ITEM_CODE_FROM VARCHAR2(32767);
14 
15   P_ITEM_CODE_TO VARCHAR2(32767);
16 
17   P_QUANTITY_PRECISION NUMBER;
18 
19   P_QUANTITY_PRECISION_1 NUMBER;
20 
21   P_DETAILED_REPORT VARCHAR2(1);
22 
23   P_DETAILED_REPORT_SUBTITLE VARCHAR2(48);
24 
25   P_SUMMARIZED_REPORT_SUBTITLE VARCHAR2(48);
26 
27   P_COST_PRECISION NUMBER;
28   P_COST_PRECISION_1 NUMBER;
29 
30   P_VALUE_PRECISION NUMBER;
31   P_VALUE_PRECISION_1 NUMBER;
32   H_LEGAL_ENTITY VARCHAR2(240);
33 
34   H_COST_GROUP VARCHAR2(32767);
35 
36   H_COST_TYPE VARCHAR2(32767);
37 
38   H_PERIOD VARCHAR2(15);
39 
40   H_CURRENCY VARCHAR2(15);
41 
42   H_REPORT_SUBTITLE VARCHAR2(132);
43 
44   H_COST_GROUP_DESC VARCHAR2(240);
45 
46   H_COST_TYPE_DESC VARCHAR2(240);
47 
48   H_FISCAL_YEAR NUMBER;
49 
50   H_UPTO_DATE VARCHAR2(32767);
51 
52   qty_precision1 varchar2(100);
53   qty_precision2 varchar2(100);
54   qty_precision3 varchar2(100);
55 
56   FUNCTION AFTERREPORT RETURN BOOLEAN;
57 
58   FUNCTION BEFOREREPORT RETURN BOOLEAN;
59 
60 --  PROCEDURE FORMAT_QUANTITY(P_PRECISION IN NUMBER);
61 
62   FUNCTION H_LEGAL_ENTITY_P RETURN VARCHAR2;
63 
64   FUNCTION H_COST_GROUP_P RETURN VARCHAR2;
65 
66   FUNCTION H_COST_TYPE_P RETURN VARCHAR2;
67 
68   FUNCTION H_PERIOD_P RETURN VARCHAR2;
69 
70   FUNCTION H_CURRENCY_P RETURN VARCHAR2;
71 
72   FUNCTION H_REPORT_SUBTITLE_P RETURN VARCHAR2;
73 
74   FUNCTION H_COST_GROUP_DESC_P RETURN VARCHAR2;
75 
76   FUNCTION H_COST_TYPE_DESC_P RETURN VARCHAR2;
77 
78   FUNCTION H_FISCAL_YEAR_P RETURN NUMBER;
79 
80   FUNCTION H_UPTO_DATE_P RETURN VARCHAR2;
81 
82 END BOM_CSTGILEV_XMLP_PKG;
83