[Home] [Help]
PACKAGE: APPS.EAM_PROCESS_FAILURE_ENTRY_PUB
Source
1 PACKAGE EAM_Process_Failure_Entry_PUB AUTHID CURRENT_USER AS
2 /* $Header: EAMPFENS.pls 120.1.12020000.2 2012/12/11 06:31:28 shengywa ship $ */
3
4 G_FE_CREATE CONSTANT NUMBER := 1;
5 G_FE_UPDATE CONSTANT NUMBER := 2;
6 G_FE_DELETE CONSTANT NUMBER := 3;
7 G_RECORD_FOUND CONSTANT VARCHAR2(1) := 'S';
8 G_RECORD_NOT_FOUND CONSTANT VARCHAR2(1) := 'F';
9
10 TYPE EAM_Failure_Entry_Record_Typ IS RECORD
11 (
12 failure_id NUMBER,
13 failure_date DATE,
14 source_type NUMBER,
15 source_id NUMBER,
16 object_type NUMBER,
17 object_id NUMBER,
18 maint_organization_id NUMBER,
19 current_organization_id NUMBER,
20 department_id NUMBER,
21 area_id NUMBER,
22 transaction_type VARCHAR2(1),
23 source_name VARCHAR2(240) /* Work Order Name for source_type =1 */
24 );
25
26 TYPE Eam_Failure_Codes_Typ IS RECORD
27 (
28 /* source_id NUMBER, Wip Entity Id for source_type =1
29 source_type NUMBER, 1 for Work Order
30 source_name VARCHAR2, Work Order Name for source_type =1 */
31 failure_id NUMBER,
32 failure_entry_id NUMBER,
33 combination_id NUMBER,
34 failure_code VARCHAR2(80), /* Changed size from 30 to 80 for BUG#5904859*/
35 cause_code VARCHAR2(80), /* Changed size from 30 to 80 for BUG#5904859*/
36 resolution_code VARCHAR2(80), /* Changed size from 30 to 80 for BUG#5904859*/
37 comments VARCHAR2(2000), /* Changed size from 240 to 2000 for BUG#15980885*/
38 transaction_type VARCHAR2(1)
39 );
40
41 TYPE Eam_Failure_Codes_Tbl_Typ IS TABLE OF Eam_Failure_Codes_Typ
42 INDEX BY BINARY_INTEGER;
43
44 /**************************************************************************
45 -- Start of comments
46 -- API name : Process_Failure_Entry
47 -- Type : Public.
48 -- Function : Insert/ Update Failure Information corresponding
49 -- to a work order
50 -- Pre-reqs : None.
51 -- Parameters :
52 -- IN : p_api_version IN NUMBER Required
53 -- p_init_msg_list IN VARCHAR2 Optional
54 -- Default = FND_API.G_FALSE
55 -- p_commit IN VARCHAR2 Optional
56 -- Default = FND_API.G_FALSE
57 -- p_eam_failure_entry_record IN
58 -- Eam_Process_Failure_Entry_PUB.eam_failure_entry_record_typ
59 -- p_eam_failure_codes_tbl IN
60 -- Eam_Process_Failure_Entry_PUB.eam_failure_codes_tbl_typ
61 -- OUT : x_return_status OUT NOCOPY VARCHAR2(1)
62 -- x_msg_count OUT NOCOPY NUMBER
63 -- x_msg_data OUT NOCOPY VARCHAR2(2000)
64 -- x_eam_failure_entry_record OUT NOCOPY
65 -- Eam_Process_Failure_Entry_PUB.eam_failure_entry_record_typ
66 -- x_eam_failure_codes_tbl OUT NOCOPY
67 -- Eam_Process_Failure_Entry_PUB.eam_failure_codes_tbl_typ
68 -- Version : Current version 1.0.
69 -- Initial version 1.0
70 -- End of comments
71 ***************************************************************************/
72
73 PROCEDURE Process_Failure_Entry
74 ( p_api_version IN NUMBER := 1.0
75 , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
76 , p_commit IN VARCHAR2 := FND_API.G_FALSE
77 , p_eam_failure_entry_record IN Eam_Process_Failure_Entry_PUB.eam_failure_entry_record_typ
78 , p_eam_failure_codes_tbl IN Eam_Process_Failure_Entry_PUB.eam_failure_codes_tbl_typ
79 , x_return_status OUT NOCOPY VARCHAR2
80 , x_msg_count OUT NOCOPY NUMBER
81 , x_msg_data OUT NOCOPY VARCHAR2
82 , x_eam_failure_entry_record OUT NOCOPY Eam_Process_Failure_Entry_PUB.eam_failure_entry_record_typ
83 , x_eam_failure_codes_tbl OUT NOCOPY Eam_Process_Failure_Entry_PUB.eam_failure_codes_tbl_typ
84 );
85
86 END EAM_Process_Failure_Entry_PUB;