1 PACKAGE EAM_ObjectInstantiation_PUB AUTHID CURRENT_USER AS
2 /* $Header: EAMPMOIS.pls 115.7 2002/12/14 00:27:08 chrng noship $ */
3
4 TYPE Association_Id_Tbl_Type IS
5 TABLE OF NUMBER INDEX BY BINARY_INTEGER;
6
7 -- Log file variables
8 g_log_file UTL_FILE.FILE_TYPE;
9 g_is_logged NUMBER := NVL(FND_PROFILE.VALUE('EAM_MOI_IS_LOGGED'), EAM_API_Log_PVT.g_NO);
10 g_log_file_dir VARCHAR2(2000) := FND_PROFILE.VALUE('EAM_MOI_LOG_FILE_DIR');
11 g_log_file_name VARCHAR2(2000) := FND_PROFILE.VALUE('EAM_MOI_LOG_FILE_NAME');
12
13 -- Start of comments
14 -- API name : Instantiate_Object
15 -- Type : Public
16 -- Function :
17 -- Pre-reqs : None.
18 -- Parameters :
19 -- IN : p_api_version IN NUMBER Required
20 -- p_init_msg_list IN VARCHAR2 Optional
21 -- Default = FND_API.G_FALSE
22 -- p_commit IN VARCHAR2 Optional
23 -- Default = FND_API.G_FALSE
24 -- p_validation_level IN NUMBER Optional
25 -- Default = FND_API.G_VALID_LEVEL_FULL
26 -- p_maintenance_object_id IN NUMBER
27 -- p_maintenance_object_type IN NUMBER
28
29 -- OUT : x_return_status OUT VARCHAR2(1)
30 -- x_msg_count OUT NUMBER
31 -- x_msg_data OUT VARCHAR2(2000)
32
33 -- Version :
34 -- Initial version 1.0
35 --
36 -- Notes : This API is to be called after the creation of a
37 -- maintenance object (item, asset number, etc.).
38 -- Then it will in turn call the private packages for the
39 -- Activity Instantiation and PM Instantiation.
40 --
41 -- End of comments
42
43 PROCEDURE Instantiate_Object
44 ( p_api_version IN NUMBER ,
45 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
46 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
47 p_validation_level IN NUMBER :=
48 FND_API.G_VALID_LEVEL_FULL ,
49 -- returns if Instantiation is successful
50 x_return_status OUT NOCOPY VARCHAR2 ,
51 x_msg_count OUT NOCOPY NUMBER ,
52 x_msg_data OUT NOCOPY VARCHAR2 ,
53
54 -- input: maintenance object (id and type)
55 p_maintenance_object_id IN NUMBER, -- for Maintenance Object Type of 1, this should be Gen_Object_Id
56 p_maintenance_object_type IN NUMBER -- only supports Type 1 (Serial Numbers) for now
57 );
58
59
60
61 -- This is a wrapper for Instantiate_Object.
62 -- It takes current_organization_id, inventory_item_id, serial_number
63 -- and looks up the Gen_Object_Id before calling Instantiate_Object.
64
65 PROCEDURE Instantiate_Serial_Number
66 ( p_api_version IN NUMBER ,
67 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
68 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
69 p_validation_level IN NUMBER :=
70 FND_API.G_VALID_LEVEL_FULL ,
71 -- returns if Instantiation is successful
72 x_return_status OUT NOCOPY VARCHAR2 ,
73 x_msg_count OUT NOCOPY NUMBER ,
74 x_msg_data OUT NOCOPY VARCHAR2 ,
75
76 -- inputs: specify a Serial Number
77 p_current_organization_id IN NUMBER,
78 p_inventory_item_id IN NUMBER,
79 p_serial_number IN VARCHAR2
80 );
81
82 END EAM_ObjectInstantiation_PUB;
83