PACKAGE: APPS.PA_ASSET_REVERSAL_PVT

Source

1 PACKAGE PA_ASSET_REVERSAL_PVT AUTHID CURRENT_USER AS
2 /* $Header: PACAREVS.pls 115.3 2003/08/18 14:29:48 ajdas noship $ */
3 
4 
5 TYPE project_assets_rec_type IS RECORD
6 (project_asset_id		     NUMBER			:= NULL,
7 processed_flag				 VARCHAR2(1)	:= 'N'
8 );
9 
10 TYPE project_assets_tbl_type IS TABLE OF project_assets_rec_type
11 	INDEX BY BINARY_INTEGER;
12 
13 --Global variable for indexing of PL/SQL Table
14 G_project_assets_tbl         project_assets_tbl_type;
15 
16 --Global variable for Debug mode message control
17 PG_DEBUG varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
18 
19 
20 
21 
22 PROCEDURE CHECK_PROJECT_ASSET
23 	(p_project_asset_id     IN	    NUMBER,
24     x_project_assets           OUT NOCOPY PA_ASSET_REVERSAL_PVT.project_assets_tbl_type,
25     x_related_assets_exist     OUT NOCOPY BOOLEAN,
26     x_return_status            OUT NOCOPY VARCHAR2,
27     x_msg_data                 OUT NOCOPY VARCHAR2);
28 
29 
30 PROCEDURE CHECK_ASSET_LINES
31 	(p_project_asset_id     IN	    NUMBER);
32 
33 
34 FUNCTION ASSET_IN_TBL
35     (p_project_asset_id     IN	    NUMBER) RETURN BOOLEAN;
36 
37 
38 PROCEDURE Upd_RelAssets_RevFlag
39 	(x_project_assets       IN            PA_ASSET_REVERSAL_PVT.project_assets_tbl_type,
40          x_update_count       OUT NOCOPY NUMBER,
41     x_return_status            OUT NOCOPY VARCHAR2,
42     x_msg_data                 OUT NOCOPY VARCHAR2);
43 
44 
45 END PA_ASSET_REVERSAL_PVT;