DBA Data[Home] [Help]

APPS.EAM_WORKORDER_PKG dependencies on EAM_PROCESS_FAILURE_ENTRY_PUB

Line 202: x_eam_failure_entry_record IN OUT NOCOPY eam_process_failure_entry_pub.eam_failure_entry_record_typ ,

198: X_Parent_Wip_Name VARCHAR2 := null,
199: X_Relationship_Type NUMBER := null,
200: X_Relation_Status IN OUT NOCOPY VARCHAR2,
201: x_failure_code_required IN OUT NOCOPY VARCHAR2,
202: x_eam_failure_entry_record IN OUT NOCOPY eam_process_failure_entry_pub.eam_failure_entry_record_typ ,
203: x_eam_failure_codes_tbl IN OUT NOCOPY eam_process_failure_entry_pub.eam_failure_codes_tbl_typ
204: ) IS
205:
206: -- Bug # 2251186

Line 203: x_eam_failure_codes_tbl IN OUT NOCOPY eam_process_failure_entry_pub.eam_failure_codes_tbl_typ

199: X_Relationship_Type NUMBER := null,
200: X_Relation_Status IN OUT NOCOPY VARCHAR2,
201: x_failure_code_required IN OUT NOCOPY VARCHAR2,
202: x_eam_failure_entry_record IN OUT NOCOPY eam_process_failure_entry_pub.eam_failure_entry_record_typ ,
203: x_eam_failure_codes_tbl IN OUT NOCOPY eam_process_failure_entry_pub.eam_failure_codes_tbl_typ
204: ) IS
205:
206: -- Bug # 2251186
207: l_errbuf VARCHAR2(1000) ;

Line 283: l_eam_failure_entry_record eam_process_failure_entry_pub.eam_failure_entry_record_typ ;

279: l_Expand_Parent VARCHAR2(100);
280: temp NUMBER;
281: l_output_dir VARCHAR2(512);
282: l_err_text VARCHAR2(2000);
283: l_eam_failure_entry_record eam_process_failure_entry_pub.eam_failure_entry_record_typ ;
284: l_eam_failure_codes_tbl eam_process_failure_entry_pub.eam_failure_codes_tbl_typ;
285:
286:
287: BEGIN

Line 284: l_eam_failure_codes_tbl eam_process_failure_entry_pub.eam_failure_codes_tbl_typ;

280: temp NUMBER;
281: l_output_dir VARCHAR2(512);
282: l_err_text VARCHAR2(2000);
283: l_eam_failure_entry_record eam_process_failure_entry_pub.eam_failure_entry_record_typ ;
284: l_eam_failure_codes_tbl eam_process_failure_entry_pub.eam_failure_codes_tbl_typ;
285:
286:
287: BEGIN
288:

Line 399: l_eam_failure_entry_record.transaction_type := EAM_Process_Failure_Entry_PUB.G_FE_CREATE ;

395: l_workorder_rec.failure_code_required := x_failure_code_required;
396: IF l_eam_failure_entry_record.failure_date IS NULL THEN
397: l_eam_failure_entry_record.transaction_type := NULL;
398: ELSE
399: l_eam_failure_entry_record.transaction_type := EAM_Process_Failure_Entry_PUB.G_FE_CREATE ;
400: END IF;
401: l_workorder_rec.eam_failure_entry_record := l_eam_failure_entry_record;
402: FOR i in 1..l_eam_failure_codes_tbl.count
403: LOOP

Line 409: l_eam_failure_codes_tbl(i).transaction_type := EAM_Process_Failure_Entry_PUB.G_FE_CREATE;

405: AND l_eam_failure_codes_tbl(i).cause_code IS NULL
406: AND l_eam_failure_codes_tbl(i).resolution_code IS NULL
407: AND l_eam_failure_codes_tbl(i).comments IS NULL
408: )) THEN
409: l_eam_failure_codes_tbl(i).transaction_type := EAM_Process_Failure_Entry_PUB.G_FE_CREATE;
410: l_workorder_rec.eam_failure_codes_tbl(i) := l_eam_failure_codes_tbl(i);
411: ELSE
412: l_workorder_rec.eam_failure_codes_tbl(i) := l_eam_failure_codes_tbl(i);
413: l_workorder_rec.eam_failure_codes_tbl.delete(i);

Line 834: x_eam_failure_entry_record IN OUT NOCOPY eam_process_failure_entry_pub.eam_failure_entry_record_typ,

830: X_material_issue_by_mo IN OUT NOCOPY VARCHAR2,
831: X_activity_source IN OUT NOCOPY VARCHAR2,
832: X_old_rebuild_source NUMBER := NULL,
833: x_failure_code_required IN OUT NOCOPY VARCHAR2,
834: x_eam_failure_entry_record IN OUT NOCOPY eam_process_failure_entry_pub.eam_failure_entry_record_typ,
835: x_eam_failure_codes_tbl IN OUT NOCOPY eam_process_failure_entry_pub.eam_failure_codes_tbl_typ,
836: x_return_status IN OUT NOCOPY VARCHAR2 /*7003588*/
837: ) IS
838:

Line 835: x_eam_failure_codes_tbl IN OUT NOCOPY eam_process_failure_entry_pub.eam_failure_codes_tbl_typ,

831: X_activity_source IN OUT NOCOPY VARCHAR2,
832: X_old_rebuild_source NUMBER := NULL,
833: x_failure_code_required IN OUT NOCOPY VARCHAR2,
834: x_eam_failure_entry_record IN OUT NOCOPY eam_process_failure_entry_pub.eam_failure_entry_record_typ,
835: x_eam_failure_codes_tbl IN OUT NOCOPY eam_process_failure_entry_pub.eam_failure_codes_tbl_typ,
836: x_return_status IN OUT NOCOPY VARCHAR2 /*7003588*/
837: ) IS
838:
839:

Line 944: l_eam_failure_entry_record eam_process_failure_entry_pub.eam_failure_entry_record_typ;

940: l_prev_attribute12 VARCHAR2(150);
941: l_prev_attribute13 VARCHAR2(150);
942: l_prev_attribute14 VARCHAR2(150);
943: l_prev_attribute15 VARCHAR2(150);
944: l_eam_failure_entry_record eam_process_failure_entry_pub.eam_failure_entry_record_typ;
945: l_eam_failure_codes_tbl eam_process_failure_entry_pub.eam_failure_codes_tbl_typ;
946:
947: /* Added for bug#5346446 Start */
948: l_prev_project_id NUMBER;

Line 945: l_eam_failure_codes_tbl eam_process_failure_entry_pub.eam_failure_codes_tbl_typ;

941: l_prev_attribute13 VARCHAR2(150);
942: l_prev_attribute14 VARCHAR2(150);
943: l_prev_attribute15 VARCHAR2(150);
944: l_eam_failure_entry_record eam_process_failure_entry_pub.eam_failure_entry_record_typ;
945: l_eam_failure_codes_tbl eam_process_failure_entry_pub.eam_failure_codes_tbl_typ;
946:
947: /* Added for bug#5346446 Start */
948: l_prev_project_id NUMBER;
949: l_prev_task_id NUMBER;

Line 1286: l_eam_failure_entry_record.transaction_type := EAM_Process_Failure_Entry_PUB.G_FE_UPDATE;

1282: END IF;
1283: END LOOP;
1284:
1285: IF l_eam_failure_entry_record.failure_id IS NOT NULL THEN
1286: l_eam_failure_entry_record.transaction_type := EAM_Process_Failure_Entry_PUB.G_FE_UPDATE;
1287: ELSIF l_eam_failure_entry_record.failure_date = FND_API.G_MISS_DATE THEN
1288: l_eam_failure_entry_record.transaction_type :=null;
1289: ELSE
1290: l_eam_failure_entry_record.transaction_type := EAM_Process_Failure_Entry_PUB.G_FE_CREATE ;

Line 1290: l_eam_failure_entry_record.transaction_type := EAM_Process_Failure_Entry_PUB.G_FE_CREATE ;

1286: l_eam_failure_entry_record.transaction_type := EAM_Process_Failure_Entry_PUB.G_FE_UPDATE;
1287: ELSIF l_eam_failure_entry_record.failure_date = FND_API.G_MISS_DATE THEN
1288: l_eam_failure_entry_record.transaction_type :=null;
1289: ELSE
1290: l_eam_failure_entry_record.transaction_type := EAM_Process_Failure_Entry_PUB.G_FE_CREATE ;
1291: END IF;
1292:
1293: FOR i in 1..l_eam_failure_codes_tbl.count
1294: LOOP

Line 1296: l_eam_failure_codes_tbl(i).transaction_type := EAM_Process_Failure_Entry_PUB.G_FE_UPDATE;

1292:
1293: FOR i in 1..l_eam_failure_codes_tbl.count
1294: LOOP
1295: IF l_eam_failure_codes_tbl(i).failure_entry_id IS NOT NULL THEN
1296: l_eam_failure_codes_tbl(i).transaction_type := EAM_Process_Failure_Entry_PUB.G_FE_UPDATE;
1297: l_workorder_rec.eam_failure_codes_tbl(i) := l_eam_failure_codes_tbl(i);
1298: ELSE
1299: IF (not( (l_eam_failure_codes_tbl(i).failure_code = FND_API.G_MISS_CHAR)
1300: and (l_eam_failure_codes_tbl(i).cause_code = FND_API.G_MISS_CHAR)

Line 1304: l_eam_failure_codes_tbl(i).transaction_type := EAM_Process_Failure_Entry_PUB.G_FE_CREATE;

1300: and (l_eam_failure_codes_tbl(i).cause_code = FND_API.G_MISS_CHAR)
1301: and (l_eam_failure_codes_tbl(i).resolution_code = FND_API.G_MISS_CHAR)
1302: and (l_eam_failure_codes_tbl(i).comments = FND_API.G_MISS_CHAR)
1303: )) THEN
1304: l_eam_failure_codes_tbl(i).transaction_type := EAM_Process_Failure_Entry_PUB.G_FE_CREATE;
1305: if l_eam_failure_codes_tbl(i).failure_code = FND_API.G_MISS_CHAR THEN
1306: l_eam_failure_codes_tbl(i).failure_code := NULL;
1307: END IF;
1308: IF l_eam_failure_codes_tbl(i).cause_code = FND_API.G_MISS_CHAR THEN