PACKAGE: APPS.IBE_REPORTING_PVT

Source

1 PACKAGE IBE_REPORTING_PVT AUTHID CURRENT_USER AS
2 /* $Header: IBEVECRS.pls 115.15 2002/12/10 11:29:08 suchandr ship $ */
3 
4 G_PKG_NAME CONSTANT VARCHAR2(30) := 'IBE_REPORTING_PKG';
5 
6 PROCEDURE  printDebugLog(pDebugStmt Varchar2);
7 
8 FUNCTION get_item_count(inventory_item_id in number,header_id in number) return number;
9 
10 PROCEDURE  getFrequencyDate(pDate IN Date, pFrequency IN Varchar2, pPeriodSetName IN varchar2, pdayoffset IN Number, pStartDate OUT NOCOPY Date, pEndDate OUT NOCOPY Date);
11 
12 PROCEDURE  removeFactData( pMode IN Varchar2, pName IN Varchar2, pFromDate IN Date, pToDate IN Date);
13 
14 PROCEDURE  forceRefreshData(pForceRefreshFlag IN Varchar2,pMode IN Varchar2, pObjName IN Varchar2,pBeginDate IN Date,pEndDate IN Date,pForceRefreshStatus OUT NOCOPY Varchar2);
15 
16 PROCEDURE  dropIndex( pMode IN Varchar2, pOwner IN Varchar2,pName IN Varchar2);
17 PROCEDURE  createIndex( pMode IN Varchar2, pName IN Varchar2);
18 
19 
20 PROCEDURE insertOrderHeaderFact( p_currency_code IN Varchar2, pFromDate IN Date, pToDate IN Date);
21 PROCEDURE insertOrderLineFact( p_currency_code IN Varchar2, pFromDate IN Date, pToDate IN Date);
22 PROCEDURE insertBinFact(pRefreshDate IN Date);
23 PROCEDURE insertBinFact(pCurrencyCode IN Varchar2,pRefreshDate IN Date);
24 
25 PROCEDURE refreshFact(pMode IN Varchar2,pFactName IN Varchar2,pBeginDate IN Varchar2, pEndDate IN Varchar2);
26 
27 PROCEDURE refreshFactMain(errbuf OUT NOCOPY VARCHAR2,retcode OUT NOCOPY NUMBER,
28 		pMode IN varchar2 default 'COMPLETE', pBeginDate IN varchar2,
29 		pEndDate IN varchar2,pDayOffset IN Number default 0,
30 		pDebugFlag IN Varchar2 default 'N',pRateCheckFlag IN Varchar2 default 'N');
31 
32 PROCEDURE refreshMview(pMode IN Varchar2, pMViewName Varchar2,pFactName Varchar2);
33 
34 PROCEDURE refreshMviewMain( errbuf OUT NOCOPY VARCHAR2,retcode OUT NOCOPY NUMBER, pfactRefreshMode IN Varchar2 default 'COMPLETE', pDebugFlag IN Varchar2 Default 'N');
35 
36 PROCEDURE purgeMain(errbuf    OUT NOCOPY  VARCHAR2, retcode OUT NOCOPY    NUMBER, pDebugFlag IN Varchar2 Default 'N');
37 
38 -- added by savio for bundle roll up
39 FUNCTION return_amount(p_inventory_item_id number,p_organization_id number,p_order_header_id number) return number;
40 
41 FUNCTION return_functional_amount(p_inventory_item_id number   , p_organization_id number ,
42                                   p_order_header_id number     , p_item_type_code varchar2,
43                                   p_line_category_code varchar2, p_ordered_Quantity number,
44                                   p_Unit_Selling_Price number  ,p_conversion_rate number)
45          RETURN number;
46 
47 FUNCTION get_section_path(section_id in number,store_id in number)
48 	    RETURN varchar2;
49 
50 PRAGMA RESTRICT_REFERENCES (get_section_path, WNDS);
51 END;