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 422: x_eam_wo_rec.transaction_type := EAM_PROCESS_WO_PUB.G_OPR_CREATE;

418: **/
419:
420: -- Set the DML Operation for the Job Header Record
421: IF ( p_workorder_rec.dml_operation = 'C' ) THEN
422: x_eam_wo_rec.transaction_type := EAM_PROCESS_WO_PUB.G_OPR_CREATE;
423: ELSIF ( p_workorder_rec.dml_operation = 'U' ) THEN
424: x_eam_wo_rec.transaction_type := EAM_PROCESS_WO_PUB.G_OPR_UPDATE;
425: --Srini
426: OPEN Get_Job_Dates_Cur(x_eam_wo_rec.wip_entity_id);

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

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

Line 484: x_eam_wo_relations_rec OUT NOCOPY EAM_PROCESS_WO_PUB.eam_wo_relations_rec_type

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

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

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

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

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

Line 528: x_eam_op_rec OUT NOCOPY EAM_PROCESS_WO_PUB.eam_op_rec_type

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

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

582: **/
583:
584: -- Set the DML Operation for the Record
585: IF ( p_operation_rec.dml_operation = 'C' ) THEN
586: x_eam_op_rec.transaction_type := EAM_PROCESS_WO_PUB.G_OPR_CREATE;
587: ELSIF ( p_operation_rec.dml_operation = 'U' ) THEN
588: x_eam_op_rec.transaction_type := EAM_PROCESS_WO_PUB.G_OPR_UPDATE;
589: END IF;
590:

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

584: -- Set the DML Operation for the Record
585: IF ( p_operation_rec.dml_operation = 'C' ) THEN
586: x_eam_op_rec.transaction_type := EAM_PROCESS_WO_PUB.G_OPR_CREATE;
587: ELSIF ( p_operation_rec.dml_operation = 'U' ) THEN
588: x_eam_op_rec.transaction_type := EAM_PROCESS_WO_PUB.G_OPR_UPDATE;
589: END IF;
590:
591: x_eam_op_rec.return_status := NULL;
592:

Line 598: x_eam_mat_req_rec OUT NOCOPY EAM_PROCESS_WO_PUB.eam_mat_req_rec_type

594:
595: PROCEDURE map_ahl_eam_mat_rec
596: (
597: p_material_req_rec IN AHL_PP_MATERIALS_PVT.req_material_rec_type,
598: x_eam_mat_req_rec OUT NOCOPY EAM_PROCESS_WO_PUB.eam_mat_req_rec_type
599: )
600: AS
601:
602: BEGIN

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

644: **/
645:
646: -- Set the DML Operation for the Record
647: IF ( p_material_req_rec.operation_flag = 'C' ) THEN
648: x_eam_mat_req_rec.transaction_type := EAM_PROCESS_WO_PUB.G_OPR_CREATE;
649: ELSIF ( p_material_req_rec.operation_flag = 'U' ) THEN
650: x_eam_mat_req_rec.transaction_type := EAM_PROCESS_WO_PUB.G_OPR_UPDATE;
651: ELSIF ( p_material_req_rec.operation_flag = 'D' ) THEN
652: x_eam_mat_req_rec.transaction_type := EAM_PROCESS_WO_PUB.G_OPR_DELETE;

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

646: -- Set the DML Operation for the Record
647: IF ( p_material_req_rec.operation_flag = 'C' ) THEN
648: x_eam_mat_req_rec.transaction_type := EAM_PROCESS_WO_PUB.G_OPR_CREATE;
649: ELSIF ( p_material_req_rec.operation_flag = 'U' ) THEN
650: x_eam_mat_req_rec.transaction_type := EAM_PROCESS_WO_PUB.G_OPR_UPDATE;
651: ELSIF ( p_material_req_rec.operation_flag = 'D' ) THEN
652: x_eam_mat_req_rec.transaction_type := EAM_PROCESS_WO_PUB.G_OPR_DELETE;
653: END IF;
654:

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

648: x_eam_mat_req_rec.transaction_type := EAM_PROCESS_WO_PUB.G_OPR_CREATE;
649: ELSIF ( p_material_req_rec.operation_flag = 'U' ) THEN
650: x_eam_mat_req_rec.transaction_type := EAM_PROCESS_WO_PUB.G_OPR_UPDATE;
651: ELSIF ( p_material_req_rec.operation_flag = 'D' ) THEN
652: x_eam_mat_req_rec.transaction_type := EAM_PROCESS_WO_PUB.G_OPR_DELETE;
653: END IF;
654:
655: x_eam_mat_req_rec.return_status := NULL;
656:

Line 662: x_eam_res_rec OUT NOCOPY EAM_PROCESS_WO_PUB.eam_res_rec_type

658:
659: PROCEDURE map_ahl_eam_res_rec
660: (
661: p_resource_req_rec IN AHL_PP_RESRC_REQUIRE_PVT.resrc_require_rec_type,
662: x_eam_res_rec OUT NOCOPY EAM_PROCESS_WO_PUB.eam_res_rec_type
663: )
664: AS
665:
666: BEGIN

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

716: **/
717:
718: -- Set the DML Operation for the Record
719: IF ( p_resource_req_rec.operation_flag = 'C' ) THEN
720: x_eam_res_rec.transaction_type := EAM_PROCESS_WO_PUB.G_OPR_CREATE;
721: ELSIF ( p_resource_req_rec.operation_flag = 'U' ) THEN
722: x_eam_res_rec.transaction_type := EAM_PROCESS_WO_PUB.G_OPR_UPDATE;
723: ELSIF ( p_resource_req_rec.operation_flag = 'D' ) THEN
724: x_eam_res_rec.transaction_type := EAM_PROCESS_WO_PUB.G_OPR_DELETE;

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

718: -- Set the DML Operation for the Record
719: IF ( p_resource_req_rec.operation_flag = 'C' ) THEN
720: x_eam_res_rec.transaction_type := EAM_PROCESS_WO_PUB.G_OPR_CREATE;
721: ELSIF ( p_resource_req_rec.operation_flag = 'U' ) THEN
722: x_eam_res_rec.transaction_type := EAM_PROCESS_WO_PUB.G_OPR_UPDATE;
723: ELSIF ( p_resource_req_rec.operation_flag = 'D' ) THEN
724: x_eam_res_rec.transaction_type := EAM_PROCESS_WO_PUB.G_OPR_DELETE;
725: END IF;
726:

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

720: x_eam_res_rec.transaction_type := EAM_PROCESS_WO_PUB.G_OPR_CREATE;
721: ELSIF ( p_resource_req_rec.operation_flag = 'U' ) THEN
722: x_eam_res_rec.transaction_type := EAM_PROCESS_WO_PUB.G_OPR_UPDATE;
723: ELSIF ( p_resource_req_rec.operation_flag = 'D' ) THEN
724: x_eam_res_rec.transaction_type := EAM_PROCESS_WO_PUB.G_OPR_DELETE;
725: END IF;
726:
727: x_eam_res_rec.return_status := NULL;
728:

Line 734: x_eam_res_inst_rec OUT NOCOPY EAM_PROCESS_WO_PUB.eam_res_inst_rec_type

730:
731: PROCEDURE map_ahl_eam_res_inst_rec
732: (
733: p_resource_assign_rec IN AHL_PP_RESRC_ASSIGN_PVT.resrc_assign_rec_type,
734: x_eam_res_inst_rec OUT NOCOPY EAM_PROCESS_WO_PUB.eam_res_inst_rec_type
735: )
736: AS
737:
738: BEGIN

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

766: **/
767:
768: -- Set the DML Operation for the Record
769: IF ( p_resource_assign_rec.operation_flag = 'C' ) THEN
770: x_eam_res_inst_rec.transaction_type := EAM_PROCESS_WO_PUB.G_OPR_CREATE;
771: ELSIF ( p_resource_assign_rec.operation_flag = 'U' ) THEN
772: x_eam_res_inst_rec.transaction_type := EAM_PROCESS_WO_PUB.G_OPR_UPDATE;
773: ELSIF ( p_resource_assign_rec.operation_flag = 'D' ) THEN
774: x_eam_res_inst_rec.transaction_type := EAM_PROCESS_WO_PUB.G_OPR_DELETE;

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

768: -- Set the DML Operation for the Record
769: IF ( p_resource_assign_rec.operation_flag = 'C' ) THEN
770: x_eam_res_inst_rec.transaction_type := EAM_PROCESS_WO_PUB.G_OPR_CREATE;
771: ELSIF ( p_resource_assign_rec.operation_flag = 'U' ) THEN
772: x_eam_res_inst_rec.transaction_type := EAM_PROCESS_WO_PUB.G_OPR_UPDATE;
773: ELSIF ( p_resource_assign_rec.operation_flag = 'D' ) THEN
774: x_eam_res_inst_rec.transaction_type := EAM_PROCESS_WO_PUB.G_OPR_DELETE;
775: END IF;
776:

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

770: x_eam_res_inst_rec.transaction_type := EAM_PROCESS_WO_PUB.G_OPR_CREATE;
771: ELSIF ( p_resource_assign_rec.operation_flag = 'U' ) THEN
772: x_eam_res_inst_rec.transaction_type := EAM_PROCESS_WO_PUB.G_OPR_UPDATE;
773: ELSIF ( p_resource_assign_rec.operation_flag = 'D' ) THEN
774: x_eam_res_inst_rec.transaction_type := EAM_PROCESS_WO_PUB.G_OPR_DELETE;
775: END IF;
776:
777: x_eam_res_inst_rec.return_status := NULL;
778:

Line 810: l_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;

806: l_debug_filename VARCHAR2(80);
807: l_debug_file_mode VARCHAR2(1);
808: l_return_status VARCHAR2(1);
809: l_msg_count NUMBER;
810: l_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
811: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
812: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
813: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
814: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;

Line 811: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;

807: l_debug_file_mode VARCHAR2(1);
808: l_return_status VARCHAR2(1);
809: l_msg_count NUMBER;
810: l_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
811: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
812: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
813: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
814: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
815: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;

Line 812: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;

808: l_return_status VARCHAR2(1);
809: l_msg_count NUMBER;
810: l_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
811: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
812: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
813: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
814: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
815: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
816: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;

Line 813: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;

809: l_msg_count NUMBER;
810: l_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
811: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
812: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
813: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
814: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
815: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
816: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
817: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;

Line 814: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;

810: l_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
811: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
812: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
813: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
814: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
815: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
816: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
817: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
818: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;

Line 815: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;

811: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
812: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
813: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
814: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
815: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
816: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
817: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
818: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
819: l_out_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;

Line 816: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;

812: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
813: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
814: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
815: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
816: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
817: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
818: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
819: l_out_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
820: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;

Line 817: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;

813: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
814: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
815: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
816: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
817: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
818: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
819: l_out_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
820: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
821: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;

Line 818: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;

814: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
815: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
816: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
817: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
818: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
819: l_out_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
820: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
821: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
822: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;

Line 819: l_out_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;

815: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
816: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
817: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
818: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
819: l_out_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
820: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
821: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
822: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
823: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;

Line 820: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;

816: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
817: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
818: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
819: l_out_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
820: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
821: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
822: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
823: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
824: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;

Line 821: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;

817: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
818: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
819: l_out_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
820: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
821: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
822: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
823: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
824: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
825: l_out_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;

Line 822: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;

818: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
819: l_out_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
820: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
821: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
822: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
823: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
824: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
825: l_out_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
826: l_out_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;

Line 823: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;

819: l_out_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
820: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
821: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
822: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
823: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
824: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
825: l_out_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
826: l_out_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
827: l_out_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;

Line 824: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;

820: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
821: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
822: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
823: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
824: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
825: l_out_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
826: l_out_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
827: l_out_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
828:

Line 825: l_out_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;

821: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
822: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
823: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
824: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
825: l_out_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
826: l_out_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
827: l_out_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
828:
829: BEGIN

Line 826: l_out_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;

822: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
823: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
824: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
825: l_out_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
826: l_out_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
827: l_out_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
828:
829: BEGIN
830:

Line 827: l_out_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;

823: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
824: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
825: l_out_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
826: l_out_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
827: l_out_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
828:
829: BEGIN
830:
831: -- Enable Debug

Line 943: EAM_PROCESS_WO_PUB.process_wo

939: AHL_DEBUG_PUB.debug( 'Invoking EAM process_wo API' );
940: END IF;
941:
942: -- Invoke EAM BO API for Updating the Job
943: EAM_PROCESS_WO_PUB.process_wo
944: (
945: p_bo_identifier => l_bo_identifier,
946: p_api_version_number => 1.0,
947: p_init_msg_list => l_init_msg_list,

Line 1087: l_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;

1083: l_debug_filename VARCHAR2(80);
1084: l_debug_file_mode VARCHAR2(1);
1085: l_return_status VARCHAR2(1);
1086: l_msg_count NUMBER;
1087: l_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1088: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1089: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1090: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1091: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;

Line 1088: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;

1084: l_debug_file_mode VARCHAR2(1);
1085: l_return_status VARCHAR2(1);
1086: l_msg_count NUMBER;
1087: l_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1088: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1089: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1090: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1091: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1092: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;

Line 1089: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;

1085: l_return_status VARCHAR2(1);
1086: l_msg_count NUMBER;
1087: l_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1088: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1089: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1090: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1091: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1092: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1093: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;

Line 1090: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;

1086: l_msg_count NUMBER;
1087: l_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1088: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1089: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1090: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1091: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1092: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1093: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
1094: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;

Line 1091: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;

1087: l_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1088: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1089: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1090: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1091: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1092: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1093: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
1094: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
1095: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;

Line 1092: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;

1088: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1089: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1090: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1091: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1092: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1093: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
1094: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
1095: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
1096: l_out_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;

Line 1093: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;

1089: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1090: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1091: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1092: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1093: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
1094: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
1095: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
1096: l_out_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1097: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;

Line 1094: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;

1090: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1091: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1092: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1093: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
1094: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
1095: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
1096: l_out_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1097: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1098: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;

Line 1095: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;

1091: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1092: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1093: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
1094: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
1095: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
1096: l_out_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1097: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1098: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1099: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;

Line 1096: l_out_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;

1092: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1093: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
1094: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
1095: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
1096: l_out_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1097: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1098: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1099: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1100: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;

Line 1097: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;

1093: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
1094: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
1095: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
1096: l_out_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1097: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1098: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1099: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1100: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1101: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;

Line 1098: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;

1094: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
1095: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
1096: l_out_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1097: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1098: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1099: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1100: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1101: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1102: l_out_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;

Line 1099: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;

1095: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
1096: l_out_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1097: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1098: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1099: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1100: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1101: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1102: l_out_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
1103: l_out_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;

Line 1100: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;

1096: l_out_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1097: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1098: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1099: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1100: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1101: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1102: l_out_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
1103: l_out_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
1104: l_out_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;

Line 1101: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;

1097: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1098: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1099: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1100: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1101: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1102: l_out_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
1103: l_out_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
1104: l_out_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
1105:

Line 1102: l_out_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;

1098: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1099: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1100: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1101: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1102: l_out_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
1103: l_out_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
1104: l_out_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
1105:
1106: BEGIN

Line 1103: l_out_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;

1099: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1100: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1101: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1102: l_out_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
1103: l_out_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
1104: l_out_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
1105:
1106: BEGIN
1107:

Line 1104: l_out_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;

1100: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1101: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1102: l_out_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
1103: l_out_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
1104: l_out_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
1105:
1106: BEGIN
1107:
1108: -- Enable Debug

Line 1209: EAM_PROCESS_WO_PUB.process_wo

1205: AHL_DEBUG_PUB.debug( 'Invoking EAM process_wo API' );
1206: END IF;
1207:
1208: -- Invoke EAM BO API for Updating the Job
1209: EAM_PROCESS_WO_PUB.process_wo
1210: (
1211: p_bo_identifier => l_bo_identifier,
1212: p_api_version_number => 1.0,
1213: p_init_msg_list => l_init_msg_list,

Line 1342: l_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;

1338: l_debug_filename VARCHAR2(80);
1339: l_debug_file_mode VARCHAR2(1);
1340: l_return_status VARCHAR2(1);
1341: l_msg_count NUMBER;
1342: l_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1343: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1344: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1345: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1346: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;

Line 1343: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;

1339: l_debug_file_mode VARCHAR2(1);
1340: l_return_status VARCHAR2(1);
1341: l_msg_count NUMBER;
1342: l_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1343: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1344: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1345: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1346: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1347: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;

Line 1344: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;

1340: l_return_status VARCHAR2(1);
1341: l_msg_count NUMBER;
1342: l_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1343: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1344: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1345: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1346: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1347: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1348: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;

Line 1345: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;

1341: l_msg_count NUMBER;
1342: l_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1343: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1344: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1345: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1346: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1347: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1348: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
1349: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;

Line 1346: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;

1342: l_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1343: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1344: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1345: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1346: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1347: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1348: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
1349: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
1350: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;

Line 1347: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;

1343: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1344: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1345: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1346: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1347: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1348: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
1349: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
1350: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
1351: l_out_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;

Line 1348: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;

1344: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1345: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1346: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1347: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1348: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
1349: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
1350: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
1351: l_out_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1352: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;

Line 1349: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;

1345: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1346: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1347: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1348: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
1349: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
1350: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
1351: l_out_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1352: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1353: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;

Line 1350: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;

1346: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1347: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1348: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
1349: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
1350: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
1351: l_out_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1352: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1353: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1354: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;

Line 1351: l_out_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;

1347: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1348: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
1349: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
1350: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
1351: l_out_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1352: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1353: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1354: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1355: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;

Line 1352: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;

1348: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
1349: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
1350: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
1351: l_out_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1352: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1353: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1354: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1355: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1356: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;

Line 1353: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;

1349: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
1350: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
1351: l_out_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1352: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1353: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1354: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1355: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1356: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1357: l_out_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;

Line 1354: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;

1350: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
1351: l_out_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1352: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1353: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1354: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1355: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1356: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1357: l_out_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
1358: l_out_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;

Line 1355: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;

1351: l_out_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1352: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1353: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1354: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1355: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1356: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1357: l_out_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
1358: l_out_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
1359: l_out_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;

Line 1356: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;

1352: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1353: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1354: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1355: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1356: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1357: l_out_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
1358: l_out_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
1359: l_out_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
1360:

Line 1357: l_out_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;

1353: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1354: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1355: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1356: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1357: l_out_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
1358: l_out_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
1359: l_out_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
1360:
1361: BEGIN

Line 1358: l_out_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;

1354: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1355: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1356: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1357: l_out_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
1358: l_out_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
1359: l_out_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
1360:
1361: BEGIN
1362:

Line 1359: l_out_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;

1355: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1356: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1357: l_out_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
1358: l_out_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
1359: l_out_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
1360:
1361: BEGIN
1362:
1363: -- Enable Debug

Line 1407: EAM_PROCESS_WO_PUB.process_wo

1403: AHL_DEBUG_PUB.debug( 'Invoking EAM process_wo API' );
1404: END IF;
1405:
1406: -- Invoke EAM BO API for Updating the Job
1407: EAM_PROCESS_WO_PUB.process_wo
1408: (
1409: p_bo_identifier => l_bo_identifier,
1410: p_api_version_number => 1.0,
1411: p_init_msg_list => l_init_msg_list,

Line 1539: l_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;

1535: l_debug_filename VARCHAR2(80);
1536: l_debug_file_mode VARCHAR2(1);
1537: l_return_status VARCHAR2(1);
1538: l_msg_count NUMBER;
1539: l_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1540: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1541: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1542: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1543: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;

Line 1540: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;

1536: l_debug_file_mode VARCHAR2(1);
1537: l_return_status VARCHAR2(1);
1538: l_msg_count NUMBER;
1539: l_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1540: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1541: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1542: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1543: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1544: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;

Line 1541: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;

1537: l_return_status VARCHAR2(1);
1538: l_msg_count NUMBER;
1539: l_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1540: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1541: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1542: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1543: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1544: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1545: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;

Line 1542: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;

1538: l_msg_count NUMBER;
1539: l_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1540: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1541: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1542: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1543: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1544: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1545: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
1546: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;

Line 1543: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;

1539: l_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1540: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1541: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1542: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1543: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1544: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1545: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
1546: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
1547: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;

Line 1544: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;

1540: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1541: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1542: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1543: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1544: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1545: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
1546: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
1547: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
1548: l_out_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;

Line 1545: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;

1541: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1542: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1543: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1544: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1545: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
1546: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
1547: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
1548: l_out_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1549: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;

Line 1546: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;

1542: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1543: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1544: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1545: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
1546: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
1547: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
1548: l_out_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1549: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1550: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;

Line 1547: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;

1543: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1544: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1545: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
1546: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
1547: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
1548: l_out_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1549: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1550: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1551: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;

Line 1548: l_out_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;

1544: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1545: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
1546: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
1547: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
1548: l_out_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1549: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1550: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1551: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1552: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;

Line 1549: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;

1545: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
1546: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
1547: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
1548: l_out_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1549: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1550: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1551: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1552: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1553: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;

Line 1550: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;

1546: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
1547: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
1548: l_out_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1549: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1550: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1551: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1552: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1553: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1554: l_out_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;

Line 1551: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;

1547: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
1548: l_out_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1549: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1550: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1551: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1552: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1553: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1554: l_out_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
1555: l_out_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;

Line 1552: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;

1548: l_out_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1549: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1550: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1551: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1552: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1553: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1554: l_out_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
1555: l_out_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
1556: l_out_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;

Line 1553: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;

1549: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1550: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1551: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1552: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1553: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1554: l_out_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
1555: l_out_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
1556: l_out_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
1557:

Line 1554: l_out_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;

1550: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1551: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1552: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1553: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1554: l_out_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
1555: l_out_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
1556: l_out_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
1557:
1558: BEGIN

Line 1555: l_out_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;

1551: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1552: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1553: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1554: l_out_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
1555: l_out_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
1556: l_out_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
1557:
1558: BEGIN
1559:

Line 1556: l_out_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;

1552: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1553: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1554: l_out_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
1555: l_out_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
1556: l_out_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
1557:
1558: BEGIN
1559:
1560: -- Enable Debug

Line 1604: EAM_PROCESS_WO_PUB.process_wo

1600: AHL_DEBUG_PUB.debug( 'Invoking EAM process_wo API' );
1601: END IF;
1602:
1603: -- Invoke EAM BO API for Updating the Job
1604: EAM_PROCESS_WO_PUB.process_wo
1605: (
1606: p_bo_identifier => l_bo_identifier,
1607: p_api_version_number => 1.0,
1608: p_init_msg_list => l_init_msg_list,

Line 1736: l_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;

1732: l_debug_filename VARCHAR2(80);
1733: l_debug_file_mode VARCHAR2(1);
1734: l_return_status VARCHAR2(1);
1735: l_msg_count NUMBER;
1736: l_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1737: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1738: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1739: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1740: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;

Line 1737: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;

1733: l_debug_file_mode VARCHAR2(1);
1734: l_return_status VARCHAR2(1);
1735: l_msg_count NUMBER;
1736: l_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1737: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1738: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1739: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1740: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1741: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;

Line 1738: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;

1734: l_return_status VARCHAR2(1);
1735: l_msg_count NUMBER;
1736: l_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1737: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1738: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1739: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1740: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1741: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1742: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;

Line 1739: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;

1735: l_msg_count NUMBER;
1736: l_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1737: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1738: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1739: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1740: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1741: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1742: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
1743: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;

Line 1740: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;

1736: l_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1737: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1738: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1739: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1740: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1741: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1742: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
1743: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
1744: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;

Line 1741: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;

1737: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1738: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1739: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1740: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1741: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1742: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
1743: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
1744: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
1745: l_out_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;

Line 1742: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;

1738: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1739: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1740: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1741: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1742: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
1743: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
1744: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
1745: l_out_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1746: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;

Line 1743: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;

1739: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1740: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1741: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1742: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
1743: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
1744: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
1745: l_out_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1746: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1747: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;

Line 1744: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;

1740: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1741: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1742: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
1743: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
1744: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
1745: l_out_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1746: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1747: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1748: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;

Line 1745: l_out_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;

1741: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1742: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
1743: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
1744: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
1745: l_out_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1746: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1747: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1748: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1749: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;

Line 1746: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;

1742: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
1743: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
1744: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
1745: l_out_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1746: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1747: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1748: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1749: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1750: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;

Line 1747: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;

1743: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
1744: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
1745: l_out_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1746: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1747: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1748: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1749: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1750: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1751: l_out_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;

Line 1748: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;

1744: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
1745: l_out_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1746: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1747: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1748: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1749: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1750: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1751: l_out_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
1752: l_out_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;

Line 1749: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;

1745: l_out_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1746: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1747: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1748: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1749: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1750: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1751: l_out_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
1752: l_out_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
1753: l_out_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;

Line 1750: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;

1746: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1747: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1748: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1749: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1750: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1751: l_out_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
1752: l_out_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
1753: l_out_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
1754:

Line 1751: l_out_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;

1747: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1748: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1749: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1750: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1751: l_out_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
1752: l_out_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
1753: l_out_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
1754:
1755: BEGIN

Line 1752: l_out_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;

1748: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1749: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1750: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1751: l_out_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
1752: l_out_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
1753: l_out_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
1754:
1755: BEGIN
1756:

Line 1753: l_out_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;

1749: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1750: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1751: l_out_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
1752: l_out_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
1753: l_out_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
1754:
1755: BEGIN
1756:
1757: -- Enable Debug

Line 1801: EAM_PROCESS_WO_PUB.process_wo

1797: AHL_DEBUG_PUB.debug( 'Invoking EAM process_wo API' );
1798: END IF;
1799:
1800: -- Invoke EAM BO API for Updating the Job
1801: EAM_PROCESS_WO_PUB.process_wo
1802: (
1803: p_bo_identifier => l_bo_identifier,
1804: p_api_version_number => 1.0,
1805: p_init_msg_list => l_init_msg_list,

Line 1918: p_x_eam_wo_tbl IN OUT NOCOPY EAM_PROCESS_WO_PUB.eam_wo_tbl_type,

1914: p_module_type IN VARCHAR2 := NULL,
1915: x_return_status OUT NOCOPY VARCHAR2,
1916: x_msg_count OUT NOCOPY NUMBER,
1917: x_msg_data OUT NOCOPY VARCHAR2,
1918: p_x_eam_wo_tbl IN OUT NOCOPY EAM_PROCESS_WO_PUB.eam_wo_tbl_type,
1919: p_eam_wo_relations_tbl IN EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type,
1920: p_eam_op_tbl IN EAM_PROCESS_WO_PUB.eam_op_tbl_type,
1921: p_eam_res_req_tbl IN EAM_PROCESS_WO_PUB.eam_res_tbl_type,
1922: p_eam_mat_req_tbl IN EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type

Line 1919: p_eam_wo_relations_tbl IN EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type,

1915: x_return_status OUT NOCOPY VARCHAR2,
1916: x_msg_count OUT NOCOPY NUMBER,
1917: x_msg_data OUT NOCOPY VARCHAR2,
1918: p_x_eam_wo_tbl IN OUT NOCOPY EAM_PROCESS_WO_PUB.eam_wo_tbl_type,
1919: p_eam_wo_relations_tbl IN EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type,
1920: p_eam_op_tbl IN EAM_PROCESS_WO_PUB.eam_op_tbl_type,
1921: p_eam_res_req_tbl IN EAM_PROCESS_WO_PUB.eam_res_tbl_type,
1922: p_eam_mat_req_tbl IN EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type
1923: )

Line 1920: p_eam_op_tbl IN EAM_PROCESS_WO_PUB.eam_op_tbl_type,

1916: x_msg_count OUT NOCOPY NUMBER,
1917: x_msg_data OUT NOCOPY VARCHAR2,
1918: p_x_eam_wo_tbl IN OUT NOCOPY EAM_PROCESS_WO_PUB.eam_wo_tbl_type,
1919: p_eam_wo_relations_tbl IN EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type,
1920: p_eam_op_tbl IN EAM_PROCESS_WO_PUB.eam_op_tbl_type,
1921: p_eam_res_req_tbl IN EAM_PROCESS_WO_PUB.eam_res_tbl_type,
1922: p_eam_mat_req_tbl IN EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type
1923: )
1924: IS

Line 1921: p_eam_res_req_tbl IN EAM_PROCESS_WO_PUB.eam_res_tbl_type,

1917: x_msg_data OUT NOCOPY VARCHAR2,
1918: p_x_eam_wo_tbl IN OUT NOCOPY EAM_PROCESS_WO_PUB.eam_wo_tbl_type,
1919: p_eam_wo_relations_tbl IN EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type,
1920: p_eam_op_tbl IN EAM_PROCESS_WO_PUB.eam_op_tbl_type,
1921: p_eam_res_req_tbl IN EAM_PROCESS_WO_PUB.eam_res_tbl_type,
1922: p_eam_mat_req_tbl IN EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type
1923: )
1924: IS
1925:

Line 1922: p_eam_mat_req_tbl IN EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type

1918: p_x_eam_wo_tbl IN OUT NOCOPY EAM_PROCESS_WO_PUB.eam_wo_tbl_type,
1919: p_eam_wo_relations_tbl IN EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type,
1920: p_eam_op_tbl IN EAM_PROCESS_WO_PUB.eam_op_tbl_type,
1921: p_eam_res_req_tbl IN EAM_PROCESS_WO_PUB.eam_res_tbl_type,
1922: p_eam_mat_req_tbl IN EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type
1923: )
1924: IS
1925:
1926: l_api_name VARCHAR2(30) := 'process_eam_workorders';

Line 1937: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;

1933: l_debug_filename VARCHAR2(80);
1934: l_debug_file_mode VARCHAR2(1);
1935: l_return_status VARCHAR2(1);
1936: l_msg_count NUMBER;
1937: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1938: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1939: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1940: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
1941: l_out_eam_wo_tbl EAM_PROCESS_WO_PUB.eam_wo_tbl_type;

Line 1938: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;

1934: l_debug_file_mode VARCHAR2(1);
1935: l_return_status VARCHAR2(1);
1936: l_msg_count NUMBER;
1937: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1938: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1939: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1940: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
1941: l_out_eam_wo_tbl EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
1942: l_out_eam_wo_rel_tbl EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;

Line 1939: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;

1935: l_return_status VARCHAR2(1);
1936: l_msg_count NUMBER;
1937: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1938: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1939: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1940: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
1941: l_out_eam_wo_tbl EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
1942: l_out_eam_wo_rel_tbl EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
1943: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;

Line 1940: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;

1936: l_msg_count NUMBER;
1937: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1938: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1939: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1940: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
1941: l_out_eam_wo_tbl EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
1942: l_out_eam_wo_rel_tbl EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
1943: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1944: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;

Line 1941: l_out_eam_wo_tbl EAM_PROCESS_WO_PUB.eam_wo_tbl_type;

1937: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1938: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1939: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1940: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
1941: l_out_eam_wo_tbl EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
1942: l_out_eam_wo_rel_tbl EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
1943: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1944: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1945: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;

Line 1942: l_out_eam_wo_rel_tbl EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;

1938: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1939: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1940: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
1941: l_out_eam_wo_tbl EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
1942: l_out_eam_wo_rel_tbl EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
1943: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1944: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1945: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1946: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;

Line 1943: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;

1939: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1940: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
1941: l_out_eam_wo_tbl EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
1942: l_out_eam_wo_rel_tbl EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
1943: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1944: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1945: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1946: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1947: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;

Line 1944: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;

1940: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
1941: l_out_eam_wo_tbl EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
1942: l_out_eam_wo_rel_tbl EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
1943: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1944: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1945: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1946: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1947: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1948: l_out_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;

Line 1945: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;

1941: l_out_eam_wo_tbl EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
1942: l_out_eam_wo_rel_tbl EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
1943: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1944: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1945: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1946: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1947: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1948: l_out_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
1949: l_out_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;

Line 1946: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;

1942: l_out_eam_wo_rel_tbl EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
1943: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1944: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1945: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1946: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1947: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1948: l_out_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
1949: l_out_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
1950:

Line 1947: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;

1943: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1944: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1945: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1946: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1947: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1948: l_out_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
1949: l_out_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
1950:
1951: BEGIN

Line 1948: l_out_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;

1944: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1945: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1946: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1947: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1948: l_out_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
1949: l_out_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
1950:
1951: BEGIN
1952:

Line 1949: l_out_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;

1945: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1946: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1947: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1948: l_out_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
1949: l_out_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
1950:
1951: BEGIN
1952:
1953: -- Enable Debug

Line 2008: EAM_PROCESS_WO_PUB.process_master_child_wo

2004: END IF;
2005:
2006: END IF;
2007:
2008: EAM_PROCESS_WO_PUB.process_master_child_wo
2009: (
2010: p_bo_identifier => l_bo_identifier,
2011: p_api_version_number => 1.0,
2012: p_init_msg_list => l_init_msg_list,