[Home] [Help]
PACKAGE: APPS.EAM_ASSET_NUM_IMPORT_PVT
Source
1 Package EAM_ASSET_NUM_IMPORT_PVT AUTHID CURRENT_USER as
2 /* $Header: EAMVANIS.pls 115.6 2002/11/20 19:02:31 aan ship $*/
3
4 -- Start of comments
5 -- API name : Load_Asset_Number
6 -- Type : Private
7 -- Function :
8 -- Pre-reqs : None.
9 -- Parameters :
10 -- IN p_batch_id IN NUMBER Required,
11 -- p_purge_option IN VARCHAR2 Optional Default = 'N'
12 -- OUT ERRBUF OUT VARCHAR2,
13 -- RETCODE OUT VARCHAR2
14 --
15 -- Version Initial version 1.0 Anirban Dey
16 --
17 -- Notes : This public API imports asset numbers into
18 -- MTL_SERIAL_NUMBERS
19 --
20 -- End of comments
21
22 Error EXCEPTION;
23 Current_Error_Code Varchar2(9) := NULL;
24 Curr_Error Varchar2(9) := NULL;
25
26 PROCEDURE Load_Asset_Numbers
27 (ERRBUF OUT NOCOPY VARCHAR2,
28 RETCODE OUT NOCOPY VARCHAR2,
29 p_batch_id IN NUMBER,
30 p_purge_option IN VARCHAR2 := 'N'
31 );
32
33 FUNCTION Import_Asset_Numbers
34 (
35 p_batch_id IN NUMBER,
36 p_purge_option IN VARCHAR2 := 'N'
37 ) RETURN Number;
38
39
40 END EAM_ASSET_NUM_IMPORT_PVT;