199: X_Parent_Wip_Name VARCHAR2 := null,
200: X_Relationship_Type NUMBER := null,
201: X_Relation_Status IN OUT NOCOPY VARCHAR2,
202: x_failure_code_required IN OUT NOCOPY VARCHAR2,
203: x_eam_failure_entry_record IN OUT NOCOPY eam_process_failure_entry_pub.eam_failure_entry_record_typ ,
204: x_eam_failure_codes_tbl IN OUT NOCOPY eam_process_failure_entry_pub.eam_failure_codes_tbl_typ
205: ) IS
206:
207: -- Bug # 2251186
200: X_Relationship_Type NUMBER := null,
201: X_Relation_Status IN OUT NOCOPY VARCHAR2,
202: x_failure_code_required IN OUT NOCOPY VARCHAR2,
203: x_eam_failure_entry_record IN OUT NOCOPY eam_process_failure_entry_pub.eam_failure_entry_record_typ ,
204: x_eam_failure_codes_tbl IN OUT NOCOPY eam_process_failure_entry_pub.eam_failure_codes_tbl_typ
205: ) IS
206:
207: -- Bug # 2251186
208: l_errbuf VARCHAR2(1000) ;
280: l_Expand_Parent VARCHAR2(100);
281: temp NUMBER;
282: l_output_dir VARCHAR2(512);
283: l_err_text VARCHAR2(2000);
284: l_eam_failure_entry_record eam_process_failure_entry_pub.eam_failure_entry_record_typ ;
285: l_eam_failure_codes_tbl eam_process_failure_entry_pub.eam_failure_codes_tbl_typ;
286:
287:
288: BEGIN
281: temp NUMBER;
282: l_output_dir VARCHAR2(512);
283: l_err_text VARCHAR2(2000);
284: l_eam_failure_entry_record eam_process_failure_entry_pub.eam_failure_entry_record_typ ;
285: l_eam_failure_codes_tbl eam_process_failure_entry_pub.eam_failure_codes_tbl_typ;
286:
287:
288: BEGIN
289:
397: l_workorder_rec.failure_code_required := x_failure_code_required;
398: IF l_eam_failure_entry_record.failure_date IS NULL THEN
399: l_eam_failure_entry_record.transaction_type := NULL;
400: ELSE
401: l_eam_failure_entry_record.transaction_type := EAM_Process_Failure_Entry_PUB.G_FE_CREATE ;
402: END IF;
403: l_workorder_rec.eam_failure_entry_record := l_eam_failure_entry_record;
404: FOR i in 1..l_eam_failure_codes_tbl.count
405: LOOP
407: AND l_eam_failure_codes_tbl(i).cause_code IS NULL
408: AND l_eam_failure_codes_tbl(i).resolution_code IS NULL
409: AND l_eam_failure_codes_tbl(i).comments IS NULL
410: )) THEN
411: l_eam_failure_codes_tbl(i).transaction_type := EAM_Process_Failure_Entry_PUB.G_FE_CREATE;
412: l_workorder_rec.eam_failure_codes_tbl(i) := l_eam_failure_codes_tbl(i);
413: ELSE
414: l_workorder_rec.eam_failure_codes_tbl(i) := l_eam_failure_codes_tbl(i);
415: l_workorder_rec.eam_failure_codes_tbl.delete(i);
834: X_material_issue_by_mo IN OUT NOCOPY VARCHAR2,
835: X_activity_source IN OUT NOCOPY VARCHAR2,
836: X_old_rebuild_source NUMBER := NULL,
837: x_failure_code_required IN OUT NOCOPY VARCHAR2,
838: x_eam_failure_entry_record IN OUT NOCOPY eam_process_failure_entry_pub.eam_failure_entry_record_typ,
839: x_eam_failure_codes_tbl IN OUT NOCOPY eam_process_failure_entry_pub.eam_failure_codes_tbl_typ,
840: x_return_status IN OUT NOCOPY VARCHAR2 /*7003588*/
841: ) IS
842:
835: X_activity_source IN OUT NOCOPY VARCHAR2,
836: X_old_rebuild_source NUMBER := NULL,
837: x_failure_code_required IN OUT NOCOPY VARCHAR2,
838: x_eam_failure_entry_record IN OUT NOCOPY eam_process_failure_entry_pub.eam_failure_entry_record_typ,
839: x_eam_failure_codes_tbl IN OUT NOCOPY eam_process_failure_entry_pub.eam_failure_codes_tbl_typ,
840: x_return_status IN OUT NOCOPY VARCHAR2 /*7003588*/
841: ) IS
842:
843:
944: l_prev_attribute12 VARCHAR2(150);
945: l_prev_attribute13 VARCHAR2(150);
946: l_prev_attribute14 VARCHAR2(150);
947: l_prev_attribute15 VARCHAR2(150);
948: l_eam_failure_entry_record eam_process_failure_entry_pub.eam_failure_entry_record_typ;
949: l_eam_failure_codes_tbl eam_process_failure_entry_pub.eam_failure_codes_tbl_typ;
950:
951: /* Added for bug#5346446 Start */
952: l_prev_project_id NUMBER;
945: l_prev_attribute13 VARCHAR2(150);
946: l_prev_attribute14 VARCHAR2(150);
947: l_prev_attribute15 VARCHAR2(150);
948: l_eam_failure_entry_record eam_process_failure_entry_pub.eam_failure_entry_record_typ;
949: l_eam_failure_codes_tbl eam_process_failure_entry_pub.eam_failure_codes_tbl_typ;
950:
951: /* Added for bug#5346446 Start */
952: l_prev_project_id NUMBER;
953: l_prev_task_id NUMBER;
1287: END IF;
1288: END LOOP;
1289:
1290: IF l_eam_failure_entry_record.failure_id IS NOT NULL THEN
1291: l_eam_failure_entry_record.transaction_type := EAM_Process_Failure_Entry_PUB.G_FE_UPDATE;
1292: ELSIF l_eam_failure_entry_record.failure_date = FND_API.G_MISS_DATE THEN
1293: l_eam_failure_entry_record.transaction_type :=null;
1294: ELSE
1295: l_eam_failure_entry_record.transaction_type := EAM_Process_Failure_Entry_PUB.G_FE_CREATE ;
1291: l_eam_failure_entry_record.transaction_type := EAM_Process_Failure_Entry_PUB.G_FE_UPDATE;
1292: ELSIF l_eam_failure_entry_record.failure_date = FND_API.G_MISS_DATE THEN
1293: l_eam_failure_entry_record.transaction_type :=null;
1294: ELSE
1295: l_eam_failure_entry_record.transaction_type := EAM_Process_Failure_Entry_PUB.G_FE_CREATE ;
1296: END IF;
1297:
1298: FOR i in 1..l_eam_failure_codes_tbl.count
1299: LOOP
1297:
1298: FOR i in 1..l_eam_failure_codes_tbl.count
1299: LOOP
1300: IF l_eam_failure_codes_tbl(i).failure_entry_id IS NOT NULL THEN
1301: l_eam_failure_codes_tbl(i).transaction_type := EAM_Process_Failure_Entry_PUB.G_FE_UPDATE;
1302: l_workorder_rec.eam_failure_codes_tbl(i) := l_eam_failure_codes_tbl(i);
1303: ELSE
1304: IF (not( (l_eam_failure_codes_tbl(i).failure_code = FND_API.G_MISS_CHAR)
1305: and (l_eam_failure_codes_tbl(i).cause_code = FND_API.G_MISS_CHAR)
1305: and (l_eam_failure_codes_tbl(i).cause_code = FND_API.G_MISS_CHAR)
1306: and (l_eam_failure_codes_tbl(i).resolution_code = FND_API.G_MISS_CHAR)
1307: and (l_eam_failure_codes_tbl(i).comments = FND_API.G_MISS_CHAR)
1308: )) THEN
1309: l_eam_failure_codes_tbl(i).transaction_type := EAM_Process_Failure_Entry_PUB.G_FE_CREATE;
1310: if l_eam_failure_codes_tbl(i).failure_code = FND_API.G_MISS_CHAR THEN
1311: l_eam_failure_codes_tbl(i).failure_code := NULL;
1312: END IF;
1313: IF l_eam_failure_codes_tbl(i).cause_code = FND_API.G_MISS_CHAR THEN