DBA Data[Home] [Help]

PACKAGE: APPS.CE_FORECAST_TRX_CELLS_PKG

Source


1 PACKAGE CE_FORECAST_TRX_CELLS_PKG AUTHID CURRENT_USER as
2 /* $Header: ceftcels.pls 120.0 2004/06/21 21:51:40 bhchung ship $ */
3 
4   PROCEDURE Insert_Row(	X_Rowid			IN OUT NOCOPY	VARCHAR2,
5 			X_forecast_cell_id	IN OUT NOCOPY	NUMBER,
6 			X_forecast_id			NUMBER,
7                         X_forecast_header_id            NUMBER,
8 			X_forecast_row_id		NUMBER,
9 			X_forecast_column_id		NUMBER,
10 			X_amount			NUMBER,
11 			X_trx_amount			NUMBER,
12 			X_reference_id			VARCHAR2,
13 			X_currency_code			VARCHAR2,
14 			X_org_id			NUMBER,
15 			X_include_flag			VARCHAR2,
16 			X_trx_date			DATE,
17 			X_bank_account_id		NUMBER,
18 			X_code_combination_id		NUMBER,
19 		        X_Created_By                    NUMBER,
20                        	X_Creation_Date                 DATE,
21                        	X_Last_Updated_By               NUMBER,
22                        	X_Last_Update_Date              DATE,
23                        	X_Last_Update_Login             NUMBER);
24 
25   PROCEDURE Update_Row( X_cellid                        NUMBER,
26                         X_amount                        NUMBER,
27                         X_Last_Updated_By               NUMBER,
28                         X_Last_Update_Date              DATE,
29                         X_Last_Update_Login             NUMBER);
30 
31   PROCEDURE Delete_row(X_rowid VARCHAR2);
32 
33   PROCEDURE Lock_Row(	X_forecast_cell_id      	NUMBER,
34                         X_amount                        NUMBER);
35 
36 
37 END CE_FORECAST_TRX_CELLS_PKG;