DBA Data[Home] [Help]

PACKAGE: APPS.CE_CSH_FCST_POP

Source


1 PACKAGE CE_CSH_FCST_POP AUTHID CURRENT_USER AS
2 /* $Header: cefpcels.pls 120.5 2003/12/05 19:09:11 sspoonen ship $ 	*/
3 
4 --
5 -- Global variables
6 --
7 source_view		VARCHAR2(160);
8 G_calendar_start	DATE;
9 G_calendar_end		DATE;
10 
11 G_sub_accounts_complete VARCHAR2(1);
12 
13 G_spec_revision 	VARCHAR2(1000) := '$Revision: 120.5 $';
14 --
15 -- Global Procedures/Functions
16 --
17 FUNCTION spec_revision RETURN VARCHAR2;
18 
19 FUNCTION body_revision RETURN VARCHAR2;
20 
21 PROCEDURE Populate_Cells;
22 
23 PROCEDURE Zero_Fill_Cells;
24 
25 PROCEDURE Insert_Fcast_Cell(	p_reference_id 		VARCHAR2,
26 				p_currency_code		VARCHAR2,
27 				p_org_id		NUMBER,
28 				p_trx_date		DATE,
29 				p_bank_account_id	NUMBER,
30 				p_forecast_amount   	NUMBER,
31 				p_trx_amount		NUMBER,
32                             	p_forecast_column_id 	NUMBER);
33 
34 PROCEDURE Populate_Opening_Bal;
35 
36 FUNCTION Get_Average_Payment_Days (X_customer_id 	Number,
37 				   X_site_use_id	Number,
38 				   X_currency_code	VARCHAR2,
39 			 	   X_period		NUMBER ) RETURN NUMBER;
40 
41 END CE_CSH_FCST_POP;