eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.EAM_CREATEUPDATE_WO_PVT dependencies on FND_API

Line 55: , p_commit => FND_API.G_FALSE

51: EAM_PROCESS_WO_PUB.COPY_WORKORDER
52: ( p_bo_identifier =>'EAM'
53: , p_api_version_number =>1.0
54: , p_init_msg_list => p_init_msg_list
55: , p_commit => FND_API.G_FALSE
56: , p_wip_entity_id =>p_wip_entity_id
57: , p_organization_id => p_organization_id
58: , x_eam_wo_rec => l_eam_wo_rec
59: , x_eam_op_tbl => l_eam_op_tbl

Line 78: IF(p_commit = FND_API.G_TRUE) THEN

74:
75: IF(x_return_status = 'S' ) THEN
76: x_wip_entity_name := l_eam_wo_rec.wip_entity_name;
77: x_wip_entity_id := l_eam_wo_rec.wip_entity_id;
78: IF(p_commit = FND_API.G_TRUE) THEN
79: COMMIT;
80: END IF;
81: END IF;
82:

Line 95: p_commit IN VARCHAR2 := FND_API.G_FALSE,

91: Wrapper procedure on top of WO API.This is used to create/update workorder and its related entities
92: ************************************************/
93: PROCEDURE CREATE_UPDATE_WO
94: (
95: p_commit IN VARCHAR2 := FND_API.G_FALSE,
96: p_eam_wo_tbl IN EAM_PROCESS_WO_PUB.eam_wo_tbl_type,
97: p_eam_wo_relations_tbl IN EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type,
98: p_eam_op_tbl IN EAM_PROCESS_WO_PUB.eam_op_tbl_type,
99: p_eam_res_tbl IN EAM_PROCESS_WO_PUB.eam_res_tbl_type,

Line 319: l_eam_failure_entry_record.failure_date := FND_API.G_MISS_DATE;

315:
316: l_eam_failure_codes_tbl(1).transaction_type := EAM_Process_Failure_Entry_PUB.G_FE_UPDATE;
317:
318: IF (l_eam_failure_entry_record.failure_date IS NULL) THEN
319: l_eam_failure_entry_record.failure_date := FND_API.G_MISS_DATE;
320: END IF;
321:
322: IF (l_eam_failure_codes_tbl(1).failure_code IS NULL) THEN
323: l_eam_failure_codes_tbl(1).failure_code := FND_API.G_MISS_CHAR;

Line 323: l_eam_failure_codes_tbl(1).failure_code := FND_API.G_MISS_CHAR;

319: l_eam_failure_entry_record.failure_date := FND_API.G_MISS_DATE;
320: END IF;
321:
322: IF (l_eam_failure_codes_tbl(1).failure_code IS NULL) THEN
323: l_eam_failure_codes_tbl(1).failure_code := FND_API.G_MISS_CHAR;
324: END IF;
325:
326: IF (l_eam_failure_codes_tbl(1).cause_code IS NULL) THEN
327: l_eam_failure_codes_tbl(1).cause_code := FND_API.G_MISS_CHAR;

Line 327: l_eam_failure_codes_tbl(1).cause_code := FND_API.G_MISS_CHAR;

323: l_eam_failure_codes_tbl(1).failure_code := FND_API.G_MISS_CHAR;
324: END IF;
325:
326: IF (l_eam_failure_codes_tbl(1).cause_code IS NULL) THEN
327: l_eam_failure_codes_tbl(1).cause_code := FND_API.G_MISS_CHAR;
328: END IF;
329:
330: IF (l_eam_failure_codes_tbl(1).resolution_code IS NULL) THEN
331: l_eam_failure_codes_tbl(1).resolution_code := FND_API.G_MISS_CHAR;

Line 331: l_eam_failure_codes_tbl(1).resolution_code := FND_API.G_MISS_CHAR;

327: l_eam_failure_codes_tbl(1).cause_code := FND_API.G_MISS_CHAR;
328: END IF;
329:
330: IF (l_eam_failure_codes_tbl(1).resolution_code IS NULL) THEN
331: l_eam_failure_codes_tbl(1).resolution_code := FND_API.G_MISS_CHAR;
332: END IF;
333:
334: IF (l_eam_failure_codes_tbl(1).comments IS NULL) THEN
335: l_eam_failure_codes_tbl(1).comments := FND_API.G_MISS_CHAR;

Line 335: l_eam_failure_codes_tbl(1).comments := FND_API.G_MISS_CHAR;

331: l_eam_failure_codes_tbl(1).resolution_code := FND_API.G_MISS_CHAR;
332: END IF;
333:
334: IF (l_eam_failure_codes_tbl(1).comments IS NULL) THEN
335: l_eam_failure_codes_tbl(1).comments := FND_API.G_MISS_CHAR;
336: END IF;
337:
338: IF(l_eam_failure_entry_record.failure_id IS NOT NULL ) THEN
339: l_eam_failure_entry_record.transaction_type := EAM_Process_Failure_Entry_PUB.G_FE_UPDATE;

Line 341: IF(l_eam_failure_entry_record.failure_date = FND_API.G_MISS_DATE) THEN

337:
338: IF(l_eam_failure_entry_record.failure_id IS NOT NULL ) THEN
339: l_eam_failure_entry_record.transaction_type := EAM_Process_Failure_Entry_PUB.G_FE_UPDATE;
340: ELSE
341: IF(l_eam_failure_entry_record.failure_date = FND_API.G_MISS_DATE) THEN
342: l_eam_failure_entry_record.transaction_type :=null;
343: l_eam_failure_entry_record.failure_date :=null;
344: ELSE
345: l_eam_failure_entry_record.transaction_type := EAM_Process_Failure_Entry_PUB.G_FE_CREATE ;

Line 354: IF( NOT( (l_eam_failure_codes_tbl(1).failure_code = FND_API.G_MISS_CHAR)

350: l_eam_failure_codes_tbl(1).transaction_type := EAM_Process_Failure_Entry_PUB.G_FE_UPDATE;
351: l_eam_wo_comp_rec.eam_failure_codes_tbl(1) := l_eam_failure_codes_tbl(1);
352:
353: ELSE
354: IF( NOT( (l_eam_failure_codes_tbl(1).failure_code = FND_API.G_MISS_CHAR)
355: AND (l_eam_failure_codes_tbl(1).cause_code = FND_API.G_MISS_CHAR)
356: AND (l_eam_failure_codes_tbl(1).resolution_code = FND_API.G_MISS_CHAR)
357: AND (l_eam_failure_codes_tbl(1).comments = FND_API.G_MISS_CHAR)
358: )

Line 355: AND (l_eam_failure_codes_tbl(1).cause_code = FND_API.G_MISS_CHAR)

351: l_eam_wo_comp_rec.eam_failure_codes_tbl(1) := l_eam_failure_codes_tbl(1);
352:
353: ELSE
354: IF( NOT( (l_eam_failure_codes_tbl(1).failure_code = FND_API.G_MISS_CHAR)
355: AND (l_eam_failure_codes_tbl(1).cause_code = FND_API.G_MISS_CHAR)
356: AND (l_eam_failure_codes_tbl(1).resolution_code = FND_API.G_MISS_CHAR)
357: AND (l_eam_failure_codes_tbl(1).comments = FND_API.G_MISS_CHAR)
358: )
359: ) THEN

Line 356: AND (l_eam_failure_codes_tbl(1).resolution_code = FND_API.G_MISS_CHAR)

352:
353: ELSE
354: IF( NOT( (l_eam_failure_codes_tbl(1).failure_code = FND_API.G_MISS_CHAR)
355: AND (l_eam_failure_codes_tbl(1).cause_code = FND_API.G_MISS_CHAR)
356: AND (l_eam_failure_codes_tbl(1).resolution_code = FND_API.G_MISS_CHAR)
357: AND (l_eam_failure_codes_tbl(1).comments = FND_API.G_MISS_CHAR)
358: )
359: ) THEN
360: l_eam_failure_codes_tbl(1).transaction_type := EAM_Process_Failure_Entry_PUB.G_FE_CREATE;

Line 357: AND (l_eam_failure_codes_tbl(1).comments = FND_API.G_MISS_CHAR)

353: ELSE
354: IF( NOT( (l_eam_failure_codes_tbl(1).failure_code = FND_API.G_MISS_CHAR)
355: AND (l_eam_failure_codes_tbl(1).cause_code = FND_API.G_MISS_CHAR)
356: AND (l_eam_failure_codes_tbl(1).resolution_code = FND_API.G_MISS_CHAR)
357: AND (l_eam_failure_codes_tbl(1).comments = FND_API.G_MISS_CHAR)
358: )
359: ) THEN
360: l_eam_failure_codes_tbl(1).transaction_type := EAM_Process_Failure_Entry_PUB.G_FE_CREATE;
361:

Line 362: IF(l_eam_failure_codes_tbl(1).failure_code = FND_API.G_MISS_CHAR) THEN

358: )
359: ) THEN
360: l_eam_failure_codes_tbl(1).transaction_type := EAM_Process_Failure_Entry_PUB.G_FE_CREATE;
361:
362: IF(l_eam_failure_codes_tbl(1).failure_code = FND_API.G_MISS_CHAR) THEN
363: l_eam_failure_codes_tbl(1).failure_code := null;
364: END IF;
365:
366: IF(l_eam_failure_codes_tbl(1).cause_code = FND_API.G_MISS_CHAR) THEN

Line 366: IF(l_eam_failure_codes_tbl(1).cause_code = FND_API.G_MISS_CHAR) THEN

362: IF(l_eam_failure_codes_tbl(1).failure_code = FND_API.G_MISS_CHAR) THEN
363: l_eam_failure_codes_tbl(1).failure_code := null;
364: END IF;
365:
366: IF(l_eam_failure_codes_tbl(1).cause_code = FND_API.G_MISS_CHAR) THEN
367: l_eam_failure_codes_tbl(1).cause_code := NULL;
368: END IF;
369:
370: IF(l_eam_failure_codes_tbl(1).resolution_code = FND_API.G_MISS_CHAR) then

Line 370: IF(l_eam_failure_codes_tbl(1).resolution_code = FND_API.G_MISS_CHAR) then

366: IF(l_eam_failure_codes_tbl(1).cause_code = FND_API.G_MISS_CHAR) THEN
367: l_eam_failure_codes_tbl(1).cause_code := NULL;
368: END IF;
369:
370: IF(l_eam_failure_codes_tbl(1).resolution_code = FND_API.G_MISS_CHAR) then
371: l_eam_failure_codes_tbl(1).resolution_code := null;
372: END IF;
373:
374: IF(l_eam_failure_codes_tbl(1).comments = FND_API.G_MISS_CHAR) then

Line 374: IF(l_eam_failure_codes_tbl(1).comments = FND_API.G_MISS_CHAR) then

370: IF(l_eam_failure_codes_tbl(1).resolution_code = FND_API.G_MISS_CHAR) then
371: l_eam_failure_codes_tbl(1).resolution_code := null;
372: END IF;
373:
374: IF(l_eam_failure_codes_tbl(1).comments = FND_API.G_MISS_CHAR) then
375: l_eam_failure_codes_tbl(1).comments := null;
376: END IF;
377: l_eam_wo_comp_rec.eam_failure_codes_tbl(1) := l_eam_failure_codes_tbl(1);
378:

Line 393: --Set the activity_id to Fnd_Api.G_Miss_Num if we want to delete the activity

389: END IF;
390:
391: /* Failure Analysis Project End */
392:
393: --Set the activity_id to Fnd_Api.G_Miss_Num if we want to delete the activity
394: l_eam_wo_tbl := p_eam_wo_tbl;
395: IF(l_eam_wo_tbl IS NOT NULL AND l_eam_wo_tbl.COUNT>0) THEN
396:
397: l_eam_wo_rec := l_eam_wo_tbl(l_eam_wo_tbl.FIRST);

Line 399: --set FND_API.G_MISS_xx if any columns are nulled out

395: IF(l_eam_wo_tbl IS NOT NULL AND l_eam_wo_tbl.COUNT>0) THEN
396:
397: l_eam_wo_rec := l_eam_wo_tbl(l_eam_wo_tbl.FIRST);
398:
399: --set FND_API.G_MISS_xx if any columns are nulled out
400: l_wo_exists := TRUE; --work order already exists...if no data found exception is thrown then l_wo_exists will be set to FALSE
401:
402: BEGIN
403: l_wip_entity_id :=l_eam_wo_rec.wip_entity_id;

Line 473: l_eam_wo_rec.asset_number := FND_API.G_MISS_CHAR;

469: FROM WIP_DISCRETE_JOBS
470: where wip_entity_id = l_wip_entity_id;
471:
472: IF(l_asset_number is NOT NULL and l_eam_wo_rec.asset_number IS NULL) THEN
473: l_eam_wo_rec.asset_number := FND_API.G_MISS_CHAR;
474: END IF;
475:
476: IF(l_rebuild_serial_number is NOT NULL and l_eam_wo_rec.rebuild_serial_number IS NULL) THEN
477: l_eam_wo_rec.rebuild_serial_number := FND_API.G_MISS_CHAR;

Line 477: l_eam_wo_rec.rebuild_serial_number := FND_API.G_MISS_CHAR;

473: l_eam_wo_rec.asset_number := FND_API.G_MISS_CHAR;
474: END IF;
475:
476: IF(l_rebuild_serial_number is NOT NULL and l_eam_wo_rec.rebuild_serial_number IS NULL) THEN
477: l_eam_wo_rec.rebuild_serial_number := FND_API.G_MISS_CHAR;
478: END IF;
479:
480: IF(l_asset_group_id is NOT NULL and l_eam_wo_rec.asset_group_id IS NULL) THEN
481: l_eam_wo_rec.asset_group_id := FND_API.G_MISS_NUM;

Line 481: l_eam_wo_rec.asset_group_id := FND_API.G_MISS_NUM;

477: l_eam_wo_rec.rebuild_serial_number := FND_API.G_MISS_CHAR;
478: END IF;
479:
480: IF(l_asset_group_id is NOT NULL and l_eam_wo_rec.asset_group_id IS NULL) THEN
481: l_eam_wo_rec.asset_group_id := FND_API.G_MISS_NUM;
482: END IF;
483:
484: IF(l_rebuild_item_id is NOT NULL and l_eam_wo_rec.rebuild_item_id IS NULL) THEN
485: l_eam_wo_rec.rebuild_item_id:= FND_API.G_MISS_NUM;

Line 485: l_eam_wo_rec.rebuild_item_id:= FND_API.G_MISS_NUM;

481: l_eam_wo_rec.asset_group_id := FND_API.G_MISS_NUM;
482: END IF;
483:
484: IF(l_rebuild_item_id is NOT NULL and l_eam_wo_rec.rebuild_item_id IS NULL) THEN
485: l_eam_wo_rec.rebuild_item_id:= FND_API.G_MISS_NUM;
486: END IF;
487:
488: IF l_prev_activity_id is not null and l_eam_wo_rec.asset_activity_id is null THEN
489: l_eam_wo_rec.asset_activity_id := FND_API.G_MISS_NUM;

Line 489: l_eam_wo_rec.asset_activity_id := FND_API.G_MISS_NUM;

485: l_eam_wo_rec.rebuild_item_id:= FND_API.G_MISS_NUM;
486: END IF;
487:
488: IF l_prev_activity_id is not null and l_eam_wo_rec.asset_activity_id is null THEN
489: l_eam_wo_rec.asset_activity_id := FND_API.G_MISS_NUM;
490: END IF;
491:
492: IF l_prev_description is not null and l_eam_wo_rec.description is null THEN
493: l_eam_wo_rec.description := FND_API.G_MISS_CHAR;

Line 493: l_eam_wo_rec.description := FND_API.G_MISS_CHAR;

489: l_eam_wo_rec.asset_activity_id := FND_API.G_MISS_NUM;
490: END IF;
491:
492: IF l_prev_description is not null and l_eam_wo_rec.description is null THEN
493: l_eam_wo_rec.description := FND_API.G_MISS_CHAR;
494: END IF;
495:
496: IF l_prev_activity_type is not null and l_eam_wo_rec.activity_type is null THEN
497: l_eam_wo_rec.activity_type := FND_API.G_MISS_CHAR;

Line 497: l_eam_wo_rec.activity_type := FND_API.G_MISS_CHAR;

493: l_eam_wo_rec.description := FND_API.G_MISS_CHAR;
494: END IF;
495:
496: IF l_prev_activity_type is not null and l_eam_wo_rec.activity_type is null THEN
497: l_eam_wo_rec.activity_type := FND_API.G_MISS_CHAR;
498: END IF;
499:
500: IF l_prev_activity_cause is not null and l_eam_wo_rec.activity_cause is null THEN
501: l_eam_wo_rec.activity_cause := FND_API.G_MISS_CHAR;

Line 501: l_eam_wo_rec.activity_cause := FND_API.G_MISS_CHAR;

497: l_eam_wo_rec.activity_type := FND_API.G_MISS_CHAR;
498: END IF;
499:
500: IF l_prev_activity_cause is not null and l_eam_wo_rec.activity_cause is null THEN
501: l_eam_wo_rec.activity_cause := FND_API.G_MISS_CHAR;
502: END IF;
503:
504: IF l_prev_activity_source is not null and l_eam_wo_rec.activity_source is null THEN
505: l_eam_wo_rec.activity_source := FND_API.G_MISS_CHAR;

Line 505: l_eam_wo_rec.activity_source := FND_API.G_MISS_CHAR;

501: l_eam_wo_rec.activity_cause := FND_API.G_MISS_CHAR;
502: END IF;
503:
504: IF l_prev_activity_source is not null and l_eam_wo_rec.activity_source is null THEN
505: l_eam_wo_rec.activity_source := FND_API.G_MISS_CHAR;
506: END IF;
507:
508: IF l_prev_shutdown_type is not null and l_eam_wo_rec.shutdown_type is null THEN
509: l_eam_wo_rec.shutdown_type := FND_API.G_MISS_CHAR;

Line 509: l_eam_wo_rec.shutdown_type := FND_API.G_MISS_CHAR;

505: l_eam_wo_rec.activity_source := FND_API.G_MISS_CHAR;
506: END IF;
507:
508: IF l_prev_shutdown_type is not null and l_eam_wo_rec.shutdown_type is null THEN
509: l_eam_wo_rec.shutdown_type := FND_API.G_MISS_CHAR;
510: END IF;
511:
512: IF l_prev_priority is not null and l_eam_wo_rec.priority is null THEN
513: l_eam_wo_rec.priority := FND_API.G_MISS_NUM;

Line 513: l_eam_wo_rec.priority := FND_API.G_MISS_NUM;

509: l_eam_wo_rec.shutdown_type := FND_API.G_MISS_CHAR;
510: END IF;
511:
512: IF l_prev_priority is not null and l_eam_wo_rec.priority is null THEN
513: l_eam_wo_rec.priority := FND_API.G_MISS_NUM;
514: END IF;
515:
516: IF l_prev_work_order_type is not null and l_eam_wo_rec.work_order_type is null THEN
517: l_eam_wo_rec.work_order_type := FND_API.G_MISS_CHAR;

Line 517: l_eam_wo_rec.work_order_type := FND_API.G_MISS_CHAR;

513: l_eam_wo_rec.priority := FND_API.G_MISS_NUM;
514: END IF;
515:
516: IF l_prev_work_order_type is not null and l_eam_wo_rec.work_order_type is null THEN
517: l_eam_wo_rec.work_order_type := FND_API.G_MISS_CHAR;
518: END IF;
519:
520: IF l_prev_attribute_category is not null and l_eam_wo_rec.attribute_category is null THEN
521: l_eam_wo_rec.attribute_category := FND_API.G_MISS_CHAR;

Line 521: l_eam_wo_rec.attribute_category := FND_API.G_MISS_CHAR;

517: l_eam_wo_rec.work_order_type := FND_API.G_MISS_CHAR;
518: END IF;
519:
520: IF l_prev_attribute_category is not null and l_eam_wo_rec.attribute_category is null THEN
521: l_eam_wo_rec.attribute_category := FND_API.G_MISS_CHAR;
522: END IF;
523:
524: IF l_prev_attribute1 is not null and l_eam_wo_rec.attribute1 is null THEN
525: l_eam_wo_rec.attribute1 := FND_API.G_MISS_CHAR;

Line 525: l_eam_wo_rec.attribute1 := FND_API.G_MISS_CHAR;

521: l_eam_wo_rec.attribute_category := FND_API.G_MISS_CHAR;
522: END IF;
523:
524: IF l_prev_attribute1 is not null and l_eam_wo_rec.attribute1 is null THEN
525: l_eam_wo_rec.attribute1 := FND_API.G_MISS_CHAR;
526: END IF;
527:
528: IF l_prev_attribute2 is not null and l_eam_wo_rec.attribute2 is null THEN
529: l_eam_wo_rec.attribute2 := FND_API.G_MISS_CHAR;

Line 529: l_eam_wo_rec.attribute2 := FND_API.G_MISS_CHAR;

525: l_eam_wo_rec.attribute1 := FND_API.G_MISS_CHAR;
526: END IF;
527:
528: IF l_prev_attribute2 is not null and l_eam_wo_rec.attribute2 is null THEN
529: l_eam_wo_rec.attribute2 := FND_API.G_MISS_CHAR;
530: END IF;
531:
532: IF l_prev_attribute3 is not null and l_eam_wo_rec.attribute3 is null THEN
533: l_eam_wo_rec.attribute3 := FND_API.G_MISS_CHAR;

Line 533: l_eam_wo_rec.attribute3 := FND_API.G_MISS_CHAR;

529: l_eam_wo_rec.attribute2 := FND_API.G_MISS_CHAR;
530: END IF;
531:
532: IF l_prev_attribute3 is not null and l_eam_wo_rec.attribute3 is null THEN
533: l_eam_wo_rec.attribute3 := FND_API.G_MISS_CHAR;
534: END IF;
535:
536: IF l_prev_attribute4 is not null and l_eam_wo_rec.attribute4 is null THEN
537: l_eam_wo_rec.attribute4 := FND_API.G_MISS_CHAR;

Line 537: l_eam_wo_rec.attribute4 := FND_API.G_MISS_CHAR;

533: l_eam_wo_rec.attribute3 := FND_API.G_MISS_CHAR;
534: END IF;
535:
536: IF l_prev_attribute4 is not null and l_eam_wo_rec.attribute4 is null THEN
537: l_eam_wo_rec.attribute4 := FND_API.G_MISS_CHAR;
538: END IF;
539:
540: IF l_prev_attribute5 is not null and l_eam_wo_rec.attribute5 is null THEN
541: l_eam_wo_rec.attribute5 := FND_API.G_MISS_CHAR;

Line 541: l_eam_wo_rec.attribute5 := FND_API.G_MISS_CHAR;

537: l_eam_wo_rec.attribute4 := FND_API.G_MISS_CHAR;
538: END IF;
539:
540: IF l_prev_attribute5 is not null and l_eam_wo_rec.attribute5 is null THEN
541: l_eam_wo_rec.attribute5 := FND_API.G_MISS_CHAR;
542: END IF;
543:
544: IF l_prev_attribute6 is not null and l_eam_wo_rec.attribute6 is null THEN
545: l_eam_wo_rec.attribute6 := FND_API.G_MISS_CHAR;

Line 545: l_eam_wo_rec.attribute6 := FND_API.G_MISS_CHAR;

541: l_eam_wo_rec.attribute5 := FND_API.G_MISS_CHAR;
542: END IF;
543:
544: IF l_prev_attribute6 is not null and l_eam_wo_rec.attribute6 is null THEN
545: l_eam_wo_rec.attribute6 := FND_API.G_MISS_CHAR;
546: END IF;
547:
548: IF l_prev_attribute7 is not null and l_eam_wo_rec.attribute7 is null THEN
549: l_eam_wo_rec.attribute7 := FND_API.G_MISS_CHAR;

Line 549: l_eam_wo_rec.attribute7 := FND_API.G_MISS_CHAR;

545: l_eam_wo_rec.attribute6 := FND_API.G_MISS_CHAR;
546: END IF;
547:
548: IF l_prev_attribute7 is not null and l_eam_wo_rec.attribute7 is null THEN
549: l_eam_wo_rec.attribute7 := FND_API.G_MISS_CHAR;
550: END IF;
551:
552: IF l_prev_attribute8 is not null and l_eam_wo_rec.attribute8 is null THEN
553: l_eam_wo_rec.attribute8 := FND_API.G_MISS_CHAR;

Line 553: l_eam_wo_rec.attribute8 := FND_API.G_MISS_CHAR;

549: l_eam_wo_rec.attribute7 := FND_API.G_MISS_CHAR;
550: END IF;
551:
552: IF l_prev_attribute8 is not null and l_eam_wo_rec.attribute8 is null THEN
553: l_eam_wo_rec.attribute8 := FND_API.G_MISS_CHAR;
554: END IF;
555:
556: IF l_prev_attribute9 is not null and l_eam_wo_rec.attribute9 is null THEN
557: l_eam_wo_rec.attribute9 := FND_API.G_MISS_CHAR;

Line 557: l_eam_wo_rec.attribute9 := FND_API.G_MISS_CHAR;

553: l_eam_wo_rec.attribute8 := FND_API.G_MISS_CHAR;
554: END IF;
555:
556: IF l_prev_attribute9 is not null and l_eam_wo_rec.attribute9 is null THEN
557: l_eam_wo_rec.attribute9 := FND_API.G_MISS_CHAR;
558: END IF;
559:
560: IF l_prev_attribute10 is not null and l_eam_wo_rec.attribute10 is null THEN
561: l_eam_wo_rec.attribute10 := FND_API.G_MISS_CHAR;

Line 561: l_eam_wo_rec.attribute10 := FND_API.G_MISS_CHAR;

557: l_eam_wo_rec.attribute9 := FND_API.G_MISS_CHAR;
558: END IF;
559:
560: IF l_prev_attribute10 is not null and l_eam_wo_rec.attribute10 is null THEN
561: l_eam_wo_rec.attribute10 := FND_API.G_MISS_CHAR;
562: END IF;
563:
564: IF l_prev_attribute11 is not null and l_eam_wo_rec.attribute11 is null THEN
565: l_eam_wo_rec.attribute11 := FND_API.G_MISS_CHAR;

Line 565: l_eam_wo_rec.attribute11 := FND_API.G_MISS_CHAR;

561: l_eam_wo_rec.attribute10 := FND_API.G_MISS_CHAR;
562: END IF;
563:
564: IF l_prev_attribute11 is not null and l_eam_wo_rec.attribute11 is null THEN
565: l_eam_wo_rec.attribute11 := FND_API.G_MISS_CHAR;
566: END IF;
567:
568: IF l_prev_attribute12 is not null and l_eam_wo_rec.attribute12 is null THEN
569: l_eam_wo_rec.attribute12 := FND_API.G_MISS_CHAR;

Line 569: l_eam_wo_rec.attribute12 := FND_API.G_MISS_CHAR;

565: l_eam_wo_rec.attribute11 := FND_API.G_MISS_CHAR;
566: END IF;
567:
568: IF l_prev_attribute12 is not null and l_eam_wo_rec.attribute12 is null THEN
569: l_eam_wo_rec.attribute12 := FND_API.G_MISS_CHAR;
570: END IF;
571:
572: IF l_prev_attribute13 is not null and l_eam_wo_rec.attribute13 is null THEN
573: l_eam_wo_rec.attribute13 := FND_API.G_MISS_CHAR;

Line 573: l_eam_wo_rec.attribute13 := FND_API.G_MISS_CHAR;

569: l_eam_wo_rec.attribute12 := FND_API.G_MISS_CHAR;
570: END IF;
571:
572: IF l_prev_attribute13 is not null and l_eam_wo_rec.attribute13 is null THEN
573: l_eam_wo_rec.attribute13 := FND_API.G_MISS_CHAR;
574: END IF;
575:
576: IF l_prev_attribute14 is not null and l_eam_wo_rec.attribute14 is null THEN
577: l_eam_wo_rec.attribute14 := FND_API.G_MISS_CHAR;

Line 577: l_eam_wo_rec.attribute14 := FND_API.G_MISS_CHAR;

573: l_eam_wo_rec.attribute13 := FND_API.G_MISS_CHAR;
574: END IF;
575:
576: IF l_prev_attribute14 is not null and l_eam_wo_rec.attribute14 is null THEN
577: l_eam_wo_rec.attribute14 := FND_API.G_MISS_CHAR;
578: END IF;
579:
580: IF l_prev_attribute15 is not null and l_eam_wo_rec.attribute15 is null THEN
581: l_eam_wo_rec.attribute15 := FND_API.G_MISS_CHAR;

Line 581: l_eam_wo_rec.attribute15 := FND_API.G_MISS_CHAR;

577: l_eam_wo_rec.attribute14 := FND_API.G_MISS_CHAR;
578: END IF;
579:
580: IF l_prev_attribute15 is not null and l_eam_wo_rec.attribute15 is null THEN
581: l_eam_wo_rec.attribute15 := FND_API.G_MISS_CHAR;
582: END IF;
583:
584: /* Added for bug#6053425 Start */
585:

Line 587: l_eam_wo_rec.project_id := FND_API.G_MISS_NUM;

583:
584: /* Added for bug#6053425 Start */
585:
586: IF l_prev_project_id is not null AND l_eam_wo_rec.project_id is null THEN
587: l_eam_wo_rec.project_id := FND_API.G_MISS_NUM;
588: END IF;
589:
590: IF l_prev_task_id is not null AND l_eam_wo_rec.task_id is null THEN
591: l_eam_wo_rec.task_id := FND_API.G_MISS_NUM;

Line 591: l_eam_wo_rec.task_id := FND_API.G_MISS_NUM;

587: l_eam_wo_rec.project_id := FND_API.G_MISS_NUM;
588: END IF;
589:
590: IF l_prev_task_id is not null AND l_eam_wo_rec.task_id is null THEN
591: l_eam_wo_rec.task_id := FND_API.G_MISS_NUM;
592: END IF;
593:
594: /* Added for bug#6053425 End */
595:

Line 733: l_eam_failure_entry_record.failure_date := FND_API.G_MISS_DATE;

729:
730:
731: l_eam_failure_codes_tbl(1).transaction_type := EAM_Process_Failure_Entry_PUB.G_FE_UPDATE;
732: if (l_eam_failure_entry_record.failure_date is null) then
733: l_eam_failure_entry_record.failure_date := FND_API.G_MISS_DATE;
734: end if;
735: if (l_eam_failure_codes_tbl(1).failure_code is null) then
736: l_eam_failure_codes_tbl(1).failure_code := FND_API.G_MISS_CHAR;
737: end if;

Line 736: l_eam_failure_codes_tbl(1).failure_code := FND_API.G_MISS_CHAR;

732: if (l_eam_failure_entry_record.failure_date is null) then
733: l_eam_failure_entry_record.failure_date := FND_API.G_MISS_DATE;
734: end if;
735: if (l_eam_failure_codes_tbl(1).failure_code is null) then
736: l_eam_failure_codes_tbl(1).failure_code := FND_API.G_MISS_CHAR;
737: end if;
738: if (l_eam_failure_codes_tbl(1).cause_code is null) then
739: l_eam_failure_codes_tbl(1).cause_code := FND_API.G_MISS_CHAR;
740: end if;

Line 739: l_eam_failure_codes_tbl(1).cause_code := FND_API.G_MISS_CHAR;

735: if (l_eam_failure_codes_tbl(1).failure_code is null) then
736: l_eam_failure_codes_tbl(1).failure_code := FND_API.G_MISS_CHAR;
737: end if;
738: if (l_eam_failure_codes_tbl(1).cause_code is null) then
739: l_eam_failure_codes_tbl(1).cause_code := FND_API.G_MISS_CHAR;
740: end if;
741: if (l_eam_failure_codes_tbl(1).resolution_code is null) then
742: l_eam_failure_codes_tbl(1).resolution_code := FND_API.G_MISS_CHAR;
743: end if;

Line 742: l_eam_failure_codes_tbl(1).resolution_code := FND_API.G_MISS_CHAR;

738: if (l_eam_failure_codes_tbl(1).cause_code is null) then
739: l_eam_failure_codes_tbl(1).cause_code := FND_API.G_MISS_CHAR;
740: end if;
741: if (l_eam_failure_codes_tbl(1).resolution_code is null) then
742: l_eam_failure_codes_tbl(1).resolution_code := FND_API.G_MISS_CHAR;
743: end if;
744: if (l_eam_failure_codes_tbl(1).comments is null) then
745: l_eam_failure_codes_tbl(1).comments := FND_API.G_MISS_CHAR;
746: end if;

Line 745: l_eam_failure_codes_tbl(1).comments := FND_API.G_MISS_CHAR;

741: if (l_eam_failure_codes_tbl(1).resolution_code is null) then
742: l_eam_failure_codes_tbl(1).resolution_code := FND_API.G_MISS_CHAR;
743: end if;
744: if (l_eam_failure_codes_tbl(1).comments is null) then
745: l_eam_failure_codes_tbl(1).comments := FND_API.G_MISS_CHAR;
746: end if;
747: if(l_eam_failure_entry_record.failure_id is not null ) then
748: l_eam_failure_entry_record.transaction_type := EAM_Process_Failure_Entry_PUB.G_FE_UPDATE;
749: else

Line 750: if(l_eam_failure_entry_record.failure_date = FND_API.G_MISS_DATE) then

746: end if;
747: if(l_eam_failure_entry_record.failure_id is not null ) then
748: l_eam_failure_entry_record.transaction_type := EAM_Process_Failure_Entry_PUB.G_FE_UPDATE;
749: else
750: if(l_eam_failure_entry_record.failure_date = FND_API.G_MISS_DATE) then
751: l_eam_failure_entry_record.transaction_type :=null;
752: l_eam_failure_entry_record.failure_date :=null;
753: else
754: l_eam_failure_entry_record.transaction_type := EAM_Process_Failure_Entry_PUB.G_FE_CREATE ;

Line 763: if( not( (l_eam_failure_codes_tbl(1).failure_code = FND_API.G_MISS_CHAR)

759: l_eam_failure_codes_tbl(1).transaction_type := EAM_Process_Failure_Entry_PUB.G_FE_UPDATE;
760: l_eam_wo_rec.eam_failure_codes_tbl(1) := l_eam_failure_codes_tbl(1);
761:
762: else
763: if( not( (l_eam_failure_codes_tbl(1).failure_code = FND_API.G_MISS_CHAR)
764: and (l_eam_failure_codes_tbl(1).cause_code = FND_API.G_MISS_CHAR)
765: and (l_eam_failure_codes_tbl(1).resolution_code = FND_API.G_MISS_CHAR)
766: and (l_eam_failure_codes_tbl(1).comments = FND_API.G_MISS_CHAR)
767: )

Line 764: and (l_eam_failure_codes_tbl(1).cause_code = FND_API.G_MISS_CHAR)

760: l_eam_wo_rec.eam_failure_codes_tbl(1) := l_eam_failure_codes_tbl(1);
761:
762: else
763: if( not( (l_eam_failure_codes_tbl(1).failure_code = FND_API.G_MISS_CHAR)
764: and (l_eam_failure_codes_tbl(1).cause_code = FND_API.G_MISS_CHAR)
765: and (l_eam_failure_codes_tbl(1).resolution_code = FND_API.G_MISS_CHAR)
766: and (l_eam_failure_codes_tbl(1).comments = FND_API.G_MISS_CHAR)
767: )
768: ) then

Line 765: and (l_eam_failure_codes_tbl(1).resolution_code = FND_API.G_MISS_CHAR)

761:
762: else
763: if( not( (l_eam_failure_codes_tbl(1).failure_code = FND_API.G_MISS_CHAR)
764: and (l_eam_failure_codes_tbl(1).cause_code = FND_API.G_MISS_CHAR)
765: and (l_eam_failure_codes_tbl(1).resolution_code = FND_API.G_MISS_CHAR)
766: and (l_eam_failure_codes_tbl(1).comments = FND_API.G_MISS_CHAR)
767: )
768: ) then
769: l_eam_failure_codes_tbl(1).transaction_type := EAM_Process_Failure_Entry_PUB.G_FE_CREATE;

Line 766: and (l_eam_failure_codes_tbl(1).comments = FND_API.G_MISS_CHAR)

762: else
763: if( not( (l_eam_failure_codes_tbl(1).failure_code = FND_API.G_MISS_CHAR)
764: and (l_eam_failure_codes_tbl(1).cause_code = FND_API.G_MISS_CHAR)
765: and (l_eam_failure_codes_tbl(1).resolution_code = FND_API.G_MISS_CHAR)
766: and (l_eam_failure_codes_tbl(1).comments = FND_API.G_MISS_CHAR)
767: )
768: ) then
769: l_eam_failure_codes_tbl(1).transaction_type := EAM_Process_Failure_Entry_PUB.G_FE_CREATE;
770: if(l_eam_failure_codes_tbl(1).failure_code = FND_API.G_MISS_CHAR) then

Line 770: if(l_eam_failure_codes_tbl(1).failure_code = FND_API.G_MISS_CHAR) then

766: and (l_eam_failure_codes_tbl(1).comments = FND_API.G_MISS_CHAR)
767: )
768: ) then
769: l_eam_failure_codes_tbl(1).transaction_type := EAM_Process_Failure_Entry_PUB.G_FE_CREATE;
770: if(l_eam_failure_codes_tbl(1).failure_code = FND_API.G_MISS_CHAR) then
771: l_eam_failure_codes_tbl(1).failure_code := null;
772: end if;
773: if(l_eam_failure_codes_tbl(1).cause_code = FND_API.G_MISS_CHAR) then
774: l_eam_failure_codes_tbl(1).cause_code := null;

Line 773: if(l_eam_failure_codes_tbl(1).cause_code = FND_API.G_MISS_CHAR) then

769: l_eam_failure_codes_tbl(1).transaction_type := EAM_Process_Failure_Entry_PUB.G_FE_CREATE;
770: if(l_eam_failure_codes_tbl(1).failure_code = FND_API.G_MISS_CHAR) then
771: l_eam_failure_codes_tbl(1).failure_code := null;
772: end if;
773: if(l_eam_failure_codes_tbl(1).cause_code = FND_API.G_MISS_CHAR) then
774: l_eam_failure_codes_tbl(1).cause_code := null;
775: end if;
776: if(l_eam_failure_codes_tbl(1).resolution_code = FND_API.G_MISS_CHAR) then
777: l_eam_failure_codes_tbl(1).resolution_code := null;

Line 776: if(l_eam_failure_codes_tbl(1).resolution_code = FND_API.G_MISS_CHAR) then

772: end if;
773: if(l_eam_failure_codes_tbl(1).cause_code = FND_API.G_MISS_CHAR) then
774: l_eam_failure_codes_tbl(1).cause_code := null;
775: end if;
776: if(l_eam_failure_codes_tbl(1).resolution_code = FND_API.G_MISS_CHAR) then
777: l_eam_failure_codes_tbl(1).resolution_code := null;
778: end if;
779: if(l_eam_failure_codes_tbl(1).comments = FND_API.G_MISS_CHAR) then
780: l_eam_failure_codes_tbl(1).comments := null;

Line 779: if(l_eam_failure_codes_tbl(1).comments = FND_API.G_MISS_CHAR) then

775: end if;
776: if(l_eam_failure_codes_tbl(1).resolution_code = FND_API.G_MISS_CHAR) then
777: l_eam_failure_codes_tbl(1).resolution_code := null;
778: end if;
779: if(l_eam_failure_codes_tbl(1).comments = FND_API.G_MISS_CHAR) then
780: l_eam_failure_codes_tbl(1).comments := null;
781: end if;
782: l_eam_wo_rec.eam_failure_codes_tbl(1) := l_eam_failure_codes_tbl(1);
783:

Line 946: IF p_commit = FND_API.G_TRUE THEN

942:
943: END IF; /*MSP IF END*/
944:
945: IF(x_return_status='S') THEN
946: IF p_commit = FND_API.G_TRUE THEN
947: COMMIT WORK;
948: end if;
949: IF(l_eam_wo_tbl_out IS NOT NULL AND l_eam_wo_tbl_out.COUNT>0) THEN
950: x_wip_entity_id := l_eam_wo_tbl_out(l_eam_wo_tbl_out.FIRST).wip_entity_id;