773: p_ump_maint_rec.MAINTENANCE_TYPE_CODE,
774: p_ump_maint_rec.TITLE,
775: p_ump_maint_rec.ITEM_INSTANCE_ID,
776: SYSDATE,
777: fnd_global.user_id,
778: SYSDATE,
779: fnd_global.user_id,
780: fnd_global.login_id,
781: p_ump_maint_rec.FLEET_HEADER_ID
775: p_ump_maint_rec.ITEM_INSTANCE_ID,
776: SYSDATE,
777: fnd_global.user_id,
778: SYSDATE,
779: fnd_global.user_id,
780: fnd_global.login_id,
781: p_ump_maint_rec.FLEET_HEADER_ID
782: );
783: G_DEBUG_LINE_NUM := l_debug_module||': '||7040;
776: SYSDATE,
777: fnd_global.user_id,
778: SYSDATE,
779: fnd_global.user_id,
780: fnd_global.login_id,
781: p_ump_maint_rec.FLEET_HEADER_ID
782: );
783: G_DEBUG_LINE_NUM := l_debug_module||': '||7040;
784: -- Insert Resource records for the root UE now
813: p_x_consolidated_res_tbl(x).ASSIGNED_UNITS,
814: p_x_consolidated_res_tbl(x).TOTAL_QUANTITY,
815: p_x_consolidated_res_tbl(x).CMRO_RESOURCE_ID,
816: SYSDATE,
817: fnd_global.user_id,
818: SYSDATE,
819: fnd_global.user_id,
820: fnd_global.login_id
821: );
815: p_x_consolidated_res_tbl(x).CMRO_RESOURCE_ID,
816: SYSDATE,
817: fnd_global.user_id,
818: SYSDATE,
819: fnd_global.user_id,
820: fnd_global.login_id
821: );
822: EXCEPTION
823: WHEN ex_dml_errors
816: SYSDATE,
817: fnd_global.user_id,
818: SYSDATE,
819: fnd_global.user_id,
820: fnd_global.login_id
821: );
822: EXCEPTION
823: WHEN ex_dml_errors
824: THEN
863: p_x_consolidated_mat_tbl(x).INVENTORY_ITEM_ID,
864: p_x_consolidated_mat_tbl(x).QUANTITY,
865: p_x_consolidated_mat_tbl(x).PRIMARY_UOM,
866: SYSDATE,
867: fnd_global.user_id,
868: SYSDATE,
869: fnd_global.user_id,
870: fnd_global.login_id
871: );
865: p_x_consolidated_mat_tbl(x).PRIMARY_UOM,
866: SYSDATE,
867: fnd_global.user_id,
868: SYSDATE,
869: fnd_global.user_id,
870: fnd_global.login_id
871: );
872: EXCEPTION
873: WHEN ex_dml_errors
866: SYSDATE,
867: fnd_global.user_id,
868: SYSDATE,
869: fnd_global.user_id,
870: fnd_global.login_id
871: );
872: EXCEPTION
873: WHEN ex_dml_errors
874: THEN