DBA Data[Home] [Help]

APPS.EAM_WORKORDER_PKG dependencies on EAM_PROCESS_FAILURE_ENTRY_PUB

Line 203: x_eam_failure_entry_record IN OUT NOCOPY eam_process_failure_entry_pub.eam_failure_entry_record_typ ,

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

Line 204: x_eam_failure_codes_tbl IN OUT NOCOPY eam_process_failure_entry_pub.eam_failure_codes_tbl_typ

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) ;

Line 284: l_eam_failure_entry_record eam_process_failure_entry_pub.eam_failure_entry_record_typ ;

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

Line 285: l_eam_failure_codes_tbl eam_process_failure_entry_pub.eam_failure_codes_tbl_typ;

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:

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

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

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

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);

Line 838: x_eam_failure_entry_record IN OUT NOCOPY eam_process_failure_entry_pub.eam_failure_entry_record_typ,

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:

Line 839: x_eam_failure_codes_tbl IN OUT NOCOPY eam_process_failure_entry_pub.eam_failure_codes_tbl_typ,

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:

Line 948: l_eam_failure_entry_record eam_process_failure_entry_pub.eam_failure_entry_record_typ;

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;

Line 949: l_eam_failure_codes_tbl eam_process_failure_entry_pub.eam_failure_codes_tbl_typ;

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;

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

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 ;

Line 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

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

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)

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

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