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.AHL_EAM_JOB_PVT dependencies on EAM_PROCESS_WO_PUB

Line 281: x_eam_wo_rec OUT NOCOPY EAM_PROCESS_WO_PUB.eam_wo_rec_type

277:
278: PROCEDURE map_ahl_eam_wo_rec
279: (
280: p_workorder_rec IN AHL_PRD_WORKORDER_PVT.prd_workorder_rec,
281: x_eam_wo_rec OUT NOCOPY EAM_PROCESS_WO_PUB.eam_wo_rec_type
282: )
283: AS
284:
285: CURSOR Get_Job_Dates_Cur (c_wip_entity_id IN NUMBER)

Line 425: x_eam_wo_rec.transaction_type := EAM_PROCESS_WO_PUB.G_OPR_CREATE;

421: x_eam_wo_rec.source_code := 'AHL';
422:
423: -- Set the DML Operation for the Job Header Record
424: IF ( p_workorder_rec.dml_operation = 'C' ) THEN
425: x_eam_wo_rec.transaction_type := EAM_PROCESS_WO_PUB.G_OPR_CREATE;
426: ELSIF ( p_workorder_rec.dml_operation = 'U' ) THEN
427: x_eam_wo_rec.transaction_type := EAM_PROCESS_WO_PUB.G_OPR_UPDATE;
428: --Srini
429: OPEN Get_Job_Dates_Cur(x_eam_wo_rec.wip_entity_id);

Line 427: x_eam_wo_rec.transaction_type := EAM_PROCESS_WO_PUB.G_OPR_UPDATE;

423: -- Set the DML Operation for the Job Header Record
424: IF ( p_workorder_rec.dml_operation = 'C' ) THEN
425: x_eam_wo_rec.transaction_type := EAM_PROCESS_WO_PUB.G_OPR_CREATE;
426: ELSIF ( p_workorder_rec.dml_operation = 'U' ) THEN
427: x_eam_wo_rec.transaction_type := EAM_PROCESS_WO_PUB.G_OPR_UPDATE;
428: --Srini
429: OPEN Get_Job_Dates_Cur(x_eam_wo_rec.wip_entity_id);
430: FETCH Get_Job_Dates_Cur INTO Get_Job_Dates_Rec;
431: CLOSE Get_Job_Dates_Cur;

Line 487: x_eam_wo_relations_rec OUT NOCOPY EAM_PROCESS_WO_PUB.eam_wo_relations_rec_type

483:
484: PROCEDURE map_ahl_eam_wo_rel_rec
485: (
486: p_workorder_rel_rec IN AHL_PRD_WORKORDER_PVT.prd_workorder_rel_rec,
487: x_eam_wo_relations_rec OUT NOCOPY EAM_PROCESS_WO_PUB.eam_wo_relations_rec_type
488: )
489: AS
490:
491: BEGIN

Line 519: x_eam_wo_relations_rec.transaction_type := EAM_PROCESS_WO_PUB.G_OPR_CREATE;

515: x_eam_wo_relations_rec.relationship_status := 0;
516:
517: -- Set the DML Operation for the Job Header Record
518: IF ( p_workorder_rel_rec.dml_operation = 'C' ) THEN
519: x_eam_wo_relations_rec.transaction_type := EAM_PROCESS_WO_PUB.G_OPR_CREATE;
520: ELSIF ( p_workorder_rel_rec.dml_operation = 'D' ) THEN
521: x_eam_wo_relations_rec.transaction_type := EAM_PROCESS_WO_PUB.G_OPR_DELETE;
522: END IF;
523:

Line 521: x_eam_wo_relations_rec.transaction_type := EAM_PROCESS_WO_PUB.G_OPR_DELETE;

517: -- Set the DML Operation for the Job Header Record
518: IF ( p_workorder_rel_rec.dml_operation = 'C' ) THEN
519: x_eam_wo_relations_rec.transaction_type := EAM_PROCESS_WO_PUB.G_OPR_CREATE;
520: ELSIF ( p_workorder_rel_rec.dml_operation = 'D' ) THEN
521: x_eam_wo_relations_rec.transaction_type := EAM_PROCESS_WO_PUB.G_OPR_DELETE;
522: END IF;
523:
524: x_eam_wo_relations_rec.return_status := NULL;
525:

Line 531: x_eam_op_rec OUT NOCOPY EAM_PROCESS_WO_PUB.eam_op_rec_type

527:
528: PROCEDURE map_ahl_eam_op_rec
529: (
530: p_operation_rec IN AHL_PRD_OPERATIONS_PVT.prd_workoperation_rec,
531: x_eam_op_rec OUT NOCOPY EAM_PROCESS_WO_PUB.eam_op_rec_type
532: )
533: AS
534:
535: BEGIN

Line 591: x_eam_op_rec.transaction_type := EAM_PROCESS_WO_PUB.G_OPR_CREATE;

587: **/
588:
589: -- Set the DML Operation for the Record
590: IF ( p_operation_rec.dml_operation = 'C' ) THEN
591: x_eam_op_rec.transaction_type := EAM_PROCESS_WO_PUB.G_OPR_CREATE;
592: ELSIF ( p_operation_rec.dml_operation = 'U' ) THEN
593: x_eam_op_rec.transaction_type := EAM_PROCESS_WO_PUB.G_OPR_UPDATE;
594: END IF;
595:

Line 593: x_eam_op_rec.transaction_type := EAM_PROCESS_WO_PUB.G_OPR_UPDATE;

589: -- Set the DML Operation for the Record
590: IF ( p_operation_rec.dml_operation = 'C' ) THEN
591: x_eam_op_rec.transaction_type := EAM_PROCESS_WO_PUB.G_OPR_CREATE;
592: ELSIF ( p_operation_rec.dml_operation = 'U' ) THEN
593: x_eam_op_rec.transaction_type := EAM_PROCESS_WO_PUB.G_OPR_UPDATE;
594: END IF;
595:
596: x_eam_op_rec.return_status := NULL;
597:

Line 603: x_eam_mat_req_rec OUT NOCOPY EAM_PROCESS_WO_PUB.eam_mat_req_rec_type

599:
600: PROCEDURE map_ahl_eam_mat_rec
601: (
602: p_material_req_rec IN AHL_PP_MATERIALS_PVT.req_material_rec_type,
603: x_eam_mat_req_rec OUT NOCOPY EAM_PROCESS_WO_PUB.eam_mat_req_rec_type
604: )
605: AS
606:
607: BEGIN

Line 653: x_eam_mat_req_rec.transaction_type := EAM_PROCESS_WO_PUB.G_OPR_CREATE;

649: **/
650:
651: -- Set the DML Operation for the Record
652: IF ( p_material_req_rec.operation_flag = 'C' ) THEN
653: x_eam_mat_req_rec.transaction_type := EAM_PROCESS_WO_PUB.G_OPR_CREATE;
654: ELSIF ( p_material_req_rec.operation_flag = 'U' ) THEN
655: x_eam_mat_req_rec.transaction_type := EAM_PROCESS_WO_PUB.G_OPR_UPDATE;
656: ELSIF ( p_material_req_rec.operation_flag = 'D' ) THEN
657: x_eam_mat_req_rec.transaction_type := EAM_PROCESS_WO_PUB.G_OPR_DELETE;

Line 655: x_eam_mat_req_rec.transaction_type := EAM_PROCESS_WO_PUB.G_OPR_UPDATE;

651: -- Set the DML Operation for the Record
652: IF ( p_material_req_rec.operation_flag = 'C' ) THEN
653: x_eam_mat_req_rec.transaction_type := EAM_PROCESS_WO_PUB.G_OPR_CREATE;
654: ELSIF ( p_material_req_rec.operation_flag = 'U' ) THEN
655: x_eam_mat_req_rec.transaction_type := EAM_PROCESS_WO_PUB.G_OPR_UPDATE;
656: ELSIF ( p_material_req_rec.operation_flag = 'D' ) THEN
657: x_eam_mat_req_rec.transaction_type := EAM_PROCESS_WO_PUB.G_OPR_DELETE;
658: END IF;
659:

Line 657: x_eam_mat_req_rec.transaction_type := EAM_PROCESS_WO_PUB.G_OPR_DELETE;

653: x_eam_mat_req_rec.transaction_type := EAM_PROCESS_WO_PUB.G_OPR_CREATE;
654: ELSIF ( p_material_req_rec.operation_flag = 'U' ) THEN
655: x_eam_mat_req_rec.transaction_type := EAM_PROCESS_WO_PUB.G_OPR_UPDATE;
656: ELSIF ( p_material_req_rec.operation_flag = 'D' ) THEN
657: x_eam_mat_req_rec.transaction_type := EAM_PROCESS_WO_PUB.G_OPR_DELETE;
658: END IF;
659:
660: x_eam_mat_req_rec.return_status := NULL;
661:

Line 667: x_eam_res_rec OUT NOCOPY EAM_PROCESS_WO_PUB.eam_res_rec_type

663:
664: PROCEDURE map_ahl_eam_res_rec
665: (
666: p_resource_req_rec IN AHL_PP_RESRC_REQUIRE_PVT.resrc_require_rec_type,
667: x_eam_res_rec OUT NOCOPY EAM_PROCESS_WO_PUB.eam_res_rec_type
668: )
669: AS
670:
671: BEGIN

Line 725: x_eam_res_rec.transaction_type := EAM_PROCESS_WO_PUB.G_OPR_CREATE;

721: **/
722:
723: -- Set the DML Operation for the Record
724: IF ( p_resource_req_rec.operation_flag = 'C' ) THEN
725: x_eam_res_rec.transaction_type := EAM_PROCESS_WO_PUB.G_OPR_CREATE;
726: ELSIF ( p_resource_req_rec.operation_flag = 'U' ) THEN
727: x_eam_res_rec.transaction_type := EAM_PROCESS_WO_PUB.G_OPR_UPDATE;
728: ELSIF ( p_resource_req_rec.operation_flag = 'D' ) THEN
729: x_eam_res_rec.transaction_type := EAM_PROCESS_WO_PUB.G_OPR_DELETE;

Line 727: x_eam_res_rec.transaction_type := EAM_PROCESS_WO_PUB.G_OPR_UPDATE;

723: -- Set the DML Operation for the Record
724: IF ( p_resource_req_rec.operation_flag = 'C' ) THEN
725: x_eam_res_rec.transaction_type := EAM_PROCESS_WO_PUB.G_OPR_CREATE;
726: ELSIF ( p_resource_req_rec.operation_flag = 'U' ) THEN
727: x_eam_res_rec.transaction_type := EAM_PROCESS_WO_PUB.G_OPR_UPDATE;
728: ELSIF ( p_resource_req_rec.operation_flag = 'D' ) THEN
729: x_eam_res_rec.transaction_type := EAM_PROCESS_WO_PUB.G_OPR_DELETE;
730: END IF;
731:

Line 729: x_eam_res_rec.transaction_type := EAM_PROCESS_WO_PUB.G_OPR_DELETE;

725: x_eam_res_rec.transaction_type := EAM_PROCESS_WO_PUB.G_OPR_CREATE;
726: ELSIF ( p_resource_req_rec.operation_flag = 'U' ) THEN
727: x_eam_res_rec.transaction_type := EAM_PROCESS_WO_PUB.G_OPR_UPDATE;
728: ELSIF ( p_resource_req_rec.operation_flag = 'D' ) THEN
729: x_eam_res_rec.transaction_type := EAM_PROCESS_WO_PUB.G_OPR_DELETE;
730: END IF;
731:
732: x_eam_res_rec.return_status := NULL;
733:

Line 739: x_eam_res_inst_rec OUT NOCOPY EAM_PROCESS_WO_PUB.eam_res_inst_rec_type

735:
736: PROCEDURE map_ahl_eam_res_inst_rec
737: (
738: p_resource_assign_rec IN AHL_PP_RESRC_ASSIGN_PVT.resrc_assign_rec_type,
739: x_eam_res_inst_rec OUT NOCOPY EAM_PROCESS_WO_PUB.eam_res_inst_rec_type
740: )
741: AS
742:
743: BEGIN

Line 775: x_eam_res_inst_rec.transaction_type := EAM_PROCESS_WO_PUB.G_OPR_CREATE;

771: **/
772:
773: -- Set the DML Operation for the Record
774: IF ( p_resource_assign_rec.operation_flag = 'C' ) THEN
775: x_eam_res_inst_rec.transaction_type := EAM_PROCESS_WO_PUB.G_OPR_CREATE;
776: ELSIF ( p_resource_assign_rec.operation_flag = 'U' ) THEN
777: x_eam_res_inst_rec.transaction_type := EAM_PROCESS_WO_PUB.G_OPR_UPDATE;
778: ELSIF ( p_resource_assign_rec.operation_flag = 'D' ) THEN
779: x_eam_res_inst_rec.transaction_type := EAM_PROCESS_WO_PUB.G_OPR_DELETE;

Line 777: x_eam_res_inst_rec.transaction_type := EAM_PROCESS_WO_PUB.G_OPR_UPDATE;

773: -- Set the DML Operation for the Record
774: IF ( p_resource_assign_rec.operation_flag = 'C' ) THEN
775: x_eam_res_inst_rec.transaction_type := EAM_PROCESS_WO_PUB.G_OPR_CREATE;
776: ELSIF ( p_resource_assign_rec.operation_flag = 'U' ) THEN
777: x_eam_res_inst_rec.transaction_type := EAM_PROCESS_WO_PUB.G_OPR_UPDATE;
778: ELSIF ( p_resource_assign_rec.operation_flag = 'D' ) THEN
779: x_eam_res_inst_rec.transaction_type := EAM_PROCESS_WO_PUB.G_OPR_DELETE;
780: END IF;
781:

Line 779: x_eam_res_inst_rec.transaction_type := EAM_PROCESS_WO_PUB.G_OPR_DELETE;

775: x_eam_res_inst_rec.transaction_type := EAM_PROCESS_WO_PUB.G_OPR_CREATE;
776: ELSIF ( p_resource_assign_rec.operation_flag = 'U' ) THEN
777: x_eam_res_inst_rec.transaction_type := EAM_PROCESS_WO_PUB.G_OPR_UPDATE;
778: ELSIF ( p_resource_assign_rec.operation_flag = 'D' ) THEN
779: x_eam_res_inst_rec.transaction_type := EAM_PROCESS_WO_PUB.G_OPR_DELETE;
780: END IF;
781:
782: x_eam_res_inst_rec.return_status := NULL;
783:

Line 815: l_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;

811: l_debug_filename VARCHAR2(80);
812: l_debug_file_mode VARCHAR2(1);
813: l_return_status VARCHAR2(1);
814: l_msg_count NUMBER;
815: l_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
816: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
817: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
818: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
819: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;

Line 816: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;

812: l_debug_file_mode VARCHAR2(1);
813: l_return_status VARCHAR2(1);
814: l_msg_count NUMBER;
815: l_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
816: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
817: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
818: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
819: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
820: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;

Line 817: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;

813: l_return_status VARCHAR2(1);
814: l_msg_count NUMBER;
815: l_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
816: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
817: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
818: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
819: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
820: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
821: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;

Line 818: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;

814: l_msg_count NUMBER;
815: l_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
816: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
817: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
818: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
819: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
820: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
821: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
822: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;

Line 819: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;

815: l_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
816: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
817: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
818: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
819: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
820: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
821: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
822: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
823: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;

Line 820: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;

816: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
817: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
818: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
819: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
820: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
821: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
822: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
823: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
824: l_out_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;

Line 821: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;

817: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
818: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
819: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
820: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
821: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
822: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
823: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
824: l_out_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
825: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;

Line 822: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;

818: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
819: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
820: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
821: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
822: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
823: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
824: l_out_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
825: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
826: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;

Line 823: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;

819: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
820: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
821: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
822: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
823: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
824: l_out_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
825: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
826: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
827: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;

Line 824: l_out_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;

820: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
821: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
822: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
823: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
824: l_out_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
825: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
826: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
827: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
828: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;

Line 825: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;

821: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
822: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
823: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
824: l_out_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
825: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
826: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
827: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
828: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
829: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;

Line 826: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;

822: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
823: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
824: l_out_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
825: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
826: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
827: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
828: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
829: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
830: l_out_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;

Line 827: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;

823: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
824: l_out_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
825: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
826: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
827: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
828: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
829: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
830: l_out_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
831: l_out_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;

Line 828: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;

824: l_out_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
825: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
826: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
827: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
828: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
829: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
830: l_out_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
831: l_out_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
832: l_out_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;

Line 829: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;

825: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
826: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
827: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
828: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
829: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
830: l_out_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
831: l_out_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
832: l_out_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
833:

Line 830: l_out_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;

826: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
827: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
828: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
829: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
830: l_out_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
831: l_out_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
832: l_out_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
833:
834: BEGIN

Line 831: l_out_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;

827: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
828: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
829: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
830: l_out_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
831: l_out_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
832: l_out_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
833:
834: BEGIN
835:

Line 832: l_out_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;

828: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
829: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
830: l_out_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
831: l_out_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
832: l_out_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
833:
834: BEGIN
835:
836: -- Enable Debug

Line 948: EAM_PROCESS_WO_PUB.process_wo

944: AHL_DEBUG_PUB.debug( 'Invoking EAM process_wo API' );
945: END IF;
946:
947: -- Invoke EAM BO API for Updating the Job
948: EAM_PROCESS_WO_PUB.process_wo
949: (
950: p_bo_identifier => l_bo_identifier,
951: p_api_version_number => 1.0,
952: p_init_msg_list => l_init_msg_list,

Line 1092: l_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;

1088: l_debug_filename VARCHAR2(80);
1089: l_debug_file_mode VARCHAR2(1);
1090: l_return_status VARCHAR2(1);
1091: l_msg_count NUMBER;
1092: l_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1093: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1094: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1095: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1096: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;

Line 1093: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;

1089: l_debug_file_mode VARCHAR2(1);
1090: l_return_status VARCHAR2(1);
1091: l_msg_count NUMBER;
1092: l_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1093: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1094: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1095: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1096: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1097: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;

Line 1094: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;

1090: l_return_status VARCHAR2(1);
1091: l_msg_count NUMBER;
1092: l_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1093: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1094: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1095: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1096: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1097: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1098: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;

Line 1095: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;

1091: l_msg_count NUMBER;
1092: l_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1093: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1094: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1095: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1096: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1097: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1098: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
1099: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;

Line 1096: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;

1092: l_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1093: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1094: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1095: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1096: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1097: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1098: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
1099: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
1100: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;

Line 1097: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;

1093: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1094: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1095: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1096: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1097: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1098: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
1099: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
1100: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
1101: l_out_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;

Line 1098: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;

1094: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1095: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1096: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1097: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1098: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
1099: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
1100: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
1101: l_out_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1102: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;

Line 1099: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;

1095: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1096: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1097: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1098: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
1099: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
1100: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
1101: l_out_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1102: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1103: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;

Line 1100: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;

1096: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1097: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1098: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
1099: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
1100: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
1101: l_out_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1102: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1103: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1104: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;

Line 1101: l_out_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;

1097: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1098: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
1099: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
1100: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
1101: l_out_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1102: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1103: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1104: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1105: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;

Line 1102: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;

1098: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
1099: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
1100: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
1101: l_out_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1102: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1103: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1104: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1105: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1106: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;

Line 1103: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;

1099: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
1100: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
1101: l_out_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1102: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1103: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1104: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1105: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1106: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1107: l_out_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;

Line 1104: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;

1100: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
1101: l_out_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1102: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1103: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1104: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1105: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1106: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1107: l_out_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
1108: l_out_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;

Line 1105: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;

1101: l_out_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1102: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1103: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1104: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1105: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1106: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1107: l_out_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
1108: l_out_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
1109: l_out_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;

Line 1106: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;

1102: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1103: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1104: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1105: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1106: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1107: l_out_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
1108: l_out_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
1109: l_out_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
1110:

Line 1107: l_out_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;

1103: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1104: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1105: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1106: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1107: l_out_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
1108: l_out_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
1109: l_out_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
1110:
1111: BEGIN

Line 1108: l_out_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;

1104: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1105: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1106: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1107: l_out_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
1108: l_out_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
1109: l_out_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
1110:
1111: BEGIN
1112:

Line 1109: l_out_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;

1105: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1106: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1107: l_out_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
1108: l_out_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
1109: l_out_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
1110:
1111: BEGIN
1112:
1113: -- Enable Debug

Line 1214: EAM_PROCESS_WO_PUB.process_wo

1210: AHL_DEBUG_PUB.debug( 'Invoking EAM process_wo API' );
1211: END IF;
1212:
1213: -- Invoke EAM BO API for Updating the Job
1214: EAM_PROCESS_WO_PUB.process_wo
1215: (
1216: p_bo_identifier => l_bo_identifier,
1217: p_api_version_number => 1.0,
1218: p_init_msg_list => l_init_msg_list,

Line 1347: l_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;

1343: l_debug_filename VARCHAR2(80);
1344: l_debug_file_mode VARCHAR2(1);
1345: l_return_status VARCHAR2(1);
1346: l_msg_count NUMBER;
1347: l_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1348: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1349: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1350: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1351: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;

Line 1348: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;

1344: l_debug_file_mode VARCHAR2(1);
1345: l_return_status VARCHAR2(1);
1346: l_msg_count NUMBER;
1347: l_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1348: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1349: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1350: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1351: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1352: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;

Line 1349: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;

1345: l_return_status VARCHAR2(1);
1346: l_msg_count NUMBER;
1347: l_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1348: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1349: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1350: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1351: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1352: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1353: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;

Line 1350: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;

1346: l_msg_count NUMBER;
1347: l_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1348: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1349: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1350: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1351: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1352: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1353: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
1354: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;

Line 1351: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;

1347: l_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1348: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1349: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1350: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1351: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1352: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1353: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
1354: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
1355: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;

Line 1352: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;

1348: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1349: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1350: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1351: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1352: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1353: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
1354: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
1355: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
1356: l_out_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;

Line 1353: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;

1349: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1350: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1351: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1352: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1353: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
1354: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
1355: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
1356: l_out_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1357: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;

Line 1354: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;

1350: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1351: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1352: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1353: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
1354: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
1355: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
1356: l_out_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1357: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1358: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;

Line 1355: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;

1351: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1352: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1353: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
1354: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
1355: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
1356: l_out_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1357: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1358: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1359: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;

Line 1356: l_out_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;

1352: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1353: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
1354: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
1355: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
1356: l_out_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1357: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1358: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1359: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1360: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;

Line 1357: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;

1353: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
1354: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
1355: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
1356: l_out_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1357: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1358: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1359: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1360: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1361: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;

Line 1358: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;

1354: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
1355: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
1356: l_out_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1357: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1358: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1359: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1360: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1361: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1362: l_out_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;

Line 1359: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;

1355: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
1356: l_out_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1357: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1358: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1359: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1360: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1361: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1362: l_out_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
1363: l_out_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;

Line 1360: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;

1356: l_out_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1357: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1358: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1359: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1360: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1361: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1362: l_out_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
1363: l_out_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
1364: l_out_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;

Line 1361: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;

1357: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1358: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1359: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1360: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1361: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1362: l_out_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
1363: l_out_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
1364: l_out_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
1365:

Line 1362: l_out_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;

1358: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1359: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1360: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1361: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1362: l_out_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
1363: l_out_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
1364: l_out_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
1365:
1366: BEGIN

Line 1363: l_out_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;

1359: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1360: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1361: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1362: l_out_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
1363: l_out_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
1364: l_out_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
1365:
1366: BEGIN
1367:

Line 1364: l_out_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;

1360: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1361: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1362: l_out_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
1363: l_out_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
1364: l_out_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
1365:
1366: BEGIN
1367:
1368: -- Enable Debug

Line 1412: EAM_PROCESS_WO_PUB.process_wo

1408: AHL_DEBUG_PUB.debug( 'Invoking EAM process_wo API' );
1409: END IF;
1410:
1411: -- Invoke EAM BO API for Updating the Job
1412: EAM_PROCESS_WO_PUB.process_wo
1413: (
1414: p_bo_identifier => l_bo_identifier,
1415: p_api_version_number => 1.0,
1416: p_init_msg_list => l_init_msg_list,

Line 1553: l_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;

1549: l_debug_filename VARCHAR2(80);
1550: l_debug_file_mode VARCHAR2(1);
1551: l_return_status VARCHAR2(1);
1552: l_msg_count NUMBER;
1553: l_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1554: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1555: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1556: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1557: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;

Line 1554: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;

1550: l_debug_file_mode VARCHAR2(1);
1551: l_return_status VARCHAR2(1);
1552: l_msg_count NUMBER;
1553: l_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1554: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1555: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1556: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1557: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1558: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;

Line 1555: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;

1551: l_return_status VARCHAR2(1);
1552: l_msg_count NUMBER;
1553: l_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1554: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1555: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1556: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1557: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1558: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1559: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;

Line 1556: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;

1552: l_msg_count NUMBER;
1553: l_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1554: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1555: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1556: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1557: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1558: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1559: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
1560: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;

Line 1557: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;

1553: l_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1554: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1555: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1556: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1557: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1558: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1559: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
1560: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
1561: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;

Line 1558: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;

1554: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1555: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1556: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1557: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1558: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1559: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
1560: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
1561: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
1562: l_out_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;

Line 1559: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;

1555: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1556: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1557: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1558: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1559: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
1560: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
1561: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
1562: l_out_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1563: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;

Line 1560: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;

1556: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1557: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1558: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1559: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
1560: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
1561: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
1562: l_out_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1563: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1564: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;

Line 1561: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;

1557: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1558: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1559: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
1560: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
1561: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
1562: l_out_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1563: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1564: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1565: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;

Line 1562: l_out_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;

1558: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1559: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
1560: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
1561: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
1562: l_out_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1563: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1564: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1565: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1566: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;

Line 1563: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;

1559: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
1560: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
1561: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
1562: l_out_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1563: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1564: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1565: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1566: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1567: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;

Line 1564: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;

1560: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
1561: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
1562: l_out_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1563: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1564: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1565: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1566: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1567: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1568: l_out_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;

Line 1565: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;

1561: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
1562: l_out_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1563: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1564: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1565: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1566: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1567: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1568: l_out_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
1569: l_out_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;

Line 1566: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;

1562: l_out_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1563: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1564: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1565: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1566: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1567: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1568: l_out_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
1569: l_out_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
1570: l_out_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;

Line 1567: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;

1563: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1564: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1565: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1566: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1567: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1568: l_out_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
1569: l_out_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
1570: l_out_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
1571:

Line 1568: l_out_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;

1564: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1565: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1566: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1567: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1568: l_out_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
1569: l_out_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
1570: l_out_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
1571:
1572: BEGIN

Line 1569: l_out_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;

1565: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1566: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1567: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1568: l_out_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
1569: l_out_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
1570: l_out_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
1571:
1572: BEGIN
1573:

Line 1570: l_out_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;

1566: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1567: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1568: l_out_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
1569: l_out_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
1570: l_out_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
1571:
1572: BEGIN
1573:
1574: -- Enable Debug

Line 1629: l_eam_wo_rec.transaction_type := EAM_PROCESS_WO_PUB.G_OPR_UPDATE;

1625: CLOSE get_wo_details;
1626: IF (l_wo_details.requested_start_date IS NULL) THEN
1627: l_eam_wo_rec.wip_entity_id := p_resource_req_tbl(1).wip_entity_id;
1628: l_eam_wo_rec.organization_id := l_wo_details.organization_id;
1629: l_eam_wo_rec.transaction_type := EAM_PROCESS_WO_PUB.G_OPR_UPDATE;
1630: l_eam_wo_rec.requested_start_date := l_wo_details.scheduled_start_date;
1631: END IF;
1632: END IF;
1633:

Line 1636: EAM_PROCESS_WO_PUB.process_wo

1632: END IF;
1633:
1634: --Changes For 9388148 --end
1635: -- Invoke EAM BO API for Updating the Job
1636: EAM_PROCESS_WO_PUB.process_wo
1637: (
1638: p_bo_identifier => l_bo_identifier,
1639: p_api_version_number => 1.0,
1640: p_init_msg_list => l_init_msg_list,

Line 1768: l_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;

1764: l_debug_filename VARCHAR2(80);
1765: l_debug_file_mode VARCHAR2(1);
1766: l_return_status VARCHAR2(1);
1767: l_msg_count NUMBER;
1768: l_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1769: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1770: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1771: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1772: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;

Line 1769: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;

1765: l_debug_file_mode VARCHAR2(1);
1766: l_return_status VARCHAR2(1);
1767: l_msg_count NUMBER;
1768: l_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1769: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1770: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1771: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1772: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1773: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;

Line 1770: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;

1766: l_return_status VARCHAR2(1);
1767: l_msg_count NUMBER;
1768: l_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1769: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1770: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1771: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1772: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1773: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1774: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;

Line 1771: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;

1767: l_msg_count NUMBER;
1768: l_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1769: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1770: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1771: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1772: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1773: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1774: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
1775: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;

Line 1772: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;

1768: l_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1769: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1770: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1771: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1772: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1773: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1774: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
1775: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
1776: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;

Line 1773: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;

1769: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1770: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1771: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1772: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1773: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1774: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
1775: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
1776: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
1777: l_out_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;

Line 1774: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;

1770: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1771: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1772: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1773: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1774: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
1775: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
1776: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
1777: l_out_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1778: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;

Line 1775: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;

1771: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1772: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1773: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1774: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
1775: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
1776: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
1777: l_out_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1778: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1779: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;

Line 1776: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;

1772: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1773: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1774: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
1775: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
1776: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
1777: l_out_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1778: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1779: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1780: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;

Line 1777: l_out_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;

1773: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1774: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
1775: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
1776: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
1777: l_out_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1778: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1779: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1780: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1781: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;

Line 1778: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;

1774: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
1775: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
1776: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
1777: l_out_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1778: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1779: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1780: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1781: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1782: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;

Line 1779: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;

1775: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
1776: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
1777: l_out_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1778: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1779: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1780: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1781: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1782: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1783: l_out_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;

Line 1780: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;

1776: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
1777: l_out_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1778: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1779: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1780: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1781: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1782: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1783: l_out_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
1784: l_out_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;

Line 1781: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;

1777: l_out_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1778: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1779: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1780: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1781: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1782: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1783: l_out_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
1784: l_out_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
1785: l_out_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;

Line 1782: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;

1778: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1779: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1780: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1781: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1782: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1783: l_out_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
1784: l_out_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
1785: l_out_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
1786:

Line 1783: l_out_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;

1779: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1780: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1781: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1782: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1783: l_out_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
1784: l_out_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
1785: l_out_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
1786:
1787: BEGIN

Line 1784: l_out_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;

1780: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1781: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1782: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1783: l_out_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
1784: l_out_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
1785: l_out_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
1786:
1787: BEGIN
1788:

Line 1785: l_out_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;

1781: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1782: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1783: l_out_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
1784: l_out_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
1785: l_out_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
1786:
1787: BEGIN
1788:
1789: -- Enable Debug

Line 1833: EAM_PROCESS_WO_PUB.process_wo

1829: AHL_DEBUG_PUB.debug( 'Invoking EAM process_wo API' );
1830: END IF;
1831:
1832: -- Invoke EAM BO API for Updating the Job
1833: EAM_PROCESS_WO_PUB.process_wo
1834: (
1835: p_bo_identifier => l_bo_identifier,
1836: p_api_version_number => 1.0,
1837: p_init_msg_list => l_init_msg_list,

Line 1950: p_x_eam_wo_tbl IN OUT NOCOPY EAM_PROCESS_WO_PUB.eam_wo_tbl_type,

1946: p_module_type IN VARCHAR2 := NULL,
1947: x_return_status OUT NOCOPY VARCHAR2,
1948: x_msg_count OUT NOCOPY NUMBER,
1949: x_msg_data OUT NOCOPY VARCHAR2,
1950: p_x_eam_wo_tbl IN OUT NOCOPY EAM_PROCESS_WO_PUB.eam_wo_tbl_type,
1951: p_eam_wo_relations_tbl IN EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type,
1952: p_eam_op_tbl IN EAM_PROCESS_WO_PUB.eam_op_tbl_type,
1953: p_eam_res_req_tbl IN EAM_PROCESS_WO_PUB.eam_res_tbl_type,
1954: p_eam_mat_req_tbl IN EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type

Line 1951: p_eam_wo_relations_tbl IN EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type,

1947: x_return_status OUT NOCOPY VARCHAR2,
1948: x_msg_count OUT NOCOPY NUMBER,
1949: x_msg_data OUT NOCOPY VARCHAR2,
1950: p_x_eam_wo_tbl IN OUT NOCOPY EAM_PROCESS_WO_PUB.eam_wo_tbl_type,
1951: p_eam_wo_relations_tbl IN EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type,
1952: p_eam_op_tbl IN EAM_PROCESS_WO_PUB.eam_op_tbl_type,
1953: p_eam_res_req_tbl IN EAM_PROCESS_WO_PUB.eam_res_tbl_type,
1954: p_eam_mat_req_tbl IN EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type
1955: )

Line 1952: p_eam_op_tbl IN EAM_PROCESS_WO_PUB.eam_op_tbl_type,

1948: x_msg_count OUT NOCOPY NUMBER,
1949: x_msg_data OUT NOCOPY VARCHAR2,
1950: p_x_eam_wo_tbl IN OUT NOCOPY EAM_PROCESS_WO_PUB.eam_wo_tbl_type,
1951: p_eam_wo_relations_tbl IN EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type,
1952: p_eam_op_tbl IN EAM_PROCESS_WO_PUB.eam_op_tbl_type,
1953: p_eam_res_req_tbl IN EAM_PROCESS_WO_PUB.eam_res_tbl_type,
1954: p_eam_mat_req_tbl IN EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type
1955: )
1956: IS

Line 1953: p_eam_res_req_tbl IN EAM_PROCESS_WO_PUB.eam_res_tbl_type,

1949: x_msg_data OUT NOCOPY VARCHAR2,
1950: p_x_eam_wo_tbl IN OUT NOCOPY EAM_PROCESS_WO_PUB.eam_wo_tbl_type,
1951: p_eam_wo_relations_tbl IN EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type,
1952: p_eam_op_tbl IN EAM_PROCESS_WO_PUB.eam_op_tbl_type,
1953: p_eam_res_req_tbl IN EAM_PROCESS_WO_PUB.eam_res_tbl_type,
1954: p_eam_mat_req_tbl IN EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type
1955: )
1956: IS
1957:

Line 1954: p_eam_mat_req_tbl IN EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type

1950: p_x_eam_wo_tbl IN OUT NOCOPY EAM_PROCESS_WO_PUB.eam_wo_tbl_type,
1951: p_eam_wo_relations_tbl IN EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type,
1952: p_eam_op_tbl IN EAM_PROCESS_WO_PUB.eam_op_tbl_type,
1953: p_eam_res_req_tbl IN EAM_PROCESS_WO_PUB.eam_res_tbl_type,
1954: p_eam_mat_req_tbl IN EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type
1955: )
1956: IS
1957:
1958: l_api_name VARCHAR2(30) := 'process_eam_workorders';

Line 1969: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;

1965: l_debug_filename VARCHAR2(80);
1966: l_debug_file_mode VARCHAR2(1);
1967: l_return_status VARCHAR2(1);
1968: l_msg_count NUMBER;
1969: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1970: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1971: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1972: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
1973: l_out_eam_wo_tbl EAM_PROCESS_WO_PUB.eam_wo_tbl_type;

Line 1970: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;

1966: l_debug_file_mode VARCHAR2(1);
1967: l_return_status VARCHAR2(1);
1968: l_msg_count NUMBER;
1969: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1970: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1971: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1972: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
1973: l_out_eam_wo_tbl EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
1974: l_out_eam_wo_rel_tbl EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;

Line 1971: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;

1967: l_return_status VARCHAR2(1);
1968: l_msg_count NUMBER;
1969: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1970: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1971: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1972: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
1973: l_out_eam_wo_tbl EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
1974: l_out_eam_wo_rel_tbl EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
1975: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;

Line 1972: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;

1968: l_msg_count NUMBER;
1969: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1970: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1971: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1972: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
1973: l_out_eam_wo_tbl EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
1974: l_out_eam_wo_rel_tbl EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
1975: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1976: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;

Line 1973: l_out_eam_wo_tbl EAM_PROCESS_WO_PUB.eam_wo_tbl_type;

1969: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1970: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1971: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1972: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
1973: l_out_eam_wo_tbl EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
1974: l_out_eam_wo_rel_tbl EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
1975: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1976: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1977: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;

Line 1974: l_out_eam_wo_rel_tbl EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;

1970: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1971: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1972: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
1973: l_out_eam_wo_tbl EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
1974: l_out_eam_wo_rel_tbl EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
1975: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1976: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1977: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1978: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;

Line 1975: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;

1971: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1972: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
1973: l_out_eam_wo_tbl EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
1974: l_out_eam_wo_rel_tbl EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
1975: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1976: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1977: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1978: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1979: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;

Line 1976: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;

1972: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
1973: l_out_eam_wo_tbl EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
1974: l_out_eam_wo_rel_tbl EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
1975: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1976: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1977: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1978: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1979: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1980: l_out_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;

Line 1977: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;

1973: l_out_eam_wo_tbl EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
1974: l_out_eam_wo_rel_tbl EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
1975: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1976: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1977: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1978: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1979: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1980: l_out_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
1981: l_out_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;

Line 1978: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;

1974: l_out_eam_wo_rel_tbl EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
1975: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1976: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1977: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1978: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1979: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1980: l_out_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
1981: l_out_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
1982:

Line 1979: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;

1975: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1976: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1977: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1978: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1979: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1980: l_out_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
1981: l_out_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
1982:
1983: BEGIN

Line 1980: l_out_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;

1976: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1977: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1978: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1979: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1980: l_out_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
1981: l_out_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
1982:
1983: BEGIN
1984:

Line 1981: l_out_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;

1977: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1978: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1979: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1980: l_out_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
1981: l_out_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
1982:
1983: BEGIN
1984:
1985: -- Enable Debug

Line 2040: EAM_PROCESS_WO_PUB.process_master_child_wo

2036: END IF;
2037:
2038: END IF;
2039:
2040: EAM_PROCESS_WO_PUB.process_master_child_wo
2041: (
2042: p_bo_identifier => l_bo_identifier,
2043: p_api_version_number => 1.0,
2044: p_init_msg_list => l_init_msg_list,