DBA Data[Home] [Help]

APPS.EAM_DIRECT_ITEMS_DEFAULT_PVT dependencies on FND_API

Line 68: IF p_eam_direct_items_rec.attribute_category =FND_API.G_MISS_CHAR THEN

64:
65: -- In the future call Flex APIs for defaults
66: x_eam_direct_items_rec := p_eam_direct_items_rec;
67:
68: IF p_eam_direct_items_rec.attribute_category =FND_API.G_MISS_CHAR THEN
69: x_eam_direct_items_rec.attribute_category := NULL;
70: END IF;
71:
72: IF p_eam_direct_items_rec.attribute1 = FND_API.G_MISS_CHAR THEN

Line 72: IF p_eam_direct_items_rec.attribute1 = FND_API.G_MISS_CHAR THEN

68: IF p_eam_direct_items_rec.attribute_category =FND_API.G_MISS_CHAR THEN
69: x_eam_direct_items_rec.attribute_category := NULL;
70: END IF;
71:
72: IF p_eam_direct_items_rec.attribute1 = FND_API.G_MISS_CHAR THEN
73: x_eam_direct_items_rec.attribute1 := NULL;
74: END IF;
75:
76: IF p_eam_direct_items_rec.attribute2 = FND_API.G_MISS_CHAR THEN

Line 76: IF p_eam_direct_items_rec.attribute2 = FND_API.G_MISS_CHAR THEN

72: IF p_eam_direct_items_rec.attribute1 = FND_API.G_MISS_CHAR THEN
73: x_eam_direct_items_rec.attribute1 := NULL;
74: END IF;
75:
76: IF p_eam_direct_items_rec.attribute2 = FND_API.G_MISS_CHAR THEN
77: x_eam_direct_items_rec.attribute2 := NULL;
78: END IF;
79:
80: IF p_eam_direct_items_rec.attribute3 = FND_API.G_MISS_CHAR THEN

Line 80: IF p_eam_direct_items_rec.attribute3 = FND_API.G_MISS_CHAR THEN

76: IF p_eam_direct_items_rec.attribute2 = FND_API.G_MISS_CHAR THEN
77: x_eam_direct_items_rec.attribute2 := NULL;
78: END IF;
79:
80: IF p_eam_direct_items_rec.attribute3 = FND_API.G_MISS_CHAR THEN
81: x_eam_direct_items_rec.attribute3 := NULL;
82: END IF;
83:
84: IF p_eam_direct_items_rec.attribute4 = FND_API.G_MISS_CHAR THEN

Line 84: IF p_eam_direct_items_rec.attribute4 = FND_API.G_MISS_CHAR THEN

80: IF p_eam_direct_items_rec.attribute3 = FND_API.G_MISS_CHAR THEN
81: x_eam_direct_items_rec.attribute3 := NULL;
82: END IF;
83:
84: IF p_eam_direct_items_rec.attribute4 = FND_API.G_MISS_CHAR THEN
85: x_eam_direct_items_rec.attribute4 := NULL;
86: END IF;
87:
88: IF p_eam_direct_items_rec.attribute5 = FND_API.G_MISS_CHAR THEN

Line 88: IF p_eam_direct_items_rec.attribute5 = FND_API.G_MISS_CHAR THEN

84: IF p_eam_direct_items_rec.attribute4 = FND_API.G_MISS_CHAR THEN
85: x_eam_direct_items_rec.attribute4 := NULL;
86: END IF;
87:
88: IF p_eam_direct_items_rec.attribute5 = FND_API.G_MISS_CHAR THEN
89: x_eam_direct_items_rec.attribute5 := NULL;
90: END IF;
91:
92: IF p_eam_direct_items_rec.attribute6 = FND_API.G_MISS_CHAR THEN

Line 92: IF p_eam_direct_items_rec.attribute6 = FND_API.G_MISS_CHAR THEN

88: IF p_eam_direct_items_rec.attribute5 = FND_API.G_MISS_CHAR THEN
89: x_eam_direct_items_rec.attribute5 := NULL;
90: END IF;
91:
92: IF p_eam_direct_items_rec.attribute6 = FND_API.G_MISS_CHAR THEN
93: x_eam_direct_items_rec.attribute6 := NULL;
94: END IF;
95:
96: IF p_eam_direct_items_rec.attribute7 = FND_API.G_MISS_CHAR THEN

Line 96: IF p_eam_direct_items_rec.attribute7 = FND_API.G_MISS_CHAR THEN

92: IF p_eam_direct_items_rec.attribute6 = FND_API.G_MISS_CHAR THEN
93: x_eam_direct_items_rec.attribute6 := NULL;
94: END IF;
95:
96: IF p_eam_direct_items_rec.attribute7 = FND_API.G_MISS_CHAR THEN
97: x_eam_direct_items_rec.attribute7 := NULL;
98: END IF;
99:
100: IF p_eam_direct_items_rec.attribute8 = FND_API.G_MISS_CHAR THEN

Line 100: IF p_eam_direct_items_rec.attribute8 = FND_API.G_MISS_CHAR THEN

96: IF p_eam_direct_items_rec.attribute7 = FND_API.G_MISS_CHAR THEN
97: x_eam_direct_items_rec.attribute7 := NULL;
98: END IF;
99:
100: IF p_eam_direct_items_rec.attribute8 = FND_API.G_MISS_CHAR THEN
101: x_eam_direct_items_rec.attribute8 := NULL;
102: END IF;
103:
104: IF p_eam_direct_items_rec.attribute9 = FND_API.G_MISS_CHAR THEN

Line 104: IF p_eam_direct_items_rec.attribute9 = FND_API.G_MISS_CHAR THEN

100: IF p_eam_direct_items_rec.attribute8 = FND_API.G_MISS_CHAR THEN
101: x_eam_direct_items_rec.attribute8 := NULL;
102: END IF;
103:
104: IF p_eam_direct_items_rec.attribute9 = FND_API.G_MISS_CHAR THEN
105: x_eam_direct_items_rec.attribute9 := NULL;
106: END IF;
107:
108: IF p_eam_direct_items_rec.attribute10 = FND_API.G_MISS_CHAR THEN

Line 108: IF p_eam_direct_items_rec.attribute10 = FND_API.G_MISS_CHAR THEN

104: IF p_eam_direct_items_rec.attribute9 = FND_API.G_MISS_CHAR THEN
105: x_eam_direct_items_rec.attribute9 := NULL;
106: END IF;
107:
108: IF p_eam_direct_items_rec.attribute10 = FND_API.G_MISS_CHAR THEN
109: x_eam_direct_items_rec.attribute10 := NULL;
110: END IF;
111:
112: IF p_eam_direct_items_rec.attribute11 = FND_API.G_MISS_CHAR THEN

Line 112: IF p_eam_direct_items_rec.attribute11 = FND_API.G_MISS_CHAR THEN

108: IF p_eam_direct_items_rec.attribute10 = FND_API.G_MISS_CHAR THEN
109: x_eam_direct_items_rec.attribute10 := NULL;
110: END IF;
111:
112: IF p_eam_direct_items_rec.attribute11 = FND_API.G_MISS_CHAR THEN
113: x_eam_direct_items_rec.attribute11 := NULL;
114: END IF;
115:
116: IF p_eam_direct_items_rec.attribute12 = FND_API.G_MISS_CHAR THEN

Line 116: IF p_eam_direct_items_rec.attribute12 = FND_API.G_MISS_CHAR THEN

112: IF p_eam_direct_items_rec.attribute11 = FND_API.G_MISS_CHAR THEN
113: x_eam_direct_items_rec.attribute11 := NULL;
114: END IF;
115:
116: IF p_eam_direct_items_rec.attribute12 = FND_API.G_MISS_CHAR THEN
117: x_eam_direct_items_rec.attribute12 := NULL;
118: END IF;
119:
120: IF p_eam_direct_items_rec.attribute13 = FND_API.G_MISS_CHAR THEN

Line 120: IF p_eam_direct_items_rec.attribute13 = FND_API.G_MISS_CHAR THEN

116: IF p_eam_direct_items_rec.attribute12 = FND_API.G_MISS_CHAR THEN
117: x_eam_direct_items_rec.attribute12 := NULL;
118: END IF;
119:
120: IF p_eam_direct_items_rec.attribute13 = FND_API.G_MISS_CHAR THEN
121: x_eam_direct_items_rec.attribute13 := NULL;
122: END IF;
123:
124: IF p_eam_direct_items_rec.attribute14 = FND_API.G_MISS_CHAR THEN

Line 124: IF p_eam_direct_items_rec.attribute14 = FND_API.G_MISS_CHAR THEN

120: IF p_eam_direct_items_rec.attribute13 = FND_API.G_MISS_CHAR THEN
121: x_eam_direct_items_rec.attribute13 := NULL;
122: END IF;
123:
124: IF p_eam_direct_items_rec.attribute14 = FND_API.G_MISS_CHAR THEN
125: x_eam_direct_items_rec.attribute14 := NULL;
126: END IF;
127:
128: IF p_eam_direct_items_rec.attribute15 = FND_API.G_MISS_CHAR THEN

Line 128: IF p_eam_direct_items_rec.attribute15 = FND_API.G_MISS_CHAR THEN

124: IF p_eam_direct_items_rec.attribute14 = FND_API.G_MISS_CHAR THEN
125: x_eam_direct_items_rec.attribute14 := NULL;
126: END IF;
127:
128: IF p_eam_direct_items_rec.attribute15 = FND_API.G_MISS_CHAR THEN
129: x_eam_direct_items_rec.attribute15 := NULL;
130: END IF;
131:
132: END get_flex_eam_direct_items;

Line 157: x_return_status := FND_API.G_RET_STS_SUCCESS;

153: BEGIN
154:
155: x_eam_direct_items_rec := p_eam_direct_items_rec;
156: -- x_eam_direct_items_rec := p_eam_direct_items_rec;
157: x_return_status := FND_API.G_RET_STS_SUCCESS;
158:
159: IF p_eam_direct_items_rec.transaction_type = EAM_PROCESS_WO_PUB.G_OPR_CREATE
160: then
161: -- Defaulting direct_item_sequence_id

Line 167: p_eam_direct_items_rec.auto_request_material = FND_API.G_MISS_CHAR

163: END IF;
164:
165: -- Defaulting AUTO_REQUEST_MATERIAL flag.
166: IF p_eam_direct_items_rec.auto_request_material IS NULL OR
167: p_eam_direct_items_rec.auto_request_material = FND_API.G_MISS_CHAR
168: THEN
169: x_eam_direct_items_rec.auto_request_material := 'Y';
170: END IF;
171:

Line 174: p_eam_direct_items_rec.department_id = FND_API.G_MISS_NUM) AND

170: END IF;
171:
172: -- Defaulting department_id
173: IF (p_eam_direct_items_rec.department_id IS NULL OR
174: p_eam_direct_items_rec.department_id = FND_API.G_MISS_NUM) AND
175: p_eam_direct_items_rec.operation_seq_num is not null AND
176: p_eam_direct_items_rec.organization_id is not null AND
177: p_eam_direct_items_rec.wip_entity_id is not null
178: THEN

Line 208: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

204: , p_message_text => G_PKG_NAME || SQLERRM
205: , x_mesg_token_Tbl => x_mesg_token_tbl
206: );
207:
208: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
209:
210: END Attribute_Defaulting;
211:
212:

Line 236: p_eam_direct_items_rec.description = FND_API.G_MISS_CHAR

232:
233: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Processing null columns prior update'); END IF;
234:
235: IF p_eam_direct_items_rec.description IS NULL OR
236: p_eam_direct_items_rec.description = FND_API.G_MISS_CHAR
237: THEN
238: x_eam_direct_items_rec.description := p_old_eam_direct_items_rec.description;
239: END IF;
240:

Line 242: p_eam_direct_items_rec.purchasing_category_id = FND_API.G_MISS_NUM

238: x_eam_direct_items_rec.description := p_old_eam_direct_items_rec.description;
239: END IF;
240:
241: IF p_eam_direct_items_rec.purchasing_category_id IS NULL OR
242: p_eam_direct_items_rec.purchasing_category_id = FND_API.G_MISS_NUM
243: THEN
244: x_eam_direct_items_rec.purchasing_category_id := p_old_eam_direct_items_rec.purchasing_category_id;
245: END IF;
246:

Line 248: p_eam_direct_items_rec.uom = FND_API.G_MISS_CHAR

244: x_eam_direct_items_rec.purchasing_category_id := p_old_eam_direct_items_rec.purchasing_category_id;
245: END IF;
246:
247: IF p_eam_direct_items_rec.uom IS NULL OR
248: p_eam_direct_items_rec.uom = FND_API.G_MISS_CHAR
249: THEN
250: x_eam_direct_items_rec.uom := p_old_eam_direct_items_rec.uom;
251: END IF;
252:

Line 254: p_eam_direct_items_rec.suggested_vendor_name = FND_API.G_MISS_CHAR

250: x_eam_direct_items_rec.uom := p_old_eam_direct_items_rec.uom;
251: END IF;
252:
253: IF p_eam_direct_items_rec.suggested_vendor_name IS NULL OR
254: p_eam_direct_items_rec.suggested_vendor_name = FND_API.G_MISS_CHAR
255: THEN
256: x_eam_direct_items_rec.suggested_vendor_name := p_old_eam_direct_items_rec.suggested_vendor_name;
257: END IF;
258:

Line 260: p_eam_direct_items_rec.suggested_vendor_id = FND_API.G_MISS_NUM

256: x_eam_direct_items_rec.suggested_vendor_name := p_old_eam_direct_items_rec.suggested_vendor_name;
257: END IF;
258:
259: IF p_eam_direct_items_rec.suggested_vendor_id IS NULL OR
260: p_eam_direct_items_rec.suggested_vendor_id = FND_API.G_MISS_NUM
261: THEN
262: x_eam_direct_items_rec.suggested_vendor_id := p_old_eam_direct_items_rec.suggested_vendor_id;
263: END IF;
264:

Line 266: p_eam_direct_items_rec.suggested_vendor_site = FND_API.G_MISS_CHAR

262: x_eam_direct_items_rec.suggested_vendor_id := p_old_eam_direct_items_rec.suggested_vendor_id;
263: END IF;
264:
265: IF p_eam_direct_items_rec.suggested_vendor_site IS NULL OR
266: p_eam_direct_items_rec.suggested_vendor_site = FND_API.G_MISS_CHAR
267: THEN
268: x_eam_direct_items_rec.suggested_vendor_site := p_old_eam_direct_items_rec.suggested_vendor_site;
269: END IF;
270:

Line 272: p_eam_direct_items_rec.suggested_vendor_site_id = FND_API.G_MISS_NUM

268: x_eam_direct_items_rec.suggested_vendor_site := p_old_eam_direct_items_rec.suggested_vendor_site;
269: END IF;
270:
271: IF p_eam_direct_items_rec.suggested_vendor_site_id IS NULL OR
272: p_eam_direct_items_rec.suggested_vendor_site_id = FND_API.G_MISS_NUM
273: THEN
274: x_eam_direct_items_rec.suggested_vendor_site_id := p_old_eam_direct_items_rec.suggested_vendor_site_id;
275: END IF;
276:

Line 278: p_eam_direct_items_rec.suggested_vendor_contact = FND_API.G_MISS_CHAR

274: x_eam_direct_items_rec.suggested_vendor_site_id := p_old_eam_direct_items_rec.suggested_vendor_site_id;
275: END IF;
276:
277: IF p_eam_direct_items_rec.suggested_vendor_contact IS NULL OR
278: p_eam_direct_items_rec.suggested_vendor_contact = FND_API.G_MISS_CHAR
279: THEN
280: x_eam_direct_items_rec.suggested_vendor_contact := p_old_eam_direct_items_rec.suggested_vendor_contact;
281: END IF;
282:

Line 284: p_eam_direct_items_rec.suggested_vendor_contact_id = FND_API.G_MISS_NUM

280: x_eam_direct_items_rec.suggested_vendor_contact := p_old_eam_direct_items_rec.suggested_vendor_contact;
281: END IF;
282:
283: IF p_eam_direct_items_rec.suggested_vendor_contact_id IS NULL OR
284: p_eam_direct_items_rec.suggested_vendor_contact_id = FND_API.G_MISS_NUM
285: THEN
286: x_eam_direct_items_rec.suggested_vendor_contact_id := p_old_eam_direct_items_rec.suggested_vendor_contact_id;
287: END IF;
288:

Line 290: p_eam_direct_items_rec.suggested_vendor_phone = FND_API.G_MISS_CHAR

286: x_eam_direct_items_rec.suggested_vendor_contact_id := p_old_eam_direct_items_rec.suggested_vendor_contact_id;
287: END IF;
288:
289: IF p_eam_direct_items_rec.suggested_vendor_phone IS NULL OR
290: p_eam_direct_items_rec.suggested_vendor_phone = FND_API.G_MISS_CHAR
291: THEN
292: x_eam_direct_items_rec.suggested_vendor_phone := p_old_eam_direct_items_rec.suggested_vendor_phone;
293: END IF;
294:

Line 296: p_eam_direct_items_rec.suggested_vendor_item_num = FND_API.G_MISS_CHAR

292: x_eam_direct_items_rec.suggested_vendor_phone := p_old_eam_direct_items_rec.suggested_vendor_phone;
293: END IF;
294:
295: IF p_eam_direct_items_rec.suggested_vendor_item_num IS NULL OR
296: p_eam_direct_items_rec.suggested_vendor_item_num = FND_API.G_MISS_CHAR
297: THEN
298: x_eam_direct_items_rec.suggested_vendor_item_num := p_old_eam_direct_items_rec.suggested_vendor_item_num;
299: END IF;
300:

Line 302: p_eam_direct_items_rec.unit_price = FND_API.G_MISS_NUM

298: x_eam_direct_items_rec.suggested_vendor_item_num := p_old_eam_direct_items_rec.suggested_vendor_item_num;
299: END IF;
300:
301: IF p_eam_direct_items_rec.unit_price IS NULL OR
302: p_eam_direct_items_rec.unit_price = FND_API.G_MISS_NUM
303: THEN
304: x_eam_direct_items_rec.unit_price := p_old_eam_direct_items_rec.unit_price;
305: END IF;
306:

Line 308: p_eam_direct_items_rec.department_id = FND_API.G_MISS_NUM

304: x_eam_direct_items_rec.unit_price := p_old_eam_direct_items_rec.unit_price;
305: END IF;
306:
307: IF p_eam_direct_items_rec.department_id IS NULL OR
308: p_eam_direct_items_rec.department_id = FND_API.G_MISS_NUM
309: THEN
310: x_eam_direct_items_rec.department_id := p_old_eam_direct_items_rec.department_id;
311: END IF;
312:

Line 315: p_eam_direct_items_rec.need_by_date = FND_API.G_MISS_DATE

311: END IF;
312:
313:
314: IF p_eam_direct_items_rec.need_by_date IS NULL OR
315: p_eam_direct_items_rec.need_by_date = FND_API.G_MISS_DATE
316: THEN
317: x_eam_direct_items_rec.need_by_date := p_old_eam_direct_items_rec.need_by_date;
318: END IF;
319:

Line 321: p_eam_direct_items_rec.required_quantity = FND_API.G_MISS_NUM

317: x_eam_direct_items_rec.need_by_date := p_old_eam_direct_items_rec.need_by_date;
318: END IF;
319:
320: IF p_eam_direct_items_rec.required_quantity IS NULL OR
321: p_eam_direct_items_rec.required_quantity = FND_API.G_MISS_NUM
322: THEN
323: x_eam_direct_items_rec.required_quantity := p_old_eam_direct_items_rec.required_quantity;
324: END IF;
325:

Line 411: IF p_eam_direct_items_rec.auto_request_material = FND_API.G_MISS_CHAR OR

407: THEN
408: x_eam_direct_items_rec.attribute15 := p_old_eam_direct_items_rec.attribute15;
409: END IF;
410:
411: IF p_eam_direct_items_rec.auto_request_material = FND_API.G_MISS_CHAR OR
412: p_eam_direct_items_rec.auto_request_material IS NULL
413: THEN
414: x_eam_direct_items_rec.auto_request_material := p_old_eam_direct_items_rec.auto_request_material;
415: END IF;