[Home] [Help]
PACKAGE: APPS.AHL_PRD_DISPOSITION_PVT
Source
1 PACKAGE AHL_PRD_DISPOSITION_PVT AUTHID CURRENT_USER AS
2 /* $Header: AHLVDISS.pls 120.4.12020000.2 2012/12/14 07:53:29 shnatu ship $ */
3
4 G_OP_CREATE CONSTANT VARCHAR(1) := 'C';
5 G_OP_UPDATE CONSTANT VARCHAR(1) := 'U';
6 G_OP_DELETE CONSTANT VARCHAR(1) := 'D';
7
8 --YES NO FLAGS
9 G_NO_FLAG CONSTANT VARCHAR2(1) := 'N';
10 G_YES_FLAG CONSTANT VARCHAR2(1) := 'Y';
11
12
13
14
15 TYPE disposition_rec_type IS RECORD (
16 DISPOSITION_ID NUMBER,
17 OPERATION_FLAG VARCHAR2(1),
18 OBJECT_VERSION_NUMBER NUMBER,
19 LAST_UPDATE_DATE DATE,
20 LAST_UPDATED_BY NUMBER,
21 CREATION_DATE DATE,
22 CREATED_BY NUMBER,
23 LAST_UPDATE_LOGIN NUMBER,
24 WORKORDER_ID NUMBER,
25 PART_CHANGE_ID NUMBER,
26 PATH_POSITION_ID NUMBER,
27 INVENTORY_ITEM_ID NUMBER,
28 ITEM_ORG_ID NUMBER,
29 ITEM_GROUP_ID NUMBER,
30 CONDITION_ID NUMBER,
31 INSTANCE_ID NUMBER,
32 COLLECTION_ID NUMBER,
33 PRIMARY_SERVICE_REQUEST_ID NUMBER,
34 NON_ROUTINE_WORKORDER_ID NUMBER,
35 WO_OPERATION_ID NUMBER,
36 ITEM_REVISION VARCHAR(3),
37 SERIAL_NUMBER VARCHAR2(30),
38 LOT_NUMBER MTL_LOT_NUMBERS.LOT_NUMBER%TYPE,
39 IMMEDIATE_DISPOSITION_CODE VARCHAR2(30),
40 SECONDARY_DISPOSITION_CODE VARCHAR2(30),
41 STATUS_CODE VARCHAR2(30),
42 QUANTITY NUMBER,
43 UOM VARCHAR2(3),
44 COMMENTS VARCHAR2(2000),
45 SEVERITY_ID NUMBER,
46 PROBLEM_CODE VARCHAR(50),
47 SUMMARY VARCHAR(240),
48 DURATION NUMBER, -- For Service Request
49 -- Following option added by jaramana on October 9, 2007 for ER 5903318
50 CREATE_WORK_ORDER_OPTION VARCHAR2(30),
51 IMMEDIATE_DISPOSITION VARCHAR(150),
52 SECONDARY_DISPOSITION VARCHAR(150),
53 CONDITION_MEANING VARCHAR(150),
54 INSTANCE_NUMBER VARCHAR(30),
55 ITEM_NUMBER VARCHAR(40),
56 ITEM_GROUP_NAME VARCHAR(80),
57 DISPOSITION_STATUS VARCHAR(80),
58 SEVERITY_NAME VARCHAR2(30),
59 PROBLEM_MEANING VARCHAR2(80),
60 OPERATION_SEQUENCE NUMBER,
61 -- Following two attributes added by jaramana on 18-NOV-2008 for bug 7566597
62 RESOLUTION_CODE VARCHAR2(30),
63 RESOLUTION_MEANING VARCHAR2(80),
64 -- Following attribute added by surrkuma on 29-NOV-2010 for ER 9213556
65 PARENT_INSTANCE_ID NUMBER,
66 SECURITY_GROUP_ID NUMBER,
67 -- AVIKUKUM :: FP:PIE ::14-OCT-2010 :: Service Type attributes added
68 SERVICE_TYPE_CODE VARCHAR2(30) := NULL,
69 SERVICE_TYPE VARCHAR2(80) := NULL,
70 ATTRIBUTE_CATEGORY VARCHAR2(30),
71 ATTRIBUTE1 VARCHAR2(150),
72 ATTRIBUTE2 VARCHAR2(150),
73 ATTRIBUTE3 VARCHAR2(150),
74 ATTRIBUTE4 VARCHAR2(150),
75 ATTRIBUTE5 VARCHAR2(150),
76 ATTRIBUTE6 VARCHAR2(150),
77 ATTRIBUTE7 VARCHAR2(150),
78 ATTRIBUTE8 VARCHAR2(150),
79 ATTRIBUTE9 VARCHAR2(150),
80 ATTRIBUTE10 VARCHAR2(150),
81 ATTRIBUTE11 VARCHAR2(150),
82 ATTRIBUTE12 VARCHAR2(150),
83 ATTRIBUTE13 VARCHAR2(150),
84 ATTRIBUTE14 VARCHAR2(150),
85 ATTRIBUTE15 VARCHAR2(150)
86 );
87
88 TYPE Disposition_Tbl_Type IS TABLE OF Disposition_Rec_Type
89 INDEX BY BINARY_INTEGER;
90 ------------------------
91 -- Declare Procedures --
92 ------------------------
93
94 -- Start of Comments --
95 -- Define procedure CREATE_JOB_DISPOSITIONS
96 --
97 -- Procedure name: CREATE_JOB_DISPOSITIONS
98 -- Type: Private
99 -- Function: To get all default dispositions for a job from its related route and then put
100 -- them into the dispostion entity.
101 -- Pre-reqs:
102 --
103 -- Parameters:
104 -- p_workorder_id IN NUMBER Required
105 -- Version: Initial Version 1.0
106 --
107 -- End of Comments --
108 PROCEDURE create_job_dispositions(
109 p_api_version IN NUMBER := 1.0,
110 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
111 p_commit IN VARCHAR2 := FND_API.G_FALSE,
112 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
113 x_return_status OUT NOCOPY VARCHAR2,
114 x_msg_count OUT NOCOPY NUMBER,
115 x_msg_data OUT NOCOPY VARCHAR2,
116 p_workorder_id IN NUMBER);
117
118
119 -- Start of Comments --
120 -- Procedure name : process_disposition
121 -- Type : Private
122 -- Function : create or update a disposition based on the input diposition record.
123 -- Pre-reqs :
124 -- Parameters :
125 --
126 -- Standard IN Parameters :
127 -- p_api_version IN NUMBER Default 1.0
128 -- p_init_msg_list IN VARCHAR2 Default FND_API.G_TRUE
129 -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
130 -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
131 -- Standard OUT Parameters :
132 -- x_return_status OUT VARCHAR2 Required
133 -- x_msg_count OUT NUMBER Required
134 -- x_msg_data OUT VARCHAR2 Required
135 --
136 -- p_module_type IN VARCHAR2 Required.
137 --
138 -- This parameter indicates the front-end form interface. The default value is 'JSP'. If the value
139 -- is JSP, then this API clears out all id columns and validations are done using the values based
140 -- on which the Id's are populated.
141 --
142 -- process_disposition Parameters:
143 --
144 -- p_x_disposition_rec IN OUT NOCOPY AHL_PRD_DISPOSITION_PVT.disposition_rec_type Required
145 --
146 --
147 -- Version :
148 -- Initial Version 1.0
149 --
150 -- End of Comments.
151
152 PROCEDURE process_disposition(
153 p_api_version IN NUMBER := 1.0,
154 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
155 p_commit IN VARCHAR2 := FND_API.G_FALSE,
156 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
157 p_module_type IN VARCHAR2 := NULL,
158 p_x_disposition_rec IN OUT NOCOPY AHL_PRD_DISPOSITION_PVT.disposition_rec_type,
159 -- Parameter added by jaramana on Oct 9, 2007 for ER 5883257
160 p_mr_asso_tbl IN AHL_PRD_NONROUTINE_PVT.MR_Association_tbl_type,
161 x_return_status OUT NOCOPY VARCHAR2,
162 x_msg_count OUT NOCOPY NUMBER,
163 x_msg_data OUT NOCOPY VARCHAR2);
164
165 --------------------------
166 End AHL_PRD_DISPOSITION_PVT;
167 ----------------------------------------------