[Home] [Help]
PACKAGE: APPS.AHL_WORKORDER_SEARCH_PUB
Source
1 PACKAGE AHL_WORKORDER_SEARCH_PUB AS
2 /* $Header: AHLPWSOS.pls 120.0.12010000.1 2008/11/30 21:14:08 sikumar noship $ */
3
4 G_PKG_NAME CONSTANT VARCHAR2(28) := 'AHL_WORKORDER_SEARCH_PUB';
5
6 -- Definition of search criteria for searching workorders for a user role
7 TYPE WORKORDERS_SEARCH_REC_TYPE IS RECORD
8 (
9 WORKORDER_NUMBER VARCHAR2(80),
10 DESCRIPTION VARCHAR2(240),
11 STATUS_CODE VARCHAR2(30),
12 STATUS VARCHAR2(80),
13 VISIT_NUMBER NUMBER,
14 SCHEDULED_START_DATE DATE,
15 SCHEDULED_END_DATE DATE,
16 START_ROW_INDEX NUMBER,
17 NUMBER_OF_ROWS NUMBER,
18 SEARCH_TABLE_INDEX NUMBER,
19 ACCOUNTING_CLASS VARCHAR2(10),
20 DEPARTMENT_CLASS_CODE VARCHAR2(10),
21 VISIT_TASK_NUMBER NUMBER,
22 PROJECT VARCHAR2(30),
23 PROJECT_TASK VARCHAR2(20),
24 MAINTENANCE_REQUIREMENT_TITLE VARCHAR2(80),
25 ITEM VARCHAR2(30),
26 ORGANIZATION VARCHAR2(240),
27 DEPARTMENT VARCHAR2(240),
28 UNIT_NAME VARCHAR2(4000),
29 EMPLOYEE VARCHAR2(240),
30 NON_ROUTINE_NUMBER VARCHAR2(80),
31 OPERATION_CODE VARCHAR2(30),
32 OPERATION_DESCRIPTION VARCHAR2(500),
33 PRIORITY VARCHAR2(80),
34 CONFIRMED_FAILURE_FLAG VARCHAR2(1),
35 BOM_RESOURCE VARCHAR2(10),
36 WORKORDER_TYPE VARCHAR2(80)
37 );
38
39 -- Definition of WORK_ORDER_REC_TYPE
40 TYPE WORK_ORDER_REC_TYPE IS RECORD
41 (
42 WORKORDER_ID NUMBER,
43 OBJECT_VERSION_NUMBER NUMBER,
44 WORKORDER_NUMBER VARCHAR2(80),
45 DESCRIPTION VARCHAR2(240),
46 STATUS_CODE VARCHAR2(30),
47 STATUS VARCHAR2(80),
48 VISIT_NUMBER NUMBER,
49 UNIT_NAME VARCHAR2(4000),
50 MODEL VARCHAR2(30),
51 ATA_CODE VARCHAR2(30),
52 ENIGMA_DOCUMENT_ID VARCHAR2(80),
53 ASSIGNED_START_DATE DATE,
54 IS_COMPLETE_ENABLED VARCHAR2(1),
55 IS_UPDATE_ENABLED VARCHAR2(1),
56 IS_RES_TXN_ENABLED VARCHAR2(1)
57 );
58
59 -- Definition of search results record structure WORK_ORDERS_SEARCH_RESULT_TBL_TYPE
60 TYPE WORK_ORDERS_RESULT_TBL_TYPE IS TABLE OF WORK_ORDER_REC_TYPE
61 index by Binary_Integer;
62
63 -- Definition of ASSIGNED_WORK_ORDERS_TYPE
64 TYPE WORK_ORDERS_TYPE IS RECORD
65 (
66 START_ROW_INDEX NUMBER,
67 NUMBER_OF_ROWS NUMBER,
68 WORK_ORDERS WORK_ORDERS_RESULT_TBL_TYPE
69 );
70
71
72
73
74
75 ------------------------
76 -- Declare Procedure --
77 ------------------------
78 -- Start of Comments --
79 -- Procedure name : get_assgnd_wo_search_results
80 -- Function : Will return the Assigned and User qualified Work Order SEarch Results for an Input Search Criteria
81 --
82 -- Pre-reqs :
83 -- Parameters :
84 --
85 -- Standard IN Parameters :
86 -- p_api_version IN NUMBER Default 1.0
87 -- p_init_msg_list IN VARCHAR2 Default FND_API.G_TRUE
88 -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
89 -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
90 -- Standard OUT Parameters :
91 -- x_return_status OUT VARCHAR2 Required
92 -- x_msg_count OUT NUMBER Required
93 -- x_msg_data OUT VARCHAR2 Required
94 --
95 -- p_module_type IN VARCHAR2 Required.
96 --
97 --
98 -- get_assgnd_wo_search_results Parameters:
99 --
100 -- workorders_search_rec IN OUT WORKORDERS_SEARCH_REC_TYPE
101 -- assigned_work_orders_tbl OUT NOCOPY WORK_ORDERS_SEARCH_RESULT_TBL_TYPE
102 -- user_qlfd_work_orders_tbl OUT NOCOPY WORK_ORDERS_SEARCH_RESULT_TBL_TYPE
103 -- service_return_status_rec OUT NOCOPY SERVICE_RETURN_STATUS_REC_TYPE
104 --
105 --
106 -- Version :
107 -- Initial Version 1.0
108 --
109 -- End of Comments.
110 ------------------------
111
112 PROCEDURE get_wo_search_results(
113 p_api_version IN NUMBER,
114 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
115 p_commit IN VARCHAR2 := FND_API.G_FALSE,
116 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
117 p_module_type IN VARCHAR2,
118 p_userid IN VARCHAR2 := NULL,
119 x_return_status OUT NOCOPY VARCHAR2,
120 x_msg_count OUT NOCOPY NUMBER,
121 x_msg_data OUT NOCOPY VARCHAR2,
122 p_workorders_search_rec IN WORKORDERS_SEARCH_REC_TYPE,
123 x_work_order_results OUT NOCOPY WORK_ORDERS_TYPE
124 );
125
126
127 END AHL_WORKORDER_SEARCH_PUB;