[Home] [Help]
PACKAGE: APPS.AHL_PRD_DISPOSITION_PVT
Source
1 PACKAGE AHL_PRD_DISPOSITION_PVT AS
2 /* $Header: AHLVDISS.pls 120.2.12010000.2 2008/12/09 01:41:07 jaramana 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 SECURITY_GROUP_ID NUMBER,
65 ATTRIBUTE_CATEGORY VARCHAR2(30),
66 ATTRIBUTE1 VARCHAR2(150),
67 ATTRIBUTE2 VARCHAR2(150),
68 ATTRIBUTE3 VARCHAR2(150),
69 ATTRIBUTE4 VARCHAR2(150),
70 ATTRIBUTE5 VARCHAR2(150),
71 ATTRIBUTE6 VARCHAR2(150),
72 ATTRIBUTE7 VARCHAR2(150),
73 ATTRIBUTE8 VARCHAR2(150),
74 ATTRIBUTE9 VARCHAR2(150),
75 ATTRIBUTE10 VARCHAR2(150),
76 ATTRIBUTE11 VARCHAR2(150),
77 ATTRIBUTE12 VARCHAR2(150),
78 ATTRIBUTE13 VARCHAR2(150),
79 ATTRIBUTE14 VARCHAR2(150),
80 ATTRIBUTE15 VARCHAR2(150)
81 );
82
83 TYPE Disposition_Tbl_Type IS TABLE OF Disposition_Rec_Type
84 INDEX BY BINARY_INTEGER;
85 ------------------------
86 -- Declare Procedures --
87 ------------------------
88
89 -- Start of Comments --
90 -- Define procedure CREATE_JOB_DISPOSITIONS
91 --
92 -- Procedure name: CREATE_JOB_DISPOSITIONS
93 -- Type: Private
94 -- Function: To get all default dispositions for a job from its related route and then put
95 -- them into the dispostion entity.
96 -- Pre-reqs:
97 --
98 -- Parameters:
99 -- p_workorder_id IN NUMBER Required
100 -- Version: Initial Version 1.0
101 --
102 -- End of Comments --
103 PROCEDURE create_job_dispositions(
104 p_api_version IN NUMBER := 1.0,
105 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
106 p_commit IN VARCHAR2 := FND_API.G_FALSE,
107 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
108 x_return_status OUT NOCOPY VARCHAR2,
109 x_msg_count OUT NOCOPY NUMBER,
110 x_msg_data OUT NOCOPY VARCHAR2,
111 p_workorder_id IN NUMBER);
112
113
114 -- Start of Comments --
115 -- Procedure name : process_disposition
116 -- Type : Private
117 -- Function : create or update a disposition based on the input diposition record.
118 -- Pre-reqs :
119 -- Parameters :
120 --
121 -- Standard IN Parameters :
122 -- p_api_version IN NUMBER Default 1.0
123 -- p_init_msg_list IN VARCHAR2 Default FND_API.G_TRUE
124 -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
125 -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
126 -- Standard OUT Parameters :
127 -- x_return_status OUT VARCHAR2 Required
128 -- x_msg_count OUT NUMBER Required
129 -- x_msg_data OUT VARCHAR2 Required
130 --
131 -- p_module_type IN VARCHAR2 Required.
132 --
133 -- This parameter indicates the front-end form interface. The default value is 'JSP'. If the value
134 -- is JSP, then this API clears out all id columns and validations are done using the values based
135 -- on which the Id's are populated.
136 --
137 -- process_disposition Parameters:
138 --
139 -- p_x_disposition_rec IN OUT NOCOPY AHL_PRD_DISPOSITION_PVT.disposition_rec_type Required
140 --
141 --
142 -- Version :
143 -- Initial Version 1.0
144 --
145 -- End of Comments.
146
147 PROCEDURE process_disposition(
148 p_api_version IN NUMBER := 1.0,
149 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
150 p_commit IN VARCHAR2 := FND_API.G_FALSE,
151 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
152 p_module_type IN VARCHAR2 := NULL,
153 p_x_disposition_rec IN OUT NOCOPY AHL_PRD_DISPOSITION_PVT.disposition_rec_type,
154 -- Parameter added by jaramana on Oct 9, 2007 for ER 5883257
155 p_mr_asso_tbl IN AHL_PRD_NONROUTINE_PVT.MR_Association_tbl_type,
156 x_return_status OUT NOCOPY VARCHAR2,
157 x_msg_count OUT NOCOPY NUMBER,
158 x_msg_data OUT NOCOPY VARCHAR2);
159
160 --------------------------
161 End AHL_PRD_DISPOSITION_PVT;
162 ----------------------------------------------