[Home] [Help]
PACKAGE: APPS.AHL_UMP_SMRINSTANCE_PVT
Source
1 PACKAGE AHL_UMP_SMRINSTANCE_PVT AS
2 /* $Header: AHLVSMRS.pls 120.1.12010000.2 2008/12/27 17:57:39 sracha ship $ */
3
4
5
6
7 ---------------------------------------------------------------------
8 -- Define Record Types for record structures needed by the APIs --
9 --------------------------------------------------------------------
10 TYPE Search_MRInstance_Rec_Type IS RECORD (
11 UNIT_NAME VARCHAR2(80),
12 PART_NUMBER VARCHAR2(40),
13 SERIAL_NUMBER VARCHAR2(30),
14 SORT_BY VARCHAR2(30),
15 MR_STATUS VARCHAR2(30),
16 MR_TITLE VARCHAR2(80),
17 PROGRAM_TYPE VARCHAR2(80),
18 DUE_FROM DATE,
19 DUE_TO DATE,
20 SHOW_TOLERANCE VARCHAR2(1),
21 COMPONENTS_FLAG VARCHAR2(1),
22 REPETITIVE_FLAG VARCHAR2(1),
23 CONTRACT_NUMBER VARCHAR2(120),
24 CONTRACT_MODIFIER VARCHAR2(120),
25 SERVICE_LINE_ID NUMBER,
26 SERVICE_LINE_NUM VARCHAR2(150),
27 PROGRAM_ID NUMBER,
28 PROGRAM_TITLE VARCHAR2(80),
29 SHOW_GROUPMR VARCHAR2(1),
30 OBJECT_TYPE VARCHAR2(3),
31 SEARCH_FOR_TYPE VARCHAR2(30),
32 --amsriniv ER 6116245
33 VISIT_NUMBER VARCHAR2(30),
34 VISIT_ORG_NAME VARCHAR2(240),
35 VISIT_DEPT_NAME VARCHAR2(240),
36 --amsriniv ER 6116245
37 --start changes for bug# 7562008
38 INCIDENT_TYPE_ID NUMBER,
39 SERVICE_REQ_NUM cs_incidents_all_b.incident_number%TYPE
40 --end changes for bug# 7562008
41 );
42
43 TYPE Results_MRInstance_Rec_Type IS RECORD (
44 PROGRAM_TYPE_MEANING VARCHAR2(80),
45 MR_TITLE VARCHAR2(80),
46 PART_NUMBER VARCHAR2(40),
47 SERIAL_NUMBER VARCHAR2(30),
48 UOM_REMAIN NUMBER,
49 COUNTER_NAME VARCHAR2(30),
50 EARLIEST_DUE_DATE DATE,
51 DUE_DATE DATE,
52 LATEST_DUE_DATE DATE,
53 TOLERANCE_FLAG VARCHAR2(30),
54 UMR_STATUS_CODE VARCHAR2(30),
55 UMR_STATUS_MEANING VARCHAR2(80),
56 SCHEDULED_DATE DATE,
57 VISIT_NUMBER VARCHAR2(80),
58 VISIT_STATUS VARCHAR2(80),
59 ASSIGN_STATUS VARCHAR2(80),
60 SERVICE_REQ_ID NUMBER,
61 SERVICE_REQ_NUM VARCHAR2(64),
62 SERVICE_REQ_DATE DATE,
63 ORIGINATOR_TITLE VARCHAR2(80),
64 DEPENDANT_TITLE VARCHAR2(80),
65 UNIT_EFFECTIVITY_ID NUMBER,
66 MR_ID NUMBER,
67 CSI_ITEM_INSTANCE_ID NUMBER,
68 INSTANCE_NUMBER VARCHAR2(30),
69 MR_INTERVAL_ID NUMBER,
70 UNIT_NAME VARCHAR2(4000),
71 PROGRAM_TITLE VARCHAR2(80),
72 CONTRACT_NUMBER VARCHAR2(120),
73 DEFER_FROM_UE_ID NUMBER,
74 DEFER_TO_UE_ID NUMBER,
75 UNIT_EFFECTIVITY_TYPE VARCHAR2(30),
76 OBJECT_TYPE VARCHAR2(3),
77 MANUALLY_PLANNED_FLAG VARCHAR2(30),
78 MANUALLY_PLANNED_DESC VARCHAR2(80),
79 VISIT_ID NUMBER --PDOKI Added for ER# 6333770
80
81 );
82
83
84 ----------------------------------------------
85 -- Define Table Type for records structures --
86 ----------------------------------------------
87 TYPE Results_MRInstance_Tbl_Type IS TABLE OF Results_MRInstance_Rec_Type INDEX BY BINARY_INTEGER;
88
89 ------------------------
90 -- Declare Procedures --
91 ------------------------
92 --------------------------------------------------------------------------------------------
93 -- Start of Comments --
94 -- Procedure name : Search_MR_Instances
95 -- Type : Private
96 -- Function : This procedure fetches all the MR Instances based both at the instance level
97 -- and the item level for the given search criteria.
98 -- Pre-reqs :
99 -- Parameters :
100 --
101 -- Standard IN Parameters :
102 -- p_api_version IN NUMBER Required
103 -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
104 -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
105 -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
106 -- p_default IN VARCHAR2 Default FND_API.G_TRUE
107 -- Based on this flag, the API will set the default attributes.
108 -- p_module_type IN VARCHAR2 Default NULL
109 -- This will be null.
110 -- Standard OUT Parameters :
111 -- x_return_status OUT VARCHAR2 Required
112 -- x_msg_count OUT NUMBER Required
113 -- x_msg_data OUT VARCHAR2 Required
114 --
115 -- Search_MR_Instances Parameters :
116 -- p_start_row IN NUMBER Required
117 -- The row from which the search results table should be displayed.
118 -- p_rows_per_page IN NUMBER Required
119 -- The number of rows to be displayed per page.
120 -- p_search_mr_instance_rec IN Search_MRInstance_Rec_Type Required
121 -- The search criteria based on which the query needs to be run to
122 -- return the MR Instances.
123 -- x_results_mr_instance_tbl OUT Results_MRInstance_Tbl_Type Required
124 -- List of all the MR Instances which match the search criteria entered.
125 -- x_results_count OUT NUMBER Required
126 -- The total count of the results returned from the entered search criteria.
127 --
128 --
129 --
130 -- Version :
131 -- Initial Version 1.0
132 --
133 -- End of Comments.
134 --------------------------------------------------------------------------------------------
135
136 PROCEDURE Search_MR_Instances
137 (
138 p_api_version IN NUMBER,
139 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
140 p_commit IN VARCHAR2 := FND_API.G_FALSE,
141 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
142 p_default IN VARCHAR2 := FND_API.G_TRUE,
143 p_module_type IN VARCHAR2 := NULL,
144 p_start_row IN NUMBER,
145 p_rows_per_page IN NUMBER,
146 p_search_mr_instance_rec IN AHL_UMP_SMRINSTANCE_PVT.Search_MRInstance_Rec_Type,
147 x_results_mr_instance_tbl OUT NOCOPY AHL_UMP_SMRINSTANCE_PVT.Results_MRInstance_Tbl_Type,
148 x_results_count OUT NOCOPY NUMBER,
149 x_return_status OUT NOCOPY VARCHAR2,
150 x_msg_count OUT NOCOPY NUMBER,
151 x_msg_data OUT NOCOPY VARCHAR2
152 );
153
154
155
156 END AHL_UMP_SMRINSTANCE_PVT; -- Package spec