1 PACKAGE EAM_ASSET_LOG_PUB AUTHID CURRENT_USER AS
2 /* $Header: EAMPALGS.pls 120.2 2006/10/05 06:05:59 kmurthy noship $ */
3 /*
4 * This package is used for the Logging Asset Events.
5 * It defines a procedure log_event which first validates and massages the
6 * IN parameters and then carries out the respective operations.
7 */
8
9 /*
10 -- API name : LOG_EVENT
11 -- Type : Public
12 -- Function : log_event and validate_event of the asset log data
13 -- Pre-reqs : None.
14 */
15 g_pkg_name constant varchar2(30):='eam_asset_log_pub';
16
17 /* This procedure inserts a record in the eam_asset_log table
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_event_date IN DATE
27 -- p_event_type IN VARCHAR2
28 -- p_event_id IN NUMBER
29 -- p_instance_id IN NUMBER
30 -- p_asset_number IN VARCHAR2
31 -- p_comments IN VARCHAR2
32 -- p_reference IN VARCHAR2
33 -- p_ref_id IN VARCHAR2
34 -- p_operable_flag IN NUMBER
35 -- p_reason_code IN VARCHAR2
36 -- p_equipment_gen_object_id IN NUMBER
37 -- p_resource_id IN NUMBER
38 -- p_down_code IN NUMBER
39 -- p_expected_up_date IN DATE
40 --
41 -- OUT : x_return_status OUT NOCOPY VARCHAR2(1)
42 -- x_msg_count OUT NOCOPY NUMBER
43 -- x_msg_data OUT NOCOPY VARCHAR2 (2000)
44 --
45 -- Version : Current version: 1.0
46 -- Initial version: 1.0
47 --
48 -- Notes
49 --
50 -- End of comments
51 */
52
53 /*
54 * This procedure is used to insert records in to EAM_ASSET_LOG table.
55 * It is used to create Asset Event Log.
56 * p_api_version Version of the API
57 * p_init_msg_list Flag to indicate initialization of message list
58 * p_commit Flag to indicate whether API should commit changes
59 * p_validation_level Validation Level of the API
60 * x_return_status Return status of the procedure call
61 * x_msg_count Count of the return messages that API returns
62 * x_msg_data The collection of the messages
63 * p_event_date Indicates Event date of the Asset Log
64 * p_event_type Name of Event Type of the Asset Log Event
65 * p_event_id Event Id which gets logged.
66 * p_organization_id Organization Id which maintains the asset.
67 * p_instance_id Asset id identifier of the asset or rebuildable.
68 * p_instance_number Asset Number / Asset Instance number identification
69 * p_comments To log additional information / Remarks about the event on which log is generated.
70 * p_reference Reference number of the event eg: WO Number, WR Number, JO Number, etc.
71 * p_ref_id Primary Key identification of the reference.
72 * p_operable_flag Status of the Asset or Rebuildable at the time of Event Log.
73 * p_reason_code Reason Code for generation of Event Log.
74 * p_equipment_gen_object_id Identification of the OSFM resource attached to the asset.
75 * p_resource_id Prime Identification of the resource Instance attached to the asset.
76 * p_downcode Resource down code of OSFM resource attached to the asset which generated the Asset Log.
77 * p_employee_id Identification of the Employee in OSFM who creates the Event Log.
78 * p_department_id Identification of the Department which identifies this asset as Resource.
79 * p_expected_up_date Expected Up date of an OSFM resource at the time of Event Log.
80 * return Returns the newly created Primary Key for the record inserted
81 */
82
83
84 PROCEDURE LOG_EVENT(
85 p_api_version IN number := 1.0,
86 p_init_msg_list IN varchar2 := fnd_api.g_false,
87 p_commit IN varchar2 := fnd_api.g_false,
88 p_validation_level IN number := fnd_api.g_valid_level_full,
89 p_event_date IN date := sysdate,
90 p_event_type IN varchar2,
91 p_event_id IN number,
92 p_organization_id IN number := null,
93 p_instance_id IN number := null,
94 p_instance_number IN varchar2 := null,
95 p_comments IN varchar2 := null,
96 p_reference IN varchar2 := null,
97 p_ref_id IN number,
98 p_operable_flag IN number := null,
99 p_reason_code IN number := null,
100 p_equipment_gen_object_id IN number := null,
101 p_resource_id IN number := null,
102 p_downcode IN number := null,
103 p_employee_id IN number := null,
104 p_department_id IN number := null,
105 p_expected_up_date IN date := null,
106 x_return_status OUT NOCOPY varchar2,
107 x_msg_count OUT NOCOPY number,
108 x_msg_data OUT NOCOPY varchar2);
109
110 END EAM_ASSET_LOG_PUB;